747458 - Please, update the hostmask

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task, P1)

Description

[Paula Clemente [:paula]]

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.

Comment 1

[Sheeri Cabral [:sheeri]]

Sorry, just saw this, am doing it now.

Comment 2

[Sheeri Cabral [:sheeri]]

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)

Comment 3

[Paula Clemente [:paula]]

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)

Comment 4

[Sheeri Cabral [:sheeri]]

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?

Comment 5

[Paula Clemente [:paula]]

Yeah, it's working now.

Thanks.