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.
