1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

10.4.4 Upgrade Can't connect to DB via ODBC

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by Ernie@, Feb 1, 2012.

  1. Ernie@

    Ernie@ Basic Pleskian

    23
    57%
    Joined:
    Aug 27, 2005
    Messages:
    36
    Likes Received:
    0
    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
     
  2. Ernie@

    Ernie@ Basic Pleskian

    23
    57%
    Joined:
    Aug 27, 2005
    Messages:
    36
    Likes Received:
    0
    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?
     
Loading...