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.

After nightly auto-upgrade mysql does not work.

Discussion in 'General Discussion' started by mount, Dec 3, 2005.

  1. mount

    mount Member

    Joined:
    Sep 8, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    After the last nightly auto-upgrade in my server (set by cron, from 4.0.25 to 4.0.26), the MySQL daemon does not work. The log says:


    051203 12:35:21 mysqld started
    Fatal error: Can't change to run as user 'mysql'. Please check that the user exists!
    051203 12:35:21 Aborting

    051203 12:35:21 /usr/sbin/mysqld: Shutdown Complete

    051203 12:35:21 mysqld ended

    The user exists, and it is able to login in it.

    I tried all scripts for trying to fix this problem in /scripts, and I also tried reinstalling by /scripts/mysqlup --force, and doing rpm -e's and reinstalling from mysqlup, before removing mysql user.

    Nothing appears to fix this problem. Anybody can help me?

    Thanks.
     
  2. mount

    mount Member

    Joined:
    Sep 8, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I downgraded to 4.0.25 and it work fine. I think that there is a problem with 4.0.26.
     
  3. iris

    iris Member

    Joined:
    Feb 20, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    We are having the same problem, and our sites are still down!!!

    How can one downgrade MySQL?

    cPanel ticket #119703
     
    #3 iris, Dec 3, 2005
    Last edited: Dec 3, 2005
  4. mount

    mount Member

    Joined:
    Sep 8, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Simply, download 4.0.25 replacements for your MySQL packages, and install it via rpm/apt-get/... (depending on your distro).

    I also removed the autoupgrade script from cron, for avoid this situations.

    My system runs Fedora Core 4. Any evidence from cpanel staff of knowing this?
     
  5. iris

    iris Member

    Joined:
    Feb 20, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    I figured as much but i figured there might be a script to do it or require downloading a special RPM from cPanel or something else special.

    After cPanel staff having been logged in for an hour and idle for 20 minutes I went ahead and replaced 4.0.26 with .25 and everything is working.

    I hope cPanel get us a real answer on why this happened.
     
  6. contour

    contour Registered

    Joined:
    Mar 25, 2004
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
  7. iris

    iris Member

    Joined:
    Feb 20, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1

    I am not sure what part of that post you are referring to but nothing in it would have worked for this problem. the running of "mysql_install_db --user=mysql" requires the mysql server to be running where ours wouldn't even start. And there is a specific error message when you need the old password config addition.

    My question is what OS did mount have the problem on?

    We are running Fedora core 4 on a dual xeon dell server.
     
  8. mount

    mount Member

    Joined:
    Sep 8, 2004
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I also have Fedora Core 4.
     
  9. iris

    iris Member

    Joined:
    Feb 20, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    cPanel staff will be doing the upgrade to 4.0.26 again tonight and will troubleshoot the problem.

    I ill advise once they find the reason.

    Adam
     
  10. iris

    iris Member

    Joined:
    Feb 20, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    cPanel tried the upgrade to 4.0.26 and replied to my ticket with the following.


    "This is an issue with the mysql rpm build itself, and the fact that it was not properly linked against the required libraries. Because of this, we are rolling back to the previous version ( 4.0.25 ) until this issue is resolved.

    However, if you wish to run 4.0.26, you can do so by adding 'sudo -u mysql' prior to the execution of mysqld_safe in /etc/init.d/mysql.

    You are presently running 4.0.25, and should not experience any further problems with this on your server. "

    So at least they've seen the problem and are aware of it.
     
  11. iris

    iris Member

    Joined:
    Feb 20, 2003
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    I then asked if the update script would try again to upgrade MySQL to 4.0.26 and i received the following response:

    "Your server should remain with it's present configuration, as we are removing support for 4.0.26 from our mysql update scripts."

    Hope this helps folks.
     
  12. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    hey

    anyone know where I can find old versions of mysql for Trustix. namely the version 4.0.25.

    I did a cpanel install on monday and mysql was not installed by cpanel, and the trustix mirrors are now using version 4.0.26 :(

    Thanks
    Andy
     
  13. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    hey

    I tried to do a new install of cpanel, but its messing up and not finding the mysql files.
    Once the install was finished.
    I just downloaded and installed these old versions from cpanels website.
    http://updates.cpanel.net/mysqlinstall/i386/

    Its version 4.0.23 , but it works for me.

    Cheers
    andy
     
Loading...

Share This Page