TypeError with AuthOpenId Plugin

[joe@…]

A new install of trac with a new install of authopenid gives the error "TypeError: not all arguments converted during string formatting" when entering an openid (it does not do this if a random string, or a url which is not an openid is entered)

With 'joe.neoturbine.net', which is delegated to 'sargas.myopenid.com' (same thing happens with my aol openid and yahoo), I get the following before being relayed:

Request parameters:

{'__FORM_TOKEN': u'76dd3ce9c86633ef985ec5f1',
 'openid_identifier': u'joe.neoturbine.net'}

User Agent was: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9) Gecko/2008051202 Firefox/3.0

System Information

Trac	0.11rc2
Python	2.4.4 (#1, Oct 23 2006, 13:58:00) [GCC 4.1.1 20061011 (Red Hat 4.1.1-30)]
setuptools	0.6c8
SQLite	3.3.6
pysqlite	1.1.7
Genshi	0.6dev-r888
mod_python	3.2.8
Subversion	1.4.3 (r23084)
jQuery:	1.2.3

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc2-py2.4.egg/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc2-py2.4.egg/trac/web/main.py", line 197, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-i686/egg/authopenid/authopenid.py", line 180, in process_request
  File "build/bdist.linux-i686/egg/authopenid/authopenid.py", line 257, in _do_verify
  File "/usr/lib/python2.4/site-packages/openid/consumer/consumer.py", line 354, in begin
    return self.beginWithoutDiscovery(service, anonymous)
  File "/usr/lib/python2.4/site-packages/openid/consumer/consumer.py", line 377, in beginWithoutDiscovery
    auth_req = self.consumer.begin(service)
  File "/usr/lib/python2.4/site-packages/openid/consumer/consumer.py", line 599, in begin
    assoc = self._getAssociation(service_endpoint)
  File "/usr/lib/python2.4/site-packages/openid/consumer/consumer.py", line 1157, in _getAssociation
    assoc = self.store.getAssociation(endpoint.server_url)
  File "/usr/lib/python2.4/site-packages/openid/store/sqlstore.py", line 18, in wrapped
    return self._callInTransaction(func, self, *args, **kwargs)
  File "/usr/lib/python2.4/site-packages/openid/store/sqlstore.py", line 172, in _callInTransaction
    ret = func(*args, **kwargs)
  File "/usr/lib/python2.4/site-packages/openid/store/sqlstore.py", line 220, in txn_getAssociation
    self.db_get_assocs(server_url)
  File "/usr/lib/python2.4/site-packages/openid/store/sqlstore.py", line 156, in func
    return self._execSQL(sql_name, *args)
  File "/usr/lib/python2.4/site-packages/openid/store/sqlstore.py", line 147, in _execSQL
    self.cur.execute(sql, str_args)
  File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 255, in execute
    self.rs = self.con.db.execute(SQL % parms)
TypeError: not all arguments converted during string formatting

[anonymous]

Also,

[root@x2 authopenid-plugin]# python setup.py -V

0.1

[root@x2 python-openid-2.2.0]# python setup.py -V

2.2.0

[Dalius]

Have you tried using pysqlite2 (​http://pypi.python.org/pypi/pysqlite/2.0.6)? That might be solution. As you can see from traceback problem is in python-openid library.

[joe@…]

Thanks, I installed python-sqlite2 in yum and that fixed it

Sorry for the trouble

[Dalius]

No problem. New ticket is registered for OpenID library: ​http://trac.openidenabled.com/trac/ticket/263#preview