[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Phpgroupware-users] User accounts expired (

From: Dave Hall
Subject: Re: [Phpgroupware-users] User accounts expired (
Date: Tue, 22 Aug 2006 19:52:36 +1000

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).


Dave Hall (aka skwashd)
API Coordinator
| e address@hidden          | w            |
| j address@hidden                 | aim skwashd                   |
| icq 278064022                       | msn address@hidden       |
| sip address@hidden       | y! skwashd                    |

reply via email to

[Prev in Thread] Current Thread [Next in Thread]