Problems upgrading from mysql 4.1.22 to 5.0.45

[SNN]

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:

# 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]

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:

# 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]

Yes, I have.
That's where I first tried, and it didn't work.

 

[EdwardTobia]

Im also having this problem, would be great if someone has a fix for it...

 

[yaax]

I've just found simple solution for this problem here:
http://forums.cpanel.net/showthread.php?t=74184

I resolved my problem with a simply solution.

mv /etc/my.cnf /etc/my.cnf.BAD
/scripts/mysqlup --force

Thanks Asusservice for the solution posten in page 5 of http://forums.cpanel.net/showthread.php?t=36503&page=5 topic.

 

[harper2233]

I have the same problem, but the above solution didn't fix it.

 

[SNN]

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

 

[markhard]

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 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

 

[markhard]

have you found solution yet?

 

[SNN]

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]

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]

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]

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.

 

[markhard]

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)

 

[shashank]

error: install: %pre scriptlet failed

The above error is mostly due to selinux being enabled. Did you check if it was enabled before ?

 

[AMD64]

Getting this same error on a CentOS 5 openVZ VPS trying to upgrade with mysqlup.
SELinux is disabled

 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]

More info on this error:

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

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).

 

[nickp666]

try one of these: http://dag.wieers.com/rpm/packages/perl-DBI/

 

[AMD64]

Just getting this now after installing perl-DBI via yum

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

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