MySQL upgrade kills perl webapp?

breun · Unread post by **breun** » Sun Feb 19, 2006 6:07 pm

Oh, I just read in the changelog for php that you're linking against mysql 4.1 since 4.4.1-2. So I'll need to downgrade to 4.4.1-1 or older, as they are linked to mysql3 apparently. However, 4.4.0-3 is the newest mysql3-linked php release up on your server. Why was 4.4.1 removed?

breun · Unread post by **breun** » Sun Feb 19, 2006 6:24 pm

I just downgraded to php 4.4.0-3 and the old 3.23.58 mysql. However, some sites stopped working and phpmyadmin couldn't open those databases. Didn't mysql 4.x add utf-8 support? I think some clients may have changed the charset of their databases...

I'm currently upgrading back to your mysql 4.1 and php 4.4.2 again...

breun · Unread post by **breun** » Sun Feb 19, 2006 6:29 pm

Ok, I'm kind of stuck now. Upgraded again and the sites that broke after downgrading are working again. But my perl app is still broken.

Unread post by **scott** » Sun Feb 19, 2006 7:40 pm

Man you have bad timing

I had just cleared out some of the older packages from the archive this morning to free up some space.

Unread post by **scott** » Sun Feb 19, 2006 7:46 pm

Another option here, and its a fun one, is to rebuild php-4.4.2 on your system with the native mysql 3 client libraries.

breun · Unread post by **breun** » Sun Feb 19, 2006 8:20 pm

I just decided to take the perl app off that server and moved it to a CentOS 4.2 server with the distro's own MySQL 4.1.12 (server uses ART, but not for mysql) and it's working again. So I guess I won't fuss with this any further.

Thanks for the help though, Scott. You're really a great help.

Unread post by **scott** » Sun Feb 19, 2006 8:41 pm

yeah the CentOS4 and FC4 systems really make a lot of this go away. So to cause trouble again Ive started working on PHP 5.1 and Mysql 5 rpms:

http://3es.atomicrocketturtle.com/atomi ... rt/4/RPMS/

breun · Unread post by **breun** » Mon Feb 20, 2006 5:29 am

If I would install your mysql rpm on that CentOS 4 box, I wouldn't be having the mixed MySQL3/4.1 environment problems right? However, I do see a mysql-compat package in your 4ES packages. What is that for then?

I believe the CentOS Plus channel has PHP5, but for now I'll stick with PHP 4.4 and MySQL 4.1.

Unread post by **scott** » Mon Feb 20, 2006 10:19 am

CentOS4 is already using mysql 4.1, so all you'd get is the newer version of the package. The compat library probably wont be needed on CentOS4 or FC4.