pure-ftpd: Invalid SQL configuration file
Submitted by Bram Schoenmakers on 8 May, 2009 - 14:56.
When starting the Pure-FTPd daemon I came across the following error:
pure-ftpd: (?@?) [ERROR] Configuration error: Invalid SQL configuration file: /etc/pureftpd-mysql.conf
This is caused by these lines in /etc/pureftpd-mysql.conf:
MYSQLGetQTAFS SELECT maxFiles FROM pureFtpdAuth WHERE ftpUser="\L"
MYSQLGetQTASZ SELECT maxDiskUsage FROM pureFtpdAuth WHERE ftpUser="\L"
MYSQLGetQTASZ SELECT maxDiskUsage FROM pureFtpdAuth WHERE ftpUser="\L"
It appears to be that Pure-FTPd was built without quota support. Rebuilding Pure-FTPd with the option --with-quotas fixed this error.