mysql-5.0.51 Update...

[crobinson]

Is there plans to update your MySQL to 5.0.52 or later... There is a MySQL bug that causes it to ignore "order by" and puts in last edited... That seems to really fowl up WordPress blogs...

[scott]

As I recall, I ran into a problem with upgrading a plesk box that had 5.0.52 or higher on it.

[crobinson]

blast... What was the problem... I should try it out on my test box.

[scott]

It was some issue when upgrading the psa package, it had some unrecoverable error that I dont recall. I couldn't fix it without re-imaging the whole thing.

[crobinson]

HAH

I hate those errors... Going to try to update it soon... Anything you want me to do first... rpm -qa?

[scott]

Nope, just upgrade it and let us know how it goes.

[crobinson]

I'll update it and let you know...

I'll get a snapshot of all my installed packages.

[scott]

I did a 5.0.58 in the atomic-testing channel. Give that one a shot and let me know how it goes.

[crobinson]

Will do... Now I just have to find a freed up server to test on... =)

[crobinson]

Wow... This did take me a long time to get too...

I have updated to mysql-5.0.58-1.el4.art and a quick VERY basic test it looks like it works fine with Plesk 8.3... Now I have started to test with Plesk 8.4...

Is there a way to post files here?

[crobinson]

Quick check and 8.4 works fine too.... Weeeeee

[Snapdragon]

Just tried to do 58 on my Plesk 8.4 server, and got:

Code: Select all

http://www.atomicorp.com/channels/atomic-testing/centos/4/x86_64/RPMS/mysql-5.0.58-1.el4.art.x86_64.rpm: [Errno 14] HTTP Error 404: Not Found
Trying other mirror.
http://www.atomicorp.com/channels/atomic-testing/centos/4/x86_64/RPMS/mysql-server-5.0.58-1.el4.art.x86_64.rpm: [Errno 14] HTTP Error 404: Not Found
Trying other mirror.


Error Downloading Packages:
  mysql - 5.0.58-1.el4.art.x86_64: failure: RPMS/mysql-5.0.58-1.el4.art.x86_64.rpm from atomic-testing: [Errno 256] No more mirrors to try.
  mysql-server - 5.0.58-1.el4.art.x86_64: failure: RPMS/mysql-server-5.0.58-1.el4.art.x86_64.rpm from atomic-testing: [Errno 256] No more mirrors to try.

I haven't been around here much lately, ever since I bought this huge Dell server at Xmas in 2006, I haven't had to touch it. It had 490 days of uptime before I had to rip it down and move it to my new job.

Now I have a whole data center to run as a full time job So I figured I'd throw more RAM and another CPU in the box while it was down and upgrade to MySQL 5 and PHP 5.

First step was to take Plesk from 8.2.1 to 8.4, that went fine.

PHP 5 is giving me the typical php-pear dependency error, waiting for 5.2.6 to be ready.

And MySQL 5.0.58 is giving me the above.

Bleh!

[Snapdragon]

Hmm.. I found mysql-5.0.58-1.el4.art.x86_64.rpm in:

http://www.atomicorp.com/channels/atomi ... 6_64/RPMS/
http://www.atomicorp.com/channels/atomi ... 6_64/RPMS/

Does that mean that MySQL is now in the stable channel, but the package is still listed in testing, and that's why yum can't find it?



... never mind, I answered my own question.. I disabled atomic-testing and yum found it in atomic instead.

Now I get the HUGE conflict list. Obviously it must be a 64 vs. 32 bit conflict.

At the bottom, it also has:
file /etc/php.ini from install of php-common-5.2.6-1.el4.art conflicts with file from package php-4.3.9-3.22.9

[crobinson]

Yep... Looks like it is... Sweet, sweet crude....