[01:04:50] <freephile>	 Can someone help me with a DB query... I want to know who is watching wiki pages but hasn't edited in the last 2 years, ordered by the most watches
[01:05:32] <freephile>	 I have this query: but it times out in 30 seconds
[01:05:36] <freephile>	 SELECT wl_user user, u.user_name, count(*) watches, STR_TO_DATE(MAX(rev_timestamp),'%Y%m%d%H%i%s') 'latest edit' 
[01:05:37] <freephile>	 from watchlist w left join user u ON u.user_id = w.wl_user INNER JOIN revision r ON u.user_id = r.rev_user
[01:05:37] <freephile>	 WHERE 'latest edit' < (DATE_SUB(NOW(), INTERVAL 2 YEAR))
[01:05:37] <freephile>	 group by w.wl_user
[01:05:37] <freephile>	 ORDER BY watches desc;
[01:07:02] <freephile>	 https://paste.ubuntu.com/p/FtSpw6JXGd/
[04:18:53] <hns1>	 Hello --  I am trying to upgrade an old version of mediawiki to version 1.33.1 -- In the old version of the wiki that i am upgrading, the previous admin used pwauth to authenticate/validate user login and password.  The wiki was configured so that anyone could read, however you needed to authenticate to be able to write/edit.  I have tried many of
[04:18:54] <hns1>	 the LDAP authentication extensions and have not had success.  I was wondering if anyone might know of a way to invoke the same functionality in the latest version.  Thanks!
[04:21:37] <bawolff>	 The login to edit but everyone can read aspect is separate from the auth plugin part
[04:21:46] <bawolff>	 !wg GroupPermissions
[04:21:46] <wm-bot>	 https://www.mediawiki.org/wiki/Manual:%24wgGroupPermissions
[04:25:14] <hns1>	 Thanks Brian -  I will try installing the Auth plugin again -- i think i got a 500 error last time i tried to install it.  I will also look at the manual for group permissions.  Really appreciate the help!  Thanks
[04:25:52] <bawolff>	 AuthPlugin is the old system, so that part probably won't work with modern mediawiki
[04:26:19] <bawolff>	 Although i think there is still a compatibility shim maybe
[04:26:42] <hns1>	 That is what i had difficulty finding.
[04:29:58] <bawolff>	 Yeah, AuthPlugin back compatibility was removed in 3f717984c13b671 (MediaWiki 1.33)
[04:30:15] <bawolff>	 The new thing is called auth manager
[04:30:18] <bawolff>	 !authmanager
[04:30:18] <wm-bot>	 There is no such key, you probably want to try: !AuthManager, 
[04:30:24] <bawolff>	 !AuthManager
[04:30:24] <wm-bot>	 https://www.mediawiki.org/wiki/Manual:SessionManager_and_AuthManager
[04:30:37] <bawolff>	 You will probably have to find an extension designed to work with the new system
[04:31:32] <hns1>	 Thanks -- I'll give that a try again.  I found it a little difficult to understand as I am really new to this.
[04:43:50] <hns1>	 Hi -- I am going to do some more searching ...  Not sure how to get this to work.
[11:08:54] <xse>	 Hello, i'm experiencing  an error which looks a lot like https://www.mediawiki.org/wiki/Thread:Project:Support_desk/Issue_with_new_Firefox_9.0.1_/_Left_Navigation_box_display_UNDER_content
[11:09:23] <xse>	 The navigation bar appears to me way too at the bottom : https://i.imgur.com/ZsVxwBx.png
[11:09:49] <xse>	 But i don't use firefox, i use chrome, and i also get the same results on opera.
[11:10:06] <xse>	 Any similar behavior reported recently ?
[11:30:02] <freephile>	 in case anyone's interested, here's how you find users who haven't edited in two years having watchlist greater than 100 items https://paste.ubuntu.com/p/FGskpDSy9C/
[14:01:25] <wm-bot>	 Technical Advice IRC meeting starting in 60 minutes in channel #wikimedia-tech, hosts:  - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting
[14:51:09] <wm-bot>	 Technical Advice IRC meeting starting in 10 minutes in channel #wikimedia-tech, hosts: @Lucas_WMDE - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting
[17:29:04] <hns1>	 Hello - I was wondering if there might be someone who has set up authentication similar to pwauth?  I have an old version 1.23 of mediawiki which we are trying to upgrade and i am trying to configure functionality whereby users must authenticate against our ldap before being able to edit pages.
[18:06:55] <tgr>	 hns1: there was an LDAPAuthentication extension, but it's unmaintained and does not work well post 1.27
[18:07:19] <tgr>	 there's https://www.mediawiki.org/wiki/LDAP_hub although it looks a little scary
[18:11:00] <tgr>	 although if you are looking for a pwauth replacement then I think that's https://www.mediawiki.org/wiki/Extension:Auth_remoteuser ?