Help Plesk Barfed a Hair ball after trying to upgrade php

[Mad Dawg]

Hello All definately would appreciate any advice here

I have a VPS with lunar pages
centos 4.2 and recent upgrade to plesk 9 php 4.3.9(i think )
anyways a couple of my joomla sites needed php 5 to
be able to upgrade
lunar pages provided me these instructions which I followed

@@@@@@@@
Here is some info on the process of installing php5 and mysql5. Please make sure you have yum installed

rpm -ivh http://www.atomicorp.com/channels/atomi ... noarch.rpm
rpm --nodeps -e php-domxml
yum update php*
yum update mysql*
yum install php-xml

Run php -v to verify the new version. If there are a lot of errors related to not being able to load modules, do this:
mv /etc/php.ini /etc/php.ini.bak
mv /etc/php.ini.rpmnew /etc/php.ini

Verify that the errors are cleared.

Restart Apache.


Ensure that the customer is warned to not run yum update on the machine as this may break things. If you wish to be sure that nothing is done like this, do the following:

rpm -e atomic-release
rpm -e `rpm -aq | grep yum`

The atomic repository info is from the Plesk forums, and has packages designed specially to work with Plesk.
@@@@@@@@@@@

I followed these instructions and everything seemed to go fine until
I got to the php -v step

I can not get rid of the errors (shown below )

[root@vps ~]# php -v
PHP: Error parsing /etc/php.ini on line 213
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/dbase.so' - /usr/lib/php4/dbase.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/dom.so' - /usr/lib/php4/dom.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/json.so' - /usr/lib/php4/json.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/xmlreader.so' - /usr/lib/php4/xmlreader.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/xmlwriter.so' - /usr/lib/php4/xmlwriter.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/xsl.so' - /usr/lib/php4/xsl.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/zip.so' - /usr/lib/php4/zip.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP 4.3.9 (cgi) (built: Sep 27 2006 20:40:56)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with the ionCube PHP Loader v3.1.16, Copyright (c) 2002-2006, by ionCube Ltd.
[root@vps ~]#


On the surface the server appears to be runing fine
its just the plesk interface that is messed up
in the control panel (wont load ) I can only use Virtuozzo
clicking on server link in plesk shows

Service is not available now, probably your Plesk is misconfigured.
Contact Your provider for details.

Internal Plesk error occurred: bad column in table: `backup_time` time NOT NULL default '00:00:00',


Any Help would be greatly appreciated

Edit
I thought I better add this Im sure its probably fairly clear I am no linux guru
anyways
As I needed to install yum first and they did not provide instructions for this
I did some googling and did find some instructions (cant find em now of course)

Anyways the instructions I found refered to an atomic sh script of sometype when it ran
I noticed that the rpm listed was not a 1.09 as in their instructions it was a 1.10 I believe
it all happed very quickly but I though it was just an updated version
anyway I dont know if its related but i thought I should add that in here

Thanx

[scott]

Thats why I built in the yum installation routine to the atomic installer. To fix VPS's in a state like yours

[Mad Dawg]

Hi Scott

Thanks ..although I still have no idea if or how
I can recover from this situation any
assistance or instruction would be most appreciated

[hostingguy]

did you get any updated packages for php? When you run php -v it still says your running 4.3.9 and not 5.2.9

[Mad Dawg]

Ah Thank you
I never noticed that I was too preccupied with plesk being messedup
after running yum update php again I get this

