Hallo zusammen!

ich habe viel über die Konfigurationsmöglichkeiten im Bezug zu PassiveMode mit Routern gelesen.

Meine proFTPD.conf:

Code:

ServerName "server"
ServerType standalone
MasqueradeAddress meiner.mine.nu
PassivePorts 49152 49162
DefaultServer on
Port 21
Umask 022
MaxInstances 30
User nobody
Group nogroup
DefaultRoot /srv
AllowOverwrite on
<Limit SITE_CHMOD>
  DenyAll
</Limit>

Mein Router leitet folgende Ports auf den Server um:
20, 21, 113, 1718 sowie für PassiveMode die Ports 49152-49162

Des Weiteren habe ich in der /etc/host folgende Zeile:

Code:

192.168.0.10    server.localhost server meiner.mine.nu

Wenn ich von intern zum server connecte, gibt es keine Probleme. Verbinde ich mich aber zum Server über die DynDN-Adresse (meiner.mine.nu), hängt der Client sich bei "227 Entering Passive Mode (192,168,0,10,192,0).
LIST " auf.

Was kann ich tun bzw. was habe ich falsch gemacht?
Danke :-)

Kurze Frage:

PathAllowFilter "\.(txt|jpg|jpeg|htm|html|shtm|shtml|css|gif|php|phtml|inc|php3|php4|ini|js|doc|xls|htacces|htpasswd|style|tpl|psd|ico|cap|jar|class|cfg|png|sql)$"
Funktioniert.
Nur wie bekomme ich da noch rein, dass Ordner (die gewöhnlicher weise ohne Extension sind) erstellt werden können?

Beispiel:
Ich kann nun z.B. irgendwas.txt hochladen, aber keinen Ordner "hallo" erstellen...

Danke.

Kleine Sache hab ich noch (bitte):

Ich kann auf dem Server nur mit der Standartkofniguration zugreifen.
Ich benutze folgende Konfig:

Code:

ServerName "SERVERNAME"
ServerType standalone
DefaultServer on
Port 21
Umask 022
MaxInstances 30
User nobody
Group nogroup

# 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 on
#AllowRetrieveRestart on

# Jail all users into their virtual home dir
DefaultRoot ~
#RequireValidShell off

# Logging options
TransferLog /var/log/proftpd.xferlog

# Some logging formats
LogFormat auth "%v [%P] %h %t \"%r\" %s"

# Record all logins
ExtendedLog /var/log/proftpd.auth_log AUTH auth

#------------------------mysql Modul: 4.x
# Zugangskontrolle
SQLAuthTypes Plaintext
SQLAuthenticate users*
SQLConnectInfo ftpserver @localhost ftpserver SAGICHNICHT
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

Der Server startet einwandfrei. Aber ich kann dann nicht mehr drauf zugreifen.
Folgende MySQL-Tabellen (in der Datenbank "ftpserver") sind angelegt:

Code:

# phpMyAdmin MySQL-Dump
# version 2.4.0
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Erstellungszeit: 20. April 2004 um 13:30
# Server Version: 3.23.55
# PHP-Version: 4.3.1
# Datenbank: `ftpserver`
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `quotalimits`
#

