|
Titel: verbindungsprobleme seit 1 tag - vorher ging alles Beitrag von: tispokes am 16. Oktober 2004, 00:33:49 Hi,
also wnen ich versuch auf ProFTPD zu verbinden kommt folgendes: Code: [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 Code: 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: Code: 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? Titel: verbindungsprobleme seit 1 tag - vorher ging alles Beitrag von: stonki am 16. Oktober 2004, 14:40:30 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'' hmm, das sollte es doch sein, oder ? Titel: verbindungsprobleme seit 1 tag - vorher ging alles Beitrag von: Wörsty am 16. Oktober 2004, 14:45:22 Und seit kurzem geht es nicht mehr, weil nach der fehlerhaften Änderung damals kein Neustart gemacht wurde...
Titel: verbindungsprobleme seit 1 tag - vorher ging alles Beitrag von: Anonymous am 16. Oktober 2004, 17:48:10 ich weiss nur nicht wie ich das problem lösen soll...wo soll ich ansetzen? was kann falsch sein? ....
Titel: gelöst Beitrag von: tispokes2 am 16. Oktober 2004, 18:08:11 habs gelöst :)
|