login incorrect .. why?

[Guest]

hi, also ich hab bei mir proftpd mit sql installiert. dann hab ich die tabellenstruktur und die proftpd.conf von ftpmyadmin genommen um das ganze zum laufen zu kriegen. ich hab also in die mysql tabellen einen user und eine group angelegt, jedoch wenn ich mcih einloggen will kommt immer login incorrect und ich hab kein plan mehr warum, habs schon mit crypt und plaintext probiert aber immer das gleiche.

vielen dank

[stonki]

hi, also ich hab bei mir proftpd mit sql installiert. dann hab ich die tabellenstruktur und die proftpd.conf von ftpmyadmin genommen um das ganze zum laufen zu kriegen. ich hab also in die mysql tabellen einen user und eine group angelegt, jedoch wenn ich mcih einloggen will kommt immer login incorrect und ich hab kein plan mehr warum, habs schon mit crypt und plaintext probiert aber immer das gleiche.

vielen dank

sqllogfile /var/log/proftpd.sql.log
proftpd -n -d5

und dann mal lesen

cu
stonki

[Anonymous]

danke hab ich ja schon gemacht ich hab nix auffälliges gefunden, vllt. kannst du ma drüberschauen .. besten dank!

Code:

 - parsing '/etc/proftpd.conf' configuration
 - <Directory /*>: adding section for resolved path '/*'
localhost -
localhost - Config for dukes penthouse:
localhost - /*
localhost -  Limit
localhost -   DenyAll
localhost -   AllowGroup
localhost -  AllowOverwrite
localhost -  AllowForeignAddress
localhost -  Umask
localhost -  SQLAuthTypes
localhost -  SQLAuthenticate
localhost -  SQLConnectInfo
localhost -  SQLDefaultGID
localhost -  SQLDefaultUID
localhost -  SQLHomedirOnDemand
localhost -  RequireValidShell
localhost -  SQLLog_PASS
localhost -  SQLNamedQuery_updatelogin
localhost -  SQLLog_STOR
localhost -  SQLLog_RETR
localhost -  SQLLog_ERR_STOR
localhost -  SQLLog_ERR_RETR
localhost -  SQLNamedQuery_logtrafic
localhost -  SQLLog_ERR_*
localhost -  SQLNamedQuery_logevents
localhost -  RootLogin
localhost - DefaultServer
localhost - DeferWelcome
localhost - AllowForeignAddress
localhost - Umask
localhost - UserID
localhost - UserName
localhost - GroupID
localhost - GroupName
localhost - SQLAuthTypes
localhost - SQLAuthenticate
localhost - SQLConnectInfo
localhost - SQLUserTable
localhost - SQLUsernameField
localhost - SQLPasswordField
localhost - SQLHomedirField
localhost - SQLGroupTable
localhost - SQLGroupnameField
localhost - SQLGroupGIDField
localhost - SQLGroupMembersField
localhost - SQLUserWhereClause
localhost - SQLDefaultGID
localhost - SQLDefaultUID
localhost - SQLHomedirOnDemand
localhost - RequireValidShell
localhost - SQLLog_PASS
localhost - SQLNamedQuery_updatelogin
localhost - SQLLog_STOR
localhost - SQLLog_RETR
localhost - SQLLog_ERR_STOR
localhost - SQLLog_ERR_RETR
localhost - SQLNamedQuery_logtrafic
localhost - SQLLog_ERR_*
localhost - SQLNamedQuery_logevents
localhost - SQLLogFile
localhost - DefaultRoot
localhost - AllowOverwrite
localhost - RootLogin
localhost - ProFTPD 1.2.9 (stable) (built do mrt 22 18:28:32 CET 2001) standalone mode STARTUP

Code:

Jan 10 10:05:02 mod_sql/4.10[1742]: >>> cmd_getgroups
Jan 10 10:05:02 mod_sql/4.10[1742]: cache hit for user 'duke'
Jan 10 10:05:02 mod_sql/4.10[1742]: cache miss for gid '100'
Jan 10 10:05:02 mod_sql/4.10[1742]: : entering mysql cmd_select
Jan 10 10:05:02 mod_sql/4.10[1742]: entering mysql cmd_open
Jan 10 10:05:02 mod_sql/4.10[1742]: connection 'default' count is now 2
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_open
Jan 10 10:05:02 mod_sql/4.10[1742]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jan 10 10:05:02 mod_sql/4.10[1742]: entering mysql cmd_close
Jan 10 10:05:02 mod_sql/4.10[1742]: connection 'default' count is now 1
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_close
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_select
Jan 10 10:05:02 mod_sql/4.10[1742]: : entering mysql cmd_select
Jan 10 10:05:02 mod_sql/4.10[1742]: entering mysql cmd_open
Jan 10 10:05:02 mod_sql/4.10[1742]: connection 'default' count is now 2
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_open
Jan 10 10:05:02 mod_sql/4.10[1742]: query "SELECT groupname, id, username FROM groups WHERE (username = 'duke' OR username LIKE 'duke,%' OR username LIKE '%,duke' OR username LIKE '%,duke,%')"
Jan 10 10:05:02 mod_sql/4.10[1742]: entering mysql cmd_close
Jan 10 10:05:02 mod_sql/4.10[1742]: connection 'default' count is now 1
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_close
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_select
Jan 10 10:05:02 mod_sql/4.10[1742]: cache hit for group 'admin'
Jan 10 10:05:02 mod_sql/4.10[1742]: <<< cmd_getgroups
Jan 10 10:05:02 mod_sql/4.10[1742]: >>> cmd_getpwnam
Jan 10 10:05:02 mod_sql/4.10[1742]: cache hit for user 'duke'
Jan 10 10:05:02 mod_sql/4.10[1742]: <<< cmd_getpwnam
Jan 10 10:05:02 mod_sql/4.10[1742]: >>> cmd_gid2name
Jan 10 10:05:02 mod_sql/4.10[1742]: cache miss for gid '100'
Jan 10 10:05:02 mod_sql/4.10[1742]: : entering mysql cmd_select
Jan 10 10:05:02 mod_sql/4.10[1742]: entering mysql cmd_open
Jan 10 10:05:02 mod_sql/4.10[1742]: connection 'default' count is now 2
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_open
Jan 10 10:05:02 mod_sql/4.10[1742]: query "SELECT groupname FROM groups WHERE (id = 100) LIMIT 1"
Jan 10 10:05:02 mod_sql/4.10[1742]: entering mysql cmd_close
Jan 10 10:05:02 mod_sql/4.10[1742]: connection 'default' count is now 1
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_close
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_select
Jan 10 10:05:02 mod_sql/4.10[1742]: <<< cmd_gid2name
Jan 10 10:05:02 mod_sql/4.10[1742]: >>> cmd_auth
Jan 10 10:05:02 mod_sql/4.10[1742]: entering mysql cmd_escapestring
Jan 10 10:05:02 mod_sql/4.10[1742]: exiting mysql cmd_escapestring
Jan 10 10:05:02 mod_sql/4.10[1742]: cache hit for user 'duke'
Jan 10 10:05:02 mod_sql/4.10[1742]: >>> cmd_check
Jan 10 10:05:02 mod_sql/4.10[1742]: checking auth_type Plaintext
Jan 10 10:05:02 mod_sql/4.10[1742]: 'Plaintext' auth handler reports success
Jan 10 10:05:02 mod_sql/4.10[1742]: cache hit for user 'duke'
Jan 10 10:05:02 mod_sql/4.10[1742]: <<< cmd_check
Jan 10 10:05:02 mod_sql/4.10[1742]: <<< cmd_auth
Jan 10 10:05:02 mod_sql/4.10[1742]: >>> cmd_getpwnam
Jan 10 10:05:02 mod_sql/4.10[1742]: cache hit for user 'duke'
Jan 10 10:05:02 mod_sql/4.10[1742]: <<< cmd_getpwnam

[stonki]

localhost - ProFTPD 1.2.9 (stable) (built do mrt 22 18:28:32 CET 2001) standalone mode STARTUP[/code]

hier geht es noch weiter... Was kommt da ?

cu
stonki