proftpd migration issue
Mario Caruso <[email protected]> Fri, 25 Nov 2005 19:43:42 +0100
| Newsgroups | gmane.network.pureftpd.user |
|---|---|
| Message-ID | <[email protected]> |
Hi everybody, I'm currently working to try and migrate my company ft pserver from proftpd to pureftd, I already setup pureftpd to use mysql and virtual quotas (so I already made an improvement versus the still valid proftpd), now all I'm missing is the equivalent of proftpd SQLNamedQuery; I was using SQLNamedQuery to populate two fields of mysql table with this syntax : SQLNamedQuery updatecount UPDATE "count=count+1 where userid='%u'" USERTABLE SQLNamedQuery updatelastlogin UPDATE "tstamp=now() where userid='%u'" USERTABLE This is used in order to track a user last access and the number of times a user has logged in (both were a marketing request) I know that such information can be retrieved by parsing log files, but having it in the mysql table enables me to get the information with a simple sql command rather then use some script and hunt down tapes for old log files. thank you M. -- () ASCII Ribbon Campaign /\ Against HTML E-Mail
signature.asc
(application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.7 (GNU/Linux) iD8DBQFDh1tj9XYbM7TdPPsRAsrBAJ9bCR3td1WSzfk98KfYIAa4wO33IACfZ+CT Hz1YZCp5asDwtIdfg3eVuNs= =yhxh -----END PGP SIGNATURE-----