Thanks for the suggestions. It may have been that I needed to restart
memcached after direct manipulations of the user tables.
What was really throwing me off was although I was in the xx_user_groups
table with sysop and bureaucrat (all of our permissions are just put of the
box configured and used across all wikis) when I would look at
Special:ListUsers&group=sysop I would see
I am not 100% sure how that list of groups after a name is generated, but
on the English wiki I see my groups (as well as the access right log
entries where I was granted those permissions, so perhaps it's tied to
that).
As a very quick and dirty hack, I modified the LocalSettings.php for the
specific language wiki to use $wgGroupsAddToSelf. When I first tried it I
got a message about a conflict, so I removed the manual entries from the
cs_user_groups table and tried again, and it worked as expected. I was able
to assign myself the sysop role. I now see my groups on the ListUsers page,
the entries are in the cs_user_groups, and I reverted the change in my
LocalSettings.php. I suspect the correct way to go about this is to
actually use what I assume is the master user in our wiki, SysOp (which has
the user_id of 1 and is the only user in all the language specific user
tables, which sysop permissions in all the language specific user_groups
tables.
I will certainly look into the GlobalUserGroups extension though, thanks
for that Brion. And thanks for the initial support John.
-Adam
On Wed, Feb 18, 2015 at 12:57 PM, Brion Vibber <bvibber(a)wikimedia.org>
wrote:
Someone on IRC also pointed out this extension:
https://www.mediawiki.org/wiki/Extension:GlobalUserGroups which may be
more
suited to your needs than something as heavyweight as CentralAuth. :D
-- brion
On Wed, Feb 18, 2015 at 10:55 AM, Brion Vibber <bvibber(a)wikimedia.org>
wrote:
A few quick notes --
Be warned that poking directly in the user_groups table can leave
in-cache
user data out of sync with the database. You
might have to restart
memcached if using it, or clear the objectcache table in the database,
depending on configuration.
More generally, remember that group membership doesn't do anything unless
the config is in $wgGroupPermissions -- so make sure you have a common
setup of permissions for all your wikis, or it might be seeing the group
but not conferring a permission from it.
Also, the group names are probably case sensitive -- 'SysOp' may not mean
the same as 'sysop'.
(Note that if you're using an authentication plugin you can override
things like group membership; on Wikimedia's sites these are provided via
CentralAuth extension. That might be overkill for your use if you only
need
to adjust a couple accounts.)
-- brion
On Wed, Feb 18, 2015 at 9:35 AM, Adam Hubble <adamhubble(a)gmail.com>
wrote:
> Hi there,
> I've recently been given control of a wiki which I believe is set up as
a
> wiki family for different languages. The
default wiki can be found at
>
http://wiki.magicjudges.org/en/w (and other languages are
>
http://wiki.magicjudges.org/XX/w, with XX being various language
codes).
>
> I am both bureaucrat and sysop on the English wiki (and see the
> appropriate
> entries in en_user_groups table). We have a shared database, but from
what
> I can tell not shared tables for most things,
as there are tables with
> every language prefix. The language specific user tables only have the
> SysOp user in. The language specific user_groups table has the groups
for
> the SysOp, WikiOp, and two previous wiki
admins.
>
> What I am trying to work out is how to make group permissions apply to
all
> the wikis in the family. I have manually
added rows to a language
specific
> user_groups table (in this case,
cs_user_groups), but when I access the
>
http://wiki.magicjudges.org/cs/w/Special:UserRights, I am being told I
> don't have permissions (like it's just seeing me as a normal user).
>
> What am I missing beyond adding these group permissions in the
user_group
table for
each language?
I am running MediaWiki 1.24.1, PHP 5.6.14 (php-fpm), and MariaDB 5.5.41.
Thanks in advance for any help or guidance that can be provided.
-Adam
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
