Remote MYSQL server

[JeffroMart]

I'm trying to setup a remote mysql server, and it is returning the following once I have input all the server details:

[email protected]******* 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?

 

[madaboutlinux]

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.

 

[eth00]

Also missing the module: Can't locate Cpanel/CPAN/Sys/Hostname/Long.pm