Whoops, I was using local all web2py md5
in pg_hba.conf. /Zhe On Aug 8, 1:32 pm, Zhe Li <[email protected]> wrote: > Hi Massimo, > > Yes this time I was running it from a fresh installed ubuntu server so > PostgreSQL was using the default port. > > I changed the pool_size to 0 and tried a couple of combinations. Maybe > it is a configuration problem with my PostgreSQL? > > 1. If I run: > > sudo -u www-data python www-data/web2py -a 0 -i 0.0.0.0 > > I will got an error of "ProgrammingError: relation 'auth_group' > already exists". > > 2. visit the site runs on WSGI+apache gives me: > > RuntimeError: Failure to connect to DB. Tried 5 times > > 3. Launch site with the identical web2py code in my folder: > > python web2py.py -a 0 -i 0.0.0.0 > > it runs without any problems. > > Here is part of my pg_hba.conf: > > local all postgres ident > # TYPE DATABASE USER CIDR-ADDRESS METHOD > local all web2py ident > host all all 192.168.0.0/24 md5 > host all all 127.0.0.1/32 md5 > host all all ::1/128 md5 > > and my postgresql.conf is: > > listen_addresses = '*' # what IP address(es) to listen on; > port = 5432 # (change requires restart) > max_connections = 100 # (change requires restart) > > Thank you very much! > > Regards, > Zhe > > On Aug 8, 2:30 am, mdipierro <[email protected]> wrote: > > > > > Didn't you say? > > > db = DAL('postgres://web2py:[email protected]:1216/labdb', > > pool_size=10) > > > is the DB at port 1216 or 5432? > > Can you try with pool_size=0 just to isolate the problem. > > > On Aug 7, 6:42 pm, Zhe Li <[email protected]> wrote: > > > > Hi Massimo, > > > > I am using PostgreSQL 8.4. > > > > I added print(msg) and got the message when runnning python web2.py -a > > > 123, the string looks like > > > > dbname='labdb' user='web2py' host='localhost' port=5432 > > > password='test123' > > > > I only have this error when using web2py with WSGI. But if I go to the > > > shell from the admin page running with WSGI, I could use PostgreSQL > > > without any problems. I tried this: > > > > conn = psycopg2.connect("dbname='labdb' user='web2py' host='localhost' > > > port=5432 password='test123'") > > > > and it works, I successfully added a table and a test record... > > > > Thank you! > > > > Cheers, > > > Zhe > > > > On Aug 7, 5:30 pm, mdipierro <[email protected]> wrote: > > > > > One more test: > > > > > In gluon/sql.py > > > > > before line 957, print your connection string: > > > > print msg > > > > Would that connection string work on the shell? Which postgresql > > > > version are you using? > > > > > On Aug 6, 6:48 am, Zhe Li <[email protected]> wrote: > > > > > > Yeah, that works fine. It's so odd and frustrating... > > > > > > On Aug 6, 1:25 pm, mdipierro <[email protected]> wrote: > > > > > > > I have no idea. Can you connect from a pure python shell using the > > > > > > driver API? > > > > > > > On Aug 6, 5:55 am, Zhe Li <[email protected]> wrote: > > > > > > > > thanks! > > > > > > > I tried to replace localhost with 127.0.0.1, 192.168.0.16 (it's > > > > > > > actually ip). but it doesn't work.... > > > > > > > > Cheers, > > > > > > > Zhe > > > > > > > > On Aug 6, 12:33 pm, mdipierro <[email protected]> wrote: > > > > > > > > > Try replace > > > > > > > > > localhost > > > > > > > > with > > > > > > > > 127.0.0.1 > > > > > > > > and with the actual IP of the machine. It may not be serving on > > > > > > > > localhost > > > > > > > > > On Aug 6, 5:25 am, Zhe Li <[email protected]> wrote: > > > > > > > > > > Hi, > > > > > > > > > > Thanks! This is the result from trunk. > > > > > > > > > > Error traceback > > > > > > > > > Traceback (most recent call last): > > > > > > > > > File "gluon/restricted.py", line 186, in restricted > > > > > > > > > exec ccode in environment > > > > > > > > > File > > > > > > > > > "/home/www-data/web2py/applications/welcome/models/db.py", > > > > > > > > > line > > > > > > > > > 15, in <module> > > > > > > > > > db = > > > > > > > > > DAL('postgres://web2py:test...@localhost:1216/labdb') # > > > > > > > > > if not, use SQLite or other DB > > > > > > > > > File "gluon/sql.py", line 3911, in DAL > > > > > > > > > raise RuntimeError, "%s (tried 5 times)" % exception > > > > > > > > > RuntimeError: could not connect to server: Connection refused > > > > > > > > > Is the server running on host "localhost" and accepting > > > > > > > > > TCP/IP connections on port 1216? > > > > > > > > > could not connect to server: Connection refused > > > > > > > > > Is the server running on host "localhost" and accepting > > > > > > > > > TCP/IP connections on port 1216? > > > > > > > > > (tried 5 times) > > > > > > > > > Error snapshot > > > > > > > > > Detailed traceback description > > > > > > > > > Exception: <type 'exceptions.RuntimeError'>(could not connect > > > > > > > > > to > > > > > > > > > server: Connection refused Is the server running on host > > > > > > > > > "localhost" > > > > > > > > > and accepting TCP/IP connections on port 1216? could not > > > > > > > > > connect to > > > > > > > > > server: Connection refused Is the server running on host > > > > > > > > > "localhost" > > > > > > > > > and accepting TCP/IP connections on port 1216? (tried 5 > > > > > > > > > times)) > > > > > > > > > Python 2.6.5: /usr/bin/python > > > > > > > > > > This is odd since I can connect to it both from command-line > > > > > > > > > and > > > > > > > > > another machine using web2py account.... > > > > > > > > > > Cheers, > > > > > > > > > Zhe > > > > > > > > > > On Aug 6, 11:06 am, mdipierro <[email protected]> wrote: > > > > > > > > > > > Please check the version in trunk. It should give you a > > > > > > > > > > more detailed > > > > > > > > > > error. > > > > > > > > > > > On Aug 6, 3:06 am, Zhe Li <[email protected]> wrote: > > > > > > > > > > > > Hello everyone, > > > > > > > > > > > > I tried to deploy web2py on my ubuntu server using > > > > > > > > > > > setup_web2py_ubuntu.sh. Everything seemed fine except > > > > > > > > > > > when I switch > > > > > > > > > > > database from SQLite to PostgreSQL I got: > > > > > > > > > > > > Error traceback > > > > > > > > > > > Traceback (most recent call last): > > > > > > > > > > > File "gluon/restricted.py", line 178, in restricted > > > > > > > > > > > exec ccode in environment > > > > > > > > > > > File > > > > > > > > > > > "/home/www-data/web2py/applications/init/models/db.py", > > > > > > > > > > > line > > > > > > > > > > > 16, in <module> > > > > > > > > > > > db = > > > > > > > > > > > DAL('postgres://web2py:[email protected]:1216/labdb', > > > > > > > > > > > pool_size=10) > > > > > > > > > > > File "gluon/sql.py", line 3911, in DAL > > > > > > > > > > > raise RuntimeError, "Failure to connect to DB. Tried > > > > > > > > > > > 5 times" > > > > > > > > > > > RuntimeError: Failure to connect to DB. Tried 5 times > > > > > > > > > > > > but if I run the web server using: > > > > > > > > > > > > python web2.py > > > > > > > > > > > > it works fine. I got the same issue with MySQL as well. > > > > > > > > > > > > Could you tell me what the problem might be? Thanks! > > > > > > > > > > > > Cheers, > > > > > > > > > > > Zhe
