www.ProFTPD.de
13. März 2007, 20:11:48 *
Willkommen Gast. Bitte einloggen oder registrieren.
Haben Sie Ihre Aktivierungs E-Mail übersehen?

Einloggen mit Benutzername, Passwort und Sitzungslänge
News: SMF - Neu installiert!
 
   Übersicht   Hilfe Suche Login Registrieren  
Seiten: [1]   Nach unten
  Drucken  
Autor Thema: mod_conf_sql  (Gelesen 616 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
malibubu
ProFTPD
*
Offline Offline

Beiträge: 25


Profil anzeigen
« 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
Gespeichert
Wörsty
Moderator
ProFTPD
*****
Offline Offline

Beiträge: 1602


50772603
Profil anzeigen WWW E-Mail
« Antwort #1 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  
Gespeichert

RedHat 8.0 (2.4er Kernel)
proftpd 1.2.10
-mod_sql_mysql
-mow_wrap
-mod_exec
-mod_ifsession[/size]
malibubu
ProFTPD
*
Offline Offline

Beiträge: 25


Profil anzeigen
« Antwort #2 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.
Gespeichert
Wörsty
Moderator
ProFTPD
*****
Offline Offline

Beiträge: 1602


50772603
Profil anzeigen WWW E-Mail
« Antwort #3 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?
Gespeichert

RedHat 8.0 (2.4er Kernel)
proftpd 1.2.10
-mod_sql_mysql
-mow_wrap
-mod_exec
-mod_ifsession[/size]
malibubu
ProFTPD
*
Offline Offline

Beiträge: 25


Profil anzeigen
« Antwort #4 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
Gespeichert
Wörsty
Moderator
ProFTPD
*****
Offline Offline

Beiträge: 1602


50772603
Profil anzeigen WWW E-Mail
« Antwort #5 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");
Gespeichert

RedHat 8.0 (2.4er Kernel)
proftpd 1.2.10
-mod_sql_mysql
-mow_wrap
-mod_exec
-mod_ifsession[/size]
Seiten: [1]   Nach oben
  Drucken  
 
Gehe zu:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Prüfe XHTML 1.0 Prüfe CSS
Seite erstellt in 0.079 Sekunden mit 16 Zugriffen.