CREATE TABLE quotalimits (
  name varchar(30) default NULL,
  quota_type enum('user','group','class','all') NOT NULL default 'user',
  per_session enum('false','true') NOT NULL default 'false',
  limit_type enum('soft','hard') NOT NULL default 'soft',
  bytes_in_avail float NOT NULL default '0',
  bytes_out_avail float NOT NULL default '0',
  bytes_xfer_avail float NOT NULL default '0',
  files_in_avail int(10) unsigned NOT NULL default '0',
  files_out_avail int(10) unsigned NOT NULL default '0',
  files_xfer_avail int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `quotatallies`
#

CREATE TABLE quotatallies (
  name varchar(30) NOT NULL default '',
  quota_type enum('user','group','class','all') NOT NULL default 'user',
  bytes_in_used float NOT NULL default '0',
  bytes_out_used float NOT NULL default '0',
  bytes_xfer_used float NOT NULL default '0',
  files_in_used int(10) unsigned NOT NULL default '0',
  files_out_used int(10) unsigned NOT NULL default '0',
  files_xfer_used int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `users`
#

CREATE TABLE users (
  username varchar(60) binary default NULL,
  uid int(11) default NULL,
  gid int(11) default NULL,
  password varchar(30) default NULL,
  homedir varchar(250) default NULL,
  count int(11) default NULL,
  ui bigint(20) NOT NULL auto_increment,
  shell varchar(60) default NULL,
  letzter_zugriff datetime default NULL,
  zugang char(1) default NULL,
  PRIMARY KEY  (ui)
) TYPE=ISAM PACK_KEYS=1;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `xfer_stat`
#

CREATE TABLE xfer_stat (
  username tinytext,
  filename text,
  size bigint(20) default NULL,
  host tinytext,
  ip tinytext,
  aktion tinytext,
  dauer tinytext,
  zeit_lokal datetime default NULL,
  success char(1) default NULL,
  ui bigint(20) NOT NULL auto_increment,
  PRIMARY KEY  (ui)
) TYPE=MyISAM;

Woran kann das liegen?

ES FUNKTIONIERT!!!!
DANKE DANKE DANKE:

Folgendes: Die Datei /usr/local/var/proftpd/proftpd.scoreboard existierte nicht.
Eine leere Textdatei hat abhilfe verschaffen und ProFTPD hat diese reichlich gefüllt ;-)


DANKE!!!

Hab ich gemacht:
Ich habe aber vorher die Beispiel-Konfiguration von euch (ohne SQL,...) benutzt:

server:/proftpd/proftpd-1.2.9 # ./proftpd -nd5
 - parsing '/usr/local/etc/proftpd.conf' configuration
 - <Directory />: adding section for resolved path '/'
server.local -
server.local - Config for SERVERNAME:
server.local - /
server.local -  AllowOverwrite
server.local -  Umask
server.local - DefaultServer
server.local - Umask
server.local - UserID
server.local - UserName
server.local - GroupID
server.local - GroupName
server.local - DefaultRoot
server.local - error opening scoreboard: No such file or directory
server:/proftpd/proftpd-1.2.9 #

Das Wars...

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....

in der proftpd.conf:
Include sql://ftpserver:SAGICHNICHT@localhost/db:ftpserver/ctxt:ftpctxt/conf:ftpconf/map:ftpmap

Dann habe ich die MySQL-Querrys erneut eingetragen, die du mir hier http://www.proftpd.de/forum2/viewtopic.php?p=4980#4980 gegeben hast (aber vorher Standalone in Inetd geändert). Datensätze sind drin.

In der /etc/xinetd.conf:

#proftpd: Konfigurationen liegen in MySQL
service ftp
{
   socket_type     = stream
   protocol        = tcp
   wait            = no
   user            = root
   server          = /proftpd/proftpd-1.2.9/proftpd
   disable      = no
}

Danach:
server:/ # /etc/init.d/xinetd restart
Shutting down xinetd:                                                   done
Starting INET services. (xinetd)                                     done

Anschließend bin ich in den Konquer gegangen und habe folgendes aufgerufen:
ftp://localhost:21

Folgendes kam binnen 1er Sekunde zurück:
Beim Laden von ftp://localhost:21 ist folgender Fehler aufgetreten:
Keine Verbindung zu Rechner localhost

Auf mit ps aux finde ich nirgens den proftpd...

Was tun?

Zusatz:
server:/ # /proftpd/proftpd-1.2.9/proftpd
server.local - error opening scoreboard: No such file or directory
server:/ #

was ist denn falsch bzw was muss geändert werden?

Also XINet.de bzw. (im Kontrollzentrum) inet.d sind aktiv.

Ich probieres es gleich mal aus und starte xinetd mit /etc/init.d/xinetd restart neu....

.... ne, bringt nichts:
ftp://192.168.0.2:21
->Beim Laden von ftp://192.168.0.2:21 ist folgender Fehler aufgetreten:
-> Keine Verbindung zu Rechner 192.168.0.2

Danke im Voraus.

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

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.

Also, nicht aufregen, erst lesen:
ProFtpd ist korrekt konfiguriert und installiert.
In der XINetd.conf steht folgendes drin:

service ftp
{
   socket_type     = stream
   protocol        = tcp
   wait            = no
   user            = root
   server          = /proftpd/proftpd-1.2.9/proftpd
}


Aber selbst nach einen Neustart der Suse 8.2-Maschine läuft der Proftpd nicht...
Ich kann weder Local noch Extern connecten.

Der Aufruf /proftpd/proftpd-1.2.9/proftpd -t
Checking syntax of configuration file
Syntax check complete.

Die proftpd.conf:

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

Auf die MySQL-Tabellen sind korrekt erstellt worden...

So, was ist denn nun schon wieder? ;-)

Danke für eure Hilfe!

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

@Stonki: Vielen lieben Dank für die Bemühungen.

Ich probier es weiter. Ich werde wohl erstmal mein System neu aufspielen und dann alles Schritt für Schritt ausprobieren!

Danke für eure Hilfe (seit schon ein TOP-Support Team). Ihr solltet euch bei www.awards.de anmelden.

Also, die pfade habe ich überprüft, da ist alles in ordnung.
und die mod_sql.h liegt wie schon gesagt in beiden dirs.

(Ich weiß, ist ne doofe frage, aber kann mir an dieser Stelle jemand ein ähnliches Produkt empfehlen (ebenfals mit SQl und Quota-Unterstützung) wofür es schon rpm's für suse gibt)?

Warum existieren eigentlich keine rpm's für Suse?