Page MenuHomePhabricator

Ashitabattu (Ashita)
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 23 2021, 4:03 PM (27 w, 47 m)
Availability
Available
LDAP User
Unknown
MediaWiki User
Ashitabattu [ Global Accounts ]

Recent Activity

Apr 16 2021

Ashitabattu moved T279442: Develop a web dashboard to help MYSQL account metadata inventory from Backlog to Proposals Submitted on the Google-Summer-of-Code (2021) board.
Apr 16 2021, 10:33 AM · dbbackups-dashboard, Google-Summer-of-Code (2021)

Apr 13 2021

Ashitabattu updated the task description for T279442: Develop a web dashboard to help MYSQL account metadata inventory.
Apr 13 2021, 9:44 AM · dbbackups-dashboard, Google-Summer-of-Code (2021)

Apr 12 2021

Ashitabattu updated the task description for T279442: Develop a web dashboard to help MYSQL account metadata inventory.
Apr 12 2021, 3:09 PM · dbbackups-dashboard, Google-Summer-of-Code (2021)
Ashitabattu added a comment to T279442: Develop a web dashboard to help MYSQL account metadata inventory.

Hi @jcrespo. Please look into my new timeline and give me the final feedback before I submit my proposal.
Also, I have only concentrated on making my proposal and haven't made any contribution to the microtasks during this application period. Hope this doesn't effect much. But, I am planning to be active from now onward.
Thank you.

Apr 12 2021, 2:12 PM · dbbackups-dashboard, Google-Summer-of-Code (2021)
Ashitabattu added a comment to T279442: Develop a web dashboard to help MYSQL account metadata inventory.

Hey @Ashitabattu

Thanks for showing your interest to participate in Google Summer of Code with Wikimedia Foundation! Please make sure to upload a copy of your proposal on Google's program site as well in whatever format it's expected of you, include in it this public proposal of Phabricator before the deadline i.e April 13th. Good luck :)

Apr 12 2021, 10:39 AM · dbbackups-dashboard, Google-Summer-of-Code (2021)

Apr 9 2021

Ashitabattu updated the task description for T279442: Develop a web dashboard to help MYSQL account metadata inventory.
Apr 9 2021, 8:25 PM · dbbackups-dashboard, Google-Summer-of-Code (2021)
Ashitabattu added a comment to T279442: Develop a web dashboard to help MYSQL account metadata inventory.

Thank you for the valuable feedback.

Apr 9 2021, 7:57 PM · dbbackups-dashboard, Google-Summer-of-Code (2021)
Ashitabattu updated the task description for T279442: Develop a web dashboard to help MYSQL account metadata inventory.
Apr 9 2021, 6:49 PM · dbbackups-dashboard, Google-Summer-of-Code (2021)
Ashitabattu added a project to T279442: Develop a web dashboard to help MYSQL account metadata inventory: dbbackups-dashboard.
Apr 9 2021, 7:50 AM · dbbackups-dashboard, Google-Summer-of-Code (2021)

Apr 8 2021

Ashitabattu renamed T279442: Develop a web dashboard to help MYSQL account metadata inventory from MYSQL account metadata inventory to Develop a web dashboard to help MYSQL account metadata inventory.
Apr 8 2021, 8:49 AM · dbbackups-dashboard, Google-Summer-of-Code (2021)

Apr 6 2021

Ashitabattu added a comment to T279442: Develop a web dashboard to help MYSQL account metadata inventory.

Hi @jcrespo and @Marostegui. Please go through my proposal and give me a feedback so that I would be able to improvise it.

Apr 6 2021, 3:22 PM · dbbackups-dashboard, Google-Summer-of-Code (2021)
Ashitabattu added a parent task for T274636: Develop a web dashboard or a command line tool to help inventory and/or monitor database and backup objects: T279442: Develop a web dashboard to help MYSQL account metadata inventory.
Apr 6 2021, 3:15 PM · Google-Summer-of-Code (2021)
Ashitabattu added a subtask for T279442: Develop a web dashboard to help MYSQL account metadata inventory: T274636: Develop a web dashboard or a command line tool to help inventory and/or monitor database and backup objects.
Apr 6 2021, 3:15 PM · dbbackups-dashboard, Google-Summer-of-Code (2021)
Ashitabattu created T279442: Develop a web dashboard to help MYSQL account metadata inventory.
Apr 6 2021, 3:13 PM · dbbackups-dashboard, Google-Summer-of-Code (2021)
Ashitabattu added a comment to T274636: Develop a web dashboard or a command line tool to help inventory and/or monitor database and backup objects.

Hi @jcrespo . Are there any microtasks I can contribute to, in order to get a better understanding of the project - 'MYSQL account metadata inventory'?

Apr 6 2021, 9:47 AM · Google-Summer-of-Code (2021)

Apr 1 2021

Ashitabattu added a comment to T274636: Develop a web dashboard or a command line tool to help inventory and/or monitor database and backup objects.

1)Is the database host("db1115.eqiad.wmnet") mentioned in script directly accessible from the public network or should I be using some VPN to connect to it?

The host is not publicly accessible, nor it will be made accessible for the student working on this project. This is a programming project, so no special access will be provided to people working on it. This is not something special about GSoC, not even most of employees and volunteers have access to the underlying infrastructure.

You can assume that the application will have direct access, and you should be able to setup your own database for development. Export of the several database is made available. Although we might be able to provide testing virtual machines (we did it last year) that may serve as "staging" for the project, to prove the project works on an identical environment to production.

2)How are entries inserted into instances table?

Right now, manually, using SQL. The whole point of the project is to create an interface to make that easier- both for manual operation and potentially, automatic too (e.g. for example, with a REST api). What writes to it is not in scope of the project, at least not at this stage.

How are new users created i.e how are rows inserted into mysql.users?

You won't have to handle that, that is infrastructure, so out of the scope of the project. MySQL and server setup is already "solved" through our configuration management. Authentication, configuration, server management, security are not part of the scope to solve. However, one is expected to use security best practices (eg. avoiding SQL injection, XSS, etc.).

4)Would I get access to the db instances so that I can have a look at the other columns?

Not sure what you mean with "other columns". A structure export has been provided already. I can provide example content if useful, but for a proposal the mockup should be enough to understand the kind of data that could be stored there. More details will be provided during the analysis/development phase. Again, no access will be provided to the student to any production resources.

5)How do I test things I've coded. Would there be a staging setup or should I test things on my local machine?

Yes, if possible you will have a development environment on your machine. But we may be able to provide a staging environment on WMF Cloud (we did it last year by asking for a couple of VPSs), including a very similar configuration management setup.

Apr 1 2021, 5:33 PM · Google-Summer-of-Code (2021)

Mar 30 2021

Ashitabattu added a comment to T274636: Develop a web dashboard or a command line tool to help inventory and/or monitor database and backup objects.

Hi @jcrespo.
For the 'MYSQL account metadata inventory', I have a couple of questions regarding it's relevant script.

Mar 30 2021, 5:39 PM · Google-Summer-of-Code (2021)