Hello,
I would like to query the wiki database to get a list of users with their last login time.
The user table doesn't have a field for last login. Maybe the information is somewhere in the logging table ?
Any help appreciated. -- francois.piette@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be
On 10/15/09 1:21 AM, Francois Piette wrote:
Hello,
I would like to query the wiki database to get a list of users with their last login time.
The user table doesn't have a field for last login. Maybe the information is somewhere in the logging table ?
Logins are not logged as such by MediaWiki.
Note that the user_touched cache invalidation timestamp updates on logins, preference changes, notifications, etc, but doesn't necessarily imply an action by the user themselves.
Note also that any particular session doesn't necessarily require going through the login form, as with a saved login token a user may remain logged in for up to a month within the same browser.
-- brion
Hello Brion,
I would like to query the wiki database to get a list of users with their last login time.
The user table doesn't have a field for last login. Maybe the information is somewhere in the logging table ?
Logins are not logged as such by MediaWiki.
OK. Maybe there is a hook somewhere to plug in some extension to do that login ?
Note that the user_touched cache invalidation timestamp updates on logins, preference changes, notifications, etc, but doesn't necessarily imply an action by the user themselves.
Indeed.
Note also that any particular session doesn't necessarily require going through the login form, as with a saved login token a user may remain logged in for up to a month within the same browser.
Same question as above : is there a hook somewhere to plug in an extension that would log the user validation ? Even if the browser "remember" (cookie) that a user is already authenticated, that must be surely verified within the wiki. At this could be the place to log each access.
Thanks, -- francois.piette@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be
If you use some other form of authentication you can probably get what you want. Doesn't Active Directory log more than you need to know about users? Try using, looking at, or writing an Auth extension.
-Courtney
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Francois Piette Sent: Wednesday, October 21, 2009 2:49 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Last login time
Hello Brion,
I would like to query the wiki database to get a list of users with their last login time.
The user table doesn't have a field for last login. Maybe the information is somewhere in the logging table ?
Logins are not logged as such by MediaWiki.
OK. Maybe there is a hook somewhere to plug in some extension to do that login ?
Note that the user_touched cache invalidation timestamp updates on logins, preference changes, notifications, etc, but doesn't necessarily imply an action by the user themselves.
Indeed.
Note also that any particular session doesn't necessarily require going through the login form, as with a saved login token a user may remain logged in for up to a month within the same browser.
Same question as above : is there a hook somewhere to plug in an extension that would log the user validation ? Even if the browser "remember" (cookie) that a user is already authenticated, that must be surely verified within the wiki. At this could be the place to log each access.
Thanks, -- francois.piette@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be
On Wed, Oct 21, 2009 at 8:37 AM, Christensen, Courtney ChristensenC@battelle.org wrote:
If you use some other form of authentication you can probably get what you want. Doesn't Active Directory log more than you need to know about users? Try using, looking at, or writing an Auth extension.
-Courtney
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Francois Piette Sent: Wednesday, October 21, 2009 2:49 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Last login time
Hello Brion,
I would like to query the wiki database to get a list of users with their last login time.
The user table doesn't have a field for last login. Maybe the information is somewhere in the logging table ?
Logins are not logged as such by MediaWiki.
OK. Maybe there is a hook somewhere to plug in some extension to do that login ?
Note that the user_touched cache invalidation timestamp updates on logins, preference changes, notifications, etc, but doesn't necessarily imply an action by the user themselves.
Indeed.
Note also that any particular session doesn't necessarily require going through the login form, as with a saved login token a user may remain logged in for up to a month within the same browser.
Same question as above : is there a hook somewhere to plug in an extension that would log the user validation ? Even if the browser "remember" (cookie) that a user is already authenticated, that must be surely verified within the wiki. At this could be the place to log each access.
Thanks,
francois.piette@overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be
-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
As far as logging logins/logouts, there's the "StalkerLog" extension I wrote.
-Chad
If you use some other form of authentication you can probably get what you want. Doesn't Active Directory log more than you need to know about users? Try using, looking at, or writing an Auth extension.
Newer versions of Sun Directory Server (and OpenDS as well I think), will also track last login time.
V/r,
Ryan Lane
mediawiki-l@lists.wikimedia.org