[solved] debian 5 can not log in to proftpd

[johnnyrevell]

(11-25-2009 05:21 AM)motokochan Wrote:  I think it's because the password isn't in UNIX crypt form. Look at the ftp_users table. Does the passwd value begin with $1$ ?

yes they do; I think the problem is the vftp user used by proftpd cannot log into the database at all due to some problem between the encrypted password in proftpd and in the mysql user space

from SqlLogFile:
Nov 24 20:22:39 mod_sql/4.2.2[2779]: defaulting to 'mysql' backend
Nov 24 20:22:39 mod_sql/4.2.2[2779]: backend module 'mod_sql_mysql/4.0.8'
Nov 24 20:22:39 mod_sql/4.2.2[2779]: backend api 'mod_sql_api_v1'
Nov 24 20:22:39 mod_sql/4.2.2[2779]: >>> sql_sess_init
Nov 24 20:22:39 mod_sql/4.2.2[2779]: entering mysql cmd_defineconnection
Nov 24 20:22:39 mod_sql/4.2.2[2779]: name: 'default'
Nov 24 20:22:39 mod_sql/4.2.2[2779]: user: 'vftp'
Nov 24 20:22:39 mod_sql/4.2.2[2779]: host: 'localhost'
Nov 24 20:22:39 mod_sql/4.2.2[2779]: db: 'ispcp'
Nov 24 20:22:39 mod_sql/4.2.2[2779]: port: '3306'
Nov 24 20:22:39 mod_sql/4.2.2[2779]: ttl: '0'
Nov 24 20:22:39 mod_sql/4.2.2[2779]: exiting mysql cmd_defineconnection
Nov 24 20:22:39 mod_sql/4.2.2[2779]: entering mysql cmd_open
Nov 24 20:22:39 mod_sql/4.2.2[2779]: exiting mysql cmd_open
Nov 24 20:22:39 mod_sql/4.2.2[2779]: unrecoverable backend error
Nov 24 20:22:39 mod_sql/4.2.2[2779]: error: '1045'
Nov 24 20:22:39 mod_sql/4.2.2[2779]: message: 'Access denied for user 'vftp'@'localhost' (using password: YES)'

Could it be I'm using mod_sql_mysql/4.0.8 in mysql 5?


John