Error while connecting to MySQL. Failover enacted.

[exousir]

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:

[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:
Error while connecting to MySQL. Failover enacted..

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

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:

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:

.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.

[anton_latvia]

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