We just migrated a web2py app to a new server running ubuntu 11.10 LTS. We
are running with ngingx. We are supposed to have psycopg2 installed. Yet,
the app that used to work with postgres is now complaining that it can't
connect. Here's the ticket:
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/restricted.py", line 205, in restricted
exec ccode in environment
File "/home/www-data/web2py/applications/myapp/models/0_db.py", line 25,
in <module>
db = DAL('postgres://foobar:[email protected]:5432/foobar',
pool_size=20)
File "/home/www-data/web2py/gluon/dal.py", line 5968, in __init__
raise RuntimeError, "Failure to connect, tried %d times:\n%s" %
(attempts, tb)
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/dal.py", line 5955, in __init__
self._adapter = ADAPTERS[self._dbname](*args)
File "/home/www-data/web2py/gluon/dal.py", line 1999, in __init__
self.driver = drivers.get('pg8000')
AttributeError: 'list' object has no attribute 'get'
I've tried various things, including changing the DAL connector:
db = DAL('postgres://foobar ...')
db = DAL('postgres:psycopg2://foobar ...')
db = DAL('postgres:pg8000://foobar ...')
but they all fail to connect.
I know this has been reported in other threads, such
as http://www.web2py.com/examples/static/epydoc/web2py.gluon.dal-pysrc.html,
but I'm unable to get a connection to work. Any help is much appreciated.
Thanks.
