Thread: Password Expiry
<div class="WordSection1"><p class="MsoNormal">pgAdmin v 1.16.1<p class="MsoNormal">Windows 7 x64<p class="MsoNormal"> <pclass="MsoNormal">PostgreSQL v9.4.2<p class="MsoNormal">CentOS 6.4<p class="MsoNormal"> <p class="MsoNormal">pgAdminby default when editing a user’s account settings seems to set Account Validity to ‘1969-12-3100:00:00+01’ if the role is defined as valid until infinity.<p class="MsoNormal">This results in the user notbeing able to login, and only receiving a password authentication failed error message (Account Expired would be morehelpful, but that’s for Postgres ;)).<p class="MsoNormal"> <p class="MsoNormal">An example would be adding a user toa group role via the Role membership tab, and never actually opening the Definition tab.<p class="MsoNormal">You’d be blissfullyunaware that Password validity had been changed.<p class="MsoNormal"> <p class="MsoNormal">Best regards,<p class="MsoNormal">Brett<pclass="MsoNormal"> </div>
Hi On Wed, Apr 10, 2013 at 12:31 PM, Brett Maton <matonb@ltresources.co.uk> wrote: > pgAdmin v 1.16.1 > > Windows 7 x64 > > > > PostgreSQL v9.4.2 > > CentOS 6.4 > > > > pgAdmin by default when editing a user’s account settings seems to set > Account Validity to ‘1969-12-31 00:00:00+01’ if the role is defined as valid > until infinity. > > This results in the user not being able to login, and only receiving a > password authentication failed error message (Account Expired would be more > helpful, but that’s for Postgres ;)). > > > > An example would be adding a user to a group role via the Role membership > tab, and never actually opening the Definition tab. > > You’d be blissfully unaware that Password validity had been changed. This has been fixed already for future releases: commit 265143d8134a5d191ad6db1162a9408f23c185c7 Author: Dave Page <dpage@pgadmin.org> Date: Wed Feb 6 15:24:50 2013 +0000 Fix expiry date handling for users. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company