mapping usernames to IP addresses - MediaWiki-l - lists.wikimedia.org

List overview All Threads
Download

mapping usernames to IP addresses

Links in Color

Header Tabs Extension

Reid Priedhorsky

4 Sep 2009 4 Sep '09

3:37 p.m.

Dear mediawikis,

We run a MediaWiki.

For each of our users, we would like to get a list of IP addresses that the user has used while logged in (or logged in from).

Is this possible? If so, how?

(I'm sure this has been answered already, but my Google-fu is failing me, so my apologies if this is a duplicate.)

Thanks,

Reid

Show replies by date

Fred Bauder

4 Sep 4 Sep

3:52 p.m.

New subject: [Mediawiki-l] mapping usernames to IP addresses

Reid,

That is done with the checkuser extension:

http://www.mediawiki.org/wiki/Extension:CheckUser

Fred

Dear mediawikis,

We run a MediaWiki.

For each of our users, we would like to get a list of IP addresses that the user has used while logged in (or logged in from).

Is this possible? If so, how?

(I'm sure this has been answered already, but my Google-fu is failing me, so my apologies if this is a duplicate.)

Thanks,

Reid

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Reid Priedhorsky

10 Sep 10 Sep

4:58 p.m.

New subject: [Mediawiki-l] mapping usernames to IP addresses

On 09/04/2009 02:52 PM, Fred Bauder wrote:

Reid Priedhorsky wrote:

...
We run a MediaWiki.

For each of our users, we would like to get a list of IP addresses that the user has used while logged in (or logged in from).

Is this possible? If so, how?

(I'm sure this has been answered already, but my Google-fu is failing me, so my apologies if this is a duplicate.)

That is done with the checkuser extension:

http://www.mediawiki.org/wiki/Extension:CheckUser

Thanks, Fred.

I'm happy to dig around in the database - that is preferred, actually.

We're interested in each IP that each user has *used*, whether viewing, editing, or anything else. Looking in the database schema, this does not appear to be possible... am I wrong?

Thanks,

Reid

Platonides

6:31 p.m.

New subject: [Mediawiki-l] mapping usernames to IP addresses

Reid Priedhorsky wrote:

...
http://www.mediawiki.org/wiki/Extension:CheckUser

Thanks, Fred.

I'm happy to dig around in the database - that is preferred, actually.

SELECT rc_ip FROM recentchanges; If you install CheckUser, it logs into its own table.

We're interested in each IP that each user has *used*, whether viewing, editing, or anything else. Looking in the database schema, this does not appear to be possible... am I wrong?

Thanks,

Reid

The edits are only recorded when they actually *did* something. You can always add code for more draconian logging, or combine with server logs, though.

6124

Age (days ago)

6130

Last active (days ago)

mediawiki-l@lists.wikimedia.org

3 comments

3 participants

tags (0)

participants (3)

Fred Bauder
Platonides
Reid Priedhorsky