[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-08 Thread mdipierro
:-) On Aug 8, 3:31 pm, Zhe Li wrote: > Finally!! It works now! I switched my dev server to ubuntu 9.10 and > everything works now! I couldn't find a repository for python2.5- > psycopg2 in ubuntu 10.04 so I didn't try that. > > Regards, > Zhe > > On Aug 8, 8:57 pm, Zhe Li wrote: > > > Just now I

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-08 Thread Zhe Li
Finally!! It works now! I switched my dev server to ubuntu 9.10 and everything works now! I couldn't find a repository for python2.5- psycopg2 in ubuntu 10.04 so I didn't try that. Regards, Zhe On Aug 8, 8:57 pm, Zhe Li wrote: > Just now I found that it was using python2.5 and python2.5-psycopg2

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-08 Thread Zhe Li
Just now I found that it was using python2.5 and python2.5-psycopg2 in the script, but in ubuntu 10.04 they have been removed from repository. I will try to re-install it manually. Cheers, Zhe On Aug 8, 8:27 pm, Zhe Li wrote: > Just an interesting note. Yesterday after the fresh re-installation,

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-08 Thread Zhe Li
Just an interesting note. Yesterday after the fresh re-installation, I tried to run "python web2py.py -a 0 -i 0.0.0.0" without psycog2, it gave me an "unable to connect to db" too, but didn't say that psycopg2 is missing. Can it be the reason here? But I installed psycopg2 with apt-get it should se

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-08 Thread Zhe Li
Hi, I changed local all web2pyident to local all allmd5 in pg_hba.conf, but it still can't connect to it. but i can connect to the database using: sudo -u www-data psql -h localhost labdb -U web2py Does that mean www

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-08 Thread mdipierro
aha! I think it is a problem with permissions of contect of databases folder. Make sure the apache/www-data user has permissions to read and write On Aug 8, 6:32 am, Zhe Li wrote: > Hi Massimo, > > Yes this time I was running it from a fresh installed ubuntu server so > PostgreSQL was using the d

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-08 Thread Zhe Li
Whoops, I was using local all web2pymd5 in pg_hba.conf. /Zhe On Aug 8, 1:32 pm, Zhe Li 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

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-08 Thread Zhe Li
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

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-07 Thread mdipierro
Didn't you say? db = DAL('postgres://web2py:12...@127.0.0.1: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 wrote: > Hi Massimo, > > I am using PostgreSQL 8.4. > > I added print(msg) and got the messa

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-07 Thread Zhe Li
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 t

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-07 Thread mdipierro
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 wrote: > Yeah, that works fine. It's so odd and frustrating... > > On Aug 6, 1:25 pm, mdi

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-06 Thread Zhe Li
Yeah, that works fine. It's so odd and frustrating... On Aug 6, 1:25 pm, mdipierro 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 wrote: > > > > > thanks! > > I tried to replace localhost with 127.0.0.1, 192.168.0.16 (it's

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-06 Thread mdipierro
I have no idea. Can you connect from a pure python shell using the driver API? On Aug 6, 5:55 am, Zhe Li 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 wrote: > > > Try

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-06 Thread Zhe Li
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 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

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-06 Thread mdipierro
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 wrote: > Hi, > > Thanks! This is the result from trunk. > > Error traceback > Traceback (most recent call last): >   File "gluon/restricted.py", line 186, in r

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-06 Thread Zhe Li
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 db = DAL('postgres://web2py:test...@

[web2py] Re: Failed to connect to PostgreSQL, deployed with setup_web2py_ubuntu.sh.

2010-08-06 Thread mdipierro
Please check the version in trunk. It should give you a more detailed error. On Aug 6, 3:06 am, Zhe Li 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: