• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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