Hello Guys,
I'm using postfix+Courier IMAP in a mail system where users are stored
on MySQL tables. It's working fine, postfix use those users to receive their
messages and courier-imap use those users to allow mail checking over IMAP
and POP3.
As I have LOTS of users on this system, I was thinking on some report
that would give me inactive users ( that means, users that dont login to
check messages for more than XX hours/days/months ... ). To implement that,
I could make a huge script that using information of /var/log/maillog and
users on MySQL table could give that information.
I'm not that good on programming, so I was wondering a very simple
solution. Is it possible to configure courier-imap to issue a SQL command on
MySQL for every logged user ? If yes, I would do something like "UPDATE
users set last_check=now() where address = %s' .....
Doing this, I could grab all inactive users using simple MySQL queries
relating the last_check and now().
Question: is this possible ? Is this possible with some hacking on
courier-imap code ?
Hope hearing from you soon,
Leonardo Rodrigues
-------------------------------------------------------
This SF.net email is sponsored by: ApacheCon, November 18-21 in
Las Vegas (supported by COMDEX), the only Apache event to be
fully supported by the ASF. http://www.apachecon.com
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
