On Mon, 2006-08-21 at 15:46 -0600, Anthony Chavez wrote: > Hello again, phpgroupware-users! > > This morning, my users were once again unable to login to > phpGroupWare. I currently am using LDAP authentication, but having > accounts created in a PostgreSQL 8.1.4 backend (because for some > reason I had trouble getting phpgw to write to LDAP).
I would be happy to help you debug this at some stage. > So, I assumed > that they could not login was because I had conigured "Auto-created > user accounts expire" (in /setup/config.php) to one week. > > I changed that setting to "never," and IIRC was not able to login > immediately thereafter. > > So I issued the following query to PostgreSQL: > > UPDATE phpgw_accounts SET account_expires = 0; > > This didn't seem to work either, so I tried -1, and we were once again > able to login. However, whether logins were failing because of the > values stored in the account_expires column or some other error (such > as lockout for auth failures) is unclear. > > I issued the queries under the assumption that the column > account_expires reflected the value of the aforementioned > "Auto-created user accounts expire" setting. Yes, and changing it won't change the value for already created accounts. The expiry date is set at time of "auto creation". > Is this accurate? And > does -1 equate to "never?" Yes, 0 == start of unix timestamp epoch (midnight 1-Jan-1970 utc). Cheers Dave -- Dave Hall (aka skwashd) API Coordinator phpGroupWare +-------------------------------------+-------------------------------+ | e [EMAIL PROTECTED] | w phpgroupware.org | | j [EMAIL PROTECTED] | aim skwashd | | icq 278064022 | msn [EMAIL PROTECTED] | | sip [EMAIL PROTECTED] | y! skwashd | +-------------------------------------+-------------------------------+ _______________________________________________ Phpgroupware-users mailing list [email protected] http://lists.gnu.org/mailman/listinfo/phpgroupware-users
