I have problem with proftpd ispcp

[sci2tech]

try http://www.isp-control.net/ispcp/browser...oftpd.conf
First config file was for ubuntu hardy.
Or modify that directive in DisplayFirstChadir

[Alex1]

now what? #SQLBackend mysql
SQLAuthTypes Crypt
SQLAuthenticate on
SQLConnectInfo proftpd@localhost root dbpass
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinUserUID 2000
SQLMinUserGID 2000

root@alex:/home/alex# /etc/init.d/proftpd restart
* Stopping ftp server proftpd [ OK ]
* Starting ftp server proftpd - Fatal: unknown configuration directive 'SQLAuthTypes' on line 165 of '/etc/proftpd/proftpd.conf

[sci2tech]

First in /etc/proftpd/modules.conf uncomment lines:

Code:

LoadModule mod_sql.c
LoadModule mod_sql_mysql.c

Mother god!!! you did not replaced variable between {} with proper values!!!:
SQLMinUserUID {FTPD_MIN_UID} -> SQLMinUserUID 2000
SQLMinUserGID {FTPD_MIN_GID} -> SQLMinUserGID 2000
ServerName "{HOST_NAME}" -> ServerName "your_server_name"
SQLConnectInfo {DATABASE_NAME}@{DATABASE_HOST} {DATABASE_USER} {DATABASE_PASS} -> SQLConnectInfo your conection datas

[Alex1]

SQLAuthTypes Crypt
SQLAuthenticate on
SQLConnectInfo proftpd@localhost root dbpass
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinUserUID 2000
SQLMinUserGID 2000

root@alex:/home/alex# /etc/init.d/proftpd restart
* Stopping ftp server proftpd [ OK ]
* Starting ftp server proftpd - Fatal: unknown configuration directive 'SQLAuthTypes' on line 165 of '/etc/proftpd/proftpd.conf

[sci2tech]

Why do you have commented line SQLBackend mysql ? Uncomment it!
Did you uncomment that 2 lines?

Code:

LoadModule mod_sql.c
LoadModule mod_sql_mysql.c

?
Did you installed proftpd-mysql?

Code:

apt-get install proftpd-mysql

[Alex1]

* Starting ftp server proftpd - Fatal: unknown configuration directive 'SQLAuthTypes' on line 165 of '/etc/proftpd/proftpd.conf'
[fail]
invoke-rc.d: initscript proftpd, action "start" failed.
dpkg: error processing proftpd (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of proftpd-mysql:
proftpd-mysql depends on proftpd (= 1.3.0-21ubuntu1); however:
Package proftpd is not configured yet.
dpkg: error processing proftpd-mysql (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
proftpd
proftpd-mysql
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@alex:/home/alex#

[joximu]

you have to install & configure the two packages: proftpd and proftpd-mysql...

maybe better remove them and install them again...

[Alex1]

dear my config: http://ns69.eu/proftpd.conf