Problem: proftpd + mysql

[TomGrill]

Hi,

hab proftpd mit mysql installiert. Wenn ich jetzt connecten will, bleibt der CLIENT nach dem USER command stehen.

Auf dem Server finde ich folgende Fehlermeldung:
/var/local/messages

Dec 16 11:32:51 linux proftpd[29916]: linux.local (192.168.1.69[192.168.1.69]) - FTP session opened.
Dec 16 11:32:51 linux proftpd[29916]: linux.local (192.168.1.69[192.168.1.69]) - ProFTPD terminating (signal 11)
Dec 16 11:32:51 linux proftpd[29916]: linux.local (192.168.1.69[192.168.1.69]) - FTP session closed.

/var/log/proftpd.sql

Dec 16 11:31:24 mod_sql/4.10[29912]: backend module 'mod_sql_mysql/4.04'
Dec 16 11:31:24 mod_sql/4.10[29912]: backend api    'mod_sql_api_v1'
Dec 16 11:31:24 mod_sql/4.10[29912]: >>> sql_getconf
Dec 16 11:31:24 mod_sql/4.10[29912]: entering   mysql cmd_defineconnection
Dec 16 11:31:24 mod_sql/4.10[29912]:  name: 'default'
Dec 16 11:31:24 mod_sql/4.10[29912]:  user: 'proftpd'
Dec 16 11:31:24 mod_sql/4.10[29912]:  host: 'localhost'
Dec 16 11:31:24 mod_sql/4.10[29912]:    db: 'proftpd'
Dec 16 11:31:24 mod_sql/4.10[29912]:  port: '3306'
Dec 16 11:31:24 mod_sql/4.10[29912]:   ttl: '0'
Dec 16 11:31:24 mod_sql/4.10[29912]: exiting    mysql cmd_defineconnection
Dec 16 11:31:24 mod_sql/4.10[29912]: backend will not be checked until first use.
Dec 16 11:31:24 mod_sql/4.10[29912]: mod_sql status     : on
Dec 16 11:31:24 mod_sql/4.10[29912]: negative_cache     : off
Dec 16 11:31:24 mod_sql/4.10[29912]: authenticate       : users groups userset groupset
Dec 16 11:31:24 mod_sql/4.10[29912]: usertable          : ftp
Dec 16 11:31:24 mod_sql/4.10[29912]: userid field       : username
Dec 16 11:31:24 mod_sql/4.10[29912]: password field     : password
Dec 16 11:31:24 mod_sql/4.10[29912]: uid field          : uid
Dec 16 11:31:24 mod_sql/4.10[29912]: gid field          : gid
Dec 16 11:31:24 mod_sql/4.10[29912]: homedir field      : homedir
Dec 16 11:31:24 mod_sql/4.10[29912]: shell field        : shell
Dec 16 11:31:24 mod_sql/4.10[29912]: homedirondemand    : false
Dec 16 11:31:24 mod_sql/4.10[29912]: group table        : groups
Dec 16 11:31:24 mod_sql/4.10[29912]: groupname field    : groupname
Dec 16 11:31:24 mod_sql/4.10[29912]: grp gid field      : gid
Dec 16 11:31:24 mod_sql/4.10[29912]: grp members field  : members
Dec 16 11:31:24 mod_sql/4.10[29912]: SQLMinUserUID      : 500
Dec 16 11:31:24 mod_sql/4.10[29912]: SQLMinUserGID      : 100
Dec 16 11:31:24 mod_sql/4.10[29912]: SQLDefaultUID      : 65534
Dec 16 11:31:24 mod_sql/4.10[29912]: SQLDefaultGID      : 65534
Dec 16 11:31:24 mod_sql/4.10[29912]: <<< sql_getconf
Dec 16 11:31:24 mod_sql/4.10[29912]: >>> cmd_endpwent
Dec 16 11:31:24 mod_sql/4.10[29912]: <<< cmd_endpwent
Dec 16 11:31:24 mod_sql/4.10[29912]: >>> cmd_endgrent
Dec 16 11:31:24 mod_sql/4.10[29912]: <<< cmd_endgrent
Dec 16 11:31:24 mod_sql/4.10[29912]: >>> cmd_getgroups
Dec 16 11:31:24 mod_sql/4.10[29912]: entering   mysql cmd_escapestring

ich kann damit leider nichts anfangen, wer kann mir helfen ?

