Page MenuHomePhabricator

Audiodude (Travis Briggs)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Mar 30 2017, 2:19 AM (215 w, 5 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
Audiodude [ Global Accounts ]

Recent Activity

Feb 15 2021

Audiodude added a comment to T269609: Ensure all ToolsDB databases comply with current naming conventions.

Okay I've migrated s51114_enwp10 to s51114__enwp10. There are a few tables left in the old database, but they are leftovers from the tool migration process and can be deleted.

Feb 15 2021, 8:23 PM · Developer-Advocacy (Apr-Jun 2021), cloud-services-team (Kanban), Data-Services
Audiodude added a comment to T269609: Ensure all ToolsDB databases comply with current naming conventions.

Shouldn't step 5 be CREATE DATABASE not CREATE TABLE?

Feb 15 2021, 8:14 PM · Developer-Advocacy (Apr-Jun 2021), cloud-services-team (Kanban), Data-Services

Jan 21 2021

Audiodude added a comment to T269609: Ensure all ToolsDB databases comply with current naming conventions.

s51114_enwp10 is definitely still in use. I don't know how to rename it safely, so would need help with that.

Jan 21 2021, 5:13 PM · Developer-Advocacy (Apr-Jun 2021), cloud-services-team (Kanban), Data-Services

Dec 11 2020

Audiodude closed T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github as Resolved.
Dec 11 2020, 12:49 AM · cloud-services-team (Kanban), Security
Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

Yes it's all resolved now, you can publish it if you like, I don't have an opinion and am not familiar with the policy.

Dec 11 2020, 12:49 AM · cloud-services-team (Kanban), Security
Audiodude added a comment to T269898: Bot needs account unlocked.

It worked! Thanks so much both of you for your help!

Dec 11 2020, 12:47 AM · User-Urbanecm, Wikimedia-Site-requests

Dec 10 2020

Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

Should T269898: Bot needs account unlocked be merged here? Or is there anything that can be done publically there?

Dec 10 2020, 11:20 PM · cloud-services-team (Kanban), Security

Dec 9 2020

Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

That seems to be @OlegAlexandrov who is still active on enwiki. CC'd them to this task...

Dec 9 2020, 1:50 AM · cloud-services-team (Kanban), Security

Dec 7 2020

Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

You are correct, this database is quite old. Thank you for your help with this, I have confirmed that I can read from the database again.

Dec 7 2020, 5:39 PM · cloud-services-team (Kanban), Security

Dec 6 2020

Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

How do you not have the login password for it? Does someone else?

Dec 6 2020, 6:31 PM · cloud-services-team (Kanban), Security
Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

Regarding https://phabricator.wikimedia.org/T269513#6671553 it looks like the credentials in replica.my.cnf allow login access to the databases, but the user doesn't have permissions to s51114_enwp10 which is the name of the database that the tool uses on tools.db.svc.eqiad.wmflabs. Would it be possible to grant permissions?

Dec 6 2020, 6:26 PM · cloud-services-team (Kanban), Security
Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

Thank you for this information, but I don't have access to the login password for WP 1.0 bot, I only have the bot password.

Dec 6 2020, 6:22 PM · cloud-services-team (Kanban), Security
Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

I've got a new replica.my.cnf, but I'm getting the following:

Dec 6 2020, 5:46 AM · cloud-services-team (Kanban), Security
Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

Thank you so much Andrew! How do I get new credentials?

Dec 6 2020, 5:00 AM · cloud-services-team (Kanban), Security
Audiodude added a comment to T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.

I also leaked the "bot password" for the WP 1.0 Bot. I don't know where or how to reset or rescind this password. When I log into mediawiki.org I see "Audiodude@WP_1.0_bot" but I believe that makes edits as my user account. The account I need to reset is "WP 1.0 bot@WP_1.0_bot"

Dec 6 2020, 4:56 AM · cloud-services-team (Kanban), Security
Audiodude created T269513: Leaked enwp10 replica.my.cnf/WP 1.0 bot botpassword credentials to Github.
Dec 6 2020, 4:50 AM · cloud-services-team (Kanban), Security

Nov 17 2020

Audiodude added a comment to T267987: Account recovery help needed for Developer account Audiodude.

Thank you, sorry about this. I looked around a bunch for my recovery codes but I can't remember at all where I put them!

Nov 17 2020, 12:59 AM · User-bd808, Trust-and-Safety, cloud-services-team (Kanban)

Nov 16 2020

Audiodude created T267987: Account recovery help needed for Developer account Audiodude.
Nov 16 2020, 11:25 PM · User-bd808, Trust-and-Safety, cloud-services-team (Kanban)

Aug 31 2020

Audiodude added a comment to T256533: Identify accounts with very high login rate.

Okay I've deployed the fix to WP 1.0 bot as of tonight's update. It should be good the next time you run the numbers. Please let me know.

Aug 31 2020, 2:52 AM · User-Urbanecm, Wikimedia-General-or-Unknown, Security, Security-Team

Aug 28 2020

Audiodude added a comment to T256533: Identify accounts with very high login rate.

Wanted to come here and acknowledge this issue. I've opened a bug against the WP 1.0 project to fix this. It should be taken care of this weekend. Thank you @DeltaQuad for the link to mwclient workaround!

Aug 28 2020, 9:19 PM · User-Urbanecm, Wikimedia-General-or-Unknown, Security, Security-Team

Oct 12 2019

Audiodude closed T230462: WP 1.0 Bot enhancements as Resolved.
Oct 12 2019, 7:38 PM · Wikimania-Hackathon-2019

Aug 14 2019

Audiodude created T230462: WP 1.0 Bot enhancements.
Aug 14 2019, 8:05 AM · Wikimania-Hackathon-2019

Jun 18 2019

Audiodude closed T226038: "Lost connection to MySQL server during query" using pymysql on toolforge connecting to db replica as Resolved.

That seems to have resolved the issue!

Jun 18 2019, 11:30 PM · Toolforge, Data-Services
Audiodude added a comment to T226038: "Lost connection to MySQL server during query" using pymysql on toolforge connecting to db replica.

I'm going to try replacing DictCursor with SSDictCursor and see if that helps.

Jun 18 2019, 5:28 PM · Toolforge, Data-Services
Audiodude created T226038: "Lost connection to MySQL server during query" using pymysql on toolforge connecting to db replica.
Jun 18 2019, 5:24 PM · Toolforge, Data-Services

May 12 2019

Audiodude closed T223028: enwp10 is returning 503 error as Resolved.

Hi @Kelson , I think you gave extra parameters to your restart command. I tried:

May 12 2019, 11:22 AM · Tools

Mar 28 2019

Audiodude closed T219483: "enwp10" not available anymore and shut down (due to Trusty migration) as Resolved.

Okay, I had previously added a setenv command for adding the PERL5LIB to the environment, but I didn't add it for list2.fcgi and log.fcgi, which now have their own sections in their configs for the environment variable. Things seem to be working now

Mar 28 2019, 7:10 PM · Tools
Audiodude added a comment to T219483: "enwp10" not available anymore and shut down (due to Trusty migration).

This isn't entirely accurate. The tool was in fact migrated to stretch last week. However, certain pages may still be erroring out, and that needs to be addressed. I will look at it later today when I have my laptop.

Mar 28 2019, 4:16 PM · Tools

Jan 7 2019

Audiodude added a comment to T213039: Using a "_test" database that gets created and torn down for every test.

And yes, the ORM I was speaking of was SQLAlchemy. It was much too slow with the session management strategy I was using, and manually managing multiple sessions and object eviction in order to speed it up would make the code too complicated in my opinion and negate the benefits of using the ORM.

Jan 7 2019, 3:37 PM · cloud-services-team
Audiodude closed T213039: Using a "_test" database that gets created and torn down for every test as Resolved.

Thanks for the comments. I realized that the test db never needs to be live in production and that helped me figure out the solution.

Jan 7 2019, 3:35 PM · cloud-services-team
Audiodude added a comment to T213039: Using a "_test" database that gets created and torn down for every test.

That looks promising for the Travis CI environment yes. I guess my problem is that I'm not developing locally, I'm developing directly on the Toolforge instance and I guess I just need to provision a database for test there?

Jan 7 2019, 2:28 AM · cloud-services-team

Jan 6 2019

Audiodude created T213039: Using a "_test" database that gets created and torn down for every test.
Jan 6 2019, 11:18 PM · cloud-services-team

Dec 17 2018

Audiodude added a comment to T207877: tool enwp10 is not working.

The web tool (https://tools.wmflabs.org/enwp10) looks up to me. What specifically is not working?

Dec 17 2018, 5:45 AM · Tools

Dec 3 2018

Audiodude closed T207877: tool enwp10 is not working as Resolved.

Restarted it again. Let me know if it works.

Dec 3 2018, 7:56 PM · Tools

Oct 24 2018

Audiodude closed T207877: tool enwp10 is not working as Resolved.

I just restarted it. The tool seems to die every 30 days or so, this last happened on Sept 28.

Oct 24 2018, 7:25 PM · Tools

Mar 10 2018

Audiodude added a comment to T161773: Make a plain text dump of Wikipedia available alongside the XML.

Actually, I believe plaintext would be more useful, but HTML would be a good starting point since it's reasonable to strip out.

Mar 10 2018, 8:44 AM · Dumps-Generation

Mar 31 2017

Audiodude added a comment to T161773: Make a plain text dump of Wikipedia available alongside the XML.

In fact the XML is not the problem, it's the wiki markup. From what I understand, the wiki markup is not defined by any formal grammar, so parsing it is non-trivial. Tools like mwparserfromhell help, but can be difficult to configure and not always accurate. There's also of course the problem of recursive template expansion.

Mar 31 2017, 10:54 PM · Dumps-Generation

Mar 30 2017

Audiodude updated subscribers of T161773: Make a plain text dump of Wikipedia available alongside the XML.
Mar 30 2017, 2:23 AM · Dumps-Generation
Audiodude created T161773: Make a plain text dump of Wikipedia available alongside the XML.
Mar 30 2017, 2:22 AM · Dumps-Generation