PLESK 10.4.4 Cannot load library libmysqlserver.so.2

[Ernie@]

Upgraded to Plesk 10.4.4 finally. However, when log into the Panel, it doesn't show the menu items. There's an error for the application to connect to the database, there's no problem for virtual hosting and re-generate web configuration ect via command line. I've reinstalled mySQL, it's still the same. How can I fix this problem?


It happends to the web Panel only, the error says,

Internal error: Cannot load library: /usr/lib64/libmysqlserver.so.2

---
Message Cannot load library: /usr/lib64/libmysqlserver.so.2
File aps_php.php
Line 8015
Type Exception

---

ERROR: Exception
Cannot load library: /usr/lib64/libmysqlserver.so.2

Additionally, an exception has occurred while trying to report this error: Exception
Cannot load library: /usr/lib64/libmysqlserver.so.2

0: aps_php.php:8015
aps_controller_registry_getpackage(resource, string '0')
1: aps_php.php:8015
APS_Controller_Registry->getPackage(string '0')
2: Config.php:21
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:557
Navigation->getContextMenu(object of type UserAdmin, object of type Skin)
8: left.php3:4
----

 

[IgorG]

I have checked and foun that /usr/lib64/libmysqlserver.so.2 file is a part of rdbmspp package on CentOS 6.1, for example:

# rpm -qf /usr/lib64/libmysqlserver.so.2
rdbmspp-2.0-650086.11082613.x86_64

# cat /etc/redhat-release
CentOS release 6.1 (Final)

Do you have installed this package on your server?

 

[Ernie@]

It's CentOS 5.7.

Thanks.

 

[IgorG]

For CentOS5x64 - http://64.131.90.31/PSA_10.4.4/dist...ontrib/rdbmspp-2.0-650086.11082614.x86_64.rpm

 

[Ernie@]

Hi IgorG,

I've reinstalled the RDBMSPP package. Then, it says psaadmin@localhost can not connect to the database. So, after a few research, I created the psaadmin without empty password. The error now shows, No database selected.


[MySQL][ODBC 3.51 Driver][mysqld-5.5.20]No database selected[MySQL][ODBC 3.51 Driver][mysqld-5.5.20]No database selected

File
aps_php.php

Line
8015

Having read some other similar thread, I've applied
/usr/local/psa/bootstrapper/pp10.13.4-bootstrapper/bootstrapper.sh repair

the same problem persists.

How should I fix this?

Thanks.

Ernie


Type

Exception

 

[Ernie@]

Referring to http://forum.parallels.com/showthread.php?t=111989&highlight=aps_php.php,

I got following errors in the installation log,

-----
Trying to set up APS controller database... ERROR 1007 (HY000) at line 1: Can't create database 'apsc'; database exists
-----

However, there's no records in the APSC database tables. All zero records in tables.

Also, I got a few apsc_xxxx databases, can I drop them?


Can I run the following command to fix the problem? (http://forum.parallels.com/showthread.php?t=111989&highlight=aps_php.php,)

sw_engine_pleskrun $PRODUCT_ROOT_D/admin/plib/scripts/aps-controller-data-import.php

 

[Ernie@]

More error message from sw-cp-server/error_log

1. Doe PLESK 10.4.4 use ODBC on Linux?
2. I'vd created psadmin user manually in the database and leave blank password, then this ODBC error happens


-----------------------------
2012-01-30 13:55:35: (connections.c.299) SSL: 1 error:140940E5:SSL routines:SSL3_READ_BYTES:ssl handshake failure
2012-01-30 13:55:39: (mod_fastcgi.c.2588) FastCGI-stderr: Exception: [MySQL][ODBC 3.51 Driver][mysqld-5.5.20]No database selected[MySQL][ODBC 3.51 Driver][mysqld-5.5.20]No database selected
file: /usr/share/aps_php/aps_php.php
line: 8015
code: 0
trace: #0 /usr/share/aps_php/aps_php.php(8015): aps_controller_registry_getpackage(Resource id #145, '0')
#1 /usr/local/psa/admin/plib/HelpDesk/Config.php(21): APS_Controller_Registry->getPackage('0')
#2 /usr/local/psa/admin/plib/NavigationContext.php(351): HelpDesk_Config::getHelpDeskInstances()
#3 /usr/local/psa/admin/plib/NavigationContext.php(205): NavigationContext->_fetchHelpDeskSectionNodes(Object(UserAdmin))
#4 /usr/local/psa/admin/plib/NavigationContext.php(70): NavigationContext->fetchCustomButtonsSectionNodes(Object(UserAdmin))
#5 /usr/local/psa/admin/plib/NavigationContext.php(411): NavigationContext->fetchSection(Object(UserAdmin), 'custom_buttons', Array)
#6 /usr/local/psa/admin/plib/Navigation.php(557): NavigationContext->get(Object(UserAdmin))
#7 /usr/local/psa/admin/htdocs/left.php3(4): Navigation->getContextMenu(Object(UserAdmin), Object(Skin))
#8 {main}


2012-01-30T13:55:39-08:00 CRIT (2): Exception: [MySQL][ODBC 3.51 Driver][mysqld-5.5.20]No database selected[MySQL][ODBC 3.51 Driver][mysqld-5.5.20]No database selected
file: /usr/share/aps_php/aps_php.php
line: 8015
code: 0
2012-01-30 13:55:39: (mod_fastcgi.c.2588) FastCGI-stderr: Exception: [MySQL][ODBC 3.51 Driver][mysqld-5.5.20]No database selected[MySQL][ODBC 3.51 Driver][mysqld-5.5.20]No database selected
file: /usr/share/aps_php/aps_php.php
line: 8015
code: 0
trace: #0 /usr/share/aps_php/aps_php.php(8015): aps_controller_registry_getpackage(Resource id #266, '0')
#1 /usr/local/psa/admin/plib/HelpDesk/Config.php(21): APS_Controller_Registry->getPackage('0')
#2 /usr/local/psa/admin/plib/Promo/HelpDesk.php(18): HelpDesk_Config::getHelpDeskInstances()
#3 /usr/local/psa/admin/plib/Promo/Abstract.php(22): Promo_HelpDesk->isActive()
#4 /usr/local/psa/admin/panel/application/controllers/HomeController.php(69): Promo_Abstract::getPromosList()
#5 /usr/local/psa/admin/panel/application/controllers/HomeController.php(39): HomeController->_preparePromos()
#6 /usr/local/psa/admin/plib/Zend/Controller/Action.php(513): HomeController->adminAction()
#7 /usr/local/psa/admin/plib/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('adminAction')
#8 /usr/local/psa/admin/plib/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#9 /usr/local/psa/admin/panel/application/library/AdminPanel/Application/Web.php(20): Zend_Controller_Front->dispatch()
#10 /usr/local/psa/admin/panel/application/public/index.php(15): AdminPanel_Application_Web->run()
#11 {main}