[SOLVED] Update 1.0.2 > 1.0.3 issue, db update fail

[Ignas Galuskinas]

Hi,
this morning I've faced fail while updating to new 1.0.3 version.
I did everything as noted on Upgrade 1.x.x -> ispCP 1.x.x
http://www.isp-control.net/documentation...upgrade:rc
but this is what I've got:

Code:

ispCP database
         Update ispCP database schema:DEBUG: push_el() sub_name: update_database_schema(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Starting...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Ending...
DEBUG: push_el() sub_name: exit_msg(), msg: Starting...
                                                                                                                               [failed]


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

        You can find help at http://isp-control.net/forum

DEBUG: push_el() sub_name: exit_msg(), msg: Ending...
giraite:/var/www/ispcp/engine/setup#

Thanks for quck help.

---

Just now found new document http://www.isp-control.net/documentation...ade:debian for Debian users (as I am).
Maybe it was my mistake to read "Upgrade 1.x.x -> ispCP 1.x.x" ?

Now I have no access to panel, but whole system seems working OK.

[Ignas Galuskinas]

Maybe any suggestions how to roll-back from this point?

[RatS]

The wiki page was really misleading, I changed it.

You can try to re-do the update with the new version. It could work, but I can not guarantee.

[Ignas Galuskinas]

I've followed all instructions for Debian users, but no change.. :/

Code:

ispCP database
         Update ispCP database schema:DEBUG: push_el() sub_name: update_database_schema(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Starting...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Ending...
DEBUG: push_el() sub_name: exit_msg(), msg: Starting...
                                                                                                                       [failed]


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

        You can find help at http://isp-control.net/forum

DEBUG: push_el() sub_name: exit_msg(), msg: Ending...

I think this is something with functions trying to add new tables to db..

---

Current state:
while trying to access login page at admin.domain.tld getting
Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
Did update script change mysql passwords? how to roll back to 1.0.2 version. It was my huge mistake to try this upgrade.. :/

[warcry]

(12-21-2009 01:11 AM)Ignas Galuskinas Wrote:  I think this is something with functions trying to add new tables to db..

/tmp/ispcp-update-database.log should give you more information.

You can fix the sql password in /etc/ispcp/ispcp.conf (DATABASE_PASSWORD). A roll back should be possible by reverting step 5 & 8 of Debian Update, as long as the database update wasn't done or you have a backup of the 1.0.2 ispcp database. However I'm pretty new to ispCP so you might want to wait for a more experienced user to confirm this.

[Ignas Galuskinas]

Update -database.log:

Code:

Warning: require_once(): open_basedir restriction in effect. File(/var/www/ispcp/gui/include/ispcp-lib.php) is not within the allowed path(s): (/var/www/$

Warning: require_once(/var/www/ispcp/gui/include/ispcp-lib.php): failed to open stream: Operation not permitted in /var/www/ispcp/engine/setup/updDB.php $

Fatal error: require_once(): Failed opening required '/var/www/ispcp/gui/include/ispcp-lib.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var$

---

ok, fixed with open_basedir restrictions. Now only one log entry:
Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

---

Code:

sub update_database_schema {

        push_el(\@main::el, 'update_database_schema()', 'Starting...');

        my ($rs, $cmd, $php, $rdata) = (undef, undef, undef, undef);

        # File preparation - Begin

        ($rs, $rdata) = get_file("$main::cfg{'ROOT_DIR'}/engine/setup/updDB.php");
        return $rs if($rs != 0);

        if($rdata =~ s/{GUI_ROOT_DIR}/$main::cfg{'GUI_ROOT_DIR'}/) {

                # Saving the modified file
                $rs = save_file("$main::cfg{'ROOT_DIR'}/engine/setup/updDB.php", $rdata);
                return $rs if($rs != 0);
        }

        # File preparation - End

      [b]  $main::db_pwd =~ s/([\'\"])/\\$1/g;
[/b]
        $cmd = "$main::cfg{'CMD_PHP'} $main::cfg{'ROOT_DIR'}/engine/setup/updDB.php &>/tmp/ispcp-update-database.log";
        $rs = sys_command_rs($cmd);
        return $rs if($rs !=0);

        push_el(\@main::el, 'update_database_schema()', 'Ending...');

        0;
}

what is this?

[Ignas Galuskinas]

I've changed DB pass by this doc (http://www.isp-control.net/documentation..._db_pass).

Unfoturnately it doesn help to successfully end ./ispcp-update ://

help help help!!!

[Nuxwin]

Normally, all work fine.

Normally, the open_basedir error would not occur. You have executed the update script as root ?

Concerning the password, no, the script does not change the password of the user SQL.

Normally, you should follow this document for debian http://www.isp-control.net/documentation...de:debian.

Fo the DB password issue, see http://www.isp-control.net/documentation...ge_db_pass

[Ignas Galuskinas]

1. Yes I always work as root.
2. I had set Open_basedir week ago, so it was my fault - now this line is cleared. No prob with that.
3. I've changed sql pass reading this doc - and was kind-of able to login to admin panel (got some errors like "headers already sent by enumerator.php and ~", but I think this is only becouse of unfinished db update).
4. I still get this error while starting ./ispcp-update

Code:

ispCP database
         Update ispCP database schema:DEBUG: push_el() sub_name: _update_database_schema(), msg: Starting...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Starting...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Ending...
DEBUG: push_el() sub_name: exit_msg(), msg: Starting...
                                                                                                                       [failed]


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

        You can find help at http://isp-control.net/forum

DEBUG: push_el() sub_name: exit_msg(), msg: Ending...

if freaks me out... and this update error doesnt create any ispcp-update-database.log

[Nuxwin]

ok ; If you want, I can work on your system directly to found the problem. If it's ok, send me a PM.