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 mguindon10, Jun 5, 2007.

  1. mguindon10

    mguindon10 Active Member

    Joined:
    Aug 23, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Detroit, MI.
    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?
     
  2. mguindon10

    mguindon10 Active Member

    Joined:
    Aug 23, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Detroit, MI.
    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::DBD::mysql

    But I'm still having the problem.
     
  3. mguindon10

    mguindon10 Active Member

    Joined:
    Aug 23, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Detroit, MI.
    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.
     
  4. mguindon10

    mguindon10 Active Member

    Joined:
    Aug 23, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Detroit, MI.
    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
     
Loading...

Share This Page