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
> 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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
