[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