Ich hoffe jemand kann mir helfen beim einrichten meines FTP-Servers. Ich habe folgendes Problem: Nach der eingabe vom Passwort wird die FTP Verbindung sofort beendet. Da dies nur passiert wenn ich die Daten für die SQL-Datenbank angebe (SQLConnectInfo, ....) hege ich den verdacht dass etwas mit meiner Konfiguration nicht stimmt.
Ich habe das ganze soweit aufgezogen wie ich es in Beispieln gefunden habe:
ich habe folgende änderungen an der config vorgenommen:
PersistentPasswd off
SQLConnectInfo proftpd@localhost proftpd xxx PERCALL
SQLAuthenticate users*
SQLAuthTypes Plaintext
SQLUserInfo user userid passwd uid gid homedir shell
SQLGroupInfo groups groupname gid members
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinID 100
Wie ich in anderen Threads gesehen habe braucht ihr die Logfiles - bidde schön:
DebugLog
- parsing '/etc/proftpd.conf' configuration
- Compiling deny regex '\*.*/'.
- Allocated deny regex at location 0x80f27c0.
- <Directory /*>: adding section for resolved path '/*'
localhost -
localhost - Config for Enigma:
localhost - /*
localhost - Umask
localhost - DirUmask
localhost - AllowOverwrite
localhost - ShowSymlinks
localhost - DisplayLogin
localhost - DisplayFirstChdir
localhost - ListOptions
localhost - DenyFilter
localhost - SQLConnectInfo
localhost - SQLAuthenticate
localhost - SQLAuthTypes
localhost - SQLDefaultGID
localhost - SQLDefaultUID
localhost - SQLMinID
localhost - DeferWelcome
localhost - DefaultServer
localhost - ShowSymlinks
localhost - AllowOverwrite
localhost - TimeoutNoTransfer
localhost - TimeoutStalled
localhost - TimeoutIdle
localhost - DisplayLogin
localhost - DisplayFirstChdir
localhost - ListOptions
localhost - DenyFilter
localhost - UserID
localhost - UserName
localhost - GroupID
localhost - GroupName
localhost - SQLConnectInfo
localhost - SQLAuthenticate
localhost - SQLAuthTypes
localhost - SQLUserTable
localhost - SQLUsernameField
localhost - SQLPasswordField
localhost - SQLUidField
localhost - SQLGidField
localhost - SQLHomedirField
localhost - SQLShellField
localhost - SQLGroupTable
localhost - SQLGroupnameField
localhost - SQLGroupGIDField
localhost - SQLGroupMembersField
localhost - SQLDefaultGID
localhost - SQLDefaultUID
localhost - SQLMinID
localhost - DebugLevel
localhost - SQLLogFile
localhost - ServerLog
localhost - ProFTPD 1.2.9 (stable) (built do mrt 22 18:28:32 CET 2001) standalone mode STARTUP
localhost (eni.mshome.net[192.168.0.1]) - connected - local : 192.168.0.222:21
localhost (eni.mshome.net[192.168.0.1]) - connected - remote : 192.168.0.1:4662
localhost (eni.mshome.net[192.168.0.1]) - FTP session opened.
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'USER test' to mod_rewrite
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'USER test' to mod_tls
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'USER test' to mod_core
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'USER test' to mod_core
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'USER test' to mod_auth
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endpwent" to module mod_radius
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endpwent" to module mod_sql
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endgrent" to module mod_radius
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endgrent" to module mod_sql
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endgrent" to module mod_auth_file
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endgrent" to module mod_auth_unix
localhost (eni.mshome.net[192.168.0.1]) - dispatching CMD command 'USER test' to mod_ratio
localhost (eni.mshome.net[192.168.0.1]) - dispatching CMD command 'USER test' to mod_auth
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getgroups" to module mod_radius
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getgroups" to module mod_sql
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getgroups" to module mod_auth_file
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getgroups" to module mod_auth_unix
localhost (eni.mshome.net[192.168.0.1]) - no supplemental groups found for user 'test'
localhost (eni.mshome.net[192.168.0.1]) - dispatching POST_CMD command 'USER test' to mod_sql
localhost (eni.mshome.net[192.168.0.1]) - dispatching LOG_CMD command 'USER test' to mod_sql
localhost (eni.mshome.net[192.168.0.1]) - dispatching LOG_CMD command 'USER test' to mod_log
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius
localhost (eni.mshome.net[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endpwent" to module mod_radius
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endpwent" to module mod_sql
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endgrent" to module mod_radius
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endgrent" to module mod_sql
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endgrent" to module mod_auth_file
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "endgrent" to module mod_auth_unix
localhost (eni.mshome.net[192.168.0.1]) - dispatching CMD command 'PASS (hidden)' to mod_auth
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getgroups" to module mod_radius
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getgroups" to module mod_sql
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getgroups" to module mod_auth_file
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getgroups" to module mod_auth_unix
localhost (eni.mshome.net[192.168.0.1]) - no supplemental groups found for user 'test'
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getpwnam" to module mod_radius
localhost (eni.mshome.net[192.168.0.1]) - dispatching auth request "getpwnam" to module mod_sql
localhost (eni.mshome.net[192.168.0.1]) - ProFTPD terminating (signal 11)
localhost (eni.mshome.net[192.168.0.1]) - FTP session closed.
localhost - ProFTPD terminating (signal 2)
localhost - ProFTPD 1.2.9 standalone mode SHUTDOWN
SqlLogfile
Jul 23 20:01:27 mod_sql/4.10[9970]: backend module 'mod_sql_mysql/4.04'
Jul 23 20:01:27 mod_sql/4.10[9970]: backend api 'mod_sql_api_v1'
Jul 23 20:01:27 mod_sql/4.10[9970]: >>> sql_getconf
Jul 23 20:01:27 mod_sql/4.10[9970]: entering mysql cmd_defineconnection
Jul 23 20:01:27 mod_sql/4.10[9970]: name: 'default'
Jul 23 20:01:27 mod_sql/4.10[9970]: user: 'proftpd'
Jul 23 20:01:27 mod_sql/4.10[9970]: host: 'localhost'
Jul 23 20:01:27 mod_sql/4.10[9970]: db: 'proftpd'
Jul 23 20:01:27 mod_sql/4.10[9970]: port: '3306'
Jul 23 20:01:27 mod_sql/4.10[9970]: ttl: '0'
Jul 23 20:01:27 mod_sql/4.10[9970]: exiting mysql cmd_defineconnection
Jul 23 20:01:27 mod_sql/4.10[9970]: backend will not be checked until first use.
Jul 23 20:01:27 mod_sql/4.10[9970]: mod_sql status : on
Jul 23 20:01:27 mod_sql/4.10[9970]: negative_cache : off
Jul 23 20:01:27 mod_sql/4.10[9970]: authenticate : users*
Jul 23 20:01:27 mod_sql/4.10[9970]: usertable : user
Jul 23 20:01:27 mod_sql/4.10[9970]: userid field : userid
Jul 23 20:01:27 mod_sql/4.10[9970]: password field : passwd
Jul 23 20:01:27 mod_sql/4.10[9970]: uid field : uid
Jul 23 20:01:27 mod_sql/4.10[9970]: gid field : gid
Jul 23 20:01:27 mod_sql/4.10[9970]: homedir field : homedir
Jul 23 20:01:27 mod_sql/4.10[9970]: shell field : shell
Jul 23 20:01:27 mod_sql/4.10[9970]: homedirondemand : false
Jul 23 20:01:27 mod_sql/4.10[9970]: SQLMinUserUID : 999
Jul 23 20:01:27 mod_sql/4.10[9970]: SQLMinUserGID : 999
Jul 23 20:01:27 mod_sql/4.10[9970]: <<< sql_getconf
Jul 23 20:01:31 mod_sql/4.10[9970]: >>> cmd_getpwnam
Jul 23 20:01:31 mod_sql/4.10[9970]: entering mysql cmd_escapestring
Jul 23 20:02:47 mod_sql/4.10[9986]: backend module 'mod_sql_mysql/4.04'
Jul 23 20:02:47 mod_sql/4.10[9986]: backend api 'mod_sql_api_v1'
Jul 23 20:02:47 mod_sql/4.10[9986]: >>> sql_getconf
Jul 23 20:02:47 mod_sql/4.10[9986]: entering mysql cmd_defineconnection
Jul 23 20:02:47 mod_sql/4.10[9986]: name: 'default'
Jul 23 20:02:47 mod_sql/4.10[9986]: user: 'proftpd'
Jul 23 20:02:47 mod_sql/4.10[9986]: host: 'localhost'
Jul 23 20:02:47 mod_sql/4.10[9986]: db: 'proftpd'
Jul 23 20:02:47 mod_sql/4.10[9986]: port: '3306'
Jul 23 20:02:47 mod_sql/4.10[9986]: ttl: '0'
Jul 23 20:02:47 mod_sql/4.10[9986]: exiting mysql cmd_defineconnection
Jul 23 20:02:47 mod_sql/4.10[9986]: backend will not be checked until first use.
Jul 23 20:02:47 mod_sql/4.10[9986]: mod_sql status : on
Jul 23 20:02:47 mod_sql/4.10[9986]: negative_cache : off
Jul 23 20:02:47 mod_sql/4.10[9986]: authenticate : users*
Jul 23 20:02:47 mod_sql/4.10[9986]: usertable : user
Jul 23 20:02:47 mod_sql/4.10[9986]: userid field : userid
Jul 23 20:02:47 mod_sql/4.10[9986]: password field : passwd
Jul 23 20:02:47 mod_sql/4.10[9986]: uid field : uid
Jul 23 20:02:47 mod_sql/4.10[9986]: gid field : gid
Jul 23 20:02:47 mod_sql/4.10[9986]: homedir field : homedir
Jul 23 20:02:47 mod_sql/4.10[9986]: shell field : shell
Jul 23 20:02:47 mod_sql/4.10[9986]: homedirondemand : false
Jul 23 20:02:47 mod_sql/4.10[9986]: SQLMinUserUID : 999
Jul 23 20:02:47 mod_sql/4.10[9986]: SQLMinUserGID : 999
Jul 23 20:02:47 mod_sql/4.10[9986]: <<< sql_getconf
Jul 23 20:02:51 mod_sql/4.10[9986]: >>> cmd_getpwnam
Jul 23 20:02:51 mod_sql/4.10[9986]: entering mysql cmd_escapestring
Jul 23 20:06:26 mod_sql/4.10[9990]: backend module 'mod_sql_mysql/4.04'
Jul 23 20:06:26 mod_sql/4.10[9990]: backend api 'mod_sql_api_v1'
Jul 23 20:06:26 mod_sql/4.10[9990]: >>> sql_getconf
Jul 23 20:06:26 mod_sql/4.10[9990]: entering mysql cmd_defineconnection
Jul 23 20:06:26 mod_sql/4.10[9990]: name: 'default'
Jul 23 20:06:26 mod_sql/4.10[9990]: user: 'proftpd'
Jul 23 20:06:26 mod_sql/4.10[9990]: host: 'localhost'
Jul 23 20:06:26 mod_sql/4.10[9990]: db: 'proftpd'
Jul 23 20:06:26 mod_sql/4.10[9990]: port: '3306'
Jul 23 20:06:26 mod_sql/4.10[9990]: ttl: '0'
Jul 23 20:06:26 mod_sql/4.10[9990]: exiting mysql cmd_defineconnection
Jul 23 20:06:26 mod_sql/4.10[9990]: backend will not be checked until first use.
Jul 23 20:06:26 mod_sql/4.10[9990]: mod_sql status : on
Jul 23 20:06:26 mod_sql/4.10[9990]: negative_cache : off
Jul 23 20:06:26 mod_sql/4.10[9990]: authenticate : users*
Jul 23 20:06:26 mod_sql/4.10[9990]: usertable : user
Jul 23 20:06:26 mod_sql/4.10[9990]: userid field : userid
Jul 23 20:06:26 mod_sql/4.10[9990]: password field : passwd
Jul 23 20:06:26 mod_sql/4.10[9990]: uid field : uid
Jul 23 20:06:26 mod_sql/4.10[9990]: gid field : gid
Jul 23 20:06:26 mod_sql/4.10[9990]: homedir field : homedir
Jul 23 20:06:26 mod_sql/4.10[9990]: shell field : shell
Jul 23 20:06:26 mod_sql/4.10[9990]: homedirondemand : false
Jul 23 20:06:26 mod_sql/4.10[9990]: SQLMinUserUID : 999
Jul 23 20:06:26 mod_sql/4.10[9990]: SQLMinUserGID : 999
Jul 23 20:06:26 mod_sql/4.10[9990]: <<< sql_getconf
Jul 23 20:06:30 mod_sql/4.10[9990]: >>> cmd_getpwnam
Jul 23 20:06:30 mod_sql/4.10[9990]: entering mysql cmd_escapestring
Jul 23 20:08:55 mod_sql/4.10[9999]: backend module 'mod_sql_mysql/4.04'
Jul 23 20:08:55 mod_sql/4.10[9999]: backend api 'mod_sql_api_v1'
Jul 23 20:08:55 mod_sql/4.10[9999]: >>> sql_getconf
Jul 23 20:08:55 mod_sql/4.10[9999]: entering mysql cmd_defineconnection
Jul 23 20:08:55 mod_sql/4.10[9999]: name: 'default'
Jul 23 20:08:55 mod_sql/4.10[9999]: user: 'proftpd'
Jul 23 20:08:55 mod_sql/4.10[9999]: host: 'localhost'
Jul 23 20:08:55 mod_sql/4.10[9999]: db: 'proftpd'
Jul 23 20:08:55 mod_sql/4.10[9999]: port: '3306'
Jul 23 20:08:55 mod_sql/4.10[9999]: ttl: '0'
Jul 23 20:08:55 mod_sql/4.10[9999]: exiting mysql cmd_defineconnection
Jul 23 20:08:55 mod_sql/4.10[9999]: backend will not be checked until first use.
Jul 23 20:08:55 mod_sql/4.10[9999]: mod_sql status : on
Jul 23 20:08:55 mod_sql/4.10[9999]: negative_cache : off
Jul 23 20:08:55 mod_sql/4.10[9999]: authenticate : users*
Jul 23 20:08:55 mod_sql/4.10[9999]: usertable : user
Jul 23 20:08:55 mod_sql/4.10[9999]: userid field : userid
Jul 23 20:08:55 mod_sql/4.10[9999]: password field : passwd
Jul 23 20:08:55 mod_sql/4.10[9999]: uid field : uid
Jul 23 20:08:55 mod_sql/4.10[9999]: gid field : gid
Jul 23 20:08:55 mod_sql/4.10[9999]: homedir field : homedir
Jul 23 20:08:55 mod_sql/4.10[9999]: shell field : shell
Jul 23 20:08:55 mod_sql/4.10[9999]: homedirondemand : false
Jul 23 20:08:55 mod_sql/4.10[9999]: SQLMinUserUID : 100
Jul 23 20:08:55 mod_sql/4.10[9999]: SQLMinUserGID : 100
Jul 23 20:08:55 mod_sql/4.10[9999]: <<< sql_getconf
Jul 23 20:09:00 mod_sql/4.10[9999]: >>> cmd_getpwnam
Jul 23 20:09:00 mod_sql/4.10[9999]: entering mysql cmd_escapestring
Ich hoffe ihr könnt damit mehr anfangen als ich. Ich habe zwar schon auf diversen Seiten mit google gesucht, habe aber keinen Hinweis gefunden was ich falsch gemacht habe.
In der Datenbank sind ebenfalls die Einträge:
User: test test 1337 1337 /home/enigma /bin/bash
Groups: testgroup 1337 test
