cpanel pure-ftpd and Mysql Authentication

[anup123]

Always used pure-ftpd but was missing the authentication against Mysql Databases also. I have webmail with dynamic virtual hosting and wanted tp give ftp access (and avoid web based filemanagerfor obvious reasons). This is how i could manage finally (Hope it doesn't break other things ... so far it hasn't though)

Download the src.rpm from http://diff.cpanel.net/ftpinstall/pure-ftpd/src/

rpmbuild --rebuild --define 'with_mysql 1' ...src.rpm
rpm -Uvh pure-ftpd...rpm --force

edit pure-ftpd.conf to uncomment the Mysql Authentication part.
edit /etc/rc.d/init.d/pure-ftpd to include lmysql:/etc/pureftpd-mysql.conf

put up the necessary details in /etc/pureftpd-mysql.conf file

restarted pure-ftpd

and it authenticates off the Mysql database also in addition to the default authentication.

host : user.domain.tld
username: user@domain.tld
password : userpassword

Wow. So easy.
If this has any pitfalls, please do point out.
If this is fine....

I WISH cPanel gets rpms with --with-mysql built into it so that all this can be avoided except perhaps for adding the additional switch in the startup file....

[EDIT] Here is the Official Feature Request Quite Sometime back:

http://bugzilla.cpanel.net/show_bug.cgi?id=1334

[/EDIT]

Anup