| KR-data |
01-29-2005 06:29 PM |
Pure-ftpd, login with MySQL as control - problem
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? |
