PHP & MySQL Upgrade

[corman420]

Current Versions:
4.3.9 - php
4.1.20 - mysql

Plesk 8.2 with CentOS4

I am wanting to upgrade my php/mysql installation to the latest but I am worried!

I see all these posts about people messing it up, and then I see others that say it is soo easy using yum.

I'm not a total noob, but I am confused as to what is th ebest way to update php & mysql.

If I have a BASE installation of CentOS4 and Plesk 8.2, what are the exact commands I should use to update both php & mysql?

I hope I'm not a big bother - but I just don't want to break my server.

Thanks in advance.

 

[corman420]

And in what order should I Update these?

 

[corman420]

I was getting the php-common error while updating php so I did the following:

wget -q -O - http://www.atomicorp.com/installers/atomic.sh |sh

yum install php-xml php-pdo

yum install php-pear

mv /etc/php.ini.rpmnew /etc/php.ini

And I DID NOT have to do this, but some might HAVE to do thi:
mv /etc/httpd/conf.d/php.conf.rpmnew /etc/httpd/conf.d/php.conf

PHP was updated fine!

Now I need to update MySQL - time for another few hours of searchign google I guess

 

[corman420]

Don't mind me replying to myself, I'm just hoping this will help someone else someday.

TO update MySQL I simply did this:
yum update mysql

UPDATED!

But now I have an issue with ioncube-loader. It is not loading since the upgrade.

php -v gives me this:
Failed loading /usr/lib/php/php_ioncube_loader_lin_4.3.so: /usr/lib/php/php_ioncube_loader_lin_4.3.so: undefined symbol: zend_hash_add_or_update
PHP 5.2.3 (cli) (built: Aug 27 2007 08:18:18)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies

I went into the /etc/php.d/ioncube_loader_lin_4.3.so file and changed the path. Same result. I tried coping the ioncube_loader_lin_4.3.so from /usr/lib/php4/ to /usr/lib/php/ - still didnt help.

Any advice ?

 

[atomicturtle]

Yep, youve got to update ioncube-loader when you update php. Fortunately that is also in the [atomic] channel, as well as mysql 5.0.48.

Side note for anyone else reading this thread, if you do get php-common errors, I believe it is because the priority of the channel is not set. This is fixed in the atomic-release rpm, or you can just manually add "priority = 1" to each channel definition.

 

[corman420]

How I just type yum update ioncube-loader ? Then I probably have to edit the /etc/php.d/ioncube-loader file? Or should I call it from the php.ini instead?

Thanks

 

[corman420]

To fix the ioncube loader I figured out that the version has tobe the same as the php version.

This is what I did to update my ioncube-loader

wget http://downloads2.ioncube.com/loader_downloads/ioncube_loaders_lin_x86.tar.gz
tar -zxvf ioncube_loaders_lin_x86.tar.gz
cp ioncube/ioncube_loader_lin_5.2.so /usr/lib/php/modules/ioncube_loader_lin_5.2.so

And then I edited my /etc/php.d/ioncube-loader.ini:
zend_extension=/usr/lib/php/modules/ioncube_loader_lin_5.2.so

service httpd restart

DONE

Now php -v should give the following output:

PHP 5.2.3 (cli) (built: Aug 27 2007 08:18:18)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and
with XCache v1.2.1, Copyright (c) 2005-2007, by mOo

 

[atomicturtle]

"yum update" would do it

 

[corman420]

Thanks for your help.

Hopefully somone can learn something from this thread.

 

[breun]

Did you have a special need for PHP 5 and MySQL 5? Because if you don't there is no real need to go through all of this. Just 'yum update' would have made sure you got the latest security patches for the versions you have installed.

 

[corman420]

Im running a Vbulletin community. The performance differences with PHP5 and MySQL5 with the latest VB 3.6.7L2 runs 10 times better with updated.

"yum update" is nto a good diea if you have many third-party apps installed. Much easier to do it one-by-one to make sure none of the third-party apps break.

I've done yum update many times and ended up with an hour of owrk afterwards. I wont do it again on my server.

yum update works great on plesk 8.X+ installations with no other apps installed.

 

[atomicturtle]

Provided you're not doing source installs, its perfectly safe to do it. Ive automated my updates to run nightly.

 

[corman420]

I cant. Everytime I use it, it breaks something.

 

[atomicturtle]

Well if you let me know what 3rd party stuff you're installing, I can look into adding those to my archive. Generally I can fix any conflicts pretty easily, most of the time they just have to do with the version of something like PHP in use.

 

[crobinson]

My Update Was Easy

Man did this my my PHP/MySQL upgrade easy...

=)

 

[crobinson]

Odd Error...

Now after making a fresh install of centos 4.4>install 8.2.1>update everything>install new php from art>I get an error on updating mysql5....


See attachments...

Any help would be welcome!

Thanks

 

[crobinson]

Ok... Fixed...

I removed the following and was able to do yum update mysql

--> Populating transaction set with selected packages. Please wait.
---> Package mysql-bench.x86_64 0:4.1.20-3.RHEL4.1.el4_6.1 set to be erased
---> Package mysqlclient10.i386 0:3.23.58-4.RHEL4.1 set to be erased
---> Package mysql-devel.x86_64 0:4.1.20-3.RHEL4.1.el4_6.1 set to be erased
---> Package unixODBC.i386 0:2.2.11-1.RHEL4.1 set to be erased
---> Package mysql.i386 0:4.1.20-3.RHEL4.1.el4_6.1 set to be erased
--> Running transaction check

Note that I am running CentOS 4.4 x64 so I removed all i386 packages and any extra packages.... Now off to test my Plesk install...

 

[corman420]

Hey guys. Just here to give an update.

I just got a new Plesk 8.3 server. Used "yum update" and it updated EVERYTHING perfectly.

One thing I had to do was go into my /etc/php.d/ directory and edit the ioncube-loader.ini file. After the update, there were two ioncube file in that directory. One was called "ioncube-loader.ini" and the other called "ioncube.ini". I looked in each one to see which one had the latets version number and found that "ioncube.ini" had 5.2, whereas "ioncube-loader.ini" had 4.3. So I simple "vi ioncube-loader.ini" and commented the zend_extention out with #

server httpd restart
php -v

No ioncube errors

Thanks!!!

 

[Superman859]

Thanks for keeping a running tab on what you've been doing and errors you have encountered. I have a virtual dedi with CentOS4 installed and also need to update PHP and mySQL. (Plesk 8.2.1 I believe)

However, I am still pretty inexperienced with such things, even though I've been working with the server lightly over a couple of years. Most of what I do works with it as it is (just some basic PHP scripts and commercial software). I could have gotten away with shared hosting (and did for a bit) except I decided I wanted cronjobs for the commercial software.

Anyways, I intend to upgrade very soon, but am worried about breaking things (plesk, my site, etc).

I'm looking into what errors can arise from upgrading php4 to php5 in general due to changes in PHP. From what you've been doing and posting, it seems like upgrading will not break Plesk at all.

Anyways, how did you start the update process? I read CentOS repositories do not have php5 in them, but those may have been old articles (mentioned using centosplus repositories). I will continue to look into this as I just started, but any advice or tips would be appreciated.

Thanks again for your posts to yourself Even with few answers, the posts will indeed be useful for me as I update.

 

[atomicturtle]

I have PHP 5.2.x and Mysql 5.0.x packages in my archive, and a wiki page about the PHP 4->5 upgrade process here:

http://www.atomicorp.com/wiki/index.php/PHP