Database error after upgrade

spongedoc

• July 02, 2014 03:27

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

• 

  spongedoc

  • July 02, 2014 13:17

  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.

  0
• 

  cPanelMichael

  • July 02, 2014 14:45

  Hello :) Please check the file attributes on the "/" directory. EX: 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: chattr -i /
  Thank you.

  0
• 

  spongedoc

  • July 02, 2014 15:16

  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.

  0
• 

  spongedoc

  • July 02, 2014 15:57

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

  0
• 

  cPanelMichael

  • July 02, 2014 15:59

  [quote="spongedoc, post: 1678611">I remove all attributes from the file, and i have a new error: Could not compile a simple mysql.h program: -compile- -output-
  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.

  0

Please sign in to leave a comment.