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 http://i.imgur.com/qZeJHBw.jpg 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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> > 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 > _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
