problems with my community account on www.postgresql.org

Started by Mathias Zarickabout 5 years ago3 messagesgeneral
Jump to latest
#1Mathias Zarick
Mathias.Zarick@trivadis.com

Hi there,

I created a community account some weeks ago, mainly to be able to subscribe to this email lists.
Now I want to edit my subscriptions but I am unable to login. I chose Twitter to be used for authentication.
When I do this again, and click on "Sign in with Twitter" I get into an infinite loop which goes to
https://api.twitter.com/oauth/authorize where I can click "Authorize app" but I land on api.twitter.com again and so on.
However, when I try to reset my password for my account using the password reset function on
https://www.postgresql.org/account/reset/ I get "Account error",
"This account cannot change password as it's connected to a third party login site."

Can anybody from the mailing list admins help me out here?
Thanks in advance
Mathias Zarick

#2Magnus Hagander
magnus@hagander.net
In reply to: Mathias Zarick (#1)
Re: problems with my community account on www.postgresql.org

On Wed, Mar 3, 2021 at 12:23 PM Mathias Zarick
<Mathias.Zarick@trivadis.com> wrote:

Hi there,

I created a community account some weeks ago, mainly to be able to subscribe to this email lists.

Now I want to edit my subscriptions but I am unable to login. I chose Twitter to be used for authentication.

When I do this again, and click on “Sign in with Twitter” I get into an infinite loop which goes to

https://api.twitter.com/oauth/authorize where I can click “Authorize app” but I land on api.twitter.com again and so on.

However, when I try to reset my password for my account using the password reset function on

https://www.postgresql.org/account/reset/ I get “Account error”,

“This account cannot change password as it's connected to a third party login site.”

Can anybody from the mailing list admins help me out here?

Hi!

You seem to have hit a bug in our oauth1 processing (twitter is the
only provider we use oauth1 for, the others use oauth2). I believe
it's been fixed now, please try again.

--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/

#3Mathias Zarick
Mathias.Zarick@trivadis.com
In reply to: Magnus Hagander (#2)
RE: problems with my community account on www.postgresql.org

Hello Magnus,

thank you very much for your answer and your support.
I can confirm that authentication now works as expected again.
Have a nice day Mathias

-----Original Message-----
From: Magnus Hagander <magnus@hagander.net>
Sent: Wednesday, March 3, 2021 12:50 PM
To: Mathias Zarick <Mathias.Zarick@trivadis.com>
Cc: pgsql-general@postgresql.org
Subject: Re: problems with my community account on www.postgresql.org

On Wed, Mar 3, 2021 at 12:23 PM Mathias Zarick <Mathias.Zarick@trivadis.com> wrote:

Hi there,

I created a community account some weeks ago, mainly to be able to subscribe to this email lists.

Now I want to edit my subscriptions but I am unable to login. I chose Twitter to be used for authentication.

When I do this again, and click on "Sign in with Twitter" I get into
an infinite loop which goes to

https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapi.twitter.com%2Foauth%2Fauthorize&amp;amp;data=04%7C01%7CMathias.Zarick%40trivadis.com%7C90329450f2e74f8fadbe08d8de3a91b8%7Cfe8f2b6f52c6436db363ddd6dafc103a%7C0%7C0%7C637503690424035404%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;amp;sdata=E3lyg2enpbqvRkAxu6PkxZ6ILZCjc5HrVUlSckwks8A%3D&amp;amp;reserved=0 where I can click "Authorize app" but I land on api.twitter.com again and so on.

However, when I try to reset my password for my account using the
password reset function on

https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.
postgresql.org%2Faccount%2Freset%2F&amp;data=04%7C01%7CMathias.Zarick%
40trivadis.com%7C90329450f2e74f8fadbe08d8de3a91b8%7Cfe8f2b6f52c6436db3
63ddd6dafc103a%7C0%7C0%7C637503690424035404%7CUnknown%7CTWFpbGZsb3d8ey
JWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C100
0&amp;sdata=vwShu03lC%2FeIKeUyoNcnFKaTkUA1NBx14vc8zgdgTE0%3D&amp;reser
ved=0 I get "Account error",

"This account cannot change password as it's connected to a third party login site."

Can anybody from the mailing list admins help me out here?

Hi!

You seem to have hit a bug in our oauth1 processing (twitter is the only provider we use oauth1 for, the others use oauth2). I believe it's been fixed now, please try again.

--
Magnus Hagander
Me: https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.hagander.net%2F&amp;amp;data=04%7C01%7CMathias.Zarick%40trivadis.com%7C90329450f2e74f8fadbe08d8de3a91b8%7Cfe8f2b6f52c6436db363ddd6dafc103a%7C0%7C0%7C637503690424035404%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;amp;sdata=p%2Fy5OrVFpfJody5l6iRMcmaAOgxL8bDUH2gYFqaFVkk%3D&amp;amp;reserved=0
Work: https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.redpill-linpro.com%2F&amp;amp;data=04%7C01%7CMathias.Zarick%40trivadis.com%7C90329450f2e74f8fadbe08d8de3a91b8%7Cfe8f2b6f52c6436db363ddd6dafc103a%7C0%7C0%7C637503690424035404%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;amp;sdata=uiEVAtEih07XHxB%2BfnHF3GGVpSNOed4HRx687w%2FM4dA%3D&amp;amp;reserved=0