Thanks Heiko. 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 Tue, Oct 15, 2013 at 11:38 AM, Heiko Folkerts < heiko.folke...@david-software.de> wrote: > Hi SDinish, > OK, you're right that did the trick. Thanks > Heiko > > > 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 > _______________________________________________________ > > > -----Ursprüngliche Nachricht----- > Von: pgadmin-support-ow...@postgresql.org [mailto: > pgadmin-support-ow...@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 > > 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 > > <http://www.enterprisedb.com/sites/default/files/EDB_logo_rgb_300(1).jpg> > 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 > > > >
