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: windows XP and postgresql 8.1,
> everything local, no root user, but now trys 5 seconds
> and give this error:
> <type 'exceptions.RuntimeError'> 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/make_web2py/web2py/gluon/dal.py", line 2648, in
> __init__ File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 627,
> in reconnect File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line
> 579, in after_connection_hook File
> "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 2652, in
> after_connection File "/home/mdipierro/make_web2py/web2py/gluon/dal.py",
> line 1784, in execute File
> "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1778, in
> log_execute File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/dbapi.py", line
> 246, in _fn File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/dbapi.py", line
> 317, in execute File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/dbapi.py", line
> 322, in _execute File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/interface.py",
> line 399, in execute File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/interface.py",
> line 169, in execute File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/protocol.py", line
> 943, in _fn File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/protocol.py", line
> 1142, in bind File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/protocol.py", line
> 911, in handle_messages File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/protocol.py", line
> 1181, in _bind_nodata File
> "/home/mdipierro/make_web2py/web2py/gluon/contrib/pg8000/protocol.py", line
> 916, in handle_messages ProgrammingError: ('ERROR', '55P02', 'parameter
> "standard_conforming_strings" cannot be changed')
>
>
>
>
>
>
> On 9 September 2013 08:35, Johann Spies <johann...@gmail.com <javascript:>
> > wrote:
>
>> 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,
>> modify your pg_hba.conf if necessary, apply the correct configuration for
>> that user in web2py.
>>
>> Regards
>> Johann
>>
>>
>> On 8 September 2013 23:07, starglider.dev <stargli...@gmail.com<javascript:>
>> > wrote:
>>
>>> 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/extract_pgsql_models.py
>>>
>>> and it try to connect endlessly.
>>>
>>> Thank for your replay.
>>>
>>>
>>>
>>>
>>> On 8 September 2013 21:56, Dragan Matic <perakoj...@gmail.com<javascript:>
>>> > wrote:
>>>
>>>> Postgres probably doesn't have 'root' as user. Its root user is
>>>> 'postgres'.
>>>>
>>>> After that check if your address is allowed to connect to postgres
>>>> server in pg_hba.conf and if server is listening on your network
>>>> ('listen_addresses' setting in postgresql.conf). It could also be a
>>>> firewall issue, check is port 5432 is open.
>>>>
>>>> On Sunday, September 8, 2013 5:47:38 PM UTC+2, Sartglider wrote:
>>>>>
>>>>> Hi,
>>>>> I'm really new to web2py - less than 24 hours -
>>>>> Trying to follow this example http://web2py.com/books/**
>>>>> default/chapter/29/03/**overview#Say-hello<http://web2py.com/books/default/chapter/29/03/overview#Say-hello>
>>>>> it worked fine with sqlite, so I try to connect to a postgresql
>>>>> database in another server:
>>>>> the model is this one:
>>>>> db = DAL("postgres://root:<**password>@192.168.0.98/teste")
>>>>>
>>>>> db.define_table('equipments',
>>>>> Field('eq_id', unique=True),
>>>>> Field('eq_model'),
>>>>> Field('eq_aka'),
>>>>> format = '%(title)s')
>>>>>
>>>>> db.equipments.eq_id.requires = IS_NOT_IN_DB(db, db.equipments.eq_model)
>>>>> db.equipments.eq_model.**requires = IS_IN_DB(db, db.equipments.eq_id,
>>>>> '%(title)s')
>>>>>
>>>>> db.equipments.eq_id.writable = False
>>>>>
>>>>> but I get no errors just the browser trying to connect.
>>>>>
>>>>> Thank you in advance for your help.
>>>>>
>>>>>
>>>>> Postgresq server: debian 6 & postgresql 8.4
>>>>> web2Py server: debian 7, python 2.7
>>>>>
>>>>> --
>>>>
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "web2py-users" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to web2py+un...@googlegroups.com <javascript:>.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>
>>> --
>>>
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "web2py-users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to web2py+un...@googlegroups.com <javascript:>.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>
>>
>> --
>> Because experiencing your loyal love is better than life itself,
>> my lips will praise you. (Psalm 63:3)
>>
>> --
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+un...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
