Upgrade to Plesk 10.4 ERROR

[JulienR]

Hello Everyone,

I recently upgraded plesk to 10.4 and got a series of errors once I logged in.

I've tried many solutions on forums and even boostrap repair, nothing works. HELP
Bootstrap says:
===> Installing phpMyAdmin
Trying to create pmadb... done
done
===> Installing /usr/sbin/suexec replacement
Trying to backup original /usr/sbin/suexec... done
`/usr/local/psa/suexec/psa-suexec' -> `/usr/sbin/suexec'
Trying to set up APS controller database... Attempting to check APS db connection via ODBC, usin g /usr/bin/isql (empty output is good)
/usr/bin/isql: relocation error: /usr/lib/libmyodbc3.so: symbol strmov, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference
Failed, rc = 127.
Failed to establish test connection. Cleaning up.

ERROR while trying to establish test connection to APS database via ODBC
Check the error reason(see log file: /tmp/plesk_10.4.4_installation.log), fix and try again

***** problem report *****
ERROR while trying to establish test connection to APS database via ODBC
Check the error reason(see log file: /tmp/plesk_10.4.4_installation.log), fix and try again



ERROR ON PLESK, AFTER LOGIN:

ERROR: Zend_Db_Table_Row_Exception
Specified column "registryUid" is not in the row
0: Abstract.php:179
Zend_Db_Table_Row_Abstract->__get(string 'registryUid')
1: Row.php:89
Db_Table_Row->__get(string 'registryUid')
2: Config.php:19
HelpDesk_Config::getHelpDeskInstances()
3: NavigationContext.php:351
NavigationContext->_fetchHelpDeskSectionNodes(object of type UserAdmin)
4: NavigationContext.php:205
NavigationContext->fetchCustomButtonsSectionNodes(object of type UserAdmin)
5: NavigationContext.php:70
NavigationContext->fetchSection(object of type UserAdmin, string 'custom_buttons', array)
6: NavigationContext.php:411
NavigationContext->get(object of type UserAdmin)
7: Navigation.php:95
Navigation->getUserContextList(object of type UserAdmin)
8: Navigation.php:113
Navigation->getRoot(object of type UserAdmin)
9: Navigation.php:357
Navigation->buildPathbar(string '/license.php3', NULL null, object of type UserAdmin, string 'dashboard')
10: Navigation.php:348
Navigation->getPathbar(NULL null)
11: Navigation.php:144
Navigation->detectCurrentUpLevelURI()
12: Abstract.php:301
Form_Abstract->_getUpLevelLink()
13: Abstract.php:310
Form_Abstract->renderPathbarButton(object of type Navigation, NULL null)
14: Form.php:109
Form->assign()
15: license.php3:70

 

[JulienR]

Issue resolved

If any of you have the same problem follow MikeyT's steps however change a couple things:
http://forum.parallels.com/showthread.php?t=258266


Here is the list below and good luck to you:
1. Find out existing php rpm packages.
# rpm -qa|grep php

2. Delete all php rpm packages
I left all the psa packages but manually removed all the others one by one using command below (the no dependency and all matches flags stop error messages). I had to delete about 11 php packages and 5 mysql packages.
# rpm -e --nodeps --allmatches php-5.3.10-5.el5.art

3. Do the same for mysql packages
# rpm -qa|grep mysql

4. Remove any additional yum repositories
# cd /etc/yum.repos.d/
# ls

atomic.repo CentOS-Base.repo.rpmnew CentOS-Media.repo
CentOS-Base.repo CentOS-Debuginfo.repo CentOS-Vault.repo
You should only have the CentOs repositories listed - rename the atomic.repo so it doesn't get used by yum

/*******************************************
STEP TO CHANGE IN CASE YOU CANNOT UPDATE mysqlclient15:
# mv atomic.repo atomic.repo.old

In order to have bootstrap work you will need to update your mysqlclient 2.el5.art, if it is not up to date:
Check for mysqlclient version:
# rpm -q --queryformat '%{RELEASE}\n' mysqlclient15

if you get anything else than 2.el5.art, update it:
# yum update mysqlclient15

I also found Plesk shutting down on me everytime bootstrap failed to run so you will need to restart it:
# /etc/ini.d/psa restart

Another thing that can happen is drweb failing to launch with this process, all you need to do is start it manually:
# etc/init.d/drweb restart

/*******************************************
Good luck with the rest, MikeT is awesome and explains well.
/*******************************************

5. Clean yum

Clean yum to remove any cached packages

# yum clean all

6. Reinstall mysql

Use the following command to reinstall the mysql group (includes server, client etc.)

# yum groupinstall "MySQL Database"

7. Start mysql and check connection

Restart mysql (it may not have been started)

# /etc/init.d/mysqld restart

Check connection

mysql -h 127.0.0.1 -P 3306 -uadmin -p`cat /etc/psa/.psa.shadow`

At one point in the failed upgrade, Plesk deleted the stored password. If you can't connect and you get an access denied error message then try this kb http://kb.parallels.com/112492.

8. Reinstall php

Use the following yum command

# yum install php

9. Restart mysql and apache

Just to make sure, I then restarted mysql and apache

# /etc/init.d/mysqld restart
# /etc/init.d/httpd restart

10. Rerun the Plesk repair install

Use the bootstrapper command to re-run the plesk install

# /usr/local/psa/bootstrapper/pp10.13.4-bootstrapper/bootstrapper.sh repair

The name of the subfolder 'pp10.13.4-bootstrapper' depends on the version of plesk you are upgrading to. This should now run without errors - be patient it might take a few moments to complete.

11. Check Plesk is working

Login to the control panel and make sure you can access everything

12. Check hosted sites

My static sites were now up and running but my Joomla sites were showing an MySQL adapter connection error. The server at this point really does only have the very basic php and mysql packages.

13. Install additional packages

The main one I needed to get Joomla up and running was php-mysql. Run yum to install:

# yum install php-mysql

14. Update PHP

I did run into a few problems on newer Joomla sites as Joomla 2.5 requires at least 5.2.4 and yum installs 5.1. Having got everything running I then removed php using steps 1 and 2 above and re-installed a newer version of php using:

# yum install php53
# yum install php53-mysql

 

[RomeoS]

Dear Julien,

Your instructions saved my day when upgrading to 11.09!

THANK YOU!

Btw, I upgraded to PHP 5.3 by running the Plesk Autoinstaller again and selecting PHP 5.3, there you have the option to install Apache with SNI support (to run multiple SSL Certs with a single IP address).

Kind regards,
RS

 

[MiguelG]

I'm trying to follow your instructions but mysqlclient15 fails to update. When i run 'yum update mysqlclient15' i get 'No Packages marked for Update' I've checked my current version using rpm -q --queryformat '%{RELEASE}\n' mysqlclient15 and it return 1.el5.art So i don't know why this doesn't works. Can you help me?