Page MenuHomePhabricator

Adoption of tb-dev Red Link Recovery tools
Open, Needs TriagePublic

Description

Hi, I'm looking to adopt tools for WikiProject Red Link Recovery. The tools have been down for months. Top Banana has been busy in real life, taking months to incorporate my patches/suggestions. I contacted him last month to add me as a maintainer, but he hasn't edited since August.

Related Objects

Event Timeline

Dispenser created this task.Nov 2 2017, 5:44 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 2 2017, 5:44 PM

Mentioned in SAL (#wikimedia-cloud) [2017-11-02T20:22:46Z] <bd808> Added Zhuyifei1999 as maintainer to investigate T179599

The directory /data/project/tb-dev/credentials contains one regular file, s51111, which is exactly the same (binary-wise) as /data/project/tb-dev/replica.my.cnf. Since the latter is immutable, I don't find it necessary to delete that file.

The database backup files in /data/project/tb-dev/db_backup/20171029/ are world readable:

tools.tb-dev@tools-bastion-02:~$ ls -al db_backup/20171029/
total 46000
drwxr-sr-x  2 tools.tb-dev tools.tb-dev     4096 Oct 29 06:08 .
drwxrwsr-x 45 tools.tb-dev tools.tb-dev     4096 Oct 29 06:08 ..
-rw-r--r--  1 tools.tb-dev tools.tb-dev 44792070 Oct 29 06:08 s51111__common_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev   285213 Oct 29 06:08 s51111__inconsistent_redirects_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev    21421 Oct 29 06:08 s51111__oddlinks_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev    67833 Oct 29 06:08 s51111__rlrl_cawiki_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev  1734722 Oct 29 06:08 s51111__rlrl_enwiki_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev   112596 Oct 29 06:08 s51111__rlrl_frwiki_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev    30540 Oct 29 06:08 s51111__rlrl_lvwiki_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev     1820 Oct 29 06:08 s51111__rlrl_ptwiki_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev    16578 Oct 29 06:08 s51111__unlikely_enwiki_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev     3335 Oct 29 06:08 s51111__unlikely_lvwiki_p.20171029.gz
-rw-r--r--  1 tools.tb-dev tools.tb-dev     3170 Oct 29 06:08 s51111__unlikely_ptwiki_p.20171029.gz

Tool-owned databases on the replicas are all _p-s:

tools.tb-dev@tools-bastion-02:~$ mysql -h c1.labsdb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 18264
Server version: 10.0.22-MariaDB MariaDB Server

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

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

MariaDB [(none)]> SHOW databases LIKE 's51111%';
+----------------------------------+
| Database (s51111%)               |
+----------------------------------+
| s51111__common_p                 |
| s51111__inconsistent_redirects_p |
| s51111__oddlinks_p               |
| s51111__rlrl_enwiki_p            |
| s51111__rlrl_ptwiki_p            |
| s51111__unlikely_enwiki_p        |
| s51111__unlikely_ptwiki_p        |
+----------------------------------+
7 rows in set (0.01 sec)

MariaDB [(none)]> Bye
tools.tb-dev@tools-bastion-02:~$ mysql -h c3.labsdb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 100264212
Server version: 10.0.22-MariaDB MariaDB Server

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

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

MariaDB [(none)]> SHOW databases LIKE 's51111%';
+---------------------------+
| Database (s51111%)        |
+---------------------------+
| s51111__common_p          |
| s51111__rlrl_cawiki_p     |
| s51111__rlrl_frwiki_p     |
| s51111__rlrl_lvwiki_p     |
| s51111__unlikely_lvwiki_p |
+---------------------------+
5 rows in set (0.01 sec)

MariaDB [(none)]> Bye
tools.tb-dev@tools-bastion-02:~$ mysql -h tools.labsdb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 40519114
Server version: 10.0.31-MariaDB MariaDB Server

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

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

MariaDB [(none)]> SHOW databases LIKE 's51111%';
Empty set (0.00 sec)
zhuyifei1999 added a comment.EditedNov 2 2017, 9:53 PM

I'm unable to find any oauth-related code via tools.tb-dev@tools-bastion-05:~$ find -name \*.txt | grep -i 'oauth'. I don't find any svn or git repos either for this tool, so checking each file manually can be a lot of work.

EDIT: ^ command is broken; meant to use xargs but didn't... argh. Anyhow searching for oauth gives nothing, and password does not show any secret information.

List of non-world-readable files/directories:

tools.tb-dev@tools-bastion-05:~$ find ! -perm -g=r | xargs ls -ld --color=auto
-rw------- 1 tools.tb-dev tools.tb-dev  34137 Nov  2 22:23 ./.bash_history
drwx--S--- 2 tools.tb-dev tools.tb-dev   4096 May 14  2014 ./.cache
drwx--S--- 2 tools.tb-dev tools.tb-dev   4096 Jan 21  2017 ./credentials
-r-------- 1 tools.tb-dev tools.tb-dev     52 Jan 21  2017 ./credentials/s51111
drwx--S--- 3 tools.tb-dev tools.tb-dev   4096 May 22  2013 ./.emacs.d
drwx--S--- 2 tools.tb-dev tools.tb-dev   4096 May 22  2013 ./.emacs.d/auto-save-list
-r-------- 1 tools.tb-dev tools.tb-dev    692 Jul  6  2016 ./.kube/config
-rw------- 1 tools.tb-dev tools.tb-dev     41 Jun 24  2013 ./.lesshst
-r-------- 1 tools.tb-dev tools.tb-dev     52 Jan 21  2017 ./.my.cnf
-rw------- 1 tools.tb-dev tools.tb-dev 912398 Nov  2 21:41 ./.mysql_history
-r-------- 1 tools.tb-dev tools.tb-dev     52 Dec 21  2016 ./replica.my.cnf
drwx--S--- 2 tools.tb-dev tools.tb-dev   4096 May  3  2015 ./.ssh
-rw------- 1 tools.tb-dev tools.tb-dev    884 May  3  2015 ./.ssh/known_hosts
drwx--s--x 2 tools.tb-dev tools.tb-dev   4096 Jul  5  2009 ./ts/public_html/cgi-bin
-rw------- 1 tools.tb-dev tools.tb-dev  26716 Jun 24 16:33 ./.viminfo
  • History files .bash_history, .mysql_history, .viminfo may need checking.
    • .lesshst lgtm
  • cache has a single empty file motd.legal-displayed.
  • Directory .emacs.d => single directory auto-save-list => single empty file .saves-11919-tools-login.pmtpa.wmflabs~
  • credentials/s51111 == replica.my.cnf == .my.cnf. All tool-owned databases are _p-s so the databases are public anyways.
  • .kube/config is for auth to k8s, $ kubectl get pods is empty so should not leak any information.
  • Directory .ssh contains no private keys; .ssh/known_hosts is not comprehensible (contains no unhashed hostname information); the keys inside it should be public keys of various hosts the tool has connected to (eg. cronhost)
  • Directory ts/public_html/cgi-bin is empty.

Mentioned in SAL (#wikimedia-cloud) [2017-11-02T23:55:14Z] <zhuyifei1999_> Added harej as maintainer to double check stuffs for T179599

Mentioned in SAL (#wikimedia-cloud) [2017-11-03T01:44:23Z] <zhuyifei1999_> Redacted a password (may or may not be the database password before the replica.my.cnf regenerated) in .mysql_history, to 'T179599 REDACTED'

Harej added a comment.Nov 3 2017, 1:51 AM

access.log contains your standard web server access log entries, including IP address, browser header, request. But because all traffic is routed through the same internal IP address, no one's IP address is actually being exposed. I think the file can be kept as-is but I am bringing it up for thoroughness.

.bash_history has nothing sensitive in it that I can see. We may want to, as a precaution, create a backup and then delete the file, but I am not sure how safe/effective that is. (It's not really something that's come up for me before.)

.viminfo looks totally fine

.mysql_info featured a password. It has been redacted.

As for the actual application...

I read common/database.php and found that it was loading the replica.my.cnf file instead of using a hard coded password. Kudos!

I've also noticed the various applications rely on database.php so it can generally be assumed those don't contain hardcoded passwords either. (I made spot checks just to check.)

In sum, it should be safe to hand this tool off to another person.

.bash_history copied to P6252

The owner has now been notified on their wikitech usertalk page, and via email, per instructions.
We now need to wait another 14 days to give them time for possible objections, in case they hadn't seen the messages at Enwiki.

zhuyifei1999 changed the task status from Open to Stalled.EditedNov 3 2017, 8:21 PM

Waiting 14 days, in case @Tb object to this adoption. In the meantime, Toolforge-standards-committee, anyone object?

I am ok with this.

zhuyifei1999 changed the task status from Stalled to Open.Nov 17 2017, 9:10 PM

I did a backup of the the home directory except the cronout and non-latest db backups, to /home/zhuyifei1999/tb-dev.tar.gz (around 11MiB):

109:37:02 1 ✗ zhuyifei1999@tools-bastion-05: ~$ become tb-dev
2tools.tb-dev@tools-bastion-05:~$ HISTFILE=
3tools.tb-dev@tools-bastion-05:~$ umask 0027
4tools.tb-dev@tools-bastion-05:~$ cd ..
5tools.tb-dev@tools-bastion-05:/data/project$ ls /data/scratch/tb-dev.tar.gz
6ls: cannot access /data/scratch/tb-dev.tar.gz: No such file or directory
7tools.tb-dev@tools-bastion-05:/data/project$ cat <(find tb-dev -type f | grep -v '/cronout/' | grep -v '/db_backup/') <(find tb-dev/db_backup/20171112/ -type f) | xargs tar -cvzf /data/scratch/tb-dev.tar.gz
8tb-dev/.viminfo
9tb-dev/replica.my.cnf
10tb-dev/.cache/motd.legal-displayed
11tb-dev/notes
12tb-dev/.my.cnf
13tb-dev/.vim/.netrwhist
14tb-dev/service.manifest
15tb-dev/public_html/cite/index.php
16tb-dev/public_html/cite/tool.php
17tb-dev/public_html/cite/doc.php
18tb-dev/public_html/longtalk/index.php
19tb-dev/public_html/longtalk/tool.php
20tb-dev/public_html/longtalk/doc.php
21tb-dev/public_html/lang/index.php
22tb-dev/public_html/lang/tool.php
23tb-dev/public_html/lang/doc.php
24tb-dev/public_html/images/banana.gif
25tb-dev/public_html/.htaccess
26tb-dev/public_html/CNRS/index.php
27tb-dev/public_html/CNRS/tool.php
28tb-dev/public_html/CNRS/doc.php
29tb-dev/public_html/DSS/index.php
30tb-dev/public_html/DSS/same.php
31tb-dev/public_html/DSS/diff.php
32tb-dev/public_html/DSS/tool.php
33tb-dev/public_html/DSS/doc.php
34tb-dev/public_html/DSS/diff.php.20131117
35tb-dev/public_html/common/rules.php
36tb-dev/public_html/common/robot.php
37tb-dev/public_html/common/replag.php
38tb-dev/public_html/common/http.php
39tb-dev/public_html/common/wikilinks.php
40tb-dev/public_html/common/rules.php.20150826
41tb-dev/public_html/common/convert.php
42tb-dev/public_html/common/pagetop.php.20140809
43tb-dev/public_html/common/home.php
44tb-dev/public_html/common/double_metaphone.php.20150430
45tb-dev/public_html/common/SqlFormatter.php
46tb-dev/public_html/common/rules.php.20140911
47tb-dev/public_html/common/exceptions.php20140909
48tb-dev/public_html/common/html.php
49tb-dev/public_html/common/rules.php.20140909
50tb-dev/public_html/common/diff.php
51tb-dev/public_html/common/pagetop.php
52tb-dev/public_html/common/database.php
53tb-dev/public_html/common/pagetop.php.20151007
54tb-dev/public_html/common/pagetop.php.20151001
55tb-dev/public_html/common/double_metaphone.php
56tb-dev/public_html/common/rules.php.20150803
57tb-dev/public_html/common/debug.php
58tb-dev/public_html/unlikely/whitelist.phpe
59tb-dev/public_html/unlikely/index.php.20151001
60tb-dev/public_html/unlikely/tool.phpe
61tb-dev/public_html/unlikely/index.phpe
62tb-dev/public_html/unlikely/doc.phpe
63tb-dev/public_html/unlikely/index.php
64tb-dev/public_html/unlikely/invalidate_cache.phpe
65tb-dev/public_html/unlikely/stats.phpe
66tb-dev/public_html/unlikely/stats.php
67tb-dev/public_html/unlikely/invalidate_cache.php
68tb-dev/public_html/unlikely/tool.php
69tb-dev/public_html/unlikely/doc.php
70tb-dev/public_html/unlikely/whitelist.php
71tb-dev/public_html/MEA/index.php
72tb-dev/public_html/MEA/index.php.20160901
73tb-dev/public_html/MEA/tool.php
74tb-dev/public_html/MEA/doc.php
75tb-dev/public_html/convert/index.php
76tb-dev/public_html/convert/index.php.20140508
77tb-dev/public_html/convert/tool.php
78tb-dev/public_html/convert/doc.php
79tb-dev/public_html/convert/doc.php.20140508
80tb-dev/public_html/ACRO/index.php
81tb-dev/public_html/ACRO/tool.php
82tb-dev/public_html/ACRO/doc.php
83tb-dev/public_html/CCR/index.php
84tb-dev/public_html/CCR/tool.php
85tb-dev/public_html/CCR/doc.php
86tb-dev/public_html/ECLIPSE/index.php
87tb-dev/public_html/ECLIPSE/.index.php.swp
88tb-dev/public_html/ECLIPSE/tool.php
89tb-dev/public_html/ECLIPSE/doc.php
90tb-dev/public_html/RLRL/logo.php
91tb-dev/public_html/RLRL/projlang.php
92tb-dev/public_html/RLRL/index.php
93tb-dev/public_html/RLRL/TODO
94tb-dev/public_html/RLRL/meta.php
95tb-dev/public_html/RLRL/progress.php
96tb-dev/public_html/RLRL/updatestats.php
97tb-dev/public_html/RLRL/stats.php
98tb-dev/public_html/RLRL/pagetop.php
99tb-dev/public_html/RLRL/headnotes.php
100tb-dev/public_html/RLRL/backups/pagetop.php.20140201
101tb-dev/public_html/RLRL/backups/updatestats.php.20140514
102tb-dev/public_html/RLRL/backups/updatestats.sql.20140513
103tb-dev/public_html/RLRL/backups/updatestats.sql
104tb-dev/public_html/RLRL/backups/updatestats_enwiki
105tb-dev/public_html/RLRL/backups/updatestats.php
106tb-dev/public_html/RLRL/backups/updatestats.php.20130607
107tb-dev/public_html/RLRL/backups/validate_suggestions.php.20120411
108tb-dev/public_html/RLRL/backups/updatestats_enwiki.sql
109tb-dev/public_html/RLRL/backups/updatestats
110tb-dev/public_html/RLRL/backups/validate_suggestions.php.20120410
111tb-dev/public_html/RLRL/backups/updatestats2.php
112tb-dev/public_html/RLRL/backups/updatestats_ptwiki.sql
113tb-dev/public_html/RLRL/backups/updatestats_ptwiki
114tb-dev/public_html/RLRL/validate_suggestions.php
115tb-dev/public_html/RLRL/suggestions.php
116tb-dev/public_html/RLRL/checkpage.php
117tb-dev/public_html/oddlinks/index.php
118tb-dev/public_html/oddlinks/catchup.php
119tb-dev/public_html/oddlinks/full_rebuild.php
120tb-dev/public_html/oddlinks/tables.sql
121tb-dev/public_html/oddlinks/tool.php
122tb-dev/public_html/oddlinks/doc.php
123tb-dev/public_html/UPMA/index.php
124tb-dev/public_html/UPMA/tool.php
125tb-dev/public_html/UPMA/doc.php
126tb-dev/public_html/disambig/index.php
127tb-dev/public_html/disambig/tool.php
128tb-dev/public_html/disambig/doc.php
129tb-dev/public_html/NEWP/index.php
130tb-dev/public_html/NEWP/index.php.20151008
131tb-dev/public_html/NEWP/tool.php
132tb-dev/public_html/NEWP/doc.php
133tb-dev/public_html/CITY/tool.phpe
134tb-dev/public_html/CITY/index.phpe
135tb-dev/public_html/CITY/doc.phpe
136tb-dev/public_html/CITY/index.php
137tb-dev/public_html/CITY/tool.php
138tb-dev/public_html/CITY/doc.php
139tb-dev/public_html/simt/whitelist.phpe
140tb-dev/public_html/simt/tool.phpe
141tb-dev/public_html/simt/index.phpe
142tb-dev/public_html/simt/doc.phpe
143tb-dev/public_html/simt/index.php
144tb-dev/public_html/simt/tool.php
145tb-dev/public_html/simt/doc.php
146tb-dev/public_html/simt/whitelist.php
147tb-dev/public_html/simt/doc.php.20150215
148tb-dev/public_html/ISR/whitelist.phpe
149tb-dev/public_html/ISR/tool.phpe
150tb-dev/public_html/ISR/index.phpe
151tb-dev/public_html/ISR/doc.phpe
152tb-dev/public_html/ISR/index.php
153tb-dev/public_html/ISR/tool.php
154tb-dev/public_html/ISR/doc.php
155tb-dev/public_html/ISR/whitelist.php
156tb-dev/public_html/ISO639/index.php
157tb-dev/public_html/ISO639/tool.php
158tb-dev/public_html/ISO639/doc.php
159tb-dev/public_html/ODT/index.php
160tb-dev/public_html/ODT/mb_str_replace.php
161tb-dev/public_html/ODT/tool.php
162tb-dev/public_html/ODT/doc.php
163tb-dev/public_html/tb.css
164tb-dev/public_html/MSR/index.php
165tb-dev/public_html/MSR/tool.php
166tb-dev/public_html/MSR/doc.php
167tb-dev/public_html/PUCS/index.php
168tb-dev/public_html/PUCS/tool.php
169tb-dev/public_html/PUCS/doc.php
170tb-dev/public_html/index.html
171tb-dev/public_html/PMSR/whitelist.phpe
172tb-dev/public_html/PMSR/tool.phpe
173tb-dev/public_html/PMSR/index.phpe
174tb-dev/public_html/PMSR/doc.phpe
175tb-dev/public_html/PMSR/index.php
176tb-dev/public_html/PMSR/tool.php
177tb-dev/public_html/PMSR/doc.php
178tb-dev/public_html/PMSR/whitelist.php
179tb-dev/public_html/robots.txt
180tb-dev/public_html/ticker/index.php
181tb-dev/temp.sql
182tb-dev/error.log
183tb-dev/credentials/s51111
184tb-dev/common.sql
185tb-dev/public_html.tgz.20160217
186tb-dev/.ssh/known_hosts
187tb-dev/.bashrc
188tb-dev/.kube/config
189tb-dev/.bash_history
190tb-dev/standard_three.sql
191tb-dev/.emacs.d/auto-save-list/.saves-11919-tools-login.pmtpa.wmflabs~
192tb-dev/.selected_editor
193tb-dev/.lesshst
194tb-dev/RLRL/close_set.php
195tb-dev/RLRL/find_all_red_transclusions.php
196tb-dev/RLRL/rebuild_dm_titles.php
197tb-dev/RLRL/sql/db.sql
198tb-dev/RLRL/sql/unk.sql
199tb-dev/RLRL/sql/old/methods/plurals.sql
200tb-dev/RLRL/sql/old/methods/numbers.sql
201tb-dev/RLRL/sql/old/methods/initialisation.sql
202tb-dev/RLRL/sql/old/methods/disambig.sql
203tb-dev/RLRL/sql/old/methods/repeats.sql
204tb-dev/RLRL/sql/old/methods/middlenames.sql
205tb-dev/RLRL/test.php
206tb-dev/RLRL/cat.php
207tb-dev/RLRL/old/bf.php.20150302
208tb-dev/RLRL/old/fer.php
209tb-dev/RLRL/old/find_all_red_links.php.20120504
210tb-dev/RLRL/old/rebuild_dm_titles.php.20140912
211tb-dev/RLRL/old/lev_match.php.2010026
212tb-dev/RLRL/old/exceptions.php.20121215
213tb-dev/RLRL/old/maintain_redlinks.php
214tb-dev/RLRL/old/find_all_red_templatelinks.php
215tb-dev/RLRL/old/find_all_red_linkst.php
216tb-dev/RLRL/old/find_all_red_links.php.20110915
217tb-dev/RLRL/old/fer_dm.php
218tb-dev/RLRL/old/most_wanted.php
219tb-dev/RLRL/old/mwa.php
220tb-dev/RLRL/old/find_all_red_links.php.20130519
221tb-dev/RLRL/old/bf.php.20140615
222tb-dev/RLRL/old/bf.php.20160103
223tb-dev/RLRL/find_all_red_links.php
224tb-dev/RLRL/submit_bf_jobs
225tb-dev/RLRL/rebuild_dm_redlinks.php
226tb-dev/RLRL/bf.php
227tb-dev/RLRL/find_all_red_catlinks.php
228tb-dev/RLRL/apply_rules.php
229tb-dev/RLRL/testdm.php
230tb-dev/RLRL/except.php
231tb-dev/RLRL/submit_bf_jobs.pt
232tb-dev/RLRL/ec.php
233tb-dev/RLRL/bf_utf.php
234tb-dev/.vimrc
235tb-dev/.nano_history
236tb-dev/.mysql_history
237tb-dev/access.log
238tb-dev/hits
239tb-dev/.description
240tb-dev/service.log
241tb-dev/ts/notes
242tb-dev/ts/archive/double-metaphone.sql
243tb-dev/ts/archive/lv/README
244tb-dev/ts/archive/lv/notes
245tb-dev/ts/archive/lv/mysqllevenshtein.cc
246tb-dev/ts/archive/lv/mysqllevenshtein.so
247tb-dev/ts/archive/levenshtein.sql
248tb-dev/ts/public_html/.htaccess
249tb-dev/ts/public_html/common/http.php
250tb-dev/ts/public_html/common/wikilinks.php
251tb-dev/ts/public_html/common/home.php
252tb-dev/ts/public_html/common/logging.php
253tb-dev/ts/public_html/common/html.php
254tb-dev/ts/public_html/common/diff.php
255tb-dev/ts/public_html/common/database.php
256tb-dev/ts/public_html/common/double_metaphone.php
257tb-dev/ts/public_html/common/diff2.php
258tb-dev/ts/public_html/common/debug.php
259tb-dev/ts/public_html/stubs/logo.php
260tb-dev/ts/public_html/stubs/index.php
261tb-dev/ts/public_html/stubs/pagetop.php
262tb-dev/ts/public_html/stubs/doc.php
263tb-dev/ts/public_html/RLE/logo.php
264tb-dev/ts/public_html/RLE/php
265tb-dev/ts/public_html/RLE/index.php
266tb-dev/ts/public_html/RLE/stats.php
267tb-dev/ts/public_html/RLE/pagetop.php
268tb-dev/ts/public_html/RLE/doc.php
269tb-dev/ts/public_html/RLE/whitelist.php
270tb-dev/ts/public_html/test.php
271tb-dev/ts/public_html/admin/logo.php
272tb-dev/ts/public_html/admin/index.php
273tb-dev/ts/public_html/admin/pagetop.php
274tb-dev/ts/public_html/admin/RLRL.php
275tb-dev/ts/public_html/admin/doc.php
276tb-dev/ts/public_html/wc/uniset.php
277tb-dev/ts/public_html/wc/ex2.php
278tb-dev/ts/public_html/wc/mixed_charset.php
279tb-dev/ts/public_html/wc/redlinks.old
280tb-dev/ts/public_html/wc/countwords.out.gz
281tb-dev/ts/public_html/wc/chars.txt.gz
282tb-dev/ts/public_html/wc/exotics.php.20120423
283tb-dev/ts/public_html/wc/countchars.php
284tb-dev/ts/public_html/wc/words.txt.gz
285tb-dev/ts/public_html/wc/exotics.php
286tb-dev/ts/public_html/wc/countwords.1-8.gz
287tb-dev/ts/public_html/wc/countwords.php
288tb-dev/ts/public_html/loop.php
289tb-dev/ts/public_html/RTN/index.php
290tb-dev/ts/public_html/RTN/out.txt
291tb-dev/ts/public_html/RTN/find_all_RTNs.php
292tb-dev/ts/public_html/RTN/rtn.sql
293tb-dev/ts/public_html/robots.txt
294tb-dev/ts/public_html/langlinks/logo.php
295tb-dev/ts/public_html/langlinks/index.php
296tb-dev/ts/public_html/langlinks/pagetop.php
297tb-dev/ts/public_html/langlinks/doc.php
298tb-dev/ts/C/utf.c
299tb-dev/ts/C/backup/utf.c
300tb-dev/ts/C/backup/test.c.20120404
301tb-dev/ts/C/backup/utf.h
302tb-dev/ts/C/backup/test.c.noworking
303tb-dev/ts/C/backup/test.c.20120403
304tb-dev/ts/C/backup/20120419/utf.c
305tb-dev/ts/C/backup/20120419/test.c.20120404
306tb-dev/ts/C/backup/20120419/test.o
307tb-dev/ts/C/backup/20120419/utf.h
308tb-dev/ts/C/backup/20120419/test.c.20120403
309tb-dev/ts/C/backup/20120419/test
310tb-dev/ts/C/backup/20120419/utf.o
311tb-dev/ts/C/backup/20120419/test.c
312tb-dev/ts/C/backup/20120419/test.c.20120404v2
313tb-dev/ts/C/backup/20120419/Makefile
314tb-dev/ts/C/backup/20120419/test.20120405
315tb-dev/ts/C/backup/test.c
316tb-dev/ts/C/backup/test.c.20120404v2
317tb-dev/ts/C/backup/Makefile
318tb-dev/ts/C/backup/test.20120405
319tb-dev/ts/C/test.o
320tb-dev/ts/C/utf.h
321tb-dev/ts/C/test
322tb-dev/ts/C/utf.o
323tb-dev/ts/C/test.c
324tb-dev/ts/C/Makefile
325tb-dev/ts/names.txt
326tb-dev/db_backup/20171112/s51111__rlrl_lvwiki_p.20171112.gz
327tb-dev/db_backup/20171112/s51111__unlikely_ptwiki_p.20171112.gz
328tb-dev/db_backup/20171112/s51111__rlrl_enwiki_p.20171112.gz
329tb-dev/db_backup/20171112/s51111__rlrl_ptwiki_p.20171112.gz
330tb-dev/db_backup/20171112/s51111__rlrl_frwiki_p.20171112.gz
331tb-dev/db_backup/20171112/s51111__unlikely_enwiki_p.20171112.gz
332tb-dev/db_backup/20171112/s51111__rlrl_cawiki_p.20171112.gz
333tb-dev/db_backup/20171112/s51111__unlikely_lvwiki_p.20171112.gz
334tb-dev/db_backup/20171112/s51111__inconsistent_redirects_p.20171112.gz
335tb-dev/db_backup/20171112/s51111__common_p.20171112.gz
336tb-dev/db_backup/20171112/s51111__oddlinks_p.20171112.gz
337tools.tb-dev@tools-bastion-05:/data/project$ stat /data/scratch/tb-dev.tar.gz
338 File: ‘/data/scratch/tb-dev.tar.gz’
339 Size: 10524098 Blocks: 20560 IO Block: 1048576 regular file
340Device: 25h/37d Inode: 12 Links: 1
341Access: (0640/-rw-r-----) Uid: (51111/tools.tb-dev) Gid: (51111/tools.tb-dev)
342Access: 2017-11-17 21:37:32.339957575 +0000
343Modify: 2017-11-17 21:37:37.651927886 +0000
344Change: 2017-11-17 21:37:37.651927886 +0000
345 Birth: -
346tools.tb-dev@tools-bastion-05:/data/project$ logout
34709:37:52 0 ✓ zhuyifei1999@tools-bastion-05: ~$ cp /data/scratch/tb-dev.tar.gz ~
34809:38:11 0 ✓ zhuyifei1999@tools-bastion-05: ~$ sudo -u tools.tb-dev rm /data/scratch/tb-dev.tar.gz

I'd upload it here but idk how to do so without all the database creds become public (phab access policy for files gets loose when a file gets linked in any way).

zhuyifei1999 removed zhuyifei1999 as the assignee of this task.Nov 17 2017, 10:04 PM

Uh, given https://wikitech.wikimedia.org/wiki/Special:Diff/1775977, I personally don't know if this should be continued.

Mentioned in SAL (#wikimedia-cloud) [2017-11-18T02:11:16Z] <zhuyifei1999_> Removing myself from maintainer list (cc T179599)