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 server

Discussion in 'General Discussion' started by JeffroMart, Dec 31, 2009.

  1. JeffroMart

    JeffroMart Registered

    Joined:
    Nov 11, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    I'm trying to setup a remote mysql server, and it is returning the following once I have input all the server details:

    root@******* password: ==sshcontroloutput==
    Using ********* as the access ip
    Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/scripts
    Can't locate Cpanel/CPAN/URI/Escape.pm in @INC (@INC contains: /scripts /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /scripts/cPScript/Encoder/URI.pm line 8.
    BEGIN failed--compilation aborted at /scripts/cPScript/Encoder/URI.pm line 8.
    Compilation failed in require at /scripts/cPScript/HttpRequest.pm line 15.
    BEGIN failed--compilation aborted at /scripts/cPScript/HttpRequest.pm line 15.
    Compilation failed in require at /scripts/cpanelsync line 30.
    BEGIN failed--compilation aborted at /scripts/cpanelsync line 30.
    Can't locate Cpanel/CPAN/URI/Escape.pm in @INC (@INC contains: /scripts /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /scripts/cPScript/Encoder/URI.pm line 8.
    BEGIN failed--compilation aborted at /scripts/cPScript/Encoder/URI.pm line 8.
    Compilation failed in require at /scripts/cPScript/HttpRequest.pm line 15.
    BEGIN failed--compilation aborted at /scripts/cPScript/HttpRequest.pm line 15.
    Compilation failed in require at /scripts/cpanelsync line 30.
    BEGIN failed--compilation aborted at /scripts/cpanelsync line 30.
    Sync Source: http://httpupdate.cpanel.net/RELEASE-x86_64/scripts
    Can't locate Cpanel/CPAN/URI/Escape.pm in @INC (@INC contains: /scripts /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /scripts/cPScript/Encoder/URI.pm line 8.
    BEGIN failed--compilation aborted at /scripts/cPScript/Encoder/URI.pm line 8.
    Compilation failed in require at /scripts/cPScript/HttpRequest.pm line 15.
    BEGIN failed--compilation aborted at /scripts/cPScript/HttpRequest.pm line 15.
    Compilation failed in require at /scripts/cpanelsync line 30.
    BEGIN failed--compilation aborted at /scripts/cpanelsync line 30.
    Can't locate Cpanel/CPAN/URI/Escape.pm in @INC (@INC contains: /scripts /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /scripts/cPScript/Encoder/URI.pm line 8.
    BEGIN failed--compilation aborted at /scripts/cPScript/Encoder/URI.pm line 8.
    Compilation failed in require at /scripts/cPScript/HttpRequest.pm line 15.
    BEGIN failed--compilation aborted at /scripts/cPScript/HttpRequest.pm line 15.
    Compilation failed in require at /scripts/cpanelsync line 30.
    BEGIN failed--compilation aborted at /scripts/cpanelsync line 30.
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    Can't locate Cpanel/CPAN/Sys/Hostname/Long.pm in @INC (@INC contains: /scripts /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /scripts/cPScript/Sys/Hostname.pm line 12.
    BEGIN failed--compilation aborted at /scripts/cPScript/Sys/Hostname.pm line 12.
    Compilation failed in require at /scripts/cPScript/Sys.pm line 16.
    BEGIN failed--compilation aborted at /scripts/cPScript/Sys.pm line 16.
    Compilation failed in require at /scripts/fixetchosts line 12.
    BEGIN failed--compilation aborted at /scripts/fixetchosts line 12.
    Waiting for mysql to restart..............finished.

    [2009-12-30 22:15:50 -0500] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
    mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --user=mysql) running as root with PID 8597
    mysqld (/usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock) running as mysql with PID 8647

    [2009-12-30 22:15:55 -0500] info [restartsrv_mysql] BSD::Resource not available. Resource Limits not adjusted
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'


    Any ideas?
     
    #1 JeffroMart, Dec 31, 2009
    Last edited: Dec 31, 2009
  2. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    Looking at the messages it looks like "URI::Escape" module is missing. Install the module by executing the following command:

    /scripts/perlinstaller URI::Escape

    Once done, make sure the server which is connecting to your Mysql server and the user have the necessary privileges to access the databases on your mysql server. Login to your Mysql server, goto the mysql prompt

    #mysql

    at the mysql prompt use the grant command

    mysql> grant all on *.* to 'root'@'ServerIP' identified by 'password';

    where,
    *.* is all the databases on the mysql server
    root, is the root user of 'ServerIP' server to whom privileges are granted.
    ServerIP, is the IP of the server from where you want to access the Mysql server.

    Hope this helps.
     
  3. eth00

    eth00 Well-Known Member
    PartnerNOC

    Joined:
    Mar 30, 2003
    Messages:
    723
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    NC
    cPanel Access Level:
    Root Administrator
    Also missing the module: Can't locate Cpanel/CPAN/Sys/Hostname/Long.pm
     
Loading...

Share This Page