Off-site status information for cornerhost.com.

8/11/2007

mysql was down for about 10 minutes

Well, the waking Michal up when MySQL goes down idea works. :)

I got paged when MySQL started giving a "too many connections" error around 2:00AM EST. I logged in and got MySQL back up within 5 minutes.

Whatever the cause, it seems to have hit rather suddenly. I have a tool logging the mysql status every minute. There were only a handful of connections until 1:55, and then suddenly no word for nine minutes. So either there's a bug in my logging system or MySQL suddenly started taking forever to connect.

2007-08-11 01:53:02,112:INFO:root:found   4 threads. doing nothing.
2007-08-11 01:54:01,890:INFO:root:found   4 threads. doing nothing.
2007-08-11 01:55:01,580:INFO:root:found   3 threads. doing nothing.
2007-08-11 02:04:02,209:WARN:root:got 'too many connections' error; restarting

It's interesting that the automated attempt to restart failed. I'll have to look into that.

In any case, everything's working fine now. Total downtime seems to have been about 10 minutes.

8/10/2007

prototype OpenID server

Bradley Peters rocks! :)

Following the changes to the python openID example server that he posted to innercircle, I now have a prototype OpenID server that authenticates you based on your cornerhost username and password.

Still *very* experimental, and the URL will definitely change at some point, but you can try it out for yourself here:

https://hydrogen.sabren.com:4430/

8/08/2007

help wanted: simple openID server

I'd like to open Trac access to any cornerhost user, so you guys can post bug reports.

But: I don't want to open it up to the whole world. Several people have asked me about setting up an OpenID server based on the cornerhost logins, and Trac has an OpenID plugin, so authorizing people based on OpenID logins seems like a good way to go.

The problem is I don't know how to make the server.

I made a client just fine : http://withoutane.com/openid/

... But the server example was much more confusing.

There's an example server in the openid python library, which you can see here:

http://www.openidenabled.com/openid/libraries/python

... But it doesn't actually prompt you for a password, and I just haven't had time to connect the dots.

The code for checking a password at cornerhost boils down to one line:

   clerk.match(User, username=usr).getBeaker().ispasswd(usr,pwd)

But for the life of me, I can't figure out how to get that hooked into an OpenID server.

Can somebody help?

Extended code for the login is in BeakerAuth.py.

Blog Archive