-
Sql and proftpd
I have been trying to set up proFTPd Administrator
All has gone well apart from when I try to restart proftpd it fails to start referring to the following lines in the proftpd.conf file
################################################## ################################################## ####
SQLLogFile /var/log/proftpd.mysql
# Set up authentication via SQL
# ===========
AuthOrder mod_sql.c
SQLAuthTypes Backend
SQLConnectInfo proftpd_admin@localhost proftpd "my password here"
SQLUserInfo usertable userid passwd uid gid homedir shell
SQLGroupInfo grouptable groupname gid members
SQLUserWhereClause "disabled=0 and (NOW()<=expiration or expiration=-1 or expiration=0)"
################################################## ################################################## ######
First it dosent like "SQLLogFile
################################################## ################################################## ######
Executing /etc/rc.d/init.d/proftpd restart ..
Shutting down proftpd: [FAILED]
Starting proftpd: - Fatal: unknown configuration directive 'SQLLogFile' on line 36 of '/etc/proftpd.conf'
[FAILED]
################################################## ################################################## ########
if I hash that then it moves done each line.
################################################## ################################################## #########
Executing /etc/rc.d/init.d/proftpd restart ..
Shutting down proftpd: [FAILED]
Starting proftpd: - Fatal: unknown configuration directive 'SQLAuthTypes' on line 41 of '/etc/proftpd.conf'
[FAILED]
################################################## ################################################## #########
I am quite new to Linux so I have probably made an obvious error,
Thanks in advance
Marc Emond
-
Solved this problem
I've found the solution on a German site
Problem mit SQLAuthTypes im ProFTPD - administrator ;)
Solution for above problems:
Make sure you add the line to your /etc/proftpd/proftpd.conf
Code:
Include /etc/proftpd/modules.conf
I've pasted this just below user/group in the beginning. This loads the correct modules.
This also solves the other problems with SQLLogFile, QuotaLog with me :)
Greetings djieno