Cannot create new subscriptions: Access denied for user apsc@localhost

Created:

2016-11-16 12:47:57 UTC

Modified:

2017-05-22 08:45:04 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot create new subscriptions: Access denied for user apsc@localhost

Applicable to:

  • Plesk 11.5 for Linux

Symptoms

Cannot create new subscriptions:

Error code “Internal error: ODBC error #HY000: [unixODBC][MySQL][ODBC 5.1 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)”.

Cause

Database inconsistency: user apsc specified in psa.misc table did not exist on the server.

Resolution

  1. Check APSC database user name:

    mysql> select User,Host from mysql.user where User like 'aps%';
    +-----------+-----------+

    | User | Host |
    +-----------+-----------+

    | apsc_tgbn | localhost |
    +-----------+-----------+
    1 row in set (0.00 sec)
  2. Check APSC database settings in psa.misc table:

    # mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e "select * from misc where param like 'aps%'"
    +----------------------+----------------------------------------------------------------+

    | param | val |
    +----------------------+----------------------------------------------------------------+

    | aps_database | apsc |
    | aps_host | localhost |
    | aps_login | apsc | <-
    | aps_password | $AES-128-***************************************************== |
    | aps_port | 3306 |
    | aps_secure_passwords | true |
    +----------------------+----------------------------------------------------------------+
  3. Back up Plesk psa.misc table:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa misc > /root/tbl_psa.misc_bkp.sql
  4. Update psa.misc table with proper values:

    mysql> update misc set val='apsc_tgbn' where param='aps_login';
    mysql> update misc set val='apsc_u8b0' where param='aps_database';
Have more questions? Submit a request
Please sign in to leave a comment.