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.

Remote MySQL Setup Error

Discussion in 'General Discussion' started by theqwoody, Jul 28, 2014.

  1. theqwoody

    theqwoody Registered

    Joined:
    Jul 28, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Greetings All,

    I am running into a bit of a snag setting up a remote MySQL server, I've read the setup instructions line for line.

    **Note this is not Remote SQL as in white-listing IP addresses to access a database but rather off loading the MySQL work load to another server.**

    After inputting all of the standard information such as server address, ssh port, root, pass, etc this is the response I get.

    [2014-07-28 12:23:28 -0400] info [xml-api] Critical SSH or support files appear to be missing. (Failed to normalize shell: Could not normalize shell: {export LANGC; export TERMdumb; export PS1"Cpanel::SSHControl - \TcPs# ";export PROMPT_COMMAND""; stty raw; echo $0; echo; echo /bin/sh Cpanel::SSHControl - \TcPs# [Cpanel::SSHControl::Expect::Reset::HIq_4W9vmq0AXuTh] Cpanel::SSHControl::Expect::Reset::HIq_4W9vmq0AXuTh # }) [remote_basic_credential_check] version [1].

    Both the database and CPanel/WHM servers are the latest Cent OS 6 brand new (minimal) out of the box with all updates applied and no modifications made other than their respective installations of MySQL(5.6) on the DB server and Cpanel/WHM on the web server.

    I have tried to research this both on these forums and standard Google searches and I've yet to find an answer or even a path to take for troubleshooting, I'm even finding it hard to figure out what logs to check to see even more specific data. I've considered submitting a ticket but right now I am on a trial to test this first to see performance before I make a final decision to make a full on purchase and thus be privy to ticket based support.

    Thank you for any insight that can be provided. :)
     
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    You need to make sure the server is able to SSH into the remote MySQL server, as cPanel needs to make an initial connection to get everything set up. In the setup script for remote mysql, test the credentials you are passing to it to make sure they work.
     
  3. theqwoody

    theqwoody Registered

    Joined:
    Jul 28, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Vanessa,

    Thank you for your response! I've completed this action as well, the SSH connection is indeed able to be made between the two machines both ways with no problem. As well I've done what you said and purposely provided the wrong credentials and that fails as it should with the correct response, so it looks like the connection is being made with the proper credentials.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page