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.

Error while connecting to MySQL. Failover enacted.

Discussion in 'General Discussion' started by exousir, Mar 27, 2007.

  1. exousir

    exousir Registered

    Joined:
    Jan 11, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    I have a problem when trying to run a CPAddon script that creates a database. I get the following error. This is the error when running a Cpanel provided addon for phpMyChat:

    Code:
    [a fatal error or timeout occurred while processing this directive][a fatal error or timeout occurred while processing this directive]
    cPAddon cPanel::Chat::phpMyChat
    [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]
    I've tried following this thread:
    http://forums.cpanel.net/showthread...r+while+connecting+to+MySQL.+Failover+enacted.

    But that does not solve the problem because the last step gets the following error

    Code:
    dbdimp.c: In function `mysql_st_fetch':
    dbdimp.c:3429: error: too few arguments to function `mysql_dr_error'
    dbdimp.c:3593: error: too few arguments to function `mysql_dr_error'
    dbdimp.c: In function `mysql_st_FETCH_internal':
    dbdimp.c:3931: error: too few arguments to function `mysql_dr_error'
    dbdimp.c:3945: error: too few arguments to function `mysql_dr_error'
    dbdimp.c: In function `mysql_bind_ph':
    dbdimp.c:4264: error: too few arguments to function `mysql_dr_error'
    dbdimp.c:4291: error: too few arguments to function `mysql_dr_error'
    dbdimp.c:4303: error: too few arguments to function `mysql_dr_error'
    dbdimp.c: In function `mysql_db_reconnect':
    dbdimp.c:4465: error: too few arguments to function `mysql_dr_error'
    make: *** [dbdimp.o] Error 1
    To get around this, I tried to install 4.001 of DBD::mysql by running:

    Code:
    perl -MCPAN -e shell
    force install CAPTTOFU/DBD-mysql-4.001.tar.gz
    However, the make tests don't work that connect to the database. They all seem to fail with a similar error:

    Code:
    .DBI connect('test','',...) failed: Access denied for user: 'root@localhost' (Using password: NO) at t/80procs.t line 32
    I'm not sure what the problem is as I am able to log in via the shell when su'ed: 'mysql -u root'. I don't know if the above error has any relation to the error when trying to run a cpaddon.

    I have also reset the root password in hopes of fixing the problem.

    The problem seemed to happen only after March 25th but I don't know the exact date it stopped working.

    Any help would be appreciated.

    Regards,

    Jeremy.
     
  2. anton_latvia

    anton_latvia Well-Known Member
    PartnerNOC

    Joined:
    May 11, 2004
    Messages:
    348
    Likes Received:
    3
    Trophy Points:
    18
    Location:
    Latvia
    cPanel Access Level:
    Root Administrator
    Solution, that helped me.
    I downloaded version DBD-mysql-4.00.tar.gz from here http://www.cpan.org/modules/by-module/DBD/ and installed manually (perl Makefile.PL; make; make install). Then I have reinstalled cpanel (upcp --force). Probably, if 4.00 does not work for you either, you could grab even older version.

    Anton
     
Loading...

Share This Page