exception: "ProgrammingError: Cannot operate on a closed database."

[AndrewStraw]

I think I installed the plugin properly, but when I try to login, I get:

Traceback (most recent call last):
  File "/var/lib/python-support/python2.5/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/var/lib/python-support/python2.5/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.5/site-packages/OpenIDAuth-0.1dev-py2.5.egg/openidauth/auth.py", line 162, in process_request
    self._start_login(req, req.args.get('openid_url'))
  File "/usr/lib/python2.5/site-packages/OpenIDAuth-0.1dev-py2.5.egg/openidauth/auth.py", line 205, in _start_login
    authreq = oidconsumer.begin(url)
  File "/usr/lib/python2.5/site-packages/openid/consumer/consumer.py", line 308, in begin
    return self.beginWithoutDiscovery(service)
  File "/usr/lib/python2.5/site-packages/openid/consumer/consumer.py", line 331, in beginWithoutDiscovery
    auth_req = self.consumer.begin(service)
  File "/usr/lib/python2.5/site-packages/openid/consumer/consumer.py", line 422, in begin
    nonce = self._createNonce()
  File "/usr/lib/python2.5/site-packages/openid/consumer/consumer.py", line 482, in _createNonce
    self.store.storeNonce(nonce)
  File "/usr/lib/python2.5/site-packages/openid/store/sqlstore.py", line 13, in wrapped
    return self._callInTransaction(func, self, *args, **kwargs)
  File "/usr/lib/python2.5/site-packages/openid/store/sqlstore.py", line 154, in _callInTransaction
    self.conn.rollback()
  File "/var/lib/python-support/python2.5/trac/db/sqlite_backend.py", line 177, in rollback
    self.cnx.rollback()
ProgrammingError: Cannot operate on a closed database.

I am using the svn version checked out today, Trac 10.4, the Python OpenID 1.2 combo pack, sqlite3, Python 2.5, and Ubuntu Feisty.

[AndrewStraw]

Hmm, changing from mod_python to FastCGI seems to have fixed the problem for me. I'm closing this ticket.

[Daniel Kahn Gillmor]

I'm getting this same problem under mod_python with trac 0.10.4, so i'm re-opening this ticket. This is a real problem, since trac needs to be able to run under mod python. the FastCGI workaround isn't an option for some folks who might very well want

[anonymous]

I can corroborate this error with mod_python 3.3.1, trac 0.10.4. FastCGI is non-free software so that's not an option.

According to the source code browser, ​http://trac-hacks.org/log/openidplugin/trunk/ was last changed 2006-12-21. Do we have an abandoned project here?

[Dalius]

If you want you can test this problem with AuthOpenIdPlugin which uses newer version of OpenID library which is potential source of problem.

[Dalius]

This problem solved in AuthOpenIdPlugin (​http://trac-hacks.org/ticket/2242).

[Ryan J Ollos]

Plugin is deprecated. See AuthOpenIdPlugin for an alternative.