Re: [pydotorg-www] Removing/disabling inactive users from wiki.python.org

2016-11-08 Thread Carl Karsten
On Tue, Nov 8, 2016 at 12:29 PM, M.-A. Lemburg  wrote:

> On 08.11.2016 16:31, Carl Karsten wrote:
> > On Tue, Nov 8, 2016 at 9:18 AM, M.-A. Lemburg  wrote:
> >
> >> Since we currently have more than 88k user records for the Python
> >> wiki,
> >>
> >
> >
> > 88k surprises me.  Where did they come from?
>
> Many are probably from automated user record creation scripts
> and most of those likely from the days where we did not have
> textchas enabled.
>
> We're currently getting around 75 accounts created per day,
> so even with textchas, people have obviously found a way
> to work around them.
>

I figured it was something like that.  I had a dream that we had the names
of 88k python users that were active in some small way.


-- 
Carl K
___
pydotorg-www mailing list
pydotorg-www@python.org
https://mail.python.org/mailman/listinfo/pydotorg-www


Re: [pydotorg-www] Removing/disabling inactive users from wiki.python.org

2016-11-08 Thread M.-A. Lemburg
On 08.11.2016 16:32, Chris Angelico wrote:
> On Wed, Nov 9, 2016 at 2:18 AM, M.-A. Lemburg  wrote:
>> According to the tool inactive users are users who have never
>> edited a page on the wiki.
>>
> 
> Is it possible to get login stats for these users? Anyone who's never
> made an edit and hasn't logged in within the past, say, 12 months is
> almost certainly inactive. I'd purge them in the interests of
> improving wiki performance.

I believe the command doesn't use a cut-off date.

It is possible to manually keep user records, though, so
I could force keeping all records with an access date
within the last 12 months.

> Any user in EditorsGroup has to either be kept (ie considered active),
> or removed from EditorsGroup. Otherwise, someone could create an
> account and instantly have editing access.

Good point. Figuring out the account records from the user name
will require some scripting, though, since the records use
a UID as filename based on the user record creation time.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Experts (#1, Nov 08 2016)
>>> Python Projects, Coaching and Consulting ...  http://www.egenix.com/
>>> Python Database Interfaces ...   http://products.egenix.com/
>>> Plone/Zope Database Interfaces ...   http://zope.egenix.com/


::: We implement business ideas - efficiently in both time and costs :::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
   Registered at Amtsgericht Duesseldorf: HRB 46611
   http://www.egenix.com/company/contact/
  http://www.malemburg.com/

___
pydotorg-www mailing list
pydotorg-www@python.org
https://mail.python.org/mailman/listinfo/pydotorg-www


Re: [pydotorg-www] Removing/disabling inactive users from wiki.python.org

2016-11-08 Thread M.-A. Lemburg
On 08.11.2016 16:31, Carl Karsten wrote:
> On Tue, Nov 8, 2016 at 9:18 AM, M.-A. Lemburg  wrote:
> 
>> Since we currently have more than 88k user records for the Python
>> wiki,
>>
> 
> 
> 88k surprises me.  Where did they come from?

Many are probably from automated user record creation scripts
and most of those likely from the days where we did not have
textchas enabled.

We're currently getting around 75 accounts created per day,
so even with textchas, people have obviously found a way
to work around them.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Experts (#1, Nov 08 2016)
>>> Python Projects, Coaching and Consulting ...  http://www.egenix.com/
>>> Python Database Interfaces ...   http://products.egenix.com/
>>> Plone/Zope Database Interfaces ...   http://zope.egenix.com/


::: We implement business ideas - efficiently in both time and costs :::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
   Registered at Amtsgericht Duesseldorf: HRB 46611
   http://www.egenix.com/company/contact/
  http://www.malemburg.com/

___
pydotorg-www mailing list
pydotorg-www@python.org
https://mail.python.org/mailman/listinfo/pydotorg-www


Re: [pydotorg-www] Removing/disabling inactive users from wiki.python.org

2016-11-08 Thread Chris Angelico
On Wed, Nov 9, 2016 at 2:18 AM, M.-A. Lemburg  wrote:
> According to the tool inactive users are users who have never
> edited a page on the wiki.
>

Is it possible to get login stats for these users? Anyone who's never
made an edit and hasn't logged in within the past, say, 12 months is
almost certainly inactive. I'd purge them in the interests of
improving wiki performance.

Any user in EditorsGroup has to either be kept (ie considered active),
or removed from EditorsGroup. Otherwise, someone could create an
account and instantly have editing access.

ChrisA
___
pydotorg-www mailing list
pydotorg-www@python.org
https://mail.python.org/mailman/listinfo/pydotorg-www


Re: [pydotorg-www] Removing/disabling inactive users from wiki.python.org

2016-11-08 Thread Carl Karsten
On Tue, Nov 8, 2016 at 9:18 AM, M.-A. Lemburg  wrote:

> Since we currently have more than 88k user records for the Python
> wiki,
>


88k surprises me.  Where did they come from?





-- 
Carl K
___
pydotorg-www mailing list
pydotorg-www@python.org
https://mail.python.org/mailman/listinfo/pydotorg-www


[pydotorg-www] Removing/disabling inactive users from wiki.python.org

2016-11-08 Thread M.-A. Lemburg
Hello,

I have just upgraded the moin package on wiki.python.org to 1.9.9.
As part of this, we now have a new maintenance command to disable
or remove inactive users.

According to the tool inactive users are users who have never
edited a page on the wiki.

For wikis such as the PSF one, people do need a login to see some
of the pages, and editing is not necessarily done by everyone.

On the main wiki, I'm not aware of pages which are protected by
ACLs to require login to see (only to edit).

For Jython, I don't know at all, so won't touch this.

Since we currently have more than 88k user records for the Python
wiki, but only 4k active users, I'd like to experiment this command,
even though it's dangerous.

My feeling is that the slowness of the wiki is largely caused by
the many user records we have. Moin appears to these for subscriptions
when making edits to pages.

We have three options:
1. leave everything as is
2. disable all but the 4k active users who have made edits
3. remove all but the 4k active users who have made edits

Of course, we'd run a backup before applying any of this,
to be able to revert in case people complain.

Thoughts ?

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Experts (#1, Nov 08 2016)
>>> Python Projects, Coaching and Consulting ...  http://www.egenix.com/
>>> Python Database Interfaces ...   http://products.egenix.com/
>>> Plone/Zope Database Interfaces ...   http://zope.egenix.com/


::: We implement business ideas - efficiently in both time and costs :::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
   Registered at Amtsgericht Duesseldorf: HRB 46611
   http://www.egenix.com/company/contact/
  http://www.malemburg.com/

___
pydotorg-www mailing list
pydotorg-www@python.org
https://mail.python.org/mailman/listinfo/pydotorg-www