Could not create customer: "Access denied for user 'apsc'@'localhost'"

[sajugovind]

I cannot create a new customer. The operation fails with the error below:

Code: [Select]

Internal error:
ODBC error #HY000: [MySQL][ODBC 3.51 Driver]Access denied for user 'apsc'@'localhost' (using password: YES)
You can see a similar error on subscription creation:

Code: [Select]

Internal error: ODBC error #HY000: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)ODBC error #HY000: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)ODBC error #HY000:
File aps_php.php 
Line 11933
Type Exception
Reason for the error is  Parallels Plesk Panel (Plesk) upgrade was completed with errors. Integration with the apsc database was not properly completed.

Now the solution:

Verify that information about the apsc database exists in Plesk:

NOTE: To perform the steps below for Windows, log in to the psa database first and then use the queries from the examples.

Code: [Select]

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

+----------------------+-----------+
| param                | val       |
+----------------------+-----------+
| aps_database         | apsc      |
| aps_host             | 127.0.0.1 |
| aps_login            | admin     |
| aps_password         | $AES-128-***   |
| aps_port             | 8306      |
| aps_secure_passwords | false     |
+----------------------+-----------+
6 rows in set (0.00 sec)
NOTE: If aps_password starts from '$AES-128..', then it is encrypted and you should proceed to step 2. If it is in plain format, you can skip to step 3.

If you do not have apsc-related paramaters, you can add them manually:

Code: [Select]

INSERT INTO `misc` VALUES ('aps_database','apsc'),('aps_host','127.0.0.1'),('aps_login','apsc'),('aps_password','my_secret_password'),('aps_port','8306'),('aps_secure_passwords','false');
NOTE: Specify port 8306 for Windows and 3306 for Linux.

It is not possible to decrypt the apsc user password. However, you can take the original password from the psa database backups created before the upgrade to the new Plesk version.

By default, backups are located in the /var/lib/psa/dumps directory. Open the psa backup and find a line like the one below:

Code: [Select]

('aps_password','<non_encrypted_passwd>'),('aps_port','8306')
(where <non_encrypted_passwd> is the password you need to set)

Set the proper privileges for the MySQL database:

Code: [Select]

# mysql -uadmin -p`cat /etc/psa/.psa.shadow ` mysql -e "grant all privileges on apsc.* to 'apsc'@'localhost' identified by '<non_encrypted_passwd>'"
Thank you,