Scott,
This is an example of what is in my databaes in the lastauth table:
+-------------+-------------------+-------------+--------------+
| user | domain | remote_ip | timestamp
|
+-------------+-------------------+-------------+--------------+
| test | test.com | 192.168.1.1 | 2001-07-10 16:44:00 |
+-------------+-------------------+-------------+--------------+
This is all in the development copies of vpopmail.
-Richard A. Secor
[EMAIL PROTECTED]
Sequential Logic
----- Original Message -----
From: "Scott Ramshaw" <[EMAIL PROTECTED]>
To: "Richard A. Secor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 15:33
Subject: Re: VPOPMAIL - LASTAUTH - DATE/TIME STAMP NOT RIGHT
> The vpopmail FAQ implies this is only for POP logins, does it really log
ANY
> vpopmail authentication or is it really just for POP? And I assume we are
> talking about the --enable-auth-logging=y from section 27 on the FAQ of
> vpopmail 4.9.10? Or are you talking about a seperate feature? I don't
have
> any lastauth table but I have upgraded from earlier vpopmail versions and
> not installed fresh.
>
> I would like this to disable accounts that haven't been used in a long
time.
> I also don' have a vdeloldusers bin or a .c in source, is this off some
> patch?
>
> ----- Original Message -----
> From: "Richard A. Secor" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 10, 2001 2:47 PM
> Subject: Re: VPOPMAIL - LASTAUTH - DATE/TIME STAMP NOT RIGHT
>
>
> > Also, had to change vdeloldusers.c.
> > Around lines: 92-94
> >
> > snprintf(SqlBuf, MAX_BUFF,
> > "select user,domain from lastauth where timestamp <
> > 'FROM_UNIXTIME(%lu)'",
> > nowt);
> >
> > -Richard A. Secor
> > [EMAIL PROTECTED]
> > Sequential Logic
> >
> > ----- Original Message -----
> > From: "Richard A. Secor" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, July 10, 2001 14:42
> > Subject: VPOPMAIL - LASTAUTH - DATE/TIME STAMP NOT RIGHT
> >
> >
> > > I was sick of having the wrong Date/Time stamps in my lastauth table
so
> > > here's the fix:
> > >
> > > File: vmysql.c
> > > Around lines: 1046-1048
> > > Note: I just added:
> > > FROM_UNIXTIME( )
> > >
> > > snprintf( SqlBufUpdate, SQL_BUF_SIZE,
> > > "replace into lastauth set user='%s', domain='%s', \
> > > remote_ip='%s', timestamp=FROM_UNIXTIME(%lu)", user, domain, remoteip,
> > > time(NUL
> > > L));
> > >
> > > Richard A. Secor
> > > [EMAIL PROTECTED]
> > > Sequential Logic
> > >
> > >
> >
> >
>
>
