Bandwidth accounting

Thomas Goirand <[email protected]> Fri, 23 Dec 2005 05:33:21 +0100
Newsgroups gmane.network.pureftpd.user
Message-ID <[email protected]>
Hello,

I've been using proftpd-mysql for a while, and I'm trying to switch to 
pure-ftpd-mysql. It's working well, and my hosting control panel is now 
supporting pure-ftpd (the installer does the necessary automatic 
configurations for using mysql and chroot for everyone).

Under proftpd I was doing my bandwidth accounting the following way:

# // Count the uploaded bytes
SQLLog STOR           ulbytescount
SQLNamedQuery         ulbytescount UPDATE "ul_bytes=ul_bytes+%b WHERE 
login='%u'" ftp_access

# // Count the uploaded files
SQLLog STOR           ulcount
SQLNamedQuery         ulcount UPDATE "ul_count=ul_count+1 WHERE 
login='%u'" ftp_access

All the traffic is accounted to the user. Is there a way to do it with 
pure-ftpd? If it's not possible, does pure-ftpd writes somewhere in it's 
logs the amount transfered so I can write a very simple daemon to keep 
track of it in my mysql tables?

Thomas Goirand, GPLHost LLC Manager

-- 
http://www.gplhost.com
GPLHost:>_ Opensource hosting worldwide
Webspaces featuring GPL control panel


---------------------------------------------------------------------
To post a new message, e-mail: [email protected]
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]