Re: [web2py] Re: Newby, can't connect to a Postgresl database

2013-09-11 Thread starglider.dev
Changed to Postgresql 9.1 and it worked, also I can connect to pqsl with root user. Thank you to all. On 9 September 2013 18:48, Massimo Di Pierro wrote: > You need postgresql 8.2+. postgresql 8.1 does not allow you changing the > string escaping and, by default, it is non conform to the SQL sta

Re: [web2py] Re: Newby, can't connect to a Postgresl database

2013-09-09 Thread Massimo Di Pierro
You need postgresql 8.2+. postgresql 8.1 does not allow you changing the string escaping and, by default, it is non conform to the SQL standard. This results in a security issue with web2py. You must upgrade. On Monday, 9 September 2013 10:43:55 UTC-5, Sartglider wrote: > > Change the platform:

Re: [web2py] Re: Newby, can't connect to a Postgresl database

2013-09-09 Thread starglider.dev
Change the platform: windows XP and postgresql 8.1, everything local, no root user, but now trys 5 seconds and give this error: Failure to connect, tried 5 times: Traceback (most recent call last): File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 7413, in __init__ File "/home/mdipierro

Re: [web2py] Re: Newby, can't connect to a Postgresl database

2013-09-09 Thread Johann Spies
Postgresql would not allow root as a database user. It is also not safe to work with 'postgres' as your normal user for normal day-to-day usage as postgres is the superuser for Postgresql. So you have to create a user in postgresql, create the correct database with the user you created as owner,

Re: [web2py] Re: Newby, can't connect to a Postgresl database

2013-09-08 Thread starglider.dev
Actually it as a root user because all application connect to the server by root, the other software is made with python & pscopg2. I try to connect by psql from the server that as web2py and it worked, also create a model with this script: https://github.com/phektus/cvstash/blob/master/scripts/ex