I need to be able to remotely access the mysql database on the aformentioned server in an automated way. The IP for hulmer-sandbox.stage.metrics.scl3.mozilla.com is 10.22.31.222. Please let me know if you need anything else.
Well, it looks like there's already an open firewall entry: [email@example.com ~]$ nc -vz sumotools1.webapp.phx1.mozilla.com 3306 Connection to sumotools1.webapp.phx1.mozilla.com 3306 port [tcp/mysql] succeeded! So all I have to do is open up the right ACL. What user are you logging in as? (just the username)
Granted privileges for the hulmer user from 10.22.31.222. Let me know if this works for you!
Status: NEW → ASSIGNED
please re-open if things aren't working.
Status: ASSIGNED → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
Works - thanks!
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.