Re: password authentication fails after assigning a group role to a login role

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(dot)folkerts(at)david-software(dot)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(dot)Folkerts(at)david-software(dot)de
> WWW: http://www.david-software.de
> Eintragung: Amtsgericht Braunschweig, HRB 3167
> Geschäftsführer: Frank Ptok
> _______________________________________________________
>
>
> -----Ursprüngliche Nachricht-----
> Von: pgadmin-support-owner(at)postgresql(dot)org [mailto:
> pgadmin-support-owner(at)postgresql(dot)org] Im Auftrag von Dinesh Kumar
> Gesendet: Montag, 14. Oktober 2013 14:59
> An: Heiko Folkerts
> Cc: pgadmin-support(at)postgresql(dot)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(dot)folkerts(at)david-software(dot)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(dot)Folkerts(at)david-software(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>
>
>
>