search

vmware-archive / terraforming-gcp

use terraform, deploy yourself a pcf
Apache License 2.0
71 stars 87 forks source link

PAS pas_sql_username & pas_sql_password do not work with PAS Tile #127

Open JaysonBH opened 5 years ago

JaysonBH commented 5 years ago

Opsmanager gives this error below when using the terraform output of pas_sql_username & pas_sql_password :

 Please review the errors below
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
Database verification error: Access denied for user 'USER'@'34.73.77.191' (using password: YES), type: MysqlDatabaseVerifier
All errors will be reverified before installation.

Error when connecting manually connecting from the Opsmanager VM with the mysql cli:

$ mysql -u KE4******** -h 35.237.XYZ.XYZ -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'KE4********'@'34.73.77.191' (using password: YES)

[ Yes, for some reason CloudSQL shows an unidentified IP address in the error output. In this case, its the random 34.73.77.191 showing ]

From what I can tell, it seems that the root issue is that it has a host restriction.