Current time: 06-17-2024, 05:48 AM Hello There, Guest! (LoginRegister)


Post Reply 
RC6 remote database support for upgrade script
Author Message
Standbye Offline
Newbie
*

Posts: 8
Joined: Apr 2008
Reputation: 0
Post: #1
RC6 remote database support for upgrade script
.. As i cannot create a Ticket as its rejected as spam i'll just poste it here.

If upgrading from RC5 to RC6 you have to exec ispcp-update script.
This script does not support remote database hosts (like ispcp normaly does) as you forgot to set the host to each mysql statement.

Just see the diff with the changes i made and perhaps check em in


regards
Peter

.. wtf this is no SPAM


Code:
316c316
<     if (sys_command("$main::cfg{'CMD_MYSQLDUMP'} --opt -u\"$main::db_user\" -p\"$main::db_pwd\" $main::vhcs2{'DATABASE_NAME'} | $main::cfg{'CMD_MYSQL'} -u\"$main::db_user\" -p\"$main::db_pwd\" $main::db_name") != 0) {
---
>     if (sys_command("$main::cfg{'CMD_MYSQLDUMP'} --opt --host=\"$main::db_host\" -u\"$main::db_user\" -p\"$main::db_pwd\" $main::vhcs2{'DATABASE_NAME'} | $main::cfg{'CMD_MYSQL'} --host=\"$main::db_host\" -u\"$main::db_user\" -p\"$main::db_pwd\" $main::db_name") != 0) {
340c340
<       $rs = sys_command("$main::cfg{'CMD_MYSQL'} -u\"$main::db_user\" -p\"$main::db_pwd\" < /tmp/db.sql");
---
>       $rs = sys_command("$main::cfg{'CMD_MYSQL'} --host=\"$main::db_host\" -u\"$main::db_user\" -p\"$main::db_pwd\" < /tmp/db.sql");
840c840
<       $rs = sys_command("$main::cfg{'CMD_MYSQL'} -u\"$main::db_user\" -p\"$main::db_pwd\" < /tmp/db.sql");
---
>       $rs = sys_command("$main::cfg{'CMD_MYSQL'} --host=\"$main::db_host\" -u\"$main::db_user\" -p\"$main::db_pwd\" < /tmp/db.sql");
889c889
<       $rs = sys_command("$main::cfg{'CMD_MYSQL'} -u\"$main::db_user\" -p\"$main::db_pwd\" < /tmp/db.sql");
---
>       $rs = sys_command("$main::cfg{'CMD_MYSQL'} --host=\"$main::db_host\" -u\"$main::db_user\" -p\"$main::db_pwd\" < /tmp/db.sql");
1080c1080
<       $rs = sys_command("$main::cfg{'CMD_MYSQL'} -u\"$main::db_user\" -p\"$main::db_pwd\" < /tmp/db.sql");
---
>       $rs = sys_command("$main::cfg{'CMD_MYSQL'} --host=\"$main::db_host\" -u\"$main::db_user\" -p\"$main::db_pwd\" < /tmp/db.sql");
08-28-2008 07:38 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
RC6 remote database support for upgrade script - Standbye - 08-28-2008 07:38 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)