[Zope-DB] Re: PoPy Database Connection
Luis Muñiz
lmuniz@sunformacion.com
Tue, 23 Jul 2002 00:38:30 +0200
El sáb, 20 jul, Jose Gerardo decía:
> Date: 19 Jul 2002 10:29:38 -0600
> Subject: [Zope-DB] PoPy Database Connection
>
> Hello All. I finally got my Popy Product working, but now I'm trying to
> create a database connection, following the instrucions I fill the
> database connection string following the instruction on screen.
>
>
> user=username host=hostname dbname=dbname port=port password=password
> I just need the username dbname as the default value shows in the text
> area shows.
Are you sure that you can connect to the database via IP?
In </etc/postgres/postgresql.conf>, check that IP connections are allowed:
tcpip_socket = 1
Also, you need to authorize connections (in the following example, from
localhost) in </etc/postgres/pg_hba.conf> :
host my_db 127.0.0.1 255.0.0.0 trust
Test it by starting `psql -h localhost -p 5432 my_db'
Once you're able to work with `psql', retry with PoPy. It should work
smoothly!
--
- Luis Muñiz