Comments on Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Ubuntu 8.04 LTS
This document describes how to install a Proftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine. In addition to that I will show the use of quota with this setup.
5 Comment(s)
Comments
heya )
I got an error starting ftp :
SQLBackend mysql
Fatal: unknown configuration directive 'SQLBackend' on line 121 of '/etc/proftpd/proftpd.conf'
Do you knwo what it mean ?
thanks for reply
you need uncomment a few lines in /etc/proftpd/modules.conf:
LoadModule mod_sql.c
uhh . but the web interface where i find ? :(
My machine IP is 192.168.0.23,I've created successfully a virtual machine with domaine name X with the same IP but when I tried to create another virtual host with domain name Y with an IP of the same network(ex: 192.168.0.x),it's failing. But when I use something like 127.0.1.x, it's working... Any help will be highly appreciated...Thanks
In case you get the following error
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='ProFTP group table'' at line 6
when cretating tables in the new "ftp" database, exchange TYPE with ENGINE in the commands.
Since some mysql version TYPE was removed, but ENGINE can be used instead.