Proftpd und SQL

[Pawel]

Hallo,
hab Probleme mit SQL.
Hier Auszug aus proftpd.conf:

Code:

# Reject Root-Login and require valid shell
<Global>
DefaultRoot ~
RootLogin off
RequireValidShell off
</Global>

SQLAuthTypes Plaintext
SQLAuthenticate users* groups*
SQLConnectInfo syscp@localhost syscp blabla
SQLUserInfo ftp_users username password uid gid homedir shell
SQLGroupInfo ftp_groups groupname gid members
SQLUserWhereClause "login_enabled = 'Y'

SQLLog PASS login
SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1, down_bytes=down_bytes+%b where username='%u'" ftp_users

SQLLog RETR download
SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b where username='%u'" ftp_users

SQLLog STOR upload
SQLNamedQuery upload update "up_count=up_count+1, up_bytes=up_bytes+%b where username='%u'" ftp_users

# increase speed

Das Datenbank syscp exiestiert,
Die Tabelle  ftp_users exiestiert
Der User web3  exiestiert Passw. ist auch OK
Proftpd gestartet und ohne Fehler läuft.

Von einem anderem Rechner:

Code:

pawel@papi:~> ftp domain.org
Connected to p508xxxx.dip0.t-ipconnect.de.
220 ProFTPD 1.2.10 Server (ProFTPD Default Installation) [80.134.23.xxx]
Name (domain.org:pawel): web3
331 Password required for web3.
Password:
530 Login incorrect.
ftp: Login failed.

Domain und IP manuel hier geändert
Noch was, Server hängt hinter einem DSL und Friwall, Port 21 ist offen. Mit Standart Konfig. und anonmy ging es.

In /var/log/messages steht:

Code:

Dec 31 19:14:33 pawnic proftpd[8672]: pawnic.manu.linux (192.168.0.11[192.168.0.11]) - FTP session opened.
Dec 31 19:14:42 pawnic proftpd[8672]: pawnic.manu.linux (192.168.0.11[192.168.0.11]) - no such user 'web3'
Dec 31 19:14:42 pawnic proftpd[8672]: pawnic.manu.linux (192.168.0.11[192.168.0.11]) - USER web3: no such user found from 192.168.0.11
[192.168.0.11] to 80.134.23.xxx:21

Mein System:
SUSE 9.1
MySQL: 4.0.18
phpMyAdmin: 2.6.0-pl3
ProFTPD ist mit mod_sql konfiguriert und installiert. Verzeichnisse und Rechte sind IO.

Frage: warum: no such user found?? Wo soll ich den Fehler suchen?

Guten Rutsch ins Neuses Jahr, und alles gute.

Pawel

[stonki]

in die proftpd.conf:
SQLLOGFILE /var/log/proftpd.sqllog

proFTPD neu starten, sich das logfile anschauen. Bei Bedarf mit den Angaben aus dem Log weiter fragen.

[Pawel]

Hallo stonki,

Gemacht wie Du gesagt hast,
Leider die Logfile ist leer. Das hab ich schon früher geprüft, leider wie gesagt, die logfile wird leer

Pawel

[Pawel]

Vorher habe ich die Datei angelegt:

touch proftpd.log
Pawel

[Pawel]

Hi,

weil ich die Logdatei nicht bekomme, warum, hat einer eine Idee warum?

Ich habe das ProFTPD von Konsole gestartet mit Debug, hier der Auszug. Kann mir jemand das kommentieren?.

Code:

pawnic:/etc # proftpd -nd7
 - parsing '/usr/local/etc/proftpd.conf' configuration
 - dispatching auth request "getpwnam" to module mod_sql
 - dispatching auth request "getpwnam" to module mod_auth_file
 - dispatching auth request "getpwnam" to module mod_auth_unix
 - dispatching auth request "getgrnam" to module mod_sql
 - dispatching auth request "getgrnam" to module mod_auth_file
 - dispatching auth request "getgrnam" to module mod_auth_unix