[stonki]

Proftpd bitte mal im debug mode starten (-n -d5) und die Ausgabe auch posten.

[TomGrill]

- parsing '/etc/proftpd.conf' configuration
 - <Directory />: adding section for resolved path '/'
linux.local -
linux.local - Config for ProFTPD Default Installation:
linux.local - ~ftp/
linux.local -  Limit
linux.local -   DenyAll
linux.local -  UserName
linux.local -  GroupName
linux.local -  UserAlias
linux.local -  MaxClients
linux.local -  DisplayLogin
linux.local -  DisplayFirstChdir
linux.local -  Umask
linux.local -  SQLAuthTypes
linux.local -  SQLAuthenticate
linux.local -  SQLConnectInfo
linux.local -  SQLDefaultGID
linux.local -  SQLDefaultUID
linux.local -  SQLMinUserGID
linux.local -  SQLMinUserUID
linux.local - /
linux.local -  AllowOverwrite
linux.local -  Umask
linux.local -  SQLAuthTypes
linux.local -  SQLAuthenticate
linux.local -  SQLConnectInfo
linux.local -  SQLDefaultGID
linux.local -  SQLDefaultUID
linux.local -  SQLMinUserGID
linux.local -  SQLMinUserUID
linux.local - DefaultServer
linux.local - Umask
linux.local - UserID
linux.local - UserName
linux.local - GroupID
linux.local - GroupName
linux.local - SQLAuthTypes
linux.local - SQLAuthenticate
linux.local - SQLConnectInfo
linux.local - SQLDefaultGID
linux.local - SQLDefaultUID
linux.local - SQLMinUserGID
linux.local - SQLMinUserUID
linux.local - SQLUserTable
linux.local - SQLUsernameField
linux.local - SQLPasswordField
linux.local - SQLUidField
linux.local - SQLGidField
linux.local - SQLHomedirField
linux.local - SQLShellField
linux.local - SQLLogFile
linux.local - ProFTPD 1.2.9 (stable) (built Tue Dec 16 10:44:31 CET 2003) standalone mode STARTUP

[Anonymous]

/var/log/messages nach debug

Dec 16 12:04:20 linux proftpd[29911]: linux.local - ProFTPD killed (signal 15)
Dec 16 12:04:20 linux proftpd[29911]: linux.local - ProFTPD 1.2.9 standalone mode SHUTDOWN

[Anonymous]

Das wird im Debugmodus ausgegeben, wenn ich versuche auf den Server zu connecten:

linux.local - ProFTPD 1.2.9 (stable) (built Tue Dec 16 10:44:31 CET 2003) standalone mode STARTUP
linux.local (192.168.1.69[192.168.1.69]) - connected - local  : 192.168.1.47:21
linux.local (192.168.1.69[192.168.1.69]) - connected - remote : 192.168.1.69:2496
linux.local (192.168.1.69[192.168.1.69]) - FTP session opened.
linux.local (192.168.1.69[192.168.1.69]) - dispatching PRE_CMD command 'USER mux' to mod_core
linux.local (192.168.1.69[192.168.1.69]) - dispatching PRE_CMD command 'USER mux' to mod_core
linux.local (192.168.1.69[192.168.1.69]) - dispatching PRE_CMD command 'USER mux' to mod_auth
linux.local (192.168.1.69[192.168.1.69]) - dispatching CMD command 'USER mux' to mod_auth
linux.local (192.168.1.69[192.168.1.69]) - ProFTPD terminating (signal 11)
linux.local (192.168.1.69[192.168.1.69]) - FTP session closed.

und jetzt meld ich mich mal an, damit ich editieren kann ^^

[TomGrill]

weis keiner rat ??

[Wörsty]

:shock:  :hä?
Ich versteh es nicht so ganz....

Dec 16 11:32:51 linux proftpd[29916]: linux.local (192.168.1.69[192.168.1.69]) - ProFTPD terminating (signal 11)

Dec 16 11:31:24 mod_sql/4.10[29912]: entering mysql cmd_escapestring

Also bei mod_sql ist dein Loginversuch nie angekommen....

[stonki]

- parsing '/etc/proftpd.conf' configuration
 - <Directory />: adding section for resolved path '/'

linux.local - ProFTPD 1.2.9 (stable) (built Tue Dec 16 10:44:31 CET 2003) standalone mode STARTUP

Das NACH DEM Login posten !