[web2py] PostgreSQL DAL connection issue

2012-07-19 Thread Abhishek Gupta
Hi, I am encountering the exact same problem as mentioned by Lucas in one the earlier threads : msql db_name -U user_name -h localhost *works* * * import psycopg2 psycopg2.connect *works* * * python web2py.py -S app_name DAL(...) works too But, still I get error > RuntimeError: Failure to co

[web2py] postgresql DAL connection issue with Enforced SELinux

2011-09-27 Thread lucas
hello one and all, i have a thread down below and after much to do and getting no where fast with db = DAL('postgres://postgres:passwd@localhost/prac2') because permission was denied over and over no matter what i did. here is the previous post http://groups.google.com/group/web2py/browse_thread/

Re: [web2py] postgresql DAL connection issue

2011-09-25 Thread Mariano Reingart
Can you test: #python2.6 >import psycopg2 >psycopg2.connect(database="prac2", user="postgres", password="password", >host="localhost") Maybe the server is down, you have a firewall issue or your pg_hba.conf is not open for localhost connections: hostall all 127.0.0.1

[web2py] postgresql DAL connection issue

2011-09-25 Thread lucas
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. howe