MediaWiki installed, but I don't seem to have an administrator account - MediaWiki-l

Nomad of Norad (David C Hall)

2 Jun 2 Jun

5:10 a.m.

New subject: [Mediawiki-l] MediaWiki installed, but I don't seem to have an administrator account

Nomad of Norad (David C Hall) wrote:

Well, I finally got my MediaWiki up and running, and I have set it to not allow anonymous edits. However, I don't seem to have a user with Administrator rights. The system had prompted me to create the Admin user WikiSysop, with appropriate password, when I went to the original config page, but no such user exists on the resulting wiki. I have now created a regular account for myself, and as I have said, have now changed the LocalSettings.php to deny anonymous edits. How do I give myself admin capabilities on the site, now? Is it something I must insert into the LocalSettings.php? Once that is taken care of, one of the other things I want to do is set it up so people can sign up (create an account for themselves) but cannot edit pages or create new ones until I enable them to. That is, I want to set things up so I have to select which users can edit, rather than them being able to edit just by having created an account. But first things first, I guess...

Well, following the instructions at http://meta.wikimedia.org/wiki/Setting_user_rights_in_MediaWiki for phpMyAdmin, where I have entered "UPDATE user_rights SET ur_rights="bureaucrat,sysop" WHERE ur_user=1;" in the SQL query box, and have gotten: ----------cut-here---------- Error SQL query: UPDATE user_rights SET ur_rights = "bureaucrat,sysop" WHERE ur_user =1; MySQL said: Documentation #1146 - Table 'joshua-w_wiki.user_rights' doesn't exist ----------cut-here---------- Am I missing something? The final install went without error, so why do I seem to be missing tables in the wiki MySQL database? -- Nomad of Norad (David C. Hall) --- *TeamAmiga* nomad(a)joshua-wopr.com --- http://www.joshua-wopr.com/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - For a dementedly wacky sci-fi continue-the-story project, join my WebBBS. http://www.joshua-wopr.com/phpBB/index.php ---------------------------------------------------------- This is the Emergency Backup .Signature File, it kicks in if the Regular Backup .Signature File fails to load.

Reply

Nomad of Norad (David C Hall)

8:33 p.m.

New subject: [Mediawiki-l] MediaWiki installed, but I don't seem to have an administrator account

Thank you, that worked. That command sequence actually appears in the section talking about adding bureaucrat and sysop ranks for 1.5, but where it tells the technique to use in phpMyAdmin, it lists the *other* command to use, the same one from the phpMyAdmin instructions for 1.4 above it. Looks like they need to fix that. :-D Jan-Paul Köster wrote:

...

INSERT INTO user_groups (ug_user, ug_group) VALUES ('1', 'bureaucrat'); INSERT INTO user_groups (ug_user, ug_group) VALUES ('1', 'sysop'); Where '1' is the uer ID of the user you want to grant those rights to. Cheers, JP Nomad of Norad (David C Hall) wrote:

Nomad of Norad (David C Hall) wrote:

Well, I finally got my MediaWiki up and running, and I have set it to not allow anonymous edits. However, I don't seem to have a user with Administrator rights. The system had prompted me to create the Admin user WikiSysop, with appropriate password, when I went to the original config page, but no such user exists on the resulting wiki. I have now created a regular account for myself, and as I have said, have now changed the LocalSettings.php to deny anonymous edits. How do I give myself admin capabilities on the site, now? Is it something I must insert into the LocalSettings.php? Once that is taken care of, one of the other things I want to do is set it up so people can sign up (create an account for themselves) but cannot edit pages or create new ones until I enable them to. That is, I want to set things up so I have to select which users can edit, rather than them being able to edit just by having created an account. But first things first, I guess...

Well, following the instructions at http://meta.wikimedia.org/wiki/Setting_user_rights_in_MediaWiki for phpMyAdmin, where I have entered "UPDATE user_rights SET ur_rights="bureaucrat,sysop" WHERE ur_user=1;" in the SQL query box, and have gotten: ----------cut-here---------- Error SQL query: UPDATE user_rights SET ur_rights = "bureaucrat,sysop" WHERE ur_user =1; MySQL said: Documentation #1146 - Table 'joshua-w_wiki.user_rights' doesn't exist ----------cut-here---------- Am I missing something? The final install went without error, so why do I seem to be missing tables in the wiki MySQL database?

_______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

-- Nomad of Norad (David C. Hall) --- *TeamAmiga* nomad(a)joshua-wopr.com --- http://www.joshua-wopr.com/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - For a dementedly wacky sci-fi continue-the-story project, join my WebBBS. http://www.joshua-wopr.com/phpBB/index.php ---------------------------------------------------------- This is the Emergency Backup .Signature File, it kicks in if the Regular Backup .Signature File fails to load.

Reply

Nomad of Norad (David C Hall)

10:11 p.m.

New subject: [Mediawiki-l] MediaWiki installed, but I don't seem to have an administrator account

Thank you, that did the trick. Interestingly, once it was in place, I couldn't even edit as sysop and bureaucrat, I had to make myself an editor, too. :-D Well, thankfully now spammers will not be able to hijack my wiki, even as they're trying to co-opt my webforum... Alexis Moinet wrote:

...

Nomad of Norad (David C Hall) a écrit :

Once that is taken care of, one of the other things I want to do is set it up so people can sign up (create an account for themselves) but cannot edit pages or create new ones until I enable them to.

I was looking for the same thing and I did this : In localsettings.php $wgGroupPermissions['*' ]['read'] = true; $wgGroupPermissions['*' ]['edit'] = false; $wgGroupPermissions['*' ]['talk'] = false; $wgGroupPermissions['*' ]['createpage'] = false; $wgGroupPermissions['*' ]['createtalk'] = false; $wgGroupPermissions['user']['move'] = false; $wgGroupPermissions['user']['read'] = true; $wgGroupPermissions['user']['edit'] = false; $wgGroupPermissions['user']['createpage'] = false; $wgGroupPermissions['user']['createtalk'] = false; $wgGroupPermissions['user']['talk'] = false; $wgGroupPermissions['user']['upload'] = false; $wgGroupPermissions['user']['reupload'] = false; $wgGroupPermissions['user']['reupload-shared'] = false; $wgGroupPermissions['user']['minoredit'] = false;

That is, I want to set things up so I have to select which users can edit, rather than them being able to edit just by having created an account.

in localsettings.php : $wgGroupPermissions['editor']['move'] = true; $wgGroupPermissions['editor']['read'] = true; $wgGroupPermissions['editor']['edit'] = true; $wgGroupPermissions['editor']['talk'] = true; $wgGroupPermissions['editor']['createpage'] = true; $wgGroupPermissions['editor']['createtalk'] = true; $wgGroupPermissions['editor']['upload'] = true; $wgGroupPermissions['editor']['reupload'] = true; $wgGroupPermissions['editor']['reupload-shared'] = true; $wgGroupPermissions['editor']['minoredit'] = true; this will make a new group ('editor') available and as a sysop/bureaucrat, you can allow the editor status to any user you want simply adding them in the editor group. _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

-- Nomad of Norad (David C. Hall) --- *TeamAmiga* nomad(a)joshua-wopr.com --- http://www.joshua-wopr.com/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - For a dementedly wacky sci-fi continue-the-story project, join my WebBBS. http://www.joshua-wopr.com/phpBB/index.php ---------------------------------------------------------- This is the Emergency Backup .Signature File, it kicks in if the Regular Backup .Signature File fails to load.

Reply