Hi, this is not TSL specific, but I did a Proftpd+MySQL Setup a while ago, here are my notes:
Proftpd should be build with at least # ./configure --with-modules=mod_sql:mod_sql_mysql Then create your SQL Tables: mysql> create database ftp; mysql> use ftp; mysql> create table users ( -> userid varchar(30) NOT NULL UNIQUE, -> passwd varchar(80) NOT NULL, -> uid integer UNIQUE, -> gid integer, -> homedir varchar(255), -> shell varchar(255) -> ); mysql> create table groups ( -> groupname varchar(30) NOT NULL, -> gid integer NOT NULL, -> members varchar(255) -> ); And create a mysql user which is allowed to connect to the ftp database, username and password are needed in the proftpd.conf file. The last step is to modify the proftpd.conf file and add something like this (<db> is "ftp" according to the mysql example above): # Sql Stuff SQLConnectInfo <db>@localhost <user> <password> SQLAuthTypes Plaintext Crypt SQLAuthenticate users* groups* #SQLUserInfo <- not needed, as we use the defualt tables #SQLGroupInfo <- not needed, as we use the defualt tables RootLogin off RequireValidShell off hope this helps ... best regards, Arne Brodowski Barbara M. wrote: > Hi all, > anyone have tried to use MySQL or other SQL to authenticate > Proftpd users? > Where I can find info/example? > > Regards, B. > > > > _______________________________________________ > tsl-discuss mailing list > [email protected] > http://lists.trustix.org/mailman/listinfo/tsl-discuss _______________________________________________ tsl-discuss mailing list [email protected] http://lists.trustix.org/mailman/listinfo/tsl-discuss
