Page MenuHomePhabricator

Tool massmailer cannot connect to tools.db.svc.eqiad.wmflabs (access denied)
Closed, ResolvedPublic

Description

Hello,

my tool massmailer cannot connect to tools.db.svc.eqiad.wmflabs, see following output. Connecting to database replicas works as it should. For other tools operated by myself this works correctly and as it should.

Thanks in advance for fixing,
Martin Urbanec
(Urbanecm)

tools.massmailer@tools-bastion-02 ~/src
$ sql local
ERROR 1045 (28000): Access denied for user 's53687'@'10.68.16.44' (using password: YES)
tools.massmailer@tools-bastion-02 ~/src
$ sql -v local
Connecting to tools.db.svc.eqiad.wmflabs
ERROR 1045 (28000): Access denied for user 's53687'@'10.68.16.44' (using password: YES)
tools.massmailer@tools-bastion-02 ~/src
$ mysql -h tools-db
ERROR 1045 (28000): Access denied for user 's53687'@'10.68.16.44' (using password: YES)
tools.massmailer@tools-bastion-02 ~/src
$ sql enwiki
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 139221481
Server version: 10.1.30-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [enwiki_p]> select page_id, page_title from page limit 10;
+----------+------------------------------+
| page_id  | page_title                   |
+----------+------------------------------+
|  5878274 | !                            |
|  3632887 | !!                           |
|   600744 | !!!                          |
| 34443176 | !!!Fuck_You!!!               |
| 11011780 | !!!Fuck_You!!!_And_Then_Some |
| 34443184 | !!!Fuck_You!!!_and_Then_Some |
| 39401265 | !!!_(Chk_Chk_Chk)            |
|  2556962 | !!!_(album)                  |
| 10065458 | !!!_(band)                   |
| 55029148 | !!!_(disambiguation)         |
+----------+------------------------------+
10 rows in set (0.00 sec)

MariaDB [enwiki_p]> Bye
tools.massmailer@tools-bastion-02 ~/src
$

Event Timeline

Urbanecm created this task.Mar 10 2018, 7:58 PM
Restricted Application added a project: User-Urbanecm. · View Herald TranscriptMar 10 2018, 7:58 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Urbanecm added a subscriber: bd808.Mar 10 2018, 7:59 PM

@bd808 Similar to T183644 you solved before.

Urbanecm triaged this task as High priority.Mar 10 2018, 7:59 PM
Urbanecm updated the task description. (Show Details)
bd808 claimed this task.Mar 10 2018, 11:35 PM

Fixed by removing old credentials for the u3280 and u2119 users from labsdb1005.eqiad.wmnet and allowing maintain-dbusers to complete processing all pending accounts.

bd808 closed this task as Resolved.Mar 10 2018, 11:39 PM
tools.massmailer@tools-bastion-02 ~
$ sql local
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 141169613
Server version: 10.0.33-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>