Upgrade RC7 -> stable Failed

[chappy]

Hi all,

i just tried to upgrade from RC7 to the new stable release.
Unfortunately if i want to open ispcp now it looks like you can see in the
attachment :-(
Ok as attachment is not visible here the screenshot:

At the installation before i had some errors here the output:

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.

Any idea what could be wrong?
Just let me know which logfiles you need to investigate and i will post them.

Thanks a lot in advance.

Cheers

Stefan

[sci2tech]

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
. DO you have installed / enabled apache2-suexec and fastcgi / fcgid etc?

[chappy]

Hi,
thanks for your reply.
I uncommented the both lines you mentioned and then installed package apache2-suexec.
That solved the problem -> Many, many thanks for that !
But now i figured out that proftpd is not working anymore.

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!

If i check in the proftpd.conf the block that is mentioned in the error message says:

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

I much appreciate your help.

Cheers

Stefan

[sci2tech]

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

[chappy]

(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

Yes i'm using etch.
hmm proftpd-mysql is already installed.
Any other idea?

Thanks a lot !

[sci2tech]

Post here /etc/proftpd/modules.conf

[chappy]

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

[sci2tech]

Please follow instruction. In second post I did tell:

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

Means

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

[chappy]

hi,

sorry at your 2nd post i read COMMENT not UNCOMMENT... sorry
if i uncomment these 2 lines i receive the following:

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

proftpd-mysql is installed hmm....

[sci2tech]

2 Possibility:
1. You did not edit / save /etc/proftpd/modules.conf to uncomment both lines for sql.
2. You do not have proftpd-mysql installed.
Chose one