I've the same problem. During pop login (4.10.28) the lastauth table wasn't
updated.
After user [EMAIL PROTECTED] login:
mysql> select * from lastauth;
+--------------+-----------------------+--------------+---------------------
+
| user | domain | remote_ip | timestamp
|
+--------------+-----------------------+--------------+---------------------
+
| test | test.com | 10.10.32.151 | 2000-09-94 77:62:52 |
+--------------+-----------------------+--------------+---------------------
+
And:
[root@test bin]# ./vuserinfo [EMAIL PROTECTED]
name: test
passwd: xxxxxxxxxxxxxx
uid: 0
gid: 0
all services available
test
/coda/qmail/vpopmail/domains/test.com/test
15M
last auth: Thu Jan 1 01:33:20 1970
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
But: looking at the db during auth session,
010710 16:52:43 9072 Connect [EMAIL PROTECTED] on vpopmail
9072 Query select pw_name, pw_passwd, pw_uid,
pw_gid, pw_gecos, pw_dir, pw_shell from vpopmail where pw_name = "test" and
pw_domain = "test.com"
9072 Query select ip_addr from relay
010710 16:52:44 9072 Quit
Where is the timestamp for the auth?
Did your patch solve this issue?
Thanks
---
Cordiali saluti / Best regards
Andrea Cerrito
^^^^^^^^^^^^^^
Net.Admin @ Centro MultiMediale di Terni S.p.A.
P.zzale Bosco 3A
05100 Terni IT
Tel. +39 0744 5441330
Fax. +39 0744 5441372
> -----Messaggio originale-----
> Da: Richard A. Secor [mailto:[EMAIL PROTECTED]]
> Inviato: marted� 10 luglio 2001 22.43
> A: Scott Ramshaw; [EMAIL PROTECTED]
> Oggetto: Re: VPOPMAIL - LASTAUTH - DATE/TIME STAMP NOT RIGHT
>
>
> 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>
