cPAddon don't work with remote mysql server

apogee

Well-Known Member
Nov 8, 2004
122
11
168
Europe
cPanel Access Level
DataCenter Provider
hello,

since the last update cPAddon don't works longer with an external mysql server :eek:

I just got "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"

it seams that the installer ignoring my remote mysql server...
 

apogee

Well-Known Member
Nov 8, 2004
122
11
168
Europe
cPanel Access Level
DataCenter Provider
I've still the same problem:

PHP:
[a fatal error or timeout occurred while processing this directive][a fatal error or timeout occurred while processing this directive]
Error while connecting to MySQL. Failover enacted.
[an error occurred while processing this directive]
[a fatal error or timeout occurred while processing this directive]

OR

PHP:
[an error occurred while processing this directive][an error occurred while processing this directive][a fatal error or timeout occurred while processing this directive][a fatal error or timeout occurred while processing this directive]The MySQL service appears to be down. Please contact your administrator.

Cleaning up failed install...Done!

SQL connection should work:
PHP:
[email protected] [~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 889021 to server version: 5.0.32-Debian_7etch1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye
No Idea why it don't work :(

From the Logs:
PHP:
(internal death) Wed Apr 11 21:49:53 2007 [30805] error: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/cpanel /usr/local/cpanel/cpaddons /usr/local/cpanel/perl /usr/lib/perl5/5.6.2/i686-linux /usr/lib/perl5/5.6.2 /usr/lib/perl5/site_perl/5.6.2/i686-linux /usr/lib/perl5/site_perl/5.6.2 /usr/lib/perl5/site_perl . /usr/local/cpanel/Cpanel /usr/lib/perl5/5.6.1 /usr/lib/perl5/5.6.1/i686-linux /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl/5.6.1/i686-linux /usr/lib/perl5/5.8.0 /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.5 /usr/lib/perl5/5.8.7) at (eval 69) line 3.
        eval 'package                   # hide from PAUSE
                DBI::_firesafe;         # just in case
            require DBD::mysql; # load the driver

;' called at /usr/lib/perl5/site_perl/5.6.2/i686-linux/DBI.pm line 732
        DBI::install_driver('DBI', 'mysql') called at /usr/lib/perl5/site_perl/5.6.2/i686-linux/DBI.pm line 600
        DBI::connect('DBI', 'DBI:mysql:mysql:localhost', 'root', '') called at /usr/local/cpanel/Cpanel/Mysql.pm line 41
        eval {...} called at /usr/local/cpanel/Cpanel/Mysql.pm line 23
        Cpanel::Mysql::new('Cpanel::Mysql') called at /usr/local/cpanel/Cpanel/cPAddons.pm line 1953
        Cpanel::cPAddons::my_createdbs('Cpanel::cPAddons=HASH(0x92c6110)', 'ARRAY(0x8faf374)') called at /usr/local/cpanel/Cpanel/cPAddons.pm line 1310
        Cpanel::cPAddons::stdinstall('Cpanel::cPAddons=HASH(0x92c6110)', 'HASH(0x91c2060)', 'HASH(0x8cce8a0)') called at /usr/local/cpanel/cpaddons/CPSkins/Mailing_List/poMMo.pm line 27
        CPSkins::Mailing_List::poMMo::install('Cpanel::cPAddons=HASH(0x92c6110)', 'HASH(0x91c2060)', 'HASH(0x8cce8a0)') called at /usr/local/cpanel/Cpanel/cPAddons.pm line 1239
        Cpanel::cPAddons::_handlemod(1, 'CPSkins::Mailing_List::poMMo', '642848d1b70363a19cb66c4215505194', 'HASH(0x8cce8a0)') called at /usr/local/cpanel/Cpanel/cPAddons.pm line 244
        Cpanel::cPAddons::cPAddons_mainpg('HASH(0x8cce8a0)') called at (eval 66) line 1
        eval 'cPAddons_mainpg(@RARGS);' called at cpanel.pl line 543
        main::exectag('<cpanel cPAddons="mainpg(%FORM)">') called at cpanel.pl line 3496
        main::dotag(undef) called at cpanel.pl line 3410
        main::parsehtml('GLOB(0x8ed3918)') called at cpanel.pl line 355
I think here is the error:
DBI::connect('DBI', 'DBI:mysql:mysql:localhost', 'root', '') called at /usr/local/cpanel/Cpanel/Mysql.pm line 41

My mysql serer is not on localhost!, tried to change the code in /usr/local/cpanel/Cpanel/Mysql.pm but with no luck
 
Last edited: