TracError: Cannot load Python bindings for PostgreSQL

[David Genest]

Hi, 

Not sure what changed in my hosting environment, but when I upgraded an extension (mercurial plugin that was failing), trac ceased to work saying it cannot load Python bindings for PostgreSQL. But everything was workihg before. 

I have psycopg2 installed. Trac was working.

Tried upgrading to latest trac. Still broken.

Note that I can load psycopg2 from a python prompt. I can also run without errors when I create an environment manually in a python shell.

The log posted below mentions exception while checking for upgrade. Is it possible to disable the upgrade checking to see if it's related to that? There is also an AttributeError in AdminModule. 

Can anybody help ? Thanks.

David.

Here is the relevant part of my log:

2012-05-23 20:11:24,790 Trac[env] ERROR: Exception caught while checking for upgrade: 

Traceback (most recent call last):

  File "/home/iekho/lib/python2.7/trac/env.py", line 667, in open_environment

    needs_upgrade = env.needs_upgrade()

  File "/home/iekho/lib/python2.7/trac/env.py", line 497, in needs_upgrade

    db = self.get_db_cnx()

  File "/home/iekho/lib/python2.7/trac/env.py", line 329, in get_db_cnx

    return get_read_db(self)

  File "/home/iekho/lib/python2.7/trac/db/api.py", line 90, in get_read_db

    return _transaction_local.db or DatabaseManager(env).get_connection()

  File "/home/iekho/lib/python2.7/trac/db/api.py", line 150, in get_connection

    connector, args = self.get_connector()

  File "/home/iekho/lib/python2.7/trac/db/api.py", line 195, in get_connector

    raise TracError(connector.error)

TracError: Cannot load Python bindings for PostgreSQL

2012-05-23 20:11:24,790 Trac[env] WARNING: base_url option not set in configuration, generated links may be incorrect

2012-05-23 20:11:24,790 Trac[main] DEBUG: Dispatching <Request "GET '/'">

2012-05-23 20:11:24,804 Trac[chrome] DEBUG: Prepare chrome data for request

2012-05-23 20:11:24,808 Trac[session] DEBUG: Retrieving session for ID 'david'

2012-05-23 20:11:24,809 Trac[main] ERROR: can't retrieve session: TracError: Cannot load Python bindings for PostgreSQL

2012-05-23 20:11:24,810 Trac[chrome] ERROR: Error with navigation contributor AdminModule: AttributeError: 'FakePerm' object has no attribute 'has_permission'

2012-05-23 20:11:24,811 Trac[api] INFO: Synchronized '(default)' repository in 0.01 seconds

2012-05-23 20:11:24,812 Trac[main] WARNING: HTTPInternalError: 500 Trac Error (Cannot load Python bindings for PostgreSQL)

Thanks. 

[David Genest]

Ok, I found a fix for my problem. I removed my setuptools.pth file on my host (webfaction)