setup remote mysql server broken?

[billyrobot]

I'm having a heck of a time setting up a remote mysql host. I don't understand how this could possibly work -- at some point in the setup process (via WHM), a script in the home directory of the specified user called .mysqlscript is executed. Line 11 of this script called /scripts/updatenow on the remote server. Calling updatenow, of course, "returns: updatenow should only be run from upcp at ./updatenow line 10.", and none of the scripts are properly copied over to the mysql host. Is this setup remote host feature unusable, or am I doing something completely wrong? I keep getting this:

Setting up Management Scripts...
Done
Copying Management Script cpsources.pl.....0%.. ..100%.. ...Done
Copying Management Script cpanelsync.....0%.. ..100%.. ...Done
Copying Management Script updatenow.....0%.. ..100%.. ...Done
Copying Mysql Script.....0%.. ..100%.. ...Done
Running Mysql Script...
updatenow should only be run from upcp at /scripts/updatenow line 10.
updatenow should only be run from upcp at /scripts/updatenow line 10.
/home/blahblah/.mysqlscript: line 17: /scripts/mysqlpasswd: No such file or directory
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
/home/blahblah/.mysqlscript: line 32: /scripts/fixetchosts: No such file or directory
/home/blahblah/.mysqlscript: line 34: /scripts/restartsrv: No such file or directory

Done


BR

 

[billyrobot]

Tried it again, this time I installed cpanel on the mysql server as well -- still no luck (despite being told in a support ticket that I needed cpanel on the mysql server, which doesn't really make sense to me).

Anybody been able to make this work?

BR

 

[billyrobot]

Ok -- I kind of got this to work. In fact, I guess it works, although cpanel doesn't copy any mysql data over to the new server, which is fine, since I can do that myself.

Here's the crummy part -- I get everything setup in WHM and it works -- I'm looking at databases on the remote server in cpanel and in phpMyAdmin (via cpanel). I can connect to the Db from scripts on the webserver. For some ungodly reason, however, WHM reverts back to the localhost setting periodically -- every 20 minutes or so (roughly). Am I crazy? Does anyone know where cpanel stores the remote host information, or if there's anything I could be doing that would make it reset the remote mysql server info to localhost?

BR

 

[billyrobot]

Continuing this conversation with myself...

I think I fixed the problem by syncing the root mysql password in /root/.my.cnf on the remote server and on the webserver. We'll see how it goes.

The feature is still broken, however, insofar as the update script can only be called from upcp.

BR