Quote:london190:/var/www/ispcp/engine/setup# perl ispcp-update
Name "main:b" used only once: possible typo at ispcp-update line 750.
Make sure you have read and performed all steps from docs/distro/INSTALL
document.

Continue?
(1) Yes
(0) No
Your selection: 1
Welcome to ispCP '1.0.0 OMEGA' Update Dialog.
This program will update your VHCS / ispCP OMEGA system on your server.
Please make sure you have a backup of your server data.

NOTE: During the migration process some or all services might require to be
shut down or restarted.

Please select from which version you want to update:
(1) VHCS 2.4.7 or VHCS 2.4.7.1
(2) VHCS 2.4.8 RC1
(3) ispCP OMEGA 1.0.0 RC2 (incl. b and c)
(4) ispCP OMEGA 1.0.0 RC3
(5) ispCP OMEGA 1.0.0 RC4
(6) ispCP OMEGA 1.0.0 RC5
(7) ispCP OMEGA 1.0.0 RC6
(8) ispCP OMEGA 1.0.0 RC7
(0) abort
Your selection: 8
Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
Stopping ispCP Network Traffic Logger: ispcp_network.
Upgrading system values...done
Rebuilding system configurations...
Please enter ispCP ftp SQL user. [vftp]:

Please enter ispCP ftp SQL user password. [auto generate]:
ispCP ftp SQL user password set to: )yGs9eq_@bCH,eB:,xA
done


Setting GUI Permissions: .................done
Setting Engine Permissions: .............done
Rebuilding customers...done
Starting ispCP GUI-Backend communication Daemon: ispcp_daemon.
Starting ispCP Network Traffic Logger: ispcp_network.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Warning: SuexecUserGroup directive requires SUEXEC wrapper.
Stopping Postfix Mail Transport Agent: postfix.
Starting Postfix Mail Transport Agent: postfix.
Stopping domain name service...: bind9 waiting for pid 32226 to die.
Starting domain name service...: bind9.
Stopping Courier POP3 server: pop3d.
Starting Courier POP3 server: pop3d.
Stopping Courier POP3-SSL server: pop3d-ssl.
Starting Courier POP3-SSL server: pop3d-ssl.
Stopping Courier IMAP server: imapd.
Starting Courier IMAP server: imapd.
Stopping Courier IMAP-SSL server: imapd-ssl.
Starting Courier IMAP-SSL server: imapd-ssl.
Stopping ftp server: proftpd.
Starting ftp server: proftpd - Fatal: unknown configuration directive 'SQLAuthTypes' on line 164 of '/etc/proftpd/proftpd.conf'
failed!
Stopping Courier authentication services: authdaemond.
Starting Courier authentication services: authdaemond.

Congratulations!

ispCP '1.0.0 OMEGA' Update completed successfully!

Please type http://admin.london190.server4you.de in your browser,
log in with your Administrator Account and perform
Database Updates if exists.

Quote:london190:/# /etc/init.d/proftpd restart
Stopping ftp server: proftpd.
Starting ftp server: proftpd - Fatal: unknown configuration directive 'SQLAuthTypes' on line 164 of '/etc/proftpd/proftpd.conf'
failed!

Quote:# ispCP SQL Managment
# Activate for proftpd >= 1.3
#SQLBackend mysql
SQLAuthTypes Crypt
SQLAuthenticate on
SQLConnectInfo ispcp@localhost vftp )yGs9eq_@bCH,eB:,xA
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinUserUID 2000
SQLMinUserGID 2000

(03-04-2009 05:43 AM)sci2tech Wrote:  Guess you use etch. apt-get install proftpd-mysql. Please see in INSTALL file what apps are needed to be installed before Tring to use ispcp

Quote:#
# This file is used to manage DSO modules and features.
#

# This is the directory where DSO modules reside

ModulePath /usr/lib/proftpd

# Allow only user root to load and unload modules, but allow everyone
# to see which modules have been loaded

ModuleControlsACLs insmod,rmmod allow user root
ModuleControlsACLs lsmod allow user *

LoadModule mod_ctrls_admin.c
LoadModule mod_tls.c
#LoadModule mod_sql.c
LoadModule mod_ldap.c
#LoadModule mod_sql_mysql.c
LoadModule mod_sql_postgres.c
LoadModule mod_quotatab.c
LoadModule mod_quotatab_file.c
LoadModule mod_quotatab_ldap.c
LoadModule mod_quotatab_sql.c
LoadModule mod_radius.c
LoadModule mod_wrap.c
LoadModule mod_rewrite.c

# keep this module the last one
LoadModule mod_ifsession.c

Quote:You need to enable mysql auth for proftpd in /etc/proftpd/modules.conf. Uncomment both
LoadModule mod_sql.c
and
LoadModule mod_sql_mysql.c

Quote:#
# This file is used to manage DSO modules and features.
#

# This is the directory where DSO modules reside

ModulePath /usr/lib/proftpd

# Allow only user root to load and unload modules, but allow everyone
# to see which modules have been loaded

ModuleControlsACLs insmod,rmmod allow user root
ModuleControlsACLs lsmod allow user *

LoadModule mod_ctrls_admin.c
LoadModule mod_tls.c
LoadModule mod_sql.c
LoadModule mod_ldap.c
LoadModule mod_sql_mysql.c
LoadModule mod_sql_postgres.c
LoadModule mod_quotatab.c
LoadModule mod_quotatab_file.c
LoadModule mod_quotatab_ldap.c
LoadModule mod_quotatab_sql.c
LoadModule mod_radius.c
LoadModule mod_wrap.c
LoadModule mod_rewrite.c

# keep this module the last one
LoadModule mod_ifsession.c

Quote:Fatal: unknown configuration directive 'SQLAuthTypes' on line 164 of '/etc/proftpd/proftpd.conf'
failed!