Today I upgraded to Postgresql 9.0 and web2py 1.98.2 (on Mac OS X Snow
Leopard). To test the environment I created a Login Role and Database
in pgAdmin III and entered the following connection string in db.py:

db = DAL('postgres://myusername:mypassword@localhost:5432/mydatabase')

Now, when I start up web2py from the terminal I get the following
error:

Traceback (most recent call last):
  File "/Library/Python/2.5/site-packages/web2py/gluon/restricted.py",
line 192, in restricted
    exec ccode in environment
  File "/Library/Python/2.5/site-packages/web2py/applications/init/
models/db.py", line 17, in <module>
    db = DAL('postgres://myusername:mypassword@localhost:5432/
mydatabase')       # if not, use SQLite or other DB
  File "/Library/Python/2.5/site-packages/web2py/gluon/dal.py", line
3969, in __init__
    self._adapter = ADAPTERS[self._dbname](*args)
  File "/Library/Python/2.5/site-packages/web2py/gluon/dal.py", line
1735, in __init__
    raise SyntaxError, "Invalid URI string in DAL"
SyntaxError: Invalid URI string in DAL


I hope one of you knows how to solve this problem.


Kind regards,

Annet.

Reply via email to