Page MenuHomePhabricator
Create Task
Maniphest T255915

Write permission to the Database - s53794__leaderboard_p
Closed, InvalidPublic
Actions

Description

Hi,

I am a Google Summer of Code 2020 student working on the project - https://phabricator.wikimedia.org/T248341

I created a database

s53794__leaderboard

in the tool https://toolsadmin.wikimedia.org/tools/id/commons-android-app but when I try to access it in my API it is using the

s53794__leaderboard_p

version instead of

s53794__leaderboard

so I need to write permission to the _p version of my database.

Here is my API - https://phabricator.wikimedia.org/R2364:99ddaae91818922c8684ec2da527aaa2c93eba41

and here are the logs

2020-06-19.png (510×1 px, 42 KB)

Related Objects

Event Timeline

Madhurgupta10 created this task.Jun 20 2020, 2:52 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 20 2020, 2:52 PM
Aklapper closed this task as Invalid.Jun 20 2020, 3:06 PM
Aklapper added a subscriber: maskaravivek.

so I need to write permission to the _p version of my database.

Drawing that conclusion does not convince me. :) The _p suffix is used for replica databases.
Also see https://meta.stackexchange.com/questions/66377/what-is-the-xy-problem#answer-66378

I think that the "Not done" comment in https://phabricator.wikimedia.org/R2364:99ddaae91818922c8684ec2da527aaa2c93eba41 is the thing to fix instead?
(Feel free to correct me and reopen this ticket.)

Madhurgupta10 added a comment.Jun 20 2020, 4:01 PM

@Aklapper I understand, my initial thought was to simply get the write access to the _p database which was getting connected by default but doesn't seem like a suitable solution.

I would then proceed with the suggestion from my mentor that I should create a user, but I am unable to create a user inside of it.

2020-06-19 (1).png (370×581 px, 19 KB)

Also, I want to use MySQL instead of MariaDB but if I run MySQL on the command line it opens MariaDB again? Any clue what could be the reason?

Aklapper added a comment.Jun 20 2020, 5:11 PM

Also, I want to use MySQL instead of MariaDB but if I run MySQL on the command line it opens MariaDB again? Any clue what could be the reason?

You don't explain your motivation or which problem you'd like to solve by using MySQL instead of MariaDB. Or why one would make any real difference. :) I don't run Debian but I'd expect symlinks. which mariadb and which mysql print where executables are located; ls -al for each output can tell you if one is a symlink.

Madhurgupta10 added a comment.Jun 20 2020, 6:12 PM

I managed to get my API running somehow :)

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL