Error while connecting to MySQL. Failover enacted.

[mguindon10]

Ok so I installed the new version of Perl as recommended by the guide to upgrade to cPanel 11. Now when users login to their cpanel interface they get this error for their MySQL databases " Error while connecting to MySQL. Failover enacted." which shows on the left side of the screen. They also can't connect to their phpmyadmin anymore.

So I tried a restart of the MySQL services and did a rebuild of Perl with the DBD::MySQL command but still the same problem. Now I'm trying to do /scripts/mysqlup --force and this is what I get:

Checking if your kit is complete...
Looks good
Using DBI 1.56 (for perl 5.008008 on i686-linux) installed in /usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI/
Writing Makefile for DBD::mysql
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/usr/lib/perl5/site_perl/5.8.8/i686-linux/auto/DBI -I/usr/include/mysql -g -pipe -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=\"4.004\" -DXS_VERSION=\"4.004\" -fpic "-I/usr/lib/perl5/5.8.8/i686-linux/CORE" dbdimp.c
dbdimp.c: In function `mysql_st_fetch':
dbdimp.c:3429: too few arguments to function `mysql_dr_error'
dbdimp.c:3593: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_st_FETCH_internal':
dbdimp.c:3931: too few arguments to function `mysql_dr_error'
dbdimp.c:3945: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_bind_ph':
dbdimp.c:4264: too few arguments to function `mysql_dr_error'
dbdimp.c:4291: too few arguments to function `mysql_dr_error'
dbdimp.c:4303: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_db_reconnect':
dbdimp.c:4465: too few arguments to function `mysql_dr_error'
make: *** [dbdimp.o] Error 1
CAPTTOFU/DBD-mysql-4.004.tar.gz
/usr/bin/make -- NOT OK

Running make install
Make had returned bad status, install seems impossible
perlmod--Install done
Install Complete


Any ideas on what to do?

[mguindon10]

Quick update. I ran these commands to try to fix:

/scripts/mysqlup --force <----that's what still isn't finishing correctly.

/scripts/easyapache option 5

/scripts/perlinstaller --force Bundle:BD::mysql

But I'm still having the problem.

[mguindon10]

Another update.

I noticed in this in my up2date logs:

The following Packages were marked to be skipped by your configuration:

Name Version Rel Reason
-------------------------------------------------------------------------------
httpd 2.0.46 61.entPkg name/pattern
kernel 2.4.21 47.0.1.ELPkg name/pattern
kernel-doc 2.4.21 47.0.1.ELPkg name/pattern
kernel-pcmcia-cs 3.1.31 19 Pkg name/pattern
kernel-smp 2.4.21 47.0.1.ELPkg name/pattern
kernel-source 2.4.21 47.0.1.ELPkg name/pattern
kernel-utils 2.4 8.37.15Pkg name/pattern
mod_ssl 2.0.46 61.entPkg name/pattern
perl 5.8.0 94.EL3Pkg name/pattern
php-imap 4.3.2 40.entPkg name/pattern
php-ldap 4.3.2 40.entPkg name/pattern
squirrelmail 1.4.8 6.el3Pkg name/pattern

All packages are currently up to date

So I went into up2date and deleted perl from it so it would grab it. Ran /scripts/up2date -u and it pulled down the 5.8.8. After that it fixed the "Error while connecting to MySQL. Failover enacted." and now my users can access phpmyadmin again.

But now the issue is any ftp account that isn't root. ex. test@domain.com, can't login to their ftp site. I tried switching to proftp and back to pureftp but that didn't help.

[mguindon10]

Last update I promise....

The ftp problem is fixed. The only thing I did after all the above was delete the extra ftp accounts in the users ftp manager and recreated it and it worked!

So the only problem I really have right now is that when I run /scripts/mysqlup --force I still get this error: (what I don't understand is that it says I have perl 5.8.0 when I have 5.8.8 installed...)

Checking if your kit is complete...
Looks good
Using DBI 1.56 (for perl 5.008 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::mysql
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -I/usr/include/mysql -g -pipe -march=i386 -mcpu=i686 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -march=i386 -mcpu=i686 -DVERSION=\"4.004\" -DXS_VERSION=\"4.004\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" dbdimp.c
dbdimp.c: In function `mysql_st_fetch':
dbdimp.c:3429: too few arguments to function `mysql_dr_error'
dbdimp.c:3593: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_st_FETCH_internal':
dbdimp.c:3931: too few arguments to function `mysql_dr_error'
dbdimp.c:3945: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_bind_ph':
dbdimp.c:4264: too few arguments to function `mysql_dr_error'
dbdimp.c:4291: too few arguments to function `mysql_dr_error'
dbdimp.c:4303: too few arguments to function `mysql_dr_error'
dbdimp.c: In function `mysql_db_reconnect':
dbdimp.c:4465: too few arguments to function `mysql_dr_error'
make: *** [dbdimp.o] Error 1
/usr/bin/make -- NOT OK
Running make install
make had returned bad status, install seems impossible

perlmod--Install done
Install Complete