hello one and all, i am having difficultly connecting postgres 9.1 under web2py v1.98.2 on a centos 6.0 box which has python 2.6.5. i have psycopg2 2.4 installed and working in python when i run the test
#python2.6 web2py -S welcom -N -a 'password' then >import psycopg2 > works just fine. however, when i put db = DAL('postgres://postgres:passwd@localhost:5432/prac2') and attempt to click on database administrator, i get for the traceback Traceback (most recent call last): File "/opt/web-apps/web2py/gluon/restricted.py", line 192, in restricted exec ccode in environment File "/opt/web-apps/web2py/applications/prac2_with_postgresql/models/ db.py", line 83, in <module> db = DAL('postgres://root:@localhost:5432/prac2') File "/opt/web-apps/web2py/gluon/dal.py", line 3981, in __init__ raise RuntimeError, "Failure to connect, tried %d times:\n%s" % (attempts, error) RuntimeError: Failure to connect, tried 5 times: could not connect to server: Permission denied Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? any ideas on what i have not done properly??? thank you in advance and have a great day. lucas