Pure-ftpd, login with MySQL as control

KR-data · 01-29-2005, 06:29 PM

Hi

I got a problem with my Pure-ftpd. I have compiled it with mysql-support and done what their manuals sais I have to do.

I Execute it with the command:

Code:

# pure-ftpd -C 3 -H -E -K 95 -p 1025:3000 -t 512:128 -U 755:755 -Y 2 -l mysql:/cmn/pftpd-mysql.conf

I have set up the database, table, user etc. etc.

My config file looks like this:

Code:

MYSQLServer     localhost
MYSQLPort       3306
MYSQLSocket     /var/lib/mysql/mysql.sock
MYSQLUser       pftpd
MYSQLPassword   ******
MYSQLDatabase   pftpd
MYSQLCrypt      MD5
MYSQLDefaultUID 1000
MYSQLDefaultGID 1000
MYSQLGetPW      SELECT Password FROM users WHERE User="\L"
MYSQLGetUID     SELECT Uid FROM users WHERE User="\L"
MYSQLGetGID     SELECT Gid FROM users WHERE User="\L"
MYSQLGetDir     SELECT Dir FROM users WHERE User="\L"
MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="\L"
MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="\L"

And it is also made after the manual.

If I take a look in my system-log it tells me this:

Quote:

Jan 30 01:19:14 stine pure-ftpd: (?@127.0.0.1) [ERROR] The SQL server seems to be down
Jan 30 01:19:14 stine pure-ftpd: (?@127.0.0.1) [WARNING] Authentication failed for user [kr-data]

To me it seems like it is completely ignoring my configurations, also because if I change localhost to anette (which should resolve the ip 192.168.0.1) it still says 127.0.0.1

What can I do to fix this problem?