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.