The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

setup remote mysql server broken?

Discussion in 'General Discussion' started by billyrobot, Oct 17, 2005.

  1. billyrobot

    billyrobot Active Member

    Joined:
    Feb 18, 2004
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. billyrobot

    billyrobot Active Member

    Joined:
    Feb 18, 2004
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  3. billyrobot

    billyrobot Active Member

    Joined:
    Feb 18, 2004
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  4. billyrobot

    billyrobot Active Member

    Joined:
    Feb 18, 2004
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    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
     
Loading...

Share This Page