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 Ph: +918087463317 Skype ID: dinesh.kumar432 www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> * Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and more <http://www.enterprisedb.com/resources-community> On Mon, Oct 14, 2013 at 6:04 PM, Heiko Folkerts < heiko.folke...@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.folke...@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 >
