Ich kann mich nicht per MySQL anmelden.
Kann jemand mal beine Logs checken, ich finde keinen Fehler:
FTP log: - parsing '/etc/proftpd.conf' configuration
- SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness
debian -
debian - Config for FTP-Server:
debian - SyslogLevel
debian - ServerIdent
debian - DeferWelcome
debian - DefaultServer
debian - DisplayLogin
debian - DisplayConnect
debian - DisplayFirstChdir
debian - SQLAuthTypes
debian - SQLAuthenticate
debian - SQLConnectInfo
debian - SQLDefaultGID
debian - SQLDefaultUID
debian - SQLMinUserGID
debian - SQLMinUserUID
debian - SQLUserTable
debian - SQLUsernameField
debian - SQLPasswordField
debian - SQLUidField
debian - SQLGidField
debian - SQLHomedirField
debian - SQLShellField
debian - SQLLog_PASS
debian - SQLNamedQuery_counter
debian - SQLLog_RETR
debian - SQLLog_STOR
debian - SQLNamedQuery_transfer1
debian - SQLLog_ERR_RETR
debian - SQLLog_ERR_STOR
debian - SQLNamedQuery_transfer2
debian - AllowForeignAddress
debian - Umask
debian - UserID
debian - UserName
debian - GroupID
debian - GroupName
debian - MaxClientsPerHost
debian - MaxClients
debian - AllowStoreRestart
debian - AllowRetrieveRestart
debian - TimeoutStalled
debian - MaxLoginAttempts
debian - RequireValidShell
debian - ProFTPD 1.2.10 (stable) (built Di Okt 4 19:29:43 CEST 2005) standalone mode STARTUP
debian (proftptestserver.local[192.168.1.211]) - FTP session requested from unknown class
debian (proftptestserver.local[192.168.1.211]) - connected - local : 192.168.1.16:21
debian (proftptestserver.local[192.168.1.211]) - connected - remote : 192.168.1.211:4139
debian (proftptestserver.local[192.168.1.211]) - FTP session opened.
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'USER maik' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik'
debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD command 'USER maik' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_log
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik'
debian (proftptestserver.local[192.168.1.211]) - USER maik (Login failed): No such user found.
debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - FTP session closed.
debian (proftptestserver.local[192.168.1.211]) - FTP session requested from unknown class
debian (proftptestserver.local[192.168.1.211]) - connected - local : 192.168.1.16:21
debian (proftptestserver.local[192.168.1.211]) - connected - remote : 192.168.1.211:4153
debian (proftptestserver.local[192.168.1.211]) - FTP session opened.
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'USER maik' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik'
debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD command 'USER maik' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_log
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik'
debian (proftptestserver.local[192.168.1.211]) - USER maik (Login failed): No such user found.
debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - FTP session closed.
FTP SQL log:Oct 05 15:06:46 mod_sql/4.11[22370]: entering mysql cmd_escapestring
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_escapestring
Oct 05 15:06:46 mod_sql/4.11[22370]: cache miss for user 'maik'
Oct 05 15:06:46 mod_sql/4.11[22370]: : entering mysql cmd_select
Oct 05 15:06:46 mod_sql/4.11[22370]: entering mysql cmd_open
Oct 05 15:06:46 mod_sql/4.11[22370]: connection 'default' count is now 2
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_open
Oct 05 15:06:46 mod_sql/4.11[22370]: query "SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username
='maik') LIMIT 1"
Oct 05 15:06:46 mod_sql/4.11[22370]: entering mysql cmd_close
Oct 05 15:06:46 mod_sql/4.11[22370]: connection 'default' count is now 1
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_close
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_select
Oct 05 15:06:46 mod_sql/4.11[22370]: cache miss for user 'maik'
Oct 05 15:06:46 mod_sql/4.11[22370]: user 'maik' cached
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_name : maik
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_uid : 65534
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_gid : 65534
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_dir : /var/ftp/
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_shell :
Oct 05 15:06:46 mod_sql/4.11[22370]: <<< cmd_getpwnam
Oct 05 15:06:46 mod_sql/4.11[22370]: >>> cmd_auth
Oct 05 15:06:46 mod_sql/4.11[22370]: entering mysql cmd_escapestring
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_escapestring
Oct 05 15:06:46 mod_sql/4.11[22370]: cache hit for user 'maik'
Oct 05 15:06:46 mod_sql/4.11[22370]: negative cache entry for user 'maik'
Oct 05 15:06:46 mod_sql/4.11[22370]: <<< cmd_auth
Oct 05 15:06:47 mod_sql/4.11[22370]: entering mysql cmd_exit
Oct 05 15:06:47 mod_sql/4.11[22370]: entering mysql cmd_close
Oct 05 15:06:47 mod_sql/4.11[22370]: connection 'default' closed
Oct 05 15:06:47 mod_sql/4.11[22370]: connection 'default' count is now 0
Oct 05 15:06:47 mod_sql/4.11[22370]: exiting mysql cmd_close
Oct 05 15:06:47 mod_sql/4.11[22370]: exiting mysql cmd_exit
mein proftpd.conf sieht wie folgt aus:
serverType standalone
SyslogLevel debug
SystemLog /var/log/proftpd.system.log
ServerIdent on "Stonki's Server"
DeferWelcome on
DefaultServer on
DisplayLogin /messages/ftp.motd
DisplayConnect /net/messages/ftp.pre
DisplayFirstChdir index.txt
Port 21
SQLAuthTypes Plaintext
SQLAuthenticate users*
SQLConnectInfo proftpd@localhost root
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo ftp username uid gid password homedir shell
SQLLog PASS counter
SQLNamedQuery counter UPDATE "letzter_zugriff=now(), count=count+1 WHERE username='%u'" ftp
SQLLog RETR,STOR transfer1
SQLNamedQuery transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c', NULL" xfer_stat
SQLLOG ERR_RETR,ERR_STOR transfer2
SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL" xfer_stat
AllowForeignAddress on
Umask 022
User nobody
Group nogroup
MaxClientsPerHost 3 "Nicht mehr als %m Verbindungen"
MaxClients 5 "Leider sind schon %m Clients verbunden"
AllowStoreRestart on
AllowRetrieveRestart on
MaxInstances 30
UseReverseDNS on
TimeoutStalled 300
LogFormat default "%h %l %u %t \"%r\" %s %b"
LogFormat auth "%v [%P] %h %t \"%r\" %s"
LogFormat write "%h %l %u %t \"%r\" %s %b"
MaxLoginAttempts 3
RequireValidShell off
Das ganze läuft auf nem Debian Sarge.
Alle notwendigen Module dürften korrekt einkompeliert sein.
Compiled-in modules:
mod_core.c
mod_xfer.c
mod_auth_unix.c
mod_auth_file.c
mod_auth.c
mod_ls.c
mod_log.c
mod_site.c
mod_sql.c
mod_sql_mysql.c
mod_cap.c
Ich bin für jeden Hinweis dankbar.
