We moved our machines to SCL3 and we need you to update the hostmask for the user 'personas', on the database 'personas'. We need access from the machines: etl[3|4].metrics.scl3.mozilla.com app[1|2].metrics.scl3.mozilla.com Here is the log: Connected to tm-sfx01-master01.mozilla.org (10.2.70.147). Escape character is '^]'. Host '10.22.27.13' is not allowed to connect to this MySQL server Connection closed by foreign host. Thanks.
Sorry, just saw this, am doing it now.
I have given the same grants to: personas@'10.22.27.1_' personas@'10.22.27.2_' which covers app1, app2, etl3, etl4. Please confirm and resolve this bug if it works for you. If not, please ping me on IRC (if nowhere else, I'm in #db...."sheeri" is my nick unless I'm afk)
Something is not right yet.. I got this error: ERROR 20-04 13:53:11,974 - Table input personas - An error occurred, processing will be stopped: Error occured while trying to connect to the database Unable to pre-load connection to the connection pool Access denied for user 'personas'@'10.22.27.23' (using password: YES)
Try again? There seem to be 2 different passwords in use for the "personas" user, so I changed the password to the other password hash. LEt me know if it works now?
Yeah, it's working now. Thanks.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.