There is a new version of this tutorial available for Debian 5 (Lenny).

Virtual Hosting With Proftpd And MySQL (Incl. Quota) - Page 3

This tutorial exists for these OS versions

On this page

5.1 Database Administration

For most people it is easier if they have a graphical front-end to MySQL; therefore you can also use phpMyAdmin (in this example under to administrate the ftp database.

Whenever you create a new user, you only have to create entries in the tables ftpquotalimits and ftpuser so I will explain the columns of these tables here:

ftpuser Table:

The important columns are these (the others are handled by MySQL or Proftpd automatically, so do not fill these manually!):

  • userid: The name of the virtual Proftpd user (e.g. exampleuser).
  • passwd: The unencrypted (i.e., clear-text) password of the user.
  • uid: The userid of the ftp user you created at the end of step two (e.g. 2001).
  • gid: The groupid of the ftp group you created at the end of step two (e.g. 2001).
  • homedir: The home directory of the virtual Proftpd user (e.g. /home/ If it does not exist, it will be created when the new user logs in the first time via FTP. The virtual user will be jailed into this home directory, i.e., he cannot access other directories outside his home directory.
  • shell: It is ok if you fill in /sbin/nologin here by default.

ftpquotalimits Table:

The important columns are these (the others are handled by MySQL or Proftpd automatically, so do not fill these manually!):

  • name: The name of the virtual Proftpd user (e.g. exampleuser).
  • quota_type: user or group. Normally, we use user here.
  • per_session: true or false. true means the quota limits are valid only for a session. For example, if the user has a quota of 15 MB, and he has uploaded 15 MB during the current session, then he cannot upload anything more. But if he logs out and in again, he again has 15 MB available. false means, that the user has 15 MB at, no matter if he logs out and in again.
  • limit_type: hard or soft. A hard quota limit is a never-to-exceed limit, while a soft quota can be temporarily exceeded. Normally you use hard here.
  • bytes_in_avail: Upload limit in bytes (e.g. 15728640 for 15 MB). 0 means unlimited.
  • bytes_out_avail: Download limit in bytes. 0 means unlimited.
  • bytes_xfer_avail: Transfer limit in bytes. The sum of uploads and downloads a user is allowed to do. 0 means unlimited.
  • files_in_avail: Upload limit in files. 0 means unlimited.
  • files_out_avail: Download limit in files. 0 means unlimited.
  • files_xfer_avail: Tranfer limit in files. 0 means unlimited.

The ftpquotatallies table is used by Proftpd internally to manage quotas so you do not have to make entries there!

6 Anonymous FTP

If you want to create an anonymous ftp account (an ftp account that everybody can login to without a password), you can do it like this:

First we create a user and group with the name anonymous_ftp. The user has the home directory /home/anonymous_ftp:

groupadd -g 2002 anonymous_ftp
useradd -u 2002 -s /bin/false -d /home/anonymous_ftp -m -c "Anonymous FTP User" -g anonymous_ftp anonymous_ftp

(Replace 2002 with a group-/userid that is free on your system.)

Then we create the directory /home/anonymous_ftp/incoming which will allow anonymous users to upload files:

mkdir /home/anonymous_ftp/incoming
chown anonymous_ftp:nogroup /home/anonymous_ftp/incoming

And finally, open /etc/proftpd.conf and append the following directives to it:

<Anonymous ~anonymous_ftp>
User anonymous_ftp
Group nogroup
# We want clients to be able to login with "anonymous" as well as "ftp"
UserAlias anonymous anonymous_ftp
# Cosmetic changes, all files belongs to ftp user
DirFakeUser on anonymous_ftp
DirFakeGroup on anonymous_ftp

RequireValidShell off

# Limit the maximum number of anonymous logins
MaxClients 10

# We want 'welcome.msg' displayed at login, and '.message' displayed
# in each newly chdired directory.
DisplayLogin welcome.msg
DisplayFirstChdir .message

# Limit WRITE everywhere in the anonymous chroot
<Directory *>
<Limit WRITE>

# Uncomment this if you're brave.
<Directory incoming>
# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
Umask 022 022
<Limit STOR>


Finally restart Proftpd:

/etc/init.d/proftpd restart

Now anonymous users can login, and they can download files from /home/anonymous_ftp, but uploads are limited to /home/anonymous_ftp/incoming (and once a file is uploaded into /home/anonymous_ftp/incoming, it cannot be read nor downloaded from there; the server admin has to move it into /home/anonymous_ftp first to make it available to others).

(Please note: You can only have one anonymous ftp account per IP address!)


Mandrake 10.1 - Proftpd + MySQL authentication + Quotas Howto:





Share this page:

Suggested articles

8 Comment(s)

Add comment


By: Anonymous

First of all, nice article! Shows you how one should do it the right way! :)

I would like to point out that there's a nice webbased admin tool for doing just what you need, like adding users, chaning passwords, etc.. It's in an early stage, but more then usefull. (there used to be a tool like myftpadmin, but this project seems to have died..)

Here's PPMy :


By: Anonymous

thank you for this quite good article. it's easy to understand and it seems to be complete...and finally, it really works :) kay (

By: Anonymous

YAY thanks for the easy to follow guide :)



By: Anonymous

It is extremely useful ! Thanks alot!

By: Anonymous

I tested ISPConfig in VMWare and I saw that when you upload files into incoming directory, those files automatically get "hidden". That's good to avoid overwriting incoming files.

You will get that if you limit read permissions in incoming directory:
chmod 331 /home/anonymous_ftp/incoming

Thank you for this guide :) 

By: Conny

No useful for me, I followed the guide and replaced the passwords when needed but I get this when I restart proftpd.

Fatal: unknown configuration directive 'SQLConnectInfo' on line 41 of '/etc/proftpd/proftpd.conf'

  Fatal: unknown configuration directive 'SQLAuthenticate' on line 37 of '/etc/proftpd/proftpd.conf'

  Fatal: unknown configuration directive 'SQLUserInfo' on line 45 of '/etc/proftpd/proftpd.conf'


Seems like everyting in the config file fails :-/



By: Conny

As I wrote before i had errors starting proftpd, don't forget to uncomment the sql modules in /etc/proftpd/modules.conf

But I still have problems connecting with the 'exampleuser' and passwd 'secret'.


I will reboot the system and try again.


By: Jon

I couldn't get this setup to work but found this one, which is similar and it worked: