/proftpd/sql.conf

 1#
 2# Proftpd sample configuration for SQL-based authentication.
 3#
 4# (This is not to be used if you prefer a PAM-based SQL authentication)
 5#
 6
 7<IfModule mod_sql.c>
 8#
 9# Choose a SQL backend among MySQL or PostgreSQL.
10# Both modules are loaded in default configuration, so you have to specify the backend 
11# or comment out the unused module in /etc/proftpd/modules.conf.
12# Use 'mysql' or 'postgres' as possible values.
13#
14#SQLBackend	mysql
15#
16#SQLEngine on
17#SQLAuthenticate on
18#
19# Use both a crypted or plaintext password 
20#SQLAuthTypes Crypt Plaintext
21#
22# Use a backend-crypted or a crypted password
23#SQLAuthTypes Backend Crypt 
24#
25# Connection 
26#SQLConnectInfo proftpd@sql.example.com proftpd_user proftpd_password
27#
28# Describes both users/groups tables
29#
30#SQLUserInfo users userid passwd uid gid homedir shell
31#SQLGroupInfo groups groupname gid members
32#
33</IfModule>