RC6 remote database support for upgrade script

[Standbye]

.. 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");

[Zothos]

could you try again to create a ticket? I thinks its critical for our next release.

[Standbye]

it always gets rejected as spam sry

[sci2tech]

Added your patch in r1340. Thank you.

[mr.x]

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

[Standbye]

Mr. x i get directly when entering the bug the message out of trac that my bugreport is spam
No Mail