+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: rc5->rc7 SQL Update failed. and no password failure (/thread-5556.html)
rc5->rc7 SQL Update failed. and no password failure - supaplex - 01-28-2009 04:51 PM
I'm upgrading from rc5, and there are no apparent changes in the CSV INSTAL file for docs/Debian for the Update section.
Everything seems to run okay until:
11. Start the engine update:
# perl ispcp-update
I used:
(6) ispCP OMEGA 1.0.0 RC5
.
.
.
DEBUG: push_el() sub_name: store_conf(), msg: Ending...
DEBUG: push_el() sub_name: patch_ispcp_rc5(), msg: Ending...
DEBUG: push_el() sub_name: patch_ispcp_rc6(), msg: Starting...
Upgrading database structure...DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Starting...
DEBUG: push_el() sub_name: setfmode(), msg: Ending...
DEBUG: push_el() sub_name: store_file(), msg: Ending...
DEBUG: push_el() sub_name: sys_command(), msg: Starting...
sh: -c: line 0: unexpected EOF while looking for matching `"'
sh: -c: line 1: syntax error: unexpected end of file
DEBUG: push_el() sub_name: sys_command(), msg: ERROR: External command '/usr/bin/mysql --host="localhost" -u"root" -p"insert-garbled-gook-here" < /tmp/db.sql' returned '2' status !
failed!
SQL Update failed.
Any suggestions? Stock Debian etch box with all updates.
RE: rc5->rc7 SQL Update failed. and no password failure - sci2tech - 01-28-2009 09:06 PM
(01-28-2009 04:51 PM)supaplex Wrote: and there are no apparent changes in the CSV INSTAL file for docs/Debian for the Update section.There are! And all critical. You just missed one of those steps
. Restore from backup and try again
RE: rc5->rc7 SQL Update failed. and no password failure - supaplex - 02-13-2009 03:26 PM
this problem is no more. I will post my "plan" in a new thread with an attachment of the shell scripts I developed to ensure each step went smoothly. We rolled back due to some unforeseen complications. (more on that later)