Re: [vchkpw] Re: MySQL logging
On Aug 24, 2004, at 6:19 AM, Maurice Snellen wrote: Have you thought of writing a script in perl and run it in the crontab? I have (although not specifically in perl), but that would require directly interfacing with MySQL and thus exposing the user/password combination in yet another place. If the script is owned by vpopmail (or root), and run in the vpopmail (or root) crontab, then it would have permissions to read the ~vpopmail/etc/vpopmail.mysql file to get the password information. Even if you embedded it in the script, you could make the file readable only by root. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] Re: MySQL logging
If the script is set to only be readable and executable by root then it shouldn't be too big of a problem unless you really have that many people with root access. There is no where that I know of in vpopmail to automatically keep tabs on the amount of records in the vlog table. That's why I had added it as a feature in my Customer Support Pages: https://sourceforge.net/projects/vpopmail-vlog/ Richard A. Secor [EMAIL PROTECTED] Sequential Logic http://www.seqlogic.com/ +1.914.494.0751 On Aug 24, 2004, at 09:19, Maurice Snellen wrote: On Tuesday, August 24, 2004 at 08:42 (which was Tuesday, August 24, 2004 at 14:42 where I am) Richard A. Secor wrote: Have you thought of writing a script in perl and run it in the crontab? I have (although not specifically in perl), but that would require directly interfacing with MySQL and thus exposing the user/password combination in yet another place. This is why I was looking for a more 'formal' way to solve this. -- Greetings, Maurice PS: please trim quotes to context.
[vchkpw] Re: MySQL logging
On Tuesday, August 24, 2004 at 08:42 (which was Tuesday, August 24, 2004 at 14:42 where I am) Richard A. Secor wrote: > Have you thought of writing a script in perl and run it in the crontab? I have (although not specifically in perl), but that would require directly interfacing with MySQL and thus exposing the user/password combination in yet another place. This is why I was looking for a more 'formal' way to solve this. -- Greetings, Maurice PS: please trim quotes to context.