[root@vps ~]# yum update php*
Setting up Update Process
Setting up repositories
http://www4.atomicorp.com/channels/ples ... repomd.xml: [Errno 14] HTTP Error 404: Not Found
Trying other mirror.
plesk 100% |=========================| 951 B 00:00
update 100% |=========================| 951 B 00:00
base 100% |=========================| 1.1 kB 00:00
atomic 100% |=========================| 951 B 00:00
addons 100% |=========================| 951 B 00:00
extras 100% |=========================| 1.1 kB 00:00
Reading repository metadata in from local files
Excluding Packages from Plesk Server Administrator
Finished
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package php-ldap.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-mysql.i386 0:5.2.9-2.el4.art set to be updated
---> Package phpMyAdmin.noarch 0:2.11.9-1.el4.art set to be updated
---> Package php-xmlrpc.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-ioncube-loader.i386 1:3.1-7.el4.art set to be updated
---> Package php-snmp.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-ncurses.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-gd.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-devel.i386 0:5.2.9-2.el4.art set to be updated
---> Package php.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-pgsql.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-imap.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-odbc.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-mbstring.i386 0:5.2.9-2.el4.art set to be updated
---> Package php-pear.noarch 1:1.7.2-2.el4.art set to be updated
--> Running transaction check
--> Processing Dependency: php-cli >= 5.1.0-1 for package: php-pear
--> Processing Dependency: libt1.so.5 for package: php-gd
--> Processing Dependency: php-pdo for package: php-odbc
--> Processing Dependency: php-pdo for package: php-mysql
--> Processing Dependency: php-pdo for package: php-pgsql
--> Processing Dependency: /usr/bin/php for package: psa-horde
--> Processing Dependency: php <= 4.4.0 for package: php-sqlite2
--> Processing Dependency: php-cli = 5.2.9-2.el4.art for package: php
--> Processing Dependency: automake for package: php-devel
--> Processing Dependency: autoconf for package: php-devel
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package automake.noarch 0:1.9.2-3 set to be updated
---> Package autoconf.noarch 0:2.59-5 set to be updated
---> Package php-pdo.i386 0:5.2.9-2.el4.art set to be updated
---> Package t1lib.i386 0:5.1.2-2.el4.art set to be updated
---> Package php-cli.i386 0:5.2.9-2.el4.art set to be updated
--> Running transaction check
--> Processing Dependency: php <= 4.4.0 for package: php-sqlite2
--> Finished Dependency Resolution
Error: Missing Dependency: php <= 4.4.0 is needed by package php-sqlite2
[root@vps ~]#

So it would appear that it cannot locate some files it needs
how might I steer it in the right direction

[hostingguy]

rpm -e php-sqlite2 --nodeps
yum update php
yum install php-sqlite2

[Mad Dawg]

Thank You so much for your assistance hostingguy
I greatly appreciate your patience and understanding
( I wish I had left the thing as it was... damn ecommerce sites needing PHP 5 lol)

Your instructions allowed it to update php now and a php -v shows only one error
using the instructions I was given by the host to fix that

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

doesnt seem to work either

php -v
PHP: Error parsing /etc/php.ini on line 213
Failed loading /usr/lib/php4/php_ioncube_loader_lin_4.3.so: /usr/lib/php4/php_i oncube_loader_lin_4.3.so: undefined symbol: zend_hash_add_or_update
PHP 5.2.9 (cli) (built: Mar 10 2009 16:30:52)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies


Virtuozzo still is the only thing I can use in the web login interface
clicking anything else displays this:

Service is not available now, probably your Plesk is misconfigured.
Contact Your provider for details.

Internal Plesk error occurred: bad column in table: `backup_time` time NOT NULL default '00:00:00',


I think we are getting closer

[Mad Dawg]

I did some more googling and found this http://forum.parallels.com/showthread.php?t=85461
the relevant instructions are below


# mysqlcheck --check-upgrade --all-databases --auto-repair -uadmin -pyouradminpassword

then issue this command:

# mysql_fix_privilege_tables

I got error because of the mysql connection needs the admin user username and password since this is the database user used by plesk, so I issued this command manually:

# cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=admin --password=youradminpassword --host=localhost --database=mysql



This fixed plesks interface
So the only issue now is the one ion cube loader error
I reinstalled it using yum but still end up with this
php -v
PHP: Error parsing /etc/php.ini on line 213
Failed loading /usr/lib/php4/php_ioncube_loader_lin_4.3.so: /usr/lib/php4/php_i oncube_loader_lin_4.3.so: cannot open shared object file: No such file or direct ory
PHP 5.2.9 (cli) (built: Mar 10 2009 16:30:52)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies
with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd

Any ideas

[scott]

Yup, check the wiki page:

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

[hostingguy]

Try doing yum update php-zend-optimizer php-eaccelerator (not sure if spelled them right)

Then you may need to go and edit the /etc/php.d/zend.ini file to update the version number fo 5.2 instead of 4.3

[scott]

the rpm should do that automatically

[hostingguy]

should, but if it doesnt its nice to know what to do