in RDF

An OpenID roster

I recently added OpenID support to my WordPress blog installation, and asked folks to test it out by leaving OpenID-authenticated comments. Seems to be working OK. I had a couple of issues with over-zealous spam filters, and people have reported a few glitches with specific providers (see comments for detail). OpenID doesn’t remove the need for spam filters btw, since anyone can run an OpenID server.

I said I wanted to see about a machine-readable export of the collected ID list. While I’ve not got to that, SQL access is simple, so I’ll show that here for now. Perhaps someone else has time to hack on the Web-export problem?


mysql> select user_id, url from wp_openid_identities;

+---------+----------------------------------------------------+
| user_id | url                                                |
+---------+----------------------------------------------------+
|      46 | http://danbri.org/                                 |
|      47 | http://piercarlos.myopenid.com/                    |
|      48 | http://claimid.com/nslater                         |
|      49 | http://nmg.livejournal.com/                        |
|      50 | http://ivanherman.pip.verisignlabs.com/            |
|      51 | http://simone.pip.verisignlabs.com/                |
|      52 | http://tommorris.org/                              |
|      53 | http://mijnopenid.nl/is/joe                        |
|      54 | http://dagoneye.it/me.html                         |
|      55 | http://kidehen.idehen.net/dataspace/person/kidehen |
|      56 | http://www.wasab.dk/morten/                        |
|      57 | http://aberingi.pip.verisignlabs.com/              |
|      59 | http://decafbad.com/                               |
|      58 | http://dltj.org/                                   |
|      60 | http://openid.aol.com/koaliemoon                   |
|      61 | http://klokie.com/                                 |
|      62 | http://petenixey.myopenid.com/                     |
+---------+----------------------------------------------------+
17 rows in set (0.02 sec)

I’m calling this list an “openid roster”, by analogy with XMPP/Jabber. I’m not sure what associations the word has in other’s minds; from a quick search, it was originally used in military contexts first, but is now a general purpose term for a list of people. So, … here is an OpenID roster derrived from my blog comments system.

Add Comment Register



  1. Hello Dambri.

    My name come out of a google alert for aberingi and it was here.
    I am very happy with OpenID,
    I am using (testing) on top of

    aberingi.pip.verisignlabs.com,

    ClaimID and ClaimID+OpenID

    OpenID.es The Spanish one is working very well and it is very simple. It’s a beauty, and in my language.

    From here I want to support all the OpenID users.
    Jorge Aberingi
    [intranetalización]

  2. As an extra layer of security you could run the collected OpenIDs through Bot Bouncer. That way, you get the extra layer of CAPTCHA, but people only ever have to do it once.

    It would be interesting to see an automated RDF output of your visitors/commentors.