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 <massimo.dipie...@gmail.com>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 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> 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> 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<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> 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/**defaul**
>>>>>> t/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.**require**s = 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.
>>>>>
>>>>> For more options, visit
>>>>> https://groups.google.com/**groups/opt_out<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.
>>>>
>>>> For more options, visit
>>>> https://groups.google.com/**groups/opt_out<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.
>>>
>>> For more options, visit
>>> https://groups.google.com/**groups/opt_out<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.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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.
