I have problem with proftpd ispcp

I have problem with proftpd ispcp - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: I have problem with proftpd ispcp (/thread-4936.html)

Pages: 1 2

RE: I have problem with proftpd ispcp - sci2tech - 11-16-2008 05:26 AM

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

RE: I have problem with proftpd ispcp - Alex1 - 11-16-2008 05:41 AM

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

RE: I have problem with proftpd ispcp - sci2tech - 11-16-2008 05:56 AM

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

RE: I have problem with proftpd ispcp - Alex1 - 11-16-2008 06:11 AM

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

RE: I have problem with proftpd ispcp - sci2tech - 11-16-2008 06:19 AM

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

RE: I have problem with proftpd ispcp - Alex1 - 11-16-2008 06:26 AM

* 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#

RE: I have problem with proftpd ispcp - joximu - 11-16-2008 08:37 AM

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

maybe better remove them and install them again...

RE: I have problem with proftpd ispcp - Alex1 - 11-16-2008 07:00 PM

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