Skip to content
This repository has been archived by the owner on Sep 16, 2020. It is now read-only.

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

Open
JaysonBH opened this issue Mar 27, 2019 · 0 comments
Open

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

JaysonBH opened this issue Mar 27, 2019 · 0 comments

Comments

@JaysonBH
Copy link
Contributor

JaysonBH commented Mar 27, 2019

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants