[SOLVED] Update 1.0.2 -> 1.0.5 error: fastCGI modules configuration failed

[yaispcpu]

I'm using Ubuntu 8.04 LTS and start the update from 1.0.2 to 1.0.5 using this documentation.

The Update (perl ispcp-update) stops with following error:

Code:

ispCP PHP (fastCGI modules configuration):                    Failed

Where can i find the log, with wich i can determine the details for this error?

How can i fix the problem?

[gOOvER]

Please enable debug in /etc/ispcp/ispcp.conf and restart the update

[yaispcpu]

thx for fast answer.

I activate the debug mode and the error is following:

Code:

DEBUG: push_el() sub_name: get_file(), msg: ERROR: File '/etc/ispcp/apache/fastcgi_ispcp.conf' does not exist !

Hmm, its true, this file does not exist.
I'm using fcgid and not fastcgi, so i thing during the fresh installation of the old version 1.0.2 in the past only the fcgid_ipscp.conf is copied an modified.

If i look at the /root/ispcp-omega-1.0.5/configs/ubuntu/apache, there ist no template with this name, but with fastcgi.conf and fastcgi2.conf

What should i do now?
Copy the templates fastcgi.conf and fastcgi2.conf from /root/ispcp-omega-1.0.5/configs/ubuntu/apache to /etc/ispcp/apache and rename them to fastcgi_ispcp.conf and fastcgi2_ispcp.conf before restarting update?

[Nuxwin]

Hello ;

First, thank to you for the report of this bug. I'll open a new ticket for this issue because it's important.

Sure, for now, the better solution is to copy the needed script for the package manually in the /etc/ispcp/apache directory and then, rename it as requested by the ispcp-update script. Then, after, just rerun the ispcp-update script and normally that should work.

Edit:

After a fast checking I read the following statements in the related makefile:

Code:

    # Ubuntu 7.04?
    if [ $(RELEASE) = 'feisty' ] ; then \
        cp ./fastcgi2.conf $(SYSTEM_CONF)/apache/fastcgi_ispcp.conf ; \
    else \
        cp ./fastcgi.conf $(SYSTEM_CONF)/apache/fastcgi_ispcp.conf ; \
    fi
    cp ./fcgid_ispcp.conf $(SYSTEM_CONF)/apache/fcgid_ispcp.conf

So, normally, if you have updated correctly, the file `fastcgi_ispcp.conf` should be copied into the directory `/etc/ispcp/apache`. Are you sure to have not forgot the make part during upgrade before run the `ispcp-update` script ?

Code:

make -f Makefile.ubuntu install
cp -R /tmp/ispcp/* /

Edit:

Ok, I see the problem now. Well, I'm sure for the make process you have typed the following command:

Code:

make install

Instead of the good command that is :

Code:

make -f Makefile.ubuntu  install

If that is the case, that is not your fault since the current documentation that describes the ispCP installation on ubuntu contains the first command that is only for Debian. So the result is that during the make process, it's the bad configs/dist directory that is used (configs/debian instead of configs/ubuntu) and of course, the needed statements for the 'fastcgi_ispcp.conf' are not run.

Why ? looking the differences betwen the debian and ubuntu statements :

For debian:

Code:

    # greater equal Debian 4.0 "Etch"?
    if [ $(RELEASE) = 'sarge' ]; then \
        cp ./fastcgi.conf $(SYSTEM_CONF)/apache/fastcgi_ispcp.conf ; \
    elif [ $(RELEASE) = 'etch' ] || [ $(RELEASE) = 'lenny' ] || [ $(RELEASE) = 'squeeze' ]; then \
        cp ./fastcgi2.conf $(SYSTEM_CONF)/apache/fastcgi_ispcp.conf ; \
    fi
    cp ./fcgid_ispcp.conf $(SYSTEM_CONF)/apache/fcgid_ispcp.conf

For Ubuntu, see the previous reported statements.

To conclude, I recommend to you to perform a new complete update procedure. The mistake was fixed in the Ubuntu related documentation in our wiki and will be fixed in the INSTALL file for the next release.

Best Regards ;

[yaispcpu]

Thanks for the answer.

(04-03-2010 07:11 AM)nuxwin Wrote:  Sure, for now, the better solution is to copy the needed script for the package manually in the /etc/ispcp/apache directory and then, rename it as requested by the ispcp-update script. Then, after, just rerun the ispcp-update script and normally that should work.

I did this.

(04-03-2010 07:11 AM)nuxwin Wrote:  Ok, I see the problem now. Well, I'm sure for the make process you have typed the following command:

Code:

make install

Instead of the good command that is :

Code:

make -f Makefile.ubuntu  install

Yes, i use just copy and paste and did not regonize, that this command is not the right one for Ubuntu.

But after the reenter the whole update procedure as recommended i get following errors:

Code:

WARNING: Your PMA configuration file should be rebuilded !
DEBUG: push_el() sub_name: ask_db_pma_user(), msg: Starting...

        Please enter ispCP phpMyAdmin Control user. [pma]:
DEBUG: push_el() sub_name: ask_db_pma_user(), msg: Ending...
DEBUG: push_el() sub_name: ask_db_pma_password(), msg: Starting...

        Please enter ispCP phpMyAdmin Control user password. [auto generate]:
        Please repeat ispCP phpMyAdmin Control user password:
DEBUG: push_el() sub_name: ask_db_pma_password(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: ERROR: Unable to connect SQL server !
                                   Failed
DEBUG: push_el() sub_name: exit_msg(), msg: Starting...

        FATAL: An error was occured during update process!
        Correct it and re-run this program.

Hmm, at this time during the update the mysql server should be down.

Edit: the mysql service is up and running.

[yaispcpu]

I start looking for the cause of failure and found

Code:

ispCP BIND main configuration file:Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)                               Done

during performing the update, but without an exit with an error.

I test successfuly the access to mysql service with the same user and password, wich should be saved in the config via mysql -p.

The password for the databases stored in the new config file matches to the one stored in the old config file.

I seems that the update script is not able to connect to the database and so any of the doSQL() fails.

The PMA part is the first part wich stops with an error, the BIND part not.

[Nuxwin]

Oh my god... Just before re-run the following command :

Code:

make -f Makefile.ubuntu install
cp -R /tmp/ispcp/* /

I hope you have re-saved you old files such as db keys files, pma configuration file.... I'm sure you have forgot this step.... and that explain all the errors.

To resume:

The ispcp-update script uses the db keys to decrypt the password stored in your ispcp.conf/ispcp.old.conf. So, if you have forgot to re-save these files before redo the make process and copy all the new files, the database connection fail. Look the content of the/var/www/ispcp/engine/ispcp-db-keys.pl and /var/www/ispcp/gui/include/ispcp-db-keys.php files. If this files content is like this:

/var/www/ispcp/engine/ispcp-db-keys.pl:

Code:

#!/usr/bin/perl

# ispCP ω (OMEGA) a Virtual Hosting Control Panel
# Copyright (C) 2001-2006 by moleSoftware GmbH - http://www.molesoftware.com
# Copyright (C) 2006-2010 by isp Control Panel - http://ispcp.net
#
# Version: $Id: ispcp-db-keys.pl 2505 2010-01-06 20:30:53Z nuxwin $
#
# The contents of this file are subject to the Mozilla Public License
# Version 1.1 (the "License"); you may not use this file except in
# compliance with the License. You may obtain a copy of the License at
# http://www.mozilla.org/MPL/
#
# Software distributed under the License is distributed on an "AS IS"
# basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
# License for the specific language governing rights and limitations
# under the License.
#
# The Original Code is "VHCS - Virtual Hosting Control System".
#
# The Initial Developer of the Original Code is moleSoftware GmbH.
# Portions created by Initial Developer are Copyright (C) 2001-2006
# by moleSoftware GmbH. All Rights Reserved.
# Portions created by the ispCP Team are Copyright (C) 2006-2010 by
# isp Control Panel. All Rights Reserved.
#
# The ispCP ω Home Page is:
#
#    http://isp-control.net/var/www/ispcp/gui/include/ispcp-db-keys.php
#

$main::db_pass_key = '{KEY}';

$main::db_pass_iv = '{IV}';

1;

/var/www/ispcp/gui/include/ispcp-db-keys.php:

Code:

<?php
/**
* ispCP ω (OMEGA) a Virtual Hosting Control System
*
* @copyright     2001-2006 by moleSoftware GmbH
* @copyright     2006-2010 by ispCP | http://isp-control.net
* @version     SVN: $Id: ispcp-db-keys.php 2599 2010-02-11 15:08:57Z benedikt $
* @link         http://isp-control.net
* @author         ispCP Team
*
* @license
* The contents of this file are subject to the Mozilla Public License
* Version 1.1 (the "License"); you may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.mozilla.org/MPL/
*
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations
* under the License.
*
* The Original Code is "VHCS - Virtual Hosting Control System".
*
* The Initial Developer of the Original Code is moleSoftware GmbH.
* Portions created by Initial Developer are Copyright (C) 2001-2006
* by moleSoftware GmbH. All Rights Reserved.
* Portions created by the ispCP Team are Copyright (C) 2006-2010 by
* isp Control Panel. All Rights Reserved.
*/

