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)

Add comment

Please register in our forum first to comment.

Comments

By: stephane

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

By: nolka4

you need uncomment a few lines in /etc/proftpd/modules.conf:

LoadModule mod_sql.c

...
LoadModule mod_sql_mysql.c

By: Anonymous

uhh . but the web interface where i find ? :(

By: Jim

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

By:

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. 

http://bugs.mysql.com/bug.php?id=17501