Thread: bug report role properties expiration date
Hi-
If I understand the help, I am to make a bug report by email to this list. If not, I apologize. I also am not sure if attached screenshots will work with a mailing list, but I'm adding them with the hope they will. (If I need to do this another way, I'd appreciate a clarification.)
I am getting unexpected behavior from pgAdmin3; Here is the basic information:
1. pgAdmin3 Macintosh version 1.18.1 binary download from http://www.pgadmin.org/download/macosx.php
2. Macintosh OS X v.10.6.8 ("Snow Leopard")
3. connecting to PostgreSQL 9.3.1 on Amazon Web Services RDS
Description of problem:
1. Start with a Login Role with no "VALID UNTIL" expiration set.
2. Open "Properties" window in pgAdmin3 and look at "Definition" tab.
3. pgAdmin3 fills in current date for "Account expires" field. There is no user action asking for this. It is done automatically and is clearly not a desired behavior since it will cause login ability to expire unexpectedly if user uses "OK" button rather than "Cancel" to exit "Properties."
4. NOTE: this automatic filling of the "Account expires" field happens even if the user never selects the "Definition" tab. That means that when a user opens the Properties box for a role just to look at things and hits "OK" even without making any changes, the expiration will be set!
Attached screenshot show open "Properties" window with offending "Account expires" field with today's date. Also shows SQL panel behind showing that there is no "VALID UNTIL" property on the selected user.
Second screenshot shows that after exiting with "OK" button the account expiration date is added to the user's role.
Resolution should be that the "Account expires" field should remain empty unless a user specifically adds a value. (It also might be nice to have an "idiot" window check that the user really wants the filled in date if it happens to be the current date, but that is a matter of opinion.)
Thanks,
David
David Elbert
Associate Program Director for Environmental Studies,
Advanced Academic Programs &
Earth and Planetary Sciences
Olin Hall
Johns Hopkins University
3400 N. Charles St
Baltimore, MD 21218
(410) 516-5049
![](/media/maillist_attaches/pgadmin-support/2014/02/22/24B677FB-BDDA-4B80-A656-2852D8CF484E@jhu.edu/pgadmin3_bug.jpg)
![](/media/maillist_attaches/pgadmin-support/2014/02/22/24B677FB-BDDA-4B80-A656-2852D8CF484E@jhu.edu/pgadmin3_bug2.jpg)
Attachment
Hi David,
This issue has been fixed. I believe, the next latest installer will be having this fix.
commitID: 3dfa02a90bfa5202c305187cf90baea1b46f6240.
commitID: 3dfa02a90bfa5202c305187cf90baea1b46f6240.
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 Sun, Feb 23, 2014 at 1:41 AM, David Elbert <elbert@jhu.edu> wrote:
Hi-If I understand the help, I am to make a bug report by email to this list. If not, I apologize. I also am not sure if attached screenshots will work with a mailing list, but I'm adding them with the hope they will. (If I need to do this another way, I'd appreciate a clarification.)I am getting unexpected behavior from pgAdmin3; Here is the basic information:1. pgAdmin3 Macintosh version 1.18.1 binary download from http://www.pgadmin.org/download/macosx.php2. Macintosh OS X v.10.6.8 ("Snow Leopard")3. connecting to PostgreSQL 9.3.1 on Amazon Web Services RDSDescription of problem:1. Start with a Login Role with no "VALID UNTIL" expiration set.2. Open "Properties" window in pgAdmin3 and look at "Definition" tab.3. pgAdmin3 fills in current date for "Account expires" field. There is no user action asking for this. It is done automatically and is clearly not a desired behavior since it will cause login ability to expire unexpectedly if user uses "OK" button rather than "Cancel" to exit "Properties."4. NOTE: this automatic filling of the "Account expires" field happens even if the user never selects the "Definition" tab. That means that when a user opens the Properties box for a role just to look at things and hits "OK" even without making any changes, the expiration will be set!Attached screenshot show open "Properties" window with offending "Account expires" field with today's date. Also shows SQL panel behind showing that there is no "VALID UNTIL" property on the selected user.Second screenshot shows that after exiting with "OK" button the account expiration date is added to the user's role.Resolution should be that the "Account expires" field should remain empty unless a user specifically adds a value. (It also might be nice to have an "idiot" window check that the user really wants the filled in date if it happens to be the current date, but that is a matter of opinion.)Thanks,DavidDavid ElbertAssociate Program Director for Environmental Studies,Advanced Academic Programs &Earth and Planetary SciencesOlin HallJohns Hopkins University3400 N. Charles StBaltimore, MD 21218
Attachment
On Mon, Feb 24, 2014 at 8:17 AM, David Elbert <elbert@jhu.edu> wrote:
Hi Dinesh-Thank you. Is there a schedule for the release of the next installer or is it a question of when there is enough to be worth the rebuild and release?
Hi David,
I believe, someone from our team will respond you on the release date of new installers. I am not sure when it will be available.
Thanks,
Dinesh
Dinesh
DavidOn Feb 23, 2014, at 1:09 AM, Dinesh Kumar wrote:Hi David,This issue has been fixed. I believe, the next latest installer will be having this fix.
commitID: 3dfa02a90bfa5202c305187cf90baea1b46f6240.Dinesh
--
Dinesh KumarSoftware EngineerSkype ID: dinesh.kumar432www.enterprisedb.com
Follow us on Twitter
@EnterpriseDB
Visit EnterpriseDB for tutorials, webinars, whitepapers and moreOn Sun, Feb 23, 2014 at 1:41 AM, David Elbert <elbert@jhu.edu> wrote:Hi-If I understand the help, I am to make a bug report by email to this list. If not, I apologize. I also am not sure if attached screenshots will work with a mailing list, but I'm adding them with the hope they will. (If I need to do this another way, I'd appreciate a clarification.)I am getting unexpected behavior from pgAdmin3; Here is the basic information:1. pgAdmin3 Macintosh version 1.18.1 binary download from http://www.pgadmin.org/download/macosx.php2. Macintosh OS X v.10.6.8 ("Snow Leopard")3. connecting to PostgreSQL 9.3.1 on Amazon Web Services RDSDescription of problem:1. Start with a Login Role with no "VALID UNTIL" expiration set.2. Open "Properties" window in pgAdmin3 and look at "Definition" tab.3. pgAdmin3 fills in current date for "Account expires" field. There is no user action asking for this. It is done automatically and is clearly not a desired behavior since it will cause login ability to expire unexpectedly if user uses "OK" button rather than "Cancel" to exit "Properties."4. NOTE: this automatic filling of the "Account expires" field happens even if the user never selects the "Definition" tab. That means that when a user opens the Properties box for a role just to look at things and hits "OK" even without making any changes, the expiration will be set!Attached screenshot show open "Properties" window with offending "Account expires" field with today's date. Also shows SQL panel behind showing that there is no "VALID UNTIL" property on the selected user.Second screenshot shows that after exiting with "OK" button the account expiration date is added to the user's role.Resolution should be that the "Account expires" field should remain empty unless a user specifically adds a value. (It also might be nice to have an "idiot" window check that the user really wants the filled in date if it happens to be the current date, but that is a matter of opinion.)Thanks,David<pgadmin3_bug.jpg>David ElbertAssociate Program Director for Environmental Studies,Advanced Academic Programs &Earth and Planetary SciencesOlin HallJohns Hopkins University3400 N. Charles StBaltimore, MD 21218<pgadmin3_bug2.jpg>