ProFTPd vs. mySQL
HejJeg får følgende fejl når jeg vil logge på min ProFTPd server som jeg har compilet med mySQL support (nu får i bare det hele):
graestoerv (kapsel[192.168.0.1]) - connected - local : 192.168.0.202:21
graestoerv (kapsel[192.168.0.1]) - connected - remote : 192.168.0.1:1270
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: configured: proftpd@localhost:3306 for proftpd
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: entering sql_getconf
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: entering fixup_SQLAuthTypes
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: exiting fixup_SQLAuthTypes
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: open [1] for mod_sql/3.1.2
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: connect OK 3.23.33 -> 3.23.33 (proftpd@localhost)
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: backend successfully connected.
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: SQLDoAuth : true
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: authoritative : false
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: usertable : users
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: userid field : userid
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: password field : password
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: uid field : uid
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: gid field : gid
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: shell field : shell
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: homedir field : homedir
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: default homedir : (none)
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: homedirondemand : false
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: SQLDoGroupAuth : false
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: group table : groups
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: groupname field : groupname
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: grp gid field : gid
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: grp members field : members
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: SQLMinUserUID : 999
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: SQLMinUserGID : 999
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: SQLDefaultUID : 50
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: SQLDefaultGID : 14
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: exiting sql_getconf
graestoerv (kapsel[192.168.0.1]) - FTP session opened.
graestoerv (kapsel[192.168.0.1]) - received: USER testing
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: entering auth_cmd_getpwnam
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: select OK: [proftpd] \"select userid from users where userid = \'testing\' \"
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: select OK: [proftpd] \"select homedir from users where userid = \'testing\' \"
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: select OK: [proftpd] \"select uid from users where userid = \'testing\' \"
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: select OK: [proftpd] \"select gid from users where userid = \'testing\' \"
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: select OK: [proftpd] \"select shell from users where userid = \'testing\' \"
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: user \"testing\" (50/14) for
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: entering show_passwd
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: pwd.pw_name : testing
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: pwd.pw_uid : 50
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: pwd.pw_gid : 14
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: pwd.pw_shell : bash2
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: pwd.pw_dir :
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: exiting show_passwd
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: exiting auth_cmd_getpwnam
graestoerv (kapsel[192.168.0.1]) - no supplemental groups found for user \'testing\'
graestoerv (kapsel[192.168.0.1]) - received: PASS (hidden)
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: entering auth_cmd_getpwnam
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: cache hit for user testing
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: exiting auth_cmd_getpwnam
graestoerv (kapsel[192.168.0.1]) - no supplemental groups found for user \'testing\'
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: entering auth_cmd_getpwnam
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: cache hit for user testing
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: exiting auth_cmd_getpwnam
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: entering auth_cmd_auth
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: select OK: [proftpd] \"select password from users where userid = \'testing\' limit 1\"
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: entering auth_cmd_check
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: exiting auth_cmd_check
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: exiting auth_cmd_auth
graestoerv (kapsel[192.168.0.1]) - PAM(testing): Authentication failure.
graestoerv (kapsel[192.168.0.1]) - USER testing (Login failed): No such user found.
graestoerv (kapsel[192.168.0.1]) - received: QUIT
graestoerv (kapsel[192.168.0.1]) - FTP session closed.
graestoerv (kapsel[192.168.0.1]) - mod_sql/3.1.2: closing backend connection
graestoerv (kapsel[192.168.0.1]) - mod_sql_mysql/3.0: close [1] for mod_sql/3.1.2
___________________________________
Min config ser såddan ud:
SQLConnectInfo proftpd@localhost proftpd xxx SQLDoAuth on
SQLGidField gid
SQLGroupGIDField gid
SQLHomedirField homedir
#SQLLogDirs on
#SQLLogHits on
#SQLLogHosts on
#SQLLogStats on
SQLLoginCountField count
SQLPasswordField password
SQLUserTable users
SQLDefaultGID 14
SQLDefaultUID 50
SQLAuthoritative on
SQLPlaintextpasswords on
RequireValidShell off
SQLDoGroupAuth off
<Directory /mnt/raid/ftp/Upload/>
<Limit MKDIR MKD STOR>
AllowAll
</Limit>
<Limit RMD DELE>
DenyAll
</Limit>
</Directory>
<Limit WRITE STOR DELE MKD MKDIR>
DenyAll
</Limit>
<Directory /mnt/raid/ftp/>
AllowOverwrite off
</Directory>
______________________________
Hvad gør jeg galt ?
