• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

10.4.4 Upgrade Can't connect to DB via ODBC

Ernie@

Basic Pleskian
PLESK 10.4.4, CENTOS 5.7 X86_64
----------------------------------------
Upgrade to 10.4.4 seems OK. Web servers are running OK.

But, can't not log into the Panel and manage services. After the login screen, it shows database connection errors.

The problem looks like that the SW-CP-Engine can't connect to MySQl via ODBC driver or the configuration was broken. How to troubleshoot this connection? Or which module will recreate or update the connection settings?

I've tried to reinstall psa and sw modules, but doesn't help. And tried /usr/local/psa/bootstrapper/pp10.13.4-bootstrapper/bootstrapper.sh repair, it didn't help.

Error message shown after the Login Screen as below,
--------------------------------------------------------

ERROR: Exception
[unixODBC][MySQL][ODBC 5.1 Driver]Access denied for user 'psaadm'@'localhost' (using password: NO)

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

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
 
The error log file also shows,

2012-02-01 01:16:25: (mod_fastcgi.c.2588) FastCGI-stderr: Exception: [unixODBC][MySQL][ODBC 5.1 Driver]Access denied for user 'psaadm'@'localhost' (using password: NO)
file: /usr/share/aps_php/aps_php.php
line: 8015


Is this something related to the fastcgi?
 
Back
Top