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.

mysql update failed, now apache also down---

Discussion in 'Database Discussions' started by vindsl, Jul 30, 2010.

  1. vindsl

    vindsl Registered

    Joined:
    Jul 30, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Hello,
    (Happy sysadmin day btw!)

    I tried to update Mysql from 4.0 to 5.1 via WHM but i got the following error near the start of the process:

    =========================
    'ERROR: 1136 Column count doesn't match value count at row 1
    071126 20:49:18 [ERROR] Aborting '
    =========================

    And the update failed, and also i think the process tried to recompile apache and PHP because i cant start/restart httpd either.

    If i try to recompile Apache, i get the following error:

    =======================
    Fetching http://httpupdate.cpanel.net/syspkgs/templates/centos/4/cpanel/CentOS-Base.repo (0)....@75.127.84.226......connected......receiving...100%......Done
    checkyum version 20.5
    checkyum version 20.5
    !! Package system can not be repaired automatically !!

    and....

    Apache Restart Output:
    Syntax error on line 9 of /usr/local/apache/conf/php.conf:
    Cannot load /usr/local/apache/libexec/libphp4.so into server: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/local/apache/libexec/libphp4.so)
    /etc/init.d/httpd start: httpd could not be started
    =======================

    So both daemons are unresponsive now,
    I tried mysqlup --force.. still the same..

    anyone halp? =)
    is there a way to really really force a apache and mysql reinstall? seems both of them are broken now :/
     
    #1 vindsl, Jul 30, 2010
    Last edited: Jul 30, 2010
  2. jeffmonte

    jeffmonte Member

    Joined:
    Jul 28, 2010
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    I have had a same situation, I just made a backup of mysql databases.

    cp -rp /var/lib/mysql /var/lib/mysql.back

    Then I just moved the actual mysql directory to some other dir.

    cd /var/lib

    Then mv mysql mysql.bk

    Then I just ran /scripts/mysqlup --force

    As the way, it just fixed up.

    Then I just copied the databases to the actual mysql dir.

    I assume the issue is with the mysql database in which the tables are not being allowed to get altered.

    Try this as this is one of my strategy...
     
Loading...

Share This Page