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.sp...@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 <starglider....@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 >> >> and it try to connect endlessly. >> >> Thank for your replay. >> >> >> >> >> On 8 September 2013 21:56, Dragan Matic <perakojotgen...@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/** >>>> 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+unsubscr...@googlegroups.com. >>> 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. >> > > > > -- > 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+unsubscr...@googlegroups.com. > 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.
