+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Contributions Area (/forum-40.html)
+--- Forum: Enhancements (/forum-43.html)
+--- Thread: RC6 remote database support for upgrade script (/thread-4132.html)
RC6 remote database support for upgrade script - Standbye - 08-28-2008 07:38 PM
.. 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");RE: RC6 remote database support for upgrade script - Zothos - 08-29-2008 12:49 AM
could you try again to create a ticket? I thinks its critical for our next release.
RE: RC6 remote database support for upgrade script - Standbye - 09-03-2008 11:23 PM
it always gets rejected as spam sry
RE: RC6 remote database support for upgrade script - sci2tech - 09-04-2008 02:58 AM
Added your patch in r1340. Thank you.
RE: RC6 remote database support for upgrade script - mr.x - 09-04-2008 03:24 AM
Standbye Wrote:it always gets rejected as spam sry
could you please send the header from that mail? That we have an overview where your mail gets the points.
Jan
RE: RC6 remote database support for upgrade script - Standbye - 09-11-2008 08:50 PM
Mr. x i get directly when entering the bug the message out of trac that my bugreport is spam
No Mail