too problem with Aspc user on plesk and all of the plesk solutions not work!!!

[rout3rx]

Hi
I'm So unhappy with plesk .
this problem causes suddenly:
ERROR: Exception
[unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'127.0.0.1' (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'@'127.0.0.1' (using password: YES)

0: aps_php.php:8075
aps_controller_registry_getpackage(resource, string '707b998a-53ec-481c-96a8-dab2859c9bbf')
1: aps_php.php:8075
APS_Controller_Registry->getPackage(string '707b998a-53ec-481c-96a8-dab2859c9bbf')
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




after install MU#3 and rerun bootstrapper no problem fixed.
around other solutions : yum update mysqlclient15 have conflict with mysql!

what can i do?
plesk should work for customers better than this.

 

[IgorG]

Try to fix it in psa database with following SQL query:

mysql> update misc set val="localhost" where param="aps_host";

 

[IgorG]

Also you can synchronize password for user apsc in mysql.user as well as in psa.misc table

1. Execute the following query in mysql prompt

mysql>update misc set val='<any_password>' where param='aps_password' and val="The value currently on mysql.misc.aps_password val";

2. Update the password in mysql.user table.

mysql>update mysql.user set password=Password('<same password updated in step1 above>') where user='apsc';

mysql> flush privileges;

3. Restart psa using the command: "/etc/init.d/psa restart"

 

[rout3rx]

thanks, this is so useful .