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.

Database error after upgrade

Discussion in 'Database Discussions' started by spongedoc, Jul 2, 2014.

  1. spongedoc

    spongedoc Member

    Joined:
    May 7, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi!

    I upgrade the mysql from 5.1 to 5.6. I have an error during the installation, but, the next try is succeeded. After that, the database is unreachable. The roundcube is not working. I repaired the roundcube access, with these commands:
    Code:
    mv /etc/my.cnf /etc/my.cnf.backup
    mv /var/lib/mysql/ib_logfile* /root/
    service mysqld restart
    After this, the roundcube is working again.

    But the wordpress site is not work. The error:
    Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

    I check the easy apache configuration, and found error in the mysql php module:

    The last time Cpanel::Easy::PHP5::Mysql was run; step returned 0.
    That just caused Cpanel::Easy::PHP5::Mysql to be skipped.
    The message it gave was:
    Could not open() file '/cpmysql.c' for writing: Permission denied
    You might want to take that into consideration when choosing options and troubleshooting.
    The log for that build is here: /usr/local/cpanel/logs/easy/apache/build.1404223691


    The Mysql of the system module is also send the same error.

    The error log is attached.

    Please help me out!

    Thank you
    SpongeDoc
     

    Attached Files:

  2. spongedoc

    spongedoc Member

    Joined:
    May 7, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I try more, and the easyapache build failing too with this error:
    "Cpanel::Easy::PHP5::Mysql":
    "dryrun": 0
    "fatal": ~
    "msg":
    - 'Could not open() file ''[_1]'' for writing: [_2]'
    - '/cpmysql.c'
    - 'Permission denied'
    "rc": 0

    And this error for mysqlofsystem.

    And the GD, and Zlib module compile failed.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please check the file attributes on the "/" directory. EX:

    Code:
    lsattr -d /
    The output you provided suggests it's configured with the immutable file attribute. If that's the case, you can correct that with a command such as:

    Code:
    chattr -i /
    Thank you.
     
  4. spongedoc

    spongedoc Member

    Joined:
    May 7, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi Michael!

    Thank you, te tip. Yes, the root folder was immutable file attribute. I remove it, but the easyapache drop the same error if i build.

    The mysql is run fine locally, but the php module is cant run.

    The cpmysql.c file in the root folder has -rw-r--r-- permission, but if i try to change the permisson to 755 the error is: Operation not permitted. I'am root.
     
  5. spongedoc

    spongedoc Member

    Joined:
    May 7, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I remove all attributes from the file, and i have a new error:
    Could not compile a simple mysql.h program: -compile- -output-

    I drop my mind soon...
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Please feel free to open a support ticket so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page