All users were logged out of Bugzilla on October 13th, 2018

Command line access to mysql for marketplace-dev.allizom.org

RESOLVED FIXED

Status

RESOLVED FIXED
7 years ago
4 years ago

People

(Reporter: kumar, Assigned: scabral)

Tracking

Details

Looks like the db for this domain got reloaded and I no longer have access. Could I get command line access to this development db with my existing mysql account under user kmcmillan? Same thing as bug 713166. Before I was accessing the db from cm-vpn01.
(Assignee)

Comment 1

7 years ago
kumar, can you give me the IP you're coming from?
(Assignee)

Comment 2

7 years ago
GRANT ALL PRIVILEGES ON `mpl_dev_allizom_org`.* TO 'kmcmillan'@'10.2.72.11'  IDENTIFIED BY PASSWORD 'password hash elided';
Assignee: server-ops-database → scabral
(Assignee)

Comment 3

7 years ago
it's on addons[1-6].stage.db.phx1.mozilla.com

GRANT ALL PRIVILEGES ON `addons_dev_allizom_org`.* TO 'kmcmillan'@'10.2.72.11'   IDENTIFIED BY PASSWORD '*34C58220CAA418FD354AEEC59463704FE3FDF77C';
Status: NEW → ASSIGNED
(Assignee)

Comment 4

7 years ago
I believe we resolved this yesterday....
Status: ASSIGNED → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
After netops opened the flow (bug 744228) I'm coming from a different IP, it looks like.

[kmcmillan@cm-vpn01 ~]$ mysql -u kmcmillan -p -h db-zlb-rw.stage.addons.phx1.mozilla.com addons_dev_allizom_org
Enter password: 
ERROR 1045 (28000): Access denied for user 'kmcmillan'@'10.8.70.202' (using password: YES)
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
(Assignee)

Comment 6

7 years ago
Try now? sorry it took so long, I was at a conference last week.


mysql> GRANT ALL PRIVILEGES ON `addons_dev_allizom_org`.* TO 'kmcmillan'@'10.8.70.202'   IDENTIFIED BY PASSWORD 'password hash elided';
Query OK, 0 rows affected (0.04 sec)

mysql> GRANT ALL PRIVILEGES ON `mpl_dev_allizom_org`.* TO 'kmcmillan'@'10.8.70.202'   IDENTIFIED BY PASSWORD 'password hash elided';
Query OK, 0 rows affected (0.00 sec)
Thanks sheeri! Yep, that did it.
Status: REOPENED → RESOLVED
Last Resolved: 7 years ago7 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.