Please, update the hostmask

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
P1
major
RESOLVED FIXED
6 years ago
3 years ago

People

(Reporter: paula, Unassigned)

Tracking

Details

(Reporter)

Description

6 years ago
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.
(Reporter)

Updated

6 years ago
Priority: -- → P1
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)
(Reporter)

Comment 3

6 years ago
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?
(Reporter)

Comment 5

6 years ago
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.