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 automatic upgrade?

Discussion in 'General Discussion' started by sparek-3, Jun 23, 2008.

  1. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,381
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Has anyone else experienced an issue where your server automatically upgraded to MySQL 5.0 from MySQL 4.1?

    I have about 3 servers that are showing as running MySQL 5.0.51a. These servers should have all been running MySQL 4.1, I have not yet made the jump to MySQL 5.0. The upgrade seems to have been carried out last on June 18th, on into the early morning hours of June 19th according to the stats of the /usr/bin/mysql binary.

    The /var/cpanel/cpanel.config file is showing the MySQL version as being 5.0, but this should not be the case. It should be showing 4.1.

    The servers all seem to be in different datacenters and while I cannot completely rule out a root compromise somewhere, the fact that our servers at multiple datacenters have been hit would seem to make this unlikely. I also have other servers at these datacenters and none of them have been affected. In fact the overall vast majority of our servers have not been affected by this.

    I am just wondering if anyone else has experienced this automatic upgrade.
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    cPanel/WHM does not perform an automatic upgrade from MySQL 4.1 to 5.0. You may wish to recompile PHP and Apache just to ensure proper functionality as this is a required part of the upgrade process to ensure Apache and PHP scripts continue functioning properly.
     
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    That should not happen. Which branch of cPanel are/were you running (RELEASE) ? Check the update logs in /var/cpanel/updatelogs to see if there are any clues to what happened. Or if you want, I can examine them for you. Simply PM me and I'll send you info on where to send the logs.
     
  4. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,381
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    I actually think that this was a type of false-positive. I thought I had all of my servers running MySQL 4.1, but the more I thought about it the more I think that just a handful of them were actually running MySQL 5.0. The problem presented itself on a server that I thought I had downgraded to MySQL 4.1 (its a relatively new server, about 2 weeks old so MySQL 5.0 was installed by default) but I don't think I ever got around to downgrading it to MySQL 4.1 and then I found just a select few servers that were running MySQL 5.0 and I jumped the gun so to speak thinking that those servers had automatically upgraded to MySQL 5.0.

    I had searched through this forum and some other forums to see if anyone else had experienced this "issue". I made this post thinking that others may have experienced the same issue and that would have acted as a confirmation. But after a lot of thought on the incident and some more checking, I think this was just a case of forgetfulness.

    Thanks for the replies though.
     
Loading...

Share This Page