Thread: password authentication fails after assigning a group role to a login role
password authentication fails after assigning a group role to a login role
From
Heiko Folkerts
Date:
Hi all, I get a error saying password authentication failed when executing the following steps. Please check wether this is a bugor a wrong usage from me. 1. create a login role called "truetest" and assign it a password. The role should get the "can add databases" privilege. 2. add a server using the file menu and call it truetest local using the current host (for which the login role was created)and use the newly created login role as username. I did this on my localhost after a fresh install. I used the passwordbeing the same as the username. 3. Connect the newly created server 4. Add a group role called truetest_owner within the group roles node for the super user postgres - where we created thelogin role in step 1. The new group role gets no password and the privilege "can add databaes" 5. open the properties from the login role "truetest" from step 1 and assign the newly created group role truetest_ownerso that truetest is a member of truetest_owner. 6. reconnect the added server frrom step 2 => the connection fails and a message saying the passwor ntication failed appears. Dropping the membership to truetest_owner from truetest doesn't fix the problem. Questions: 1. Can you copy the problem? 2. Is there a workarround for this? Maybe this is a bug in PostGreSql itself but since I experience the error when using PGAdmin this should be the first placeto send the report. Best regards Heiko My System: Windows 7 64 bit PostGreSql 9.2.4 (binary installer) The Problem could be reproduced on another machine. Mit freundlichen Grüßen Heiko Folkerts -- _______________________________________________________ DAVID Software GmbH · Wendenring 1 · 38114 Braunschweig Tel.: +49 531 24379-14 Fax.: +49 531 24379-79 E-Mail: mailto:Heiko.Folkerts@david-software.de WWW: http://www.david-software.de Eintragung: Amtsgericht Braunschweig, HRB 3167 Geschäftsführer: Frank Ptok _______________________________________________________
Re: password authentication fails after assigning a group role to a login role
From
Dinesh Kumar
Date:
Hi,
While you doing the step 5, please go to "Definition Tab" on login role properties dialogue box, and then uncheck/clear the "Account Expires" check box or the value.
And then press "OK" for applying your modifications.
This is reported earlier, and i am already working on this on priority.
Thanks in advance.
Dinesh
--
Dinesh Kumar
![](http://www.enterprisedb.com/sites/default/files/EDB_logo_rgb_300(1).jpg)
Ph: +918087463317
Follow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and more
--
Dinesh Kumar
Software Engineer
![](http://www.enterprisedb.com/sites/default/files/EDB_logo_rgb_300(1).jpg)
Ph: +918087463317
Skype ID: dinesh.kumar432
www.enterprisedb.comFollow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and more
On Mon, Oct 14, 2013 at 6:04 PM, Heiko Folkerts <heiko.folkerts@david-software.de> wrote:
Hi all,
I get a error saying password authentication failed when executing the following steps. Please check wether this is a bug or a wrong usage from me.
1. create a login role called "truetest" and assign it a password. The role should get the "can add databases" privilege.
2. add a server using the file menu and call it truetest local using the current host (for which the login role was created) and use the newly created login role as username. I did this on my localhost after a fresh install. I used the password being the same as the username.
3. Connect the newly created server
4. Add a group role called truetest_owner within the group roles node for the super user postgres - where we created the login role in step 1. The new group role gets no password and the privilege "can add databaes"
5. open the properties from the login role "truetest" from step 1 and assign the newly created group role truetest_owner so that truetest is a member of truetest_owner.
6. reconnect the added server frrom step 2
=> the connection fails and a message saying the passwor ntication failed appears.
Dropping the membership to truetest_owner from truetest doesn't fix the problem.
Questions:
1. Can you copy the problem?
2. Is there a workarround for this?
Maybe this is a bug in PostGreSql itself but since I experience the error when using PGAdmin this should be the first place to send the report.
Best regards
Heiko
My System:
Windows 7 64 bit
PostGreSql 9.2.4 (binary installer)
The Problem could be reproduced on another machine.
Mit freundlichen Grüßen
Heiko Folkerts
--
_______________________________________________________
DAVID Software GmbH · Wendenring 1 · 38114 Braunschweig
Tel.: +49 531 24379-14
Fax.: +49 531 24379-79
E-Mail: mailto:Heiko.Folkerts@david-software.de
WWW: http://www.david-software.de
Eintragung: Amtsgericht Braunschweig, HRB 3167
Geschäftsführer: Frank Ptok
_______________________________________________________
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
Re: password authentication fails after assigning a group role to a login role
From
Dinesh Kumar
Date:
Thanks Heiko.
Dinesh
--
Dinesh Kumar
![](http://www.enterprisedb.com/sites/default/files/EDB_logo_rgb_300(1).jpg)
Ph: +918087463317
Follow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and more
--
Dinesh Kumar
Software Engineer
![](http://www.enterprisedb.com/sites/default/files/EDB_logo_rgb_300(1).jpg)
Ph: +918087463317
Skype ID: dinesh.kumar432
www.enterprisedb.comFollow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and more
On Tue, Oct 15, 2013 at 11:38 AM, Heiko Folkerts <heiko.folkerts@david-software.de> wrote:
Hi SDinish,
OK, you're right that did the trick. Thanks
Heiko-----Ursprüngliche Nachricht-----
Mit freundlichen Grüßen
Heiko Folkerts
--
_______________________________________________________
DAVID Software GmbH · Wendenring 1 · 38114 Braunschweig
Tel.: +49 531 24379-14
Fax.: +49 531 24379-79
E-Mail: mailto:Heiko.Folkerts@david-software.de
WWW: http://www.david-software.de
Eintragung: Amtsgericht Braunschweig, HRB 3167
Geschäftsführer: Frank Ptok
_______________________________________________________
Von: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] Im Auftrag von Dinesh Kumar
Gesendet: Montag, 14. Oktober 2013 14:59
An: Heiko Folkerts
Cc: pgadmin-support@postgresql.org
Betreff: Re: [pgadmin-support] password authentication fails after assigning a group role to a login role<http://www.enterprisedb.com/sites/default/files/EDB_logo_rgb_300(1).jpg>
Hi,
While you doing the step 5, please go to "Definition Tab" on login role properties dialogue box, and then uncheck/clear the "Account Expires" check box or the value.
And then press "OK" for applying your modifications.
This is reported earlier, and i am already working on this on priority.
Thanks in advance.
Dinesh
--
Dinesh Kumar
Software Engineer
www.enterprisedb.co <http://www.enterprisedb.com/> m <http://www.enterprisedb.com/>Visit EnterpriseDB for tutorials, webinars, whitepapers <http://www.enterprisedb.com/resources-community> and more <http://www.enterprisedb.com/resources-community>
Follow us on Twitter
@EnterpriseDB
On Mon, Oct 14, 2013 at 6:04 PM, Heiko Folkerts <heiko.folkerts@david-software.de> wrote:
Hi all,
I get a error saying password authentication failed when executing the following steps. Please check wether this is a bug or a wrong usage from me.
1. create a login role called "truetest" and assign it a password. The role should get the "can add databases" privilege.
2. add a server using the file menu and call it truetest local using the current host (for which the login role was created) and use the newly created login role as username. I did this on my localhost after a fresh install. I used the password being the same as the username.
3. Connect the newly created server
4. Add a group role called truetest_owner within the group roles node for the super user postgres - where we created the login role in step 1. The new group role gets no password and the privilege "can add databaes"
5. open the properties from the login role "truetest" from step 1 and assign the newly created group role truetest_owner so that truetest is a member of truetest_owner.
6. reconnect the added server frrom step 2
=> the connection fails and a message saying the passwor ntication failed appears.
Dropping the membership to truetest_owner from truetest doesn't fix the problem.
Questions:
1. Can you copy the problem?
2. Is there a workarround for this?
Maybe this is a bug in PostGreSql itself but since I experience the error when using PGAdmin this should be the first place to send the report.
Best regards
Heiko
My System:
Windows 7 64 bit
PostGreSql 9.2.4 (binary installer)
The Problem could be reproduced on another machine.
Mit freundlichen Grüßen
Heiko Folkerts
--
_______________________________________________________
DAVID Software GmbH · Wendenring 1 · 38114 Braunschweig
Tel.: +49 531 24379-14
Fax.: +49 531 24379-79
E-Mail: mailto:Heiko.Folkerts@david-software.de
WWW: http://www.david-software.de
Eintragung: Amtsgericht Braunschweig, HRB 3167
Geschäftsführer: Frank Ptok
_______________________________________________________
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support