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

Want to support HowtoForge? Become a subscriber!
 
Submitted by falko (Contact Author) (Forums) on Sat, 2005-10-15 14:27. ::

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 http://server1.example.com/phpmyadmin/) 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/www.example.com). 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>
DenyAll
</Limit>
</Directory>

# 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 READ WRITE>
DenyAll
</Limit>
<Limit STOR>
AllowAll
</Limit>
</Directory>

</Anonymous>

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!)

References

Mandrake 10.1 - Proftpd + MySQL authentication + Quotas Howto: http://www.khoosys.net/single.htm?ipg=848

Links

Proftpd: http://www.proftpd.org/

MySQL: http://www.mysql.com/

phpMyAdmin: http://www.phpmyadmin.net/


Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.
Submitted by Jon (not registered) on Thu, 2011-09-22 02:16.

I couldn't get this setup to work but found this one, which is similar and it worked: http://sdykman.com/blog/proftpd-and-mysql

Submitted by Conny (not registered) on Sun, 2008-12-28 18:17.

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.

 

Submitted by Conny (not registered) on Sun, 2008-12-28 17:49.

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 :-/

 

 

Submitted by Anonymous (not registered) on Tue, 2006-08-15 03:47.

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 :) 

Submitted by Anonymous (not registered) on Tue, 2005-12-27 17:58.
It is extremely useful ! Thanks alot!
Submitted by Anonymous (not registered) on Tue, 2005-12-13 05:40.

YAY thanks for the easy to follow guide :)

WE BE VIRTUAL RAHH

Talon

Submitted by Anonymous (not registered) on Sun, 2005-12-04 00:01.
thank you for this quite good article. it's easy to understand and it seems to be complete...and finally, it really works :) kay (www.smarti.info)
Submitted by Anonymous (not registered) on Thu, 2005-11-10 08:35.

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 : http://sumpan.com/software/ppmy/

Cheers!