update problem 1.0.0 to 1.0.2

[tuxee]

hi!

I have try step by step http://www.isp-control.net/documentation...upgrade:rc

Quote:# perl ispcp-update
Name "main:b" used only once: possible typo at ispcp-update line 752.

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
(9) ispCP OMEGA 1.0.0 or later
(0) abort
Your selection: 9
Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
Stopping ispCP Network Traffic Logger: ispcp_network
ispcp_network is already stopped (warning).
.
Upgrading system values...done


Setting GUI Permissions: ................................................................................​................................................................................​.................................................................
................................................................................​................................................................................​...................................................................
................................................................................​................................................................................​...................................................................
................................................................................​................................................................................​..................................................................
................................................................................​................................................................................​..................................................................
...............................................................done
Setting Engine Permissions: .............done
Rebuilding customers...sh: -c: line 0: unexpected EOF while looking for matching ``'
sh: -c: line 1: syntax error: unexpected end of file
SQL Update failed.

any solutions?

[sci2tech]

Problem is caused by mysql password containing

Code:

`! or $

Upgrade to trunk instead or change in ispcp-update

Code:

$rs = sys_command("$main::cfg{'CMD_MYSQL'} --host=\"$main::db_host\" -u\"$main::db_user\" -p\"$main::db_pwd\" < /tmp/db.sql");

in

Code:

$rs = sys_command("$main::cfg{'CMD_MYSQL'} --host='$main::db_host' -u'$main::db_user' -p'$main::db_pwd' < /tmp/db.sql");

[tuxee]

that problem solved.
But grown new problem:

Code:

Setting GUI Permissions: ......................done
    Setting Engine Permissions: .............done
    Rebuilding customers...ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    SQL Update failed.

howto fix it?

[tuxee]

i'm fix problem:

1. add new user ispcproot - by a manual http://isp-control.net/ispcp/wiki/howto_dbchangepw.

2.

Code:

rm /etc/ispcp/ispcp.old.conf
cp /etc/ispcp/ispcp.conf /etc/ispcp/ispcp.old.conf

when I ran STEP BY STEP http://www.isp-control.net/documentation...upgrade:rc



Thanks for replyes.