[solved] debian 5 can not log in to proftpd

[johnnyrevell]

Hi I followed the install instructions at
http://www.isp-control.net/documentation...ion:debian

I'm using Debian 5.0 (lenny)

ispcp version 1.0.2
mysql 5.0.51a
proftpd 1.3.1

Everything OK except I cannot ftp in- I get a 421 service not available if I ftp the server.

I bit of digging shows proftpd cannot log into the mysql table using the credentials specified in proftpd.conf SQLConnectInfo in the default install:
# ispCP SQL Managment
SQLBackend mysql
SQLAuthTypes Crypt
SQLAuthenticate on
SQLConnectInfo ispcp@localhost vftp cXu*KAra+_])hK2g@zf
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinUserUID 2000
SQLMinUserGID 2000


If I change SQLAuthTypes from Crypt to Crypt Plaintext, and put in cleartext the password for vftp, I can ftp to the server, and users can log in OK

Is there a problem between the crypted password in proftpd.conf and mysql? I have tried setting the mysql password via old_password as someone suggested and left the proftpd.conf hash alone, but this doesn't work

Any ideas?

John