$ispcp_db_pass_key = '{KEY}';

$ispcp_db_pass_iv = '{IV}';

That explain all the errors. I hope you have a backup. for the following filesthat you should restore:

1. /var/www/ispcp/engine/ispcp-db-keys.pl
2. /var/www/ispcp/engine/messenger/ispcp-db-keys.pl
3. /var/www/ispcp/gui/include/ispcp-db-keys.php

Best Regards ;

[yaispcpu]

(04-04-2010 09:52 PM)nuxwin Wrote:  I hope you have re-saved you old files such as db keys files, pma configuration file.... I'm sure you have forgot this step.... and that explain all the errors.

Yes, i drop this step. I misinterpretate the word backup. My fault was, that i only read the documentation and perform the update step by step again after the frist problem, but at the step with the backup i did start thinking about the word "backup", but not far engough. I thought, it woudl'nt make sense, to backup again

It's not really a backup, it's "just" a migration from the old version to the new one, where old files will be preserved from being replaced by new one.

Now, i'm a bit wiser.

I did make a true backup before executing the update and will try the update after recovery again in the next time.

Thx for answer!

[jamon]

Hi,
This is my first post, but I often visit the forum.

I have the same error, but I did make -f Makefile.ubuntu install and backup correctly.
I'm updating 1.0.2 > 1.0.5 too.

Files /var/www/ispcp/engine/ispcp-db-keys.pl and /var/www/ispcp/gui/include/ispcp-db-keys.php show keys crypt, but when I run ispcp-update, script show an access error to MySql database:

Code:

ispCP Postfix configuration files:This site is already enabled!
Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)                                                                                    Done
         ispCP Courier-Authentication:                                                                                         Done
         ispCP ProFTPd configuration file:Use of uninitialized value in concatenation (.) or string at /var/www/ispcp/engine/setup/../ispcp_common_methods.pl line 437.

        WARNING: Unable to find the Proftpd configuration file!
        We will create a new one.
        Please enter ispCP ftp SQL user. [vftp]:

How can i solve this problem?
I check MySQL connection and all is Ok.

[jamon]

Good news.

I've resolved the problem Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

I modified the line DATABASE_PASSWORD with blank in /etc/ispcp/ispcp.conf:

Code:

DATABASE_PASSWORD =

Then go to /var/www/ispcp/engine and type:

Code:

./ispcp-db-passwd

Ask you a new password and this generate a new encrypted password in ispcp.conf:

Code:

DATABASE_PASSWORD = newencryptedpassword

Now, copy - paste this encrypted password in /etc/ispcp/ispcp.old.conf:

Code:

DATABASE_PASSWORD = newencryptedpassword

Finally, run ispcp-update again.
It worked fine for me.