Thread

1. psycopg2 mail list subscription issues

   Rich Shepard <rshepard@appl-ecosys.com> — 2021-07-13T17:29:43Z

   I apologize for writing to the list, but my attempts to subscribe to the
   psycopg2 mail list fail and I've not seen a response to my email message
   sent to the mail list owner.
   
   I don't know my postgres mail list password as I've not had a reason to use
   it ... until now. Subscribing to the psycopg2 mail list and, apparently
   other lists, requires a community account password which my password to this
   mail list apparently is.
   
   Thinking I might have a postgres community account (needed to subscribe to
   that mail list) I tried the reset password link on this page
   <https://www.postgresql.org/account/auth/13/?d=HK658H3fbmYHySiKbweKVg==$MiRNvoF96iuWkieYcUJtuqtjy-fYMKcy3nVvjMG0YdA=>
   but no email message with instructions to reset my password were received.
   
   This suggested I didn't have an account, so I tried to create one. The
   immediate response is that I do have a community account. Checkmate. Can't
   reset my password and I have an existing account with my email address.
   
   Suggestions on how I can subscribe to the psycopg2 mail list are needed.
   
   TIA,
   
   Rich
   
   
   
   

2. Re: psycopg2 mail list subscription issues

   Diego <mrstephenamell@gmail.com> — 2021-07-13T17:57:24Z

   Here is the link to reset your password and manage your account: 
   https://www.postgresql.org/account/reset/
   
   On 13/07/2021 14:29, Rich Shepard wrote:
   > I apologize for writing to the list, but my attempts to subscribe to the
   > psycopg2 mail list fail and I've not seen a response to my email message
   > sent to the mail list owner.
   > 
   > I don't know my postgres mail list password as I've not had a reason to use
   > it ... until now. Subscribing to the psycopg2 mail list and, apparently
   > other lists, requires a community account password which my password to 
   > this
   > mail list apparently is.
   > 
   > Thinking I might have a postgres community account (needed to subscribe to
   > that mail list) I tried the reset password link on this page
   > <https://www.postgresql.org/account/auth/13/?d=HK658H3fbmYHySiKbweKVg==$MiRNvoF96iuWkieYcUJtuqtjy-fYMKcy3nVvjMG0YdA=> 
   > 
   > but no email message with instructions to reset my password were received.
   > 
   > This suggested I didn't have an account, so I tried to create one. The
   > immediate response is that I do have a community account. Checkmate. Can't
   > reset my password and I have an existing account with my email address.
   > 
   > Suggestions on how I can subscribe to the psycopg2 mail list are needed.
   > 
   > TIA,
   > 
   > Rich
   > 
   > 
   
   
   
   

3. Re: psycopg2 mail list subscription issues

   Rich Shepard <rshepard@appl-ecosys.com> — 2021-07-13T18:53:45Z

   On Tue, 13 Jul 2021, Diego wrote:
   
   > Here is the link to reset your password and manage your account: 
   > https://www.postgresql.org/account/reset/
   
   Diego,
   
   I tried the list management link and that didn't work. The URL you sent has
   the same results as the password reset link on the community account page:
   no URL to reset the password and an instant message from the Mail Delivery
   System <Mailer-Daemon@postgresql.org>:
   
   A message that you sent could not be delivered to one or more of its
   recipients. This is a permanent error. The following address(es) failed:
   
      david@fetter.org
        host mail.fetter.org [46.226.110.146]
        SMTP error from remote mail server after RCPT TO:<david@fetter.org>:
        550 5.7.23 <david@fetter.org>: Recipient address rejected:
        Message rejected due to: SPF fail - not authorized. Please see http://www.openspf.net/Why?s=mfrom;id=rshepard@appl-ecosys.com;ip=217.196.149.56;r=<UNKNOWN>
   
   Thanks,
   
   Rich
   
   
   
   

4. Re: psycopg2 mail list subscription issues

   Tom Lane <tgl@sss.pgh.pa.us> — 2021-07-13T19:23:19Z

   Rich Shepard <rshepard@appl-ecosys.com> writes:
   >      Message rejected due to: SPF fail - not authorized. Please see http://www.openspf.net/Why?s=mfrom;id=rshepard@appl-ecosys.com;ip=217.196.149.56;r=<UNKNOWN>
   
   Hmm, I see appl-ecosys.com is advertising this SPF data:
   
   $ dig appl-ecosys.com txt
   ...
   appl-ecosys.com.        1159    IN      TXT     "v=spf1 ip4:50.126.108.78 -all"
   appl-ecosys.com.        1159    IN      TXT     "v=spf2.0/pra ?all"
   
   Is it possible that you're sending the list request mail out of some
   other IP address?
   
   			regards, tom lane
   
   
   
   

5. Re: psycopg2 mail list subscription issues

   Rich Shepard <rshepard@appl-ecosys.com> — 2021-07-13T19:27:15Z

   On Tue, 13 Jul 2021, Tom Lane wrote:
   
   > Is it possible that you're sending the list request mail out of some other
   > IP address?
   
   tom,
   
   No. I have a personal domain but use my business domain for all
   business-related mail lists.
   
   Thanks,
   
   Rich
   
   
   
   

6. Re: psycopg2 mail list subscription issues

   Stephen Frost <sfrost@snowman.net> — 2021-07-13T19:32:24Z

   Greetings,
   
   * Rich Shepard (rshepard@appl-ecosys.com) wrote:
   > On Tue, 13 Jul 2021, Tom Lane wrote:
   > 
   > >Is it possible that you're sending the list request mail out of some other
   > >IP address?
   > 
   > tom,
   > 
   > No. I have a personal domain but use my business domain for all
   > business-related mail lists.
   
   This was addressed and we got it all sorted.
   
   Thanks,
   
   Stephen