pawnic.manu.linux -
pawnic.manu.linux - Config for ProFTPD Default Installation:
pawnic.manu.linux - ~ftp/
pawnic.manu.linux -  Limit
pawnic.manu.linux -   DenyAll
pawnic.manu.linux -  UserName
pawnic.manu.linux -  GroupName
pawnic.manu.linux -  UserAlias
pawnic.manu.linux -  MaxClients
pawnic.manu.linux -  DisplayLogin
pawnic.manu.linux -  DisplayFirstChdir
pawnic.manu.linux -  Umask
pawnic.manu.linux -  AllowOverwrite
pawnic.manu.linux - Limit
pawnic.manu.linux -  DenyAll
pawnic.manu.linux - DefaultServer
pawnic.manu.linux - Umask
pawnic.manu.linux - UserID
pawnic.manu.linux - UserName
pawnic.manu.linux - GroupID
pawnic.manu.linux - GroupName
pawnic.manu.linux - AllowOverwrite
pawnic.manu.linux - Bind
pawnic.manu.linux - dispatching auth request "getgroups" to module mod_sql
pawnic.manu.linux - dispatching auth request "getgroups" to module mod_auth_file
pawnic.manu.linux - dispatching auth request "getgroups" to module mod_auth_unix
pawnic.manu.linux - opening scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
pawnic.manu.linux - ProFTPD 1.2.10 (stable) (built Fri Dec 31 03:59:44 CET 2004) standalone mode STARTUP
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - FTP session requested from unknown class
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - performing module session initializations
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - opening scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - performing ident lookup
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - ident connection failed: Connection refused
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - ident lookup returned 'UNKNOWN'
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - connected - local  : 80.134.11.57:21
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - connected - remote : 192.168.0.11:33110
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - FTP session opened.
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching PRE_CMD command 'USER web3ftp1' to mod_core
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching PRE_CMD command 'USER web3ftp1' to mod_core
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching PRE_CMD command 'USER web3ftp1' to mod_auth
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endpwent" to module mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endpwent" to module mod_auth_file
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endpwent" to module mod_auth_unix
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endgrent" to module mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endgrent" to module mod_auth_file
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endgrent" to module mod_auth_unix
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching CMD command 'USER web3ftp1' to mod_auth
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "getgroups" to module mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "getgroups" to module mod_auth_file
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "getgroups" to module mod_auth_unix
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - no supplemental groups found for user 'web3ftp1'
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching POST_CMD command 'USER web3ftp1' to mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching LOG_CMD command 'USER web3ftp1' to mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching LOG_CMD command 'USER web3ftp1' to mod_log
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endpwent" to module mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endpwent" to module mod_auth_file
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endpwent" to module mod_auth_unix
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endgrent" to module mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endgrent" to module mod_auth_file
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endgrent" to module mod_auth_unix
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching CMD command 'PASS (hidden)' to mod_auth
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "getgroups" to module mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "getgroups" to module mod_auth_file
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "getgroups" to module mod_auth_unix
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - no supplemental groups found for user 'web3ftp1'
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "getpwnam" to module mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "getpwnam" to module mod_auth_file
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "getpwnam" to module mod_auth_unix
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - no such user 'web3ftp1'
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - USER web3ftp1: no such user found from 192.168.0.11 [192.168.0.11] to 80.134.11.57:21
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - FTP login timed out, disconnected
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endpwent" to module mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endpwent" to module mod_auth_file
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endpwent" to module mod_auth_unix
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endgrent" to module mod_sql
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endgrent" to module mod_auth_file
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - dispatching auth request "endgrent" to module mod_auth_unix
pawnic.manu.linux (192.168.0.11[192.168.0.11]) - FTP session closed.

Frohes Neues Jahr.

Pawel

[Anonymous]

Hi,
jetzt weiss ich
 

Code:

pawnic:/etc # proftpd -nd7
  - parsing '/usr/local/etc/proftpd.conf' configuration
.........

Warum liest das Proftpd die configfile aus /usr/local/etc/?
Das war mein Problem

Pawel

[Pawel]

Lösung bei mir (es kann sein wegen meiner Einstellungen, sagen wir so die sind bisschen anders ;-)

In der Datei:
/etc/init.d/proftpd
musste ich ergänzen auf:

Code:

 # See how we were called.
 case "$1" in
 start)
 echo -n "Starte proFTPd: "
 $PROFTP -c /etc/proftpd.conf
 #echo
 touch /var/lock/subsys/proftpd

Pawel