PureFTPd And MySQL On OpenSuSE

Hi,

i am getting an error mesage, when i am trying to install pure ftpd with mysql auth. under opensuse 11.2

Starting pure-ftpd421 Configuration error: Invalid SQL configuration file: /etc/pure-ftpd/pureftpd-mysql.conf
startproc: exit status of parent of /usr/sbin/pure-ftpd: 252

Does anyone know why this message? I did everything acording the manual falko wrote here ....

Thanks a lot.

 

Can you post your /etc/pure-ftpd/pureftpd-mysql.conf?

 

Sure I can....

Code:

MYSQLSocket      /var/run/mysql/mysql.sock
#MYSQLServer     localhost
#MYSQLPort       3306
MYSQLUser       pureftpd
MYSQLPassword   <here is my pass>
MYSQLDatabase   pureftpd
#MYSQLCrypt md5, cleartext, crypt() or password() - md5 is VERY
RECOMMENDABLE uppon cleartext
MYSQLCrypt      md5
MYSQLGetPW      SELECT Password FROM ftpd WHERE User="\L" AND status="1"
AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetUID     SELECT Uid FROM ftpd WHERE User="\L" AND status="1" AND
(ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetGID     SELECT Gid FROM ftpd WHERE User="\L"AND status="1" AND
(ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetDir     SELECT Dir FROM ftpd WHERE User="\L"AND status="1" AND
(ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User="\L"AND
status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User="\L"AND
status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTASZ   SELECT QuotaSize FROM ftpd WHERE User="\L"AND status="1"
AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTAFS   SELECT QuotaFiles FROM ftpd WHERE User="\L"AND
status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")

It's from your manual ...

 

Please remove the line breaks so that you have one directive per line.

 

Man ...

First of all i though that you must be kidding me ....

But it is working now. Thanks. Problem solved.