Problems upgrading from mysql 4.1.22 to 5.0.45

SNN

Well-Known Member
Oct 5, 2007
78
0
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
 

cPanelDavidG

Technical Product Specialist
Nov 29, 2006
11,212
13
313
Houston, TX
cPanel Access Level
Root Administrator
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
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?
 

SNN

Well-Known Member
Oct 5, 2007
78
0
56
Yes, I have.
That's where I first tried, and it didn't work.
 

SNN

Well-Known Member
Oct 5, 2007
78
0
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
 
Last edited:

markhard

Well-Known Member
Apr 22, 2004
252
0
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.
 

SNN

Well-Known Member
Oct 5, 2007
78
0
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 :(
 

SNN

Well-Known Member
Oct 5, 2007
78
0
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
 

markhard

Well-Known Member
Apr 22, 2004
252
0
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.
 

SNN

Well-Known Member
Oct 5, 2007
78
0
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...
 

Lucas

Well-Known Member
Feb 22, 2003
132
3
168
Around the world
cPanel Access Level
Root Administrator
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.
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.
 
Last edited:

markhard

Well-Known Member
Apr 22, 2004
252
0
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)
 

AMD64

Active Member
Jun 19, 2005
27
0
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)[email protected]                     ..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
 

AMD64

Active Member
Jun 19, 2005
27
0
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).
 

AMD64

Active Member
Jun 19, 2005
27
0
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