ERROR while trying to store APS controller db connection parameters into product db

Symptoms

Plesk installation is failed with error in plesk installation log:

----------------------------
END OF INNODB MONITOR OUTPUT
============================

Attempting to check APS db connection via ODBC, using /usr/bin/iusql (empty output is good)

ERROR while trying to store APS controller db connection parameters into product db   < ======= (!)
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again

I tried the solution described in /213382169 but it did not help.

Cause

By some unknown reason Plesk was not able to add aps_* values into psa.misc table.

Resolution

It is possible to add connection details manually:

# mysql -uadmin -p` cat /etc/psa/.psa.shadow ` psa

INSERT INTO `misc` VALUES ('aps_database','apsc'),('aps_host','localhost'),('aps_login','apsc'),('aps_password','my_secret_password'),('aps_port','3306'),('aps_secure_passwords','true');

UPDATE misc SET val = 'false' WHERE param = 'secure_passwords'

UPDATE misc SET val='my_secret_password' WHERE param = 'aps_password';

grant all privileges on apsc.* to 'apsc'@'localhost' identified by 'my_secret_password';
flush privileges;