Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Problems upgrading from mysql 4.1.22 to 5.0.45

Discussion in 'Database Discussion' started by SNN, Jan 11, 2008.

Page 1 of 2
  1. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    56
    I've tried several things to upgrade from 4.1.22 (mysql standard) to 5.0.45 and I've received the same error over and over:
    Code:
    # rpm -Uvh --nodeps MySQL-server-5.0.45-0.glibc23.i386.rpm
Preparing...                ########################################### [100%]
error:   install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23
    I've tried installing perl(DBI) from a example in another thread, I've tried cPanel upgrade features, and rpm -Uvh. Nothing has seemed to work. Any idea how to fix this?
    I'm running Fedora 6.

    Thanks
    Billy
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 SNN, Jan 11, 2008
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,216
    Likes Received:
    10
    Trophy Points:
    313
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Have you tried setting the option for MySQL version in WHM -> Server Configuration -> Tweak Settings -> MySQL to 5.0 and then run /scripts/mysqlup among the other items that setting says you should do?
     
    #2 cPanelDavidG, Jan 11, 2008
  3. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    56
    Yes, I have.
    That's where I first tried, and it didn't work.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 SNN, Jan 11, 2008
  4. EdwardTobia

    EdwardTobia Member

    Joined:
    Oct 22, 2007
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    51
    Im also having this problem, would be great if someone has a fix for it...
     
    #4 EdwardTobia, Jan 13, 2008
  5. yaax

    yaax Well-Known Member

    Joined:
    Jun 15, 2003
    Messages:
    67
    Likes Received:
    0
    Trophy Points:
    156
    #5 yaax, Jan 13, 2008
  6. harper2233

    harper2233 Registered

    Joined:
    Apr 16, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    I have the same problem, but the above solution didn't fix it.
     
    #6 harper2233, Jan 13, 2008
  7. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    56
    Didn't work.
    I still get "MySQL version 4.1.22-standard"
    The only thing I see that is wrong is: error: install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 SNN, Jan 13, 2008
    Last edited: Jan 13, 2008
  8. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    i was had the same problem before: http://forums.cpanel.net/showthread.php?t=74628

    but then it fixed by upgrading to latest Cpanel RELEASE, when the cron do /scripts/upcp, the log shows that mysql upgraded "automagicly" :D

    it seems that cpanel do some changes on the script, it does stop the mysql server first before doing the upgrade.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 markhard, Jan 13, 2008
  9. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    56
    Well I've let the cron run and I've tried anything I could find on the link you provided, doesn't seem anything is working :(
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 SNN, Jan 15, 2008
  10. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    have you found solution yet?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 markhard, Jan 22, 2008
  11. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    56
    Sadly, no.

    No I have not, this has stopped allowing me to assign users to databases as well so I'm going to mess with my VPS & move accounts. The only thing I can think of to fix this is to move from Fedora 6 to CentOS 5 and upgrade to mysql 5.0.45 after install.

    Thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #11 SNN, Jan 24, 2008
  12. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    i setup a centos 5 vps and upgrade to mysql 5 right after the cpanel installation finish, it still giving the same error.

    about the problem on assigning user, i haven't got that problem, but i do have problem on assigning "all privileges" to a user for a database. what i do then is check all the check boxes minus 1 check box (so not all check box) then add the privileges. it will add the privileges, then you can come back to that page and assign the 1 privileges left.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #12 markhard, Jan 24, 2008
  13. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    56
    Ah, I never tried that.
    Well I reinstalled Fedora 6 and updated right after install and it fixed the problem.
    Now for the "fun" of restoring my websites...
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #13 SNN, Jan 25, 2008
  14. Lucas

    Lucas Well-Known Member

    Joined:
    Feb 22, 2003
    Messages:
    132
    Likes Received:
    3
    Trophy Points:
    168
    Location:
    Around the world
    cPanel Access Level:
    Root Administrator
    I just got a VPS with CentOS 5 and I am getting the same issue. MySQL will not upgrade to version 5. Neither using /scripts/mysqlup, running software update or updating cpanel is upgrading mysql 5, same error on all different ways.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #14 Lucas, Jan 26, 2008
    Last edited: Jan 26, 2008
  15. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    166
    Lucas,

    what you can do on fresh installation of a VPS is by directly install mysql 5 on initial cpanel install.

    if you haven't any data on the VPS i suggest to reload the VPS and re-install cpanel with some steps to do while the installation is running.

    after you run the "sh latest" command to install cpanel.. wait until it finished downloading all the scripts needed to install cpanel (i guess it will be when the install script shows ......3.. or around that)

    then edit the file /var/cpanel/cpanel.config

    and find mysql server version, the default is 4.1 change it to 5.0 and save

    the script will install mysql version 5.0 instead of 4.1 hence you don't need to upgrade.

    this is easier than having no clue on how to upgrade from 4.1 to 5.0 (incase you are fresh install a vps/server)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #15 markhard, Jan 26, 2008
  16. shashank

    shashank Well-Known Member
    PartnerNOC

    Joined:
    Apr 12, 2003
    Messages:
    159
    Likes Received:
    1
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    error: install: %pre scriptlet failed

    The above error is mostly due to selinux being enabled. Did you check if it was enabled before ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #16 shashank, Feb 7, 2008
  17. AMD64

    AMD64 Active Member

    Joined:
    Jun 19, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    151
    Getting this same error on a CentOS 5 openVZ VPS trying to upgrade with mysqlup.
    SELinux is disabled


    Code:
     1:MySQL-shared           ########################################### [100%]
Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-serve                     r-5.0.45-0.glibc23.i386.rpm (0)....@69.72.164.152......connected......receiving.                     ..1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%                     ...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%..                     .29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...4                     2%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%                     ...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%..                     .69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...8                     2%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%                     ...96%...97%...98%...99%...100%......Done
Preparing...                ########################################### [100%]
error:   install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glib                     c23
     
    #17 AMD64, Feb 20, 2008
  18. AMD64

    AMD64 Active Member

    Joined:
    Jun 19, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    151
    More info on this error:

    Code:
    rpm -Uvh MySQL-server-5.0.45-0.glibc23.i386.rpm                    error: Failed dependencies:
        perl(DBI) is needed by MySQL-server-5.0.45-0.glibc23.i386
    Code:
    perl -MCPAN -e 'install DBI'
CPAN: File::HomeDir loaded ok (v0.69)
CPAN: Storable loaded ok (v2.18)
Going to read /home/.cpan/Metadata
  Database was generated on Thu, 21 Feb 2008 06:31:17 GMT
DBI is up to date (1.602).
     
    #18 AMD64, Feb 22, 2008
  19. nickp666

    nickp666 Well-Known Member

    Joined:
    Jan 28, 2005
    Messages:
    769
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    /dev/null
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #19 nickp666, Feb 22, 2008
  20. AMD64

    AMD64 Active Member

    Joined:
    Jun 19, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    151
    Just getting this now after installing perl-DBI via yum

    Code:
    rpm -Uvh MySQL-server-5.0.45-0.glibc23.i386.rpm
Preparing...                ########################################### [100%]
error:   install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23


    Code:
    rpm -ivh MySQL-server-5.0.45-0.glibc23.i386.rpm
Preparing...                ########################################### [100%]
        file /etc/init.d/mysql from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/my_print_defaults from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/myisam_ftdump from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/myisamchk from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/myisamlog from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/myisampack from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysql_convert_table_format from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysql_explain_log from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysql_fix_privilege_tables from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysql_install_db from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysql_secure_installation from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysql_tzinfo_to_sql from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysql_zap from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysqlbug from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysqld_multi from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysqld_safe from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysqldumpslow from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysqlhotcopy from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/bin/mysqltest from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/dec8.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/geostd8.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/greek.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/hebrew.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/hp8.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/keybcs2.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/koi8r.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/koi8u.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/latin1.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/latin2.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/latin5.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/latin7.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/macce.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/macroman.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/charsets/swe7.xml from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/spanish/errmsg.sys from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/swedish/errmsg.sys from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
        file /usr/share/mysql/ukrainian/errmsg.sys from install of MySQL-server-5.0.45-0.glibc23 conflicts with file from package MySQL-server-4.1.22-0.glibc23
     
    #20 AMD64, Feb 22, 2008
(You must log in or sign up to post here.)
Page 1 of 2
Loading...
Similar Threads - Problems upgrading mysql
  1. charisma09

    New Thread Problems With Spam

    charisma09, Jun 16, 2018 at 10:01 PM, in forum: E-mail Discussion
    Replies:
    1
    Views:
    65
    24x7server
    Jun 17, 2018 at 11:34 AM
  2. b81erikan

    Fileman::savefile && Fileman::uploadfiles Problems

    b81erikan, Jun 10, 2018, in forum: cPanel Developers
    Replies:
    3
    Views:
    129
    cPanelMichael
    Jun 12, 2018 at 1:42 PM
  3. Gustavo Delgado

    problems with sending mail

    Gustavo Delgado, Jun 9, 2018, in forum: E-mail Discussion
    Replies:
    2
    Views:
    88
    cPanelLauren
    Jun 11, 2018
  4. Gastón

    Problems with Translation after Upgrade v70.0.44

    Gastón, May 24, 2018, in forum: User Experience
    Replies:
    1
    Views:
    359
    cPanelMichael
    May 25, 2018
  5. michaeltoan016

    Problems Updating Out of Date cPanel

    michaeltoan016, May 24, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    181
    cPanelKenneth
    May 24, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice