[make clean]

1. Mache mal make clean und poste alle Ausgaben.
2. Benutze mal die Forensuche "make"- eventuell findest du da schon was

Ja. READ und WRITE  :RTFM  
 :arrow: KLICK MICH!:wink:

*grrrrrr* :roll:

Wollte ich gerade posten.
Hatte schon alles getippt :lol:

Hauptsache geht :wink:

[2. Servertyp: Standalone]

HM, habe mir nochmal alles gut durchgelsesen:
1. Die Conf-Daten habe ich wieder in der proftpd.conf.
2. Servertyp: Standalone
3. Das BachScript von eurer Seite für Suse 8.2 runtergeladen und in /etc/inet.d/ gepackt. -> Ausführungsrechte....
4. Mit RunLeveleditor ProFtpd in Runlevel 2.3.5 gepackt (Richtig?)
4a. Versucht zu starten (hat funktioniert -> done).
4b. ftp://192.168.0.2:21/ -> Keine Verbindung,... blabla
4c. Status im Runlevel-Editor aktualisiert -> ProFTPd war wieder aus (Unused).
4d. Versucht, den ProFTpd zu starten (Fehlercode 7 - Failed).

Was nun? Erst funzt es, dann nicht,... Hm....

Wieso?

Mein Tipp:

Nimm mal den Dienst aus dem xinetd weg
Stelle den Servertype auf standalone
Starte proftpd mit proftpd -nd5
Gucke die Ausgabe an
Wenn alles ok mache den Dienst wieder im xinetd an
Stelle den Servertype wieder auf inetd
Benutze die Logfiles...
Benutze fuser -n tcp 21 (Forensuche für Details)

Mit ziemlicher Sicherheit hast du einen Fehler bei deinen MySQL Daten für die Benutzerverwaltung.

Mach mal

Code:

ls -la /var/log/

und starte mal mit

Code:

proftpd -nd9

Code:

ServerType inetd

...und gut is

[ServerType standalone]

ServerType standalone
Leeeeesen :idea:  :roll:

 :arrow: ServerType

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");

[Unknown column 'value']

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?

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  

Code:

proftpd -c datei

Na dahin wo du die proftpd Quellen entpackt hast.

bin ich da im falschen verzeichnis

Denke schon.

[LsDefaultOptions ""]

Wenn der Server als ServerType inetd läuft muß er eigentlich nicht neu gestartet werden.
LsDefaultOptions "" wäre andererseits eigentlich korrekt.
Das hieß bei alten Versionen (<1.1.6) mal ShowDotFiles.
Also frag mich nicht :?