Pureftpd exit 252

Whenever I start pureftpd useing MySQL it imediately responds with exit 252 <my startup command>

How can I fix this or at least work out whats causeing this?

P.S. I compiled pureftpd from source and start it with

Code:

sudo /usr/local/sbin/pure-ftpd -switches -l mysql:/ect/pureftpd/mysql.conf &

 

Is MySQL running? What's in /ect/pureftpd/mysql.conf?
Any errors in your log files?

 

I got mysql-server, mysql-client and libMySQLclient12-dev client form the ubuntu repositories (probobly some dependencies too). and I can log in to MySQL and make databases, but I don't know the command to check if a program is running.

I couldn't see any room for improvement on the mysql.conf in your guide so I stuck with that.

I can give you the mysql.bin.##### logs if you want but I don't seem to have any pure-ftpd logs

 

Do you see it when you run

Code:

netstat -tap

?

Do you use Debian on your system?

 

yeah its their, tcp 0 0 localhost:mysql *:* LISTEN -


And I use Ubuntu server edition.

 

And your /etc/pure-ftpd/db/mysql.conf looks like this?

Code:

MYSQLSocket      /var/run/mysqld/mysqld.sock
#MYSQLServer     localhost
#MYSQLPort       3306
MYSQLUser       pureftpd
MYSQLPassword   ftpdpass
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")

Does /var/run/mysqld/mysqld.sock exist?

 

yes to both, and I tried modifying the file to use TCP rather than the socket

 

Ok this is embaressing but I figured out the problem: typo.

Sorry to waste your time and thanks for all the help