Can't load PLESK Panel, database connection problem

[Ernie@]

CentOS 5.7 Final, MySQL 5.5.20, PLESK 10.4.4

Can't access to the panel, after upgraded to PLESK 10.4.4
After log into the Plesk Panel, no content can be displayed due to error in accessing to the database.

Tried /usr/local/psa/bootstrapper/pp10.13.4-bootstrapper/bootstrapper.sh repair, didn't help.

Does PLESK use ODBC on Linux?

How to fix this problem?



-------- ERROR LOG from sw-cp-server/error_log
2012-01-31 00:08:02: (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-31T00:08:02-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-31 00:08:02: (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}

 

[Cheech]

same issue

Debian Squeeze
Plesk 10.4.4 MU 25
Kernel info: 2.6.32-5-amd64 #1 SMP Sat Mar 31 04:00:05 UTC 2012 x86_64 GNU/Linux

issue: Navigationbar is not working after Kernel Upgrades and restart.
Did a install of the MYSQL Dump befor i did the restart to get PSA working again because some table ar missing and PSA wouldn't start.

Now i have into the Log file:


2012-04-10 11:16:22: (mod_fastcgi.c.2588) FastCGI-stderr: Exception: [MySQL][ODBC 5.1 Driver][mysqld-5.1.61-0+squeeze1-log]Table 'apsc.aps_registry_object' doesn't exist
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 #143, '3e818e25-f936-4...')
#1 /opt/psa/admin/plib/HelpDesk/Config.php(21): APS_Controller_Registry->getPackage('3e818e25-f936-4...')
#2 /opt/psa/admin/plib/NavigationContext.php(351): HelpDesk_Config::getHelpDeskInstances()
#3 /opt/psa/admin/plib/NavigationContext.php(205): NavigationContext->_fetchHelpDeskSectionNodes(Object(UserAdmin))
#4 /opt/psa/admin/plib/NavigationContext.php(70): NavigationContext->fetchCustomButtonsSectionNodes(Object(UserAdmin))
#5 /opt/psa/admin/plib/NavigationContext.php(411): NavigationContext->fetchSection(Object(UserAdmin), 'custom_buttons', Array)
#6 /opt/psa/admin/plib/Navigation.php(557): NavigationContext->get(Object(UserAdmin))
#7 /opt/psa/admin/htdocs/left.php3(4): Navigation->getContextMenu(Object(UserAdmin), Object(Skin))
#8 {main}


I found a possible solution but i don't know if i can use it or if this will fix the issue:

http://kb.parallels.com/en/112733

Regards
Marcus ak Cheech

 

[Cheech]

Hi,

i got a apsc db from afriends server after i droped and create a new db and import his database all mysql are fine now but now i get the following error:

ERROR: Exception
Package with UID '3e818e25-f936-4ce3-aa50-03074b5df225' not found.

Additionally, an exception has occurred while trying to report this error: Exception
Package with UID '3e818e25-f936-4ce3-aa50-03074b5df225' not found.

0: aps_php.php:8015
aps_controller_registry_getpackage(resource, string '3e818e25-f936-4ce3-aa50-03074b5df225')
1: aps_php.php:8015
APS_Controller_Registry->getPackage(string '3e818e25-f936-4ce3-aa50-03074b5df225')
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


He told me his tables are emty so now is my question when his tables are emty why i get now an UID error and where can i correct this / can find my correct UID ?

And please support update this thread.

Thanks in advanced.

Cheech

 

[Cheech]

Hi,

issue is fixed on my system, looks like the tables had an issue and was not success full overwriten as i import the dump.

So i imported the DB from my friend as i posted earlier and then i import the dump again.

Now all is working fine again.

Regards
Cheech

 

[TorstenD]

Hello,

have still the same problem. connection to the Database works with apsc@localhost but in Plesk i lost my Navigation

Using Plesk 11.0.9 and CentOS 5.7 final

i recieved this error after install Ngix

ERROR: Exception
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)

Additionally, an exception has occurred while trying to report this error: Exception
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)

0: aps_php.php:8075
aps_controller_registry_getpackage(resource, string '2f30f91b-cd0d-4f5a-9446-709de3e09683')
1: aps_php.php:8075
APS_Controller_Registry->getPackage(string '2f30f91b-cd0d-4f5a-9446-709de3e09683')
2: Config.php:21
HelpDesk_Config::getHelpDeskInstances()
3: NavigationContext.php:342
NavigationContext->_fetchHelpDeskSectionNodes(object of type UserAdmin)
4: NavigationContext.php:196
NavigationContext->fetchCustomButtonsSectionNodes(object of type UserAdmin)
5: NavigationContext.php:70
NavigationContext->fetchSection(object of type UserAdmin, string 'custom_buttons', array)
6: NavigationContext.php:402
NavigationContext->get(object of type UserAdmin)
7: Navigation.php:557
Navigation->getContextMenu(object of type UserAdmin, object of type Skin)
8: left.php3:4

i try a lot of solutions i found at web, but nothing works....

attached my logfiles

 

[Kirill K]

ERROR: Exception
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)

This issue was fixed. Please install MU#3 using autoinstaller.