[Solved] another proftpd issue (authentification issue)

[yohann]

hello,
i meet another proftpd issue,
when i run then debug command, everything looks fine:

Code:

root@Web2009:~# proftpd -n -d5
- mod_tls/2.1.2: using OpenSSL 0.9.8g 19 Oct 2007
- DenyFilter: compiling deny regex '\*.*/'
- <IfModule>: using 'mod_quotatab.c' section at line 92
- <IfModule>: skipping 'mod_ratio.c' section at line 96
- <IfModule>: using 'mod_delay.c' section at line 104
- <IfModule>: using 'mod_ctrls.c' section at line 108
- <IfModule>: using 'mod_ctrls_admin.c' section at line 116
Web2009.inforezo.com -
Web2009.inforezo.com - Config for Debian:
Web2009.inforezo.com - DeferWelcome
Web2009.inforezo.com - DefaultServer
Web2009.inforezo.com - ShowSymlinks
Web2009.inforezo.com - TimeoutNoTransfer
Web2009.inforezo.com - TimeoutStalled
Web2009.inforezo.com - TimeoutIdle
Web2009.inforezo.com - DisplayLogin
Web2009.inforezo.com - DisplayChdir
Web2009.inforezo.com - ListOptions
Web2009.inforezo.com - DenyFilter
Web2009.inforezo.com - UserID
Web2009.inforezo.com - UserName
Web2009.inforezo.com - GroupID
Web2009.inforezo.com - GroupName
Web2009.inforezo.com - Umask
Web2009.inforezo.com - DirUmask
Web2009.inforezo.com - AllowOverwrite
Web2009.inforezo.com - TransferLog
Web2009.inforezo.com - QuotaEngine
Web2009.inforezo.com - DelayEngine
Web2009.inforezo.com - ProFTPD 1.3.1 (stable) (built Thu Feb 21 04:21:14 UTC 2008) standalone mode STARTUP

but i have an unknow user error each time i try to connect.

after reading posts in the forum i found that i couldn't connect to mysql using an ftpuser:

mysql -u yohann@inforezo.com -pmypass
ERROR 1045 (28000): Access denied for user 'yohann@inforezo.'@'localhost' (using password: YES)

i don't know why the username is truncated.

i tried logind to mysql as root and list all mysql users:

Code:

+------------------+
| User             |
+------------------+
| root             |
|                  |
| root             |
|                  |
| adminguidance    |
| consultguidance  |
| debian-sys-maint |
| ig_testeur       |
| inforezo         |
| karine           |
| phpmyvisites     |
| pma              |
| root             |
| vftp             |
| wikini           |
+------------------+

i can't see any of the ftp account, but the user vftp.

here is a what i see when i try to login after i set proftpd in debug mode:

Code:

Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - FTP session requested from unknown class
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - connected - local  : ::ffff:192.168.0.2:21
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - connected - remote : ::ffff:88.171.98.41:52416
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - FTP session opened.
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'USER yohann@inforezo.com' to mod_rewrite
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'USER yohann@inforezo.com' to mod_tls
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'USER yohann@inforezo.com' to mod_core
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'USER yohann@inforezo.com' to mod_core
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'USER yohann@inforezo.com' to mod_delay
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'USER yohann@inforezo.com' to mod_auth
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching CMD command 'USER yohann@inforezo.com' to mod_auth
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - no supplemental groups found for user 'yohann@inforezo.com'
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching POST_CMD command 'USER yohann@inforezo.com' to mod_sql
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching POST_CMD command 'USER yohann@inforezo.com' to mod_delay
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching LOG_CMD command 'USER yohann@inforezo.com' to mod_sql
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching LOG_CMD command 'USER yohann@inforezo.com' to mod_log
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap2
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_ban
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_sql
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching CMD command 'PASS (hidden)' to mod_auth
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - no supplemental groups found for user 'yohann@inforezo.com'
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - no such user 'yohann@inforezo.com'
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - USER yohann@inforezo.com: no such user found from lal69-5-88-171-98-41.fbx.proxad.net [::ffff:88.171.98.41] to ::ffff:192.168.0.2:21
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_delay
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
Web2009.inforezo.com (lal69-5-88-171-98-41.fbx.proxad.net[::ffff:88.171.98.41]) - FTP session closed.

i really don't know where does this probleme come from.

thank you for help