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.

cPAddon don't work with remote mysql server

Discussion in 'General Discussion' started by apogee, Nov 13, 2006.

  1. apogee

    apogee Well-Known Member

    Joined:
    Nov 8, 2004
    Messages:
    107
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    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...
     
  2. apogee

    apogee Well-Known Member

    Joined:
    Nov 8, 2004
    Messages:
    107
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    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 MySQLFailover 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 downPlease contact your administrator.

    Cleaning up failed install...Done!

    SQL connection should work:
    PHP:
    root@cp41 [~]# mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 889021 to server version5.0.32-Debian_7etch1-log

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

    mysqlquit
    Bye
    No Idea why it don't work :(

    From the Logs:
    PHP:
    (internal deathWed Apr 11 21:49:53 2007 [30805errorCan'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
     
    #2 apogee, Apr 11, 2007
    Last edited: Apr 11, 2007
Loading...

Share This Page