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

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Nomad of Norad (David C Hall)
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...

--
       Nomad of Norad (David C. Hall)  ---  *TeamAmiga*
[hidden email] --- 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.
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: MediaWiki installed, but I don't seem to have an administrator account

Nomad of Norad (David C Hall)
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*
[hidden email] --- 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.
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: MediaWiki installed, but I don't seem to have an administrator account

Jan-Paul Köster
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
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: MediaWiki installed, but I don't seem to have an administrator account

Alexis Moinet
In reply to this post by Nomad of Norad (David C Hall)
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
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: MediaWiki installed, but I don't seem to have an administrator account

Nomad of Norad (David C Hall)
In reply to this post by Jan-Paul Köster
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
> [hidden email]
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>


--
       Nomad of Norad (David C. Hall)  ---  *TeamAmiga*
[hidden email] --- 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.
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: MediaWiki installed, but I don't seem to have an administrator account

Nomad of Norad (David C Hall)
In reply to this post by Alexis Moinet
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
> [hidden email]
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>


--
       Nomad of Norad (David C. Hall)  ---  *TeamAmiga*
[hidden email] --- 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.
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

RE : MediaWiki installed, but I don't seem to have an administrator account

Alexis Moinet

of course, sysop is implicitly a user and you restricted the user's rights.

simply ad this :

$wgGroupPermissions['sysop']['move']            = true;
$wgGroupPermissions['sysop']['read']            = true;
$wgGroupPermissions['sysop']['edit']            = true;
$wgGroupPermissions['sysop']['createpage']      = true;
$wgGroupPermissions['sysop']['createtalk']      = true;
$wgGroupPermissions['sysop']['talk']            = true;
$wgGroupPermissions['sysop']['upload']          = true;
$wgGroupPermissions['sysop']['reupload']        = true;
$wgGroupPermissions['sysop']['reupload-shared'] = true;
$wgGroupPermissions['sysop']['minoredit']       = true;

sorry for not mentionning that point at first time ;-)


> Interestingly, once it was in place, I couldn't even edit as sysop and
> bureaucrat, I had to make myself an editor, too.  :-D

_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l