Hi,
also wnen ich versuch auf ProFTPD zu verbinden kommt folgendes:
[23:25:58] Connecting to test #71
[23:25:58] Connected to test -> IP=83.***.***.*** PORT=21
[23:26:01] 220 ProFTPD 1.2.9 Server (TiSpOkEs Webserver) [server83*********.serverpool.info.serverpool.info]
[23:26:01] USER f5
[23:26:01] Connection failed (Connection lost)
So das ist due Ausgabe von FFXP
Jetzt sql.log
Oct 15 23:29:41 mod_sql/4.10[17585]: backend module 'mod_sql_mysql/4.04'
Oct 15 23:29:41 mod_sql/4.10[17585]: backend api 'mod_sql_api_v1'
Oct 15 23:29:41 mod_sql/4.10[17585]: >>> sql_getconf
Oct 15 23:29:41 mod_sql/4.10[17585]: entering mysql cmd_defineconnection
Oct 15 23:29:41 mod_sql/4.10[17585]: name: 'default'
Oct 15 23:29:41 mod_sql/4.10[17585]: user: 'vadmin'
Oct 15 23:29:41 mod_sql/4.10[17585]: host: 'localhost'
Oct 15 23:29:41 mod_sql/4.10[17585]: db: 'vadmin'
Oct 15 23:29:41 mod_sql/4.10[17585]: port: '3306'
Oct 15 23:29:41 mod_sql/4.10[17585]: ttl: '0'
Oct 15 23:29:41 mod_sql/4.10[17585]: exiting mysql cmd_defineconnection
Oct 15 23:29:41 mod_sql/4.10[17585]: entering mysql cmd_open
Oct 15 23:29:41 mod_sql/4.10[17585]: connection 'default' opened
Oct 15 23:29:41 mod_sql/4.10[17585]: connection 'default' count is now 1
Oct 15 23:29:41 mod_sql/4.10[17585]: exiting mysql cmd_open
Oct 15 23:29:41 mod_sql/4.10[17585]: backend successfully connected.
Oct 15 23:29:41 mod_sql/4.10[17585]: mod_sql status : on
Oct 15 23:29:41 mod_sql/4.10[17585]: negative_cache : off
Oct 15 23:29:41 mod_sql/4.10[17585]: authenticate : users groups userset groupset
Oct 15 23:29:41 mod_sql/4.10[17585]: usertable : ftp
Oct 15 23:29:41 mod_sql/4.10[17585]: userid field : login
Oct 15 23:29:41 mod_sql/4.10[17585]: password field : password
Oct 15 23:29:41 mod_sql/4.10[17585]: uid field : uid
Oct 15 23:29:41 mod_sql/4.10[17585]: gid field : gid
Oct 15 23:29:41 mod_sql/4.10[17585]: homedir field : home
Oct 15 23:29:41 mod_sql/4.10[17585]: shell field : shell
Oct 15 23:29:41 mod_sql/4.10[17585]: homedirondemand : false
Oct 15 23:29:41 mod_sql/4.10[17585]: group table : groups
Oct 15 23:29:41 mod_sql/4.10[17585]: groupname field : groupname
Oct 15 23:29:41 mod_sql/4.10[17585]: grp gid field : id
Oct 15 23:29:41 mod_sql/4.10[17585]: grp members field : username
Oct 15 23:29:41 mod_sql/4.10[17585]: SQLMinUserUID : 999
Oct 15 23:29:41 mod_sql/4.10[17585]: SQLMinUserGID : 999
Oct 15 23:29:41 mod_sql/4.10[17585]: SQLDefaultUID : 65533
Oct 15 23:29:41 mod_sql/4.10[17585]: SQLDefaultGID : 65533
Oct 15 23:29:41 mod_sql/4.10[17585]: <<< sql_getconf
Oct 15 23:29:41 mod_sql/4.10[17585]: >>> cmd_endpwent
Oct 15 23:29:41 mod_sql/4.10[17585]: <<< cmd_endpwent
Oct 15 23:29:41 mod_sql/4.10[17585]: >>> cmd_endgrent
Oct 15 23:29:41 mod_sql/4.10[17585]: <<< cmd_endgrent
Oct 15 23:29:41 mod_sql/4.10[17585]: >>> cmd_getgroups
Oct 15 23:29:41 mod_sql/4.10[17585]: entering mysql cmd_escapestring
Oct 15 23:29:41 mod_sql/4.10[17585]: exiting mysql cmd_escapestring
Oct 15 23:29:41 mod_sql/4.10[17585]: cache miss for user 'f5'
Oct 15 23:29:41 mod_sql/4.10[17585]: : entering mysql cmd_select
Oct 15 23:29:41 mod_sql/4.10[17585]: entering mysql cmd_open
Oct 15 23:29:41 mod_sql/4.10[17585]: connection 'default' count is now 2
Oct 15 23:29:41 mod_sql/4.10[17585]: exiting mysql cmd_open
Oct 15 23:29:41 mod_sql/4.10[17585]: query "SELECT login, password, uid, gid, home, shell FROM ftp WHERE (login='f5') and ((valid = 1)) LIMIT 1"
Oct 15 23:29:41 mod_sql/4.10[17585]: entering mysql cmd_close
Oct 15 23:29:41 mod_sql/4.10[17585]: connection 'default' count is now 1
Oct 15 23:29:41 mod_sql/4.10[17585]: exiting mysql cmd_close
Oct 15 23:29:41 mod_sql/4.10[17585]: exiting mysql cmd_select
Oct 15 23:29:41 mod_sql/4.10[17585]: unrecoverable backend error
Oct 15 23:29:41 mod_sql/4.10[17585]: error: '1054'
Oct 15 23:29:41 mod_sql/4.10[17585]: message: 'Unknown column 'valid' in 'where clause''
Oct 15 23:29:41 mod_sql/4.10[17585]: >>> cmd_endpwent
Oct 15 23:29:41 mod_sql/4.10[17585]: <<< cmd_endpwent
Oct 15 23:29:41 mod_sql/4.10[17585]: >>> cmd_endgrent
Oct 15 23:29:41 mod_sql/4.10[17585]: <<< cmd_endgrent
Das ist einmal der komplette log bei einem login versuch.
außerdem hab ich proftpd jetzt mal so gestartet: /usr/sbin/./proftpd -nd5
da kommt folgendes:
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - connected - local : 83.***.***.***4:21
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - connected - remote : 217.81.218.**:33728
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - FTP session opened.
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching PRE_CMD command 'USER f5' to mod_rewrite
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching PRE_CMD command 'USER f5' to mod_tls
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching PRE_CMD command 'USER f5' to mod_core
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching PRE_CMD command 'USER f5' to mod_core
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching PRE_CMD command 'USER f5' to mod_auth
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endpwent" to module mod_radius
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endpwent" to module mod_sql
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endpwent" to module mod_auth_file
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endpwent" to module mod_auth_unix
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endgrent" to module mod_radius
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endgrent" to module mod_sql
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endgrent" to module mod_auth_file
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endgrent" to module mod_auth_unix
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching CMD command 'USER f5' to mod_ratio
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching CMD command 'USER f5' to mod_auth
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "getgroups" to module mod_radius
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "getgroups" to module mod_sql
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endpwent" to module mod_radius
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endpwent" to module mod_sql
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endpwent" to module mod_auth_file
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endpwent" to module mod_auth_unix
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endgrent" to module mod_radius
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endgrent" to module mod_sql
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endgrent" to module mod_auth_file
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - dispatching auth request "endgrent" to module mod_auth_unix
server83*********.serverpool.info (217.81.218.**[217.81.218.**]) - FTP session closed.
Hat irgendwer ne Idee? Was zum teufel hab ich verstellt?
