Topic on Extension talk:Echo

Granted REFERENCES right

10
Dcljr (talkcontribs)

Under Installation, it says:

  • The database user must have been granted the "REFERENCES" right for the database.

Umm… OK, so how does one check whether this requirement is satisfied?

Jdforrester (WMF) (talkcontribs)

If you run SHOW GRANTS FOR 'wikiuser'@'localhost'; (or whatever your DB user and access mechanism is) it should give back a result – see upstream docs.

Dcljr (talkcontribs)

This should be added to the article. I assume 'wikiuser' should match $wgDBuser from LocalSettings.php?

Jdforrester (WMF) (talkcontribs)

This should be added to the article.

I don't think it should; it will depend on what database back-end you as a sysadmin have chosen to install.

I assume 'wikiuser' should match $wgDBuser from LocalSettings.php?

Sorry, yes.

Dcljr (talkcontribs)

Oh, wait… were you saying that 'wikiuser' should be used as a literal string in the SHOW command? (As you can tell, I have not had to do anything with databases since I installed my wiki, years ago.)

Dcljr (talkcontribs)

Is that an answer to my question about adding the information to the article or about the wikiuser matching $wgDBuser (or both, hence the semicolon)?

Jdforrester (WMF) (talkcontribs)

Sorry for the confusion! Have edited my answer to cover both.

Dcljr (talkcontribs)

Thank you for the clarification. I still say we should add something like what you have told me here to the instructions. If I had a question about this, then others will, too. And if your answer was good enough for me (debatable? [wink]), then something like it should be good enough for others. If the addition covers the one or two most likely configurations for someone like me, who set up their wiki in essentially complete ignorance (just followed Manual:Installing MediaWiki, the comments in LocalSettings.php, and Manual:LocalSettings.php), then that will be better than the current situation (IMO). As you can see, my understanding of these things is tenuous at best, so I'd rather you (or someone else) actually choose the wording.

Dcljr (talkcontribs)

…Or if it would be correct to say, "This is almost always the case.", we can just say that. Anything is better than leaving a reader with no idea what to do.

Dcljr (talkcontribs)

I just made a change that applies to my case (and likely that of many like me, who don't know what they're doing).

Reply to "Granted REFERENCES right"