On Sat, Jun 25, 2005 at 05:57:42PM -0400, Pete Letkeman wrote:
> I would first like to say thanks for the help that I have already gotte=
n from this list.=20
> I would like to log as much as I can into a MySQL table(s) using Proftp=
d. I already have=20
> Proftpd using MySQL to authenciate users. I would think that logging to=
a a MySQL table(s)=20
> would speed up regular Proftpd usage.
I highly doubt that.
> Relational database systems are faster than flat=20
> text files when one is dealing with a lot of data.
Hehe I bet that logging to flat files is a whole lot faster then logging
into a full blown RDBMS. It is easier to generate fanzy reports from a RD=
but for that case I would feed my logs into a DB on a second host dedicat=
for logfile analyses.
> I noticed that this example=20
> http://proftpd.org/docs/configs/mysql_simple.conf seems to be loggin al=
l transfers to=20
> MySQL, however the table structrue is not shown and the comments are no=
t in english=20
> (German or Dutch maybe?). My guess is that I need to use a variant of t=
he following two=20
# active SQL commands, from here on something happens :-)
SQLLog PASS counter
SQLNamedQuery counter UPDATE "last_access=3Dnow(), count=3Dcount+1 WHERE =
#This query simply increments a field last_access in the table ftp
# xfer Log in mysql
SQLLog RETR,STOR transfer1
SQLNamedQuery transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T'=
, now(), 'c', NULL" xfer_stat
#here you need to look up the meta-sequenzes first aeh read the docu ;)
SQLLOG ERR_RETR,ERR_STOR transfer2
SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T'=
, now(), 'i', NULL" xfer_stat
mod_sql Documentation should help you to understand it:
Das Fernsehen ist die gr=F6=DFte kulturelle Katastrophe, die die Erde in =
an die wir uns erinnern k=F6nnen, erlebt hat.
[ Joseph Weizenbaum ]