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 Problem

Discussion in 'General Discussion' started by Blue|Fusion, Oct 31, 2004.

  1. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    I am using MySQL 4.0.20-standard, however I see that 4.0.22 is out (probobly has been for a while anyway)...

    When I run sysup in WHM, I get the following when updating everything:
    What is wrong? Is there a way to fix it?
     
  2. Antarius

    Antarius Member

    Joined:
    Jun 15, 2004
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Same problem.
     
  3. Antarius

    Antarius Member

    Joined:
    Jun 15, 2004
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Does anybody know how to change a mirror from where mysql is downloaded from?
     
  4. Zaeolos

    Zaeolos Registered

    Joined:
    Aug 25, 2003
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I am getting same problem. I am setting up a new server and MySQL is not installed yet nor will it install it via buildapache or sysup. I get the same thing:

    MySQL-server is not up to date (Wed Dec 31 19:00:00 1969)
    /var/spool/cpupdates/MySQL-server-4.0.22-0.i386.rpm: not an rpm package (or package manifest):
    MySQL-embedded is not up to date (Wed Dec 31 19:00:00 1969)
    /var/spool/cpupdates/MySQL-embedded-4.0.22-0.i386.rpm: not an rpm package (or package manifest):
    MySQL-client is not up to date (Wed Dec 31 19:00:00 1969)
    /var/spool/cpupdates/MySQL-client-4.0.22-0.i386.rpm: not an rpm package (or package manifest):
    MySQL-devel is not up to date (Wed Dec 31 19:00:00 1969)
    /var/spool/cpupdates/MySQL-devel-4.0.22-0.i386.rpm: not an rpm package (or package manifest):
    MySQL-bench is not up to date (Wed Dec 31 19:00:00 1969)
    /var/spool/cpupdates/MySQL-bench-4.0.22-0.i386.rpm: not an rpm package (or package manifest):
    MySQL-shared is not up to date (Wed Dec 31 19:00:00 1969)
    /var/spool/cpupdates/MySQL-shared-4.0.22-0.i386.rpm: not an rpm package (or package manifest):
    MySQL-shared-compat is not up to date (Wed Dec 31 19:00:00 1969)
    /var/spool/cpupdates/MySQL-shared-compat-4.0.22-0.i386.rpm: not an rpm package (or package manifest):
     
    #4 Zaeolos, Nov 2, 2004
    Last edited: Nov 2, 2004
  5. mYsTicOne

    mYsTicOne Member

    Joined:
    Aug 14, 2004
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
  6. Blue|Fusion

    Blue|Fusion Well-Known Member

    Joined:
    Sep 12, 2004
    Messages:
    378
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Cleveland, Ohio
    I have fixed the problem by doing the following.

    In SSH do the following:

    rm -rf /root/.cpmysqlrpm
    /scripts/upcp --force

    Using upcpform in WHM doesn't seem to do the MySQL update correctly, so use the command above to update it.
     
  7. Zaeolos

    Zaeolos Registered

    Joined:
    Aug 25, 2003
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1

    I had my NOC submit a ticket yesterday. There was something about the links CPanel was using to do the updates. I had tried /scripts/upcp --force prior to that and it did not work but a few hours later they fixed it and using that command later on got everything updated and everything is working now.
     
  8. mrcbrown

    mrcbrown Well-Known Member

    Joined:
    Jun 5, 2003
    Messages:
    93
    Likes Received:
    0
    Trophy Points:
    6
    They didn't do anything else? I just did the update to R89 and everything went without a hitch, except the MySQL note again:

    /var/spool/cpupdates/MySQL-server-4.0.22-0.i386.rpm: read manifest failed: Success
    MySQL-embedded is not up to date (Sat May 15 20:00:43 2004)
    /var/spool/cpupdates/MySQL-embedded-4.0.22-0.i386.rpm: read manifest failed: Success
    MySQL-client is not up to date (Sat May 15 20:00:43 2004)
    /var/spool/cpupdates/MySQL-client-4.0.22-0.i386.rpm: read manifest failed: Success
    MySQL-devel is not up to date (Sat May 15 20:00:43 2004)
    /var/spool/cpupdates/MySQL-devel-4.0.22-0.i386.rpm: read manifest failed: Success
    MySQL-bench is not up to date (Sat May 15 20:00:43 2004)
    /var/spool/cpupdates/MySQL-bench-4.0.22-0.i386.rpm: read manifest failed: Success
    MySQL-shared is not up to date (Wed Dec 31 16:00:00 1969)
    /var/spool/cpupdates/MySQL-shared-4.0.22-0.i386.rpm: read manifest failed: Success
    MySQL-shared-compat is not up to date (Thu Jul 8 16:10:58 2004)
    /var/spool/cpupdates/MySQL-shared-compat-4.0.22-0.i386.rpm: read manifest failed: Success

    When I did the --force method afterwards, its hitting a location that simply doesnt have the RPM's anymore - is there a way to force a update of the download links? It's obviously not determining this set as bad. Thoughts?
     
  9. Aric1

    Aric1 Well-Known Member

    Joined:
    Oct 15, 2003
    Messages:
    324
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    I manually downloaded the correct RPM files and installed them on one server that had this problem. It worked.
     
  10. noorolhoda

    noorolhoda Active Member

    Joined:
    Jul 19, 2004
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    Hello
    Just Run
    /scripts/sysup
    then you can see which mirror link has problem
    after that run

    pico /root/.cpmysqlrpm/mirrors.lst

    find and delete the link that have problem.

    and then run

    /scripts/sysup

    ;)
     
Loading...

Share This Page