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.

Problems upgrading from mysql 4.1.22 to 5.0.45

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

  1. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  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
    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?
     
  3. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    Yes, I have.
    That's where I first tried, and it didn't work.
     
  4. EdwardTobia

    EdwardTobia Member

    Joined:
    Oct 22, 2007
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Im also having this problem, would be great if someone has a fix for it...
     
  5. yaax

    yaax Well-Known Member

    Joined:
    Jun 15, 2003
    Messages:
    67
    Likes Received:
    0
    Trophy Points:
    6
  6. harper2233

    harper2233 Registered

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

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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
     
    #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:
    16
    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.
     
  9. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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 :(
     
  10. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    have you found solution yet?
     
  11. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  12. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  13. SNN

    SNN Well-Known Member

    Joined:
    Oct 5, 2007
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    6
    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...
     
  14. Lucas

    Lucas Well-Known Member

    Joined:
    Feb 22, 2003
    Messages:
    125
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
    #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:
    16
    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)
     
  16. shashank

    shashank Well-Known Member
    PartnerNOC

    Joined:
    Apr 12, 2003
    Messages:
    159
    Likes Received:
    1
    Trophy Points:
    18
    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 ?
     
  17. AMD64

    AMD64 Active Member

    Joined:
    Jun 19, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    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
    
     
  18. AMD64

    AMD64 Active Member

    Joined:
    Jun 19, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    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).
     
  19. nickp666

    nickp666 Well-Known Member

    Joined:
    Jan 28, 2005
    Messages:
    770
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    /dev/null
  20. AMD64

    AMD64 Active Member

    Joined:
    Jun 19, 2005
    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    1
    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
     
Loading...

Share This Page