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.

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
     
    #1 SNN, Jan 11, 2008
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,277
    Likes Received:
    8
    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.
     
    #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
     
    #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.
     
    #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 :(
     
    #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?
     
    #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
     
    #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.
     
    #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...
     
    #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.
     
    #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)
     
    #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 ?
     
    #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:
    770
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    /dev/null
    #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. Spork Schivago

    Problems with OCSP stapling

    Spork Schivago, Jun 23, 2017 at 12:38 PM, in forum: Security
    Replies:
    9
    Views:
    80
    Spork Schivago
    Jun 26, 2017 at 1:36 PM
  2. jonnyydeoliveira

    Facing problems with /scripts/pkgacct

    jonnyydeoliveira, Jun 17, 2017, in forum: General Discussion
    Replies:
    13
    Views:
    99
    cPanelMichael
    Jun 19, 2017
  3. techman141102

    Problems with certificate

    techman141102, Jun 13, 2017, in forum: Security
    Replies:
    7
    Views:
    96
    cPanelMichael
    Jun 19, 2017
  4. Spork Schivago

    Problems with DMARC and e-mails from cPanel

    Spork Schivago, Jun 10, 2017, in forum: Security
    Replies:
    14
    Views:
    98
    Spork Schivago
    Jun 17, 2017
  5. dansparks127

    Jailshell Problems

    dansparks127, Jun 6, 2017, in forum: Security
    Replies:
    3
    Views:
    75
    cPanelMichael
    Jun 7, 2017

Share This Page