Re: [Phpgroupware-users] User accounts expired (0.9.16.010)

[Dave Hall]

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 address@hidden          | w phpgroupware.org            |
| j address@hidden                 | aim skwashd                   |
| icq 278064022                       | msn address@hidden       |
| sip address@hidden       | y! skwashd                    |
+-------------------------------------+-------------------------------+