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

Created:

2016-11-16 12:45:31 UTC

Modified:

2017-08-16 16:35:39 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.x for Linux
  • Plesk 12.0 for Linux

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;
Have more questions? Submit a request
Please sign in to leave a comment.