[vchkpw] bandwidth monitoring

[Nick Twaddell]

So is there anyway to monitor traffic on customers email virtualhosts?
So i can keep track of the bandwidth their domain is using through
qmail?

[vchkpw] qmail+vpopmail+mysql

[Nick Twaddell]

Ok, I compiled vpopmail with mysql support.  I want to store the open
relay information in a mysql table.  It looks like its saving all the
ips into the table. So I compiled tcpserver with the mysql patch, made a
/var/qmail/control/mysql file.  Now how do I set tcpserver to use this
file?  Someone told me to just add -S and it should work.  So now I have
this in my qmail-smtpd startup file...

#!/bin/sh
QMAILDUID=`id -u qmaild`
NOFILESGID=`id -g qmaild`
MAXSMTPD=`cat /var/qmail/control/concurrencyincoming`
LOCAL=`head -1 /var/qmail/control/me`
if [ -z $QMAILDUID -o -z $NOFILESGID -o -z $MAXSMTPD -o -z
$LOCAL ]; then
echo QMAILDUID, NOFILESGID, MAXSMTPD, or LOCAL is unset in
echo /var/qmail/supervise/qmail-smtpd/run
exit 1
fi
exec /usr/local/bin/softlimit -m 200 \
/usr/local/bin/tcpserver -v -R -l $LOCAL -S -c $MAXSMTPD \
-u $QMAILDUID -g $NOFILESGID 0 smtp
/var/qmail/bin/qmail-smtpd 21

Am I doing this right?  How can I test tcpserver to see if its reading
the sql db?

Thanks

Nick