|
Titel: mod_conf_sql Beitrag von: malibubu am 19. April 2004, 16:38:17 Hallöchen,
Ihr erinnert euch mit Sicherheit an mich (der ProFtpd auf nem Suse nicht zu laufen bekommen hat). Nach einer Neureinkanation des Systems ;-) habe ich auch ProFtpD ohne Probleme ans laufen gebracht. Das Modul mod_conf_Sql habe ich ebenfalls mit erstellt. Die Datensätze habe ich angelegt, aber nun habe ich eine Frage: Wo bzw. wie kommen die Configurationen rein? Wenn ich ProftpD mit -c sql://..... starte, brauche ich dann überhaupt die proftpd.conf noch??? Danke im Voraus.. Ciao Titel: mod_conf_sql Beitrag von: Wörsty am 19. April 2004, 17:47:29 Jein. Die brauchst du nicht mehr - lies mal die Doku.
Die Konfiguration kannst du konvertieren Code: conf2sql.pl --dbdriver=mysql --dbname=proftpd --dbuser=foo --dbpass=bar --dbserver=localhost /etc/proftpd.conf Das Modul hat bei meinen Tests aber noch Bugs gehabt: :arrow: http://www.proftpd.de/forum2/viewtopic.php?t=218 :arrow: http://castaglia.proftpd.de/modules/mod_conf_sql.html Für mich mach ich das so: Code: proftpd.conf: Include sql://ftp:ftp@localhost/db:ftp/ctxt:ftpctxt/conf:ftpconf/map:ftpmap Import ./conf2sql.pl --dbdriver=mysql --dbname=ftp --dbuser=ftp --dbpass=ftp --dbserver=localhost --verbose /www/conf/proftpd.conf Export ./sql2conf.pl --dbdriver=mysql --dbname=ftp --dbuser=ftp --dbpass=ftp --dbserver=localhost --verbose Titel: mod_conf_sql Beitrag von: malibubu am 19. April 2004, 17:59:24 hm, ok.
Aber bei mir kommt mal wieder eine Reihe von Fehlermeldungen: perl conf2sql.pl --dbdriver=mysql --dbname=ftpserver --dbuser=ftpserver --dbpass=SAGICHNICHT --dbserver=localhost /usr/local/etc/proftpd.conf AUSGABE: Code: DBD::mysql::st execute failed: Unknown column 'value' in 'field list' at conf2sq l.pl line 183. DBD::mysql::st execute failed: Unknown column 'value' in 'where clause' at conf2 sql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 156. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: You have an error in your SQL syntax near ')' at line 1 at conf2sql.pl line 183. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at l ine 1 at conf2sql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 238. DBD::mysql::st execute failed: Unknown column 'name' in 'field list' at conf2sql .pl line 183. DBD::mysql::st execute failed: Unknown column 'name' in 'where clause' at conf2s ql.pl line 183. DBD::mysql::st fetchrow_array failed: fetch() without execute() at conf2sql.pl l ine 216. DBD::mysql::st execute failed: You have an error in your SQL syntax near ' )' at line 1 at conf2sql.pl line 183. Titel: mod_conf_sql Beitrag von: Wörsty am 19. April 2004, 18:25:27 Mail mir die Konfig oder poste sie hier und ich konvertiere sie dir.
Auf Fehleranalyse im Perl-Script habe ich jetzt keinen Bock :roll: :oops: Obwohl - DBD::mysql::st execute failed: Unknown column 'value' in 'field list' at conf2sql.pl line 183. DBD::mysql::st execute failed: Unknown column 'value' in 'where clause' at conf2sql.pl line 183. Das macht mich stutzig... Wie heißen deine DB-Felder? Titel: mod_conf_sql Beitrag von: malibubu am 19. April 2004, 18:34:06 Also, die MySQL-Felder heißen so, wie er im Beispiel in der Manual zu mod_conf_sql.
Hier meine Conf: (Kann ich diese hinterher in der MySQL-Datenbank noch ändern?) Code: ServerName "SERVER" ServerType standalone ServerAdmin support@server ServerIdent on "localhost" DeferWelcome on DefaultServer on Port 21 Umask 022 MaxInstances 30 # Normally, we want files to be overwriteable. <Directory /> AllowOverwrite on </Directory> # FXP Unterstuetzung AllowForeignAddress off # Maximal Werte setzen MaxClientsPerHost 2 "Nicht mehr als %m Verbindungen" MaxClients 50 "Leider sind schon %m Clients verbunden" MaxLoginAttempts 3 # Restart erlauben AllowStoreRestart off AllowRetrieveRestart off # Jail all users into their virtual home dir DefaultRoot ~ RequireValidShell off # Logging options TransferLog /var/log/proftpd.xferlog # Some logging formats LogFormat default "%h %l %u %t \"%r\" %s %b" LogFormat auth "%v [%P] %h %t \"%r\" %s" LogFormat write "%h %l %u %t \"%r\" %s %b" # Log file/dir access ExtendedLog /var/log/proftpd.access_log WRITE,READ write # Record all logins ExtendedLog /var/log/proftpd.auth_log AUTH auth #------------------------mysql Modul: 4.x # Zugangskontrolle SQLAuthTypes Plaintext SQLAuthenticate users* SQLConnectInfo ftpserver @localhost ftpserver PASSWORT SQLDefaultGID 65534 SQLDefaultUID 65534 SQLMinUserGID 100 SQLMinUserUID 500 SQLUserInfo users username password uid gid homedir shell # aktive SQL Kommandos, ab hier passiert etwas :-) SQLLog PASS counter SQLNamedQuery counter UPDATE "letzter_zugriff=now(), count=count+1 WHERE username='%u'" users # xfer Log in mysql SQLLog RETR,STOR transfer1 SQLNamedQuery transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T',now(), 'c', NULL" xfer_stat SQLLOG ERR_RETR,ERR_STOR transfer2 SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T',now(), 'i', NULL" xfer_stat # mod_quota tab QuotaEngine on QuotaShowQuotas on QuotaLimitTable sql:/get-quota-limit QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session,limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits WHERE name = '%{0}' AND quota_type = '%{1}'" SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies WHERE name = '%{0}' AND quota_type = '%{1}'" SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'" quotatallies SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies DANKE!! ;-) Kannst du dir das mal angucken (bitte ;-))): http://www.proftpd.de/forum2/viewtopic.php?p=4982#4982 Titel: mod_conf_sql Beitrag von: Wörsty am 19. April 2004, 19:23:43 Ja. Kannst du noch ändern.
Code: # MySQL-Front Dump 2.5 USE ftpserver; # # Table structure for table 'ftpconf' # DROP TABLE IF EXISTS `ftpconf`; CREATE TABLE `ftpconf` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `value` blob, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM COMMENT='Direktiven'; # # Dumping data for table 'ftpconf' # INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("1", "ServerName", "\"SERVER\""); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("2", "ServerType", "standalone"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("3", "ServerAdmin", "support@server"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("4", "ServerIdent", "on \"localhost\""); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("5", "DeferWelcome", "on"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("6", "DefaultServer", "on"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("7", "Port", "21"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("8", "Umask", "022"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("9", "MaxInstances", "30"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("10", "AllowForeignAddress", "off"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("11", "MaxClientsPerHost", "2 \"Nicht mehr als %m Verbindungen\""); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("12", "MaxClients", "50 \"Leider sind schon %m Clients verbunden\""); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("13", "MaxLoginAttempts", "3"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("14", "AllowStoreRestart", "off"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("15", "AllowRetrieveRestart", "off"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("16", "DefaultRoot", "~"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("17", "RequireValidShell", "off"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("18", "TransferLog", "/var/log/proftpd.xferlog"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("19", "LogFormat", "default \"%h %l %u %t \\\"%r\\\" %s %b\""); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("20", "LogFormat", "auth \"%v [%P] %h %t \\\"%r\\\" %s\""); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("21", "LogFormat", "write \"%h %l %u %t \\\"%r\\\" %s %b\""); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("22", "ExtendedLog", "/var/log/proftpd.access_log WRITE,READ write"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("23", "ExtendedLog", "/var/log/proftpd.auth_log AUTH auth"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("24", "SQLAuthTypes", "Plaintext"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("25", "SQLAuthenticate", "users*"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("26", "SQLConnectInfo", "ftpserver @localhost ftpserver PASSWORT"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("27", "SQLDefaultGID", "65534"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("28", "SQLDefaultUID", "65534"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("29", "SQLMinUserGID", "100"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("30", "SQLMinUserUID", "500"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("31", "SQLUserInfo", "users username password uid gid homedir shell"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("32", "SQLLog", "PASS counter"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("33", "SQLNamedQuery", "counter UPDATE \"letzter_zugriff=now(), count=count+1 WHERE username=\'%u\'\" users"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("34", "SQLLog", "RETR,STOR transfer1"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("35", "SQLNamedQuery", "transfer1 INSERT \"\'%u\', \'%f\', \'%b\', \'%h\', \'%a\', \'%m\', \'%T\',now(), \'c\', NULL\" xfer_stat"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("36", "SQLLOG", "ERR_RETR,ERR_STOR transfer2"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("37", "SQLNamedQuery", "transfer2 INSERT \"\'%u\', \'%f\', \'%b\', \'%h\', \'%a\', \'%m\', \'%T\',now(), \'i\', NULL\" xfer_stat"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("38", "QuotaEngine", "on"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("39", "QuotaShowQuotas", "on"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("40", "QuotaLimitTable", "sql:/get-quota-limit"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("41", "QuotaTallyTable", "sql:/get-quota-tally/update-quota-tally/insert-quota-tally"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("42", "SQLNamedQuery", "get-quota-limit SELECT \"name, quota_type, per_session,limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits WHERE name = \'%{0}\' AND quota_type = \'%{1}\'\""); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("43", "SQLNamedQuery", "get-quota-tally SELECT \"name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies WHERE name = \'%{0}\' AND quota_type = \'%{1}\'\""); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("44", "SQLNamedQuery", "update-quota-tally UPDATE \"bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = \'%{6}\' AND quota_type = \'%{7}\'\" quotatallies"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("45", "SQLNamedQuery", "insert-quota-tally INSERT \"%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}\" quotatallies"); INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("46", "AllowOverwrite", "on"); # # Table structure for table 'ftpctxt' # DROP TABLE IF EXISTS `ftpctxt`; CREATE TABLE `ftpctxt` ( `id` int(10) unsigned NOT NULL auto_increment, `parent_id` int(10) unsigned default NULL, `name` varchar(255) default NULL, `value` varchar(255) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM COMMENT='Kontexte'; # # Dumping data for table 'ftpctxt' # INSERT INTO `ftpctxt` (`id`, `parent_id`, `name`, `value`) VALUES("1", NULL, "default", NULL); INSERT INTO `ftpctxt` (`id`, `parent_id`, `name`, `value`) VALUES("2", "1", "Directory", "/"); # # Table structure for table 'ftpmap' # DROP TABLE IF EXISTS `ftpmap`; CREATE TABLE `ftpmap` ( `conf_id` int(10) unsigned NOT NULL default '0', `ctxt_id` int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM COMMENT='Direktiven2Kontexte'; # # Dumping data for table 'ftpmap' # INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("1", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("2", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("3", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("4", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("5", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("6", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("7", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("8", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("9", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("10", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("11", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("12", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("13", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("14", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("15", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("16", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("17", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("18", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("19", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("20", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("21", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("22", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("23", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("24", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("25", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("26", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("27", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("28", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("29", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("30", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("31", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("32", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("33", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("34", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("35", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("36", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("37", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("38", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("39", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("40", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("41", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("42", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("43", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("44", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("45", "1"); INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("46", "2"); |