Yep. I saw the solved msg right after I sent the last message. The message about an invalid string is correct. The DA _could_ suggest checking the permissions, but it is behaving properly. It likely doesn't have permission to read the pg_hba.conf file and if the db were remote, it couldn't do so easily. While the error is good, it should suggest checking permissions. Glad it's working now. Troy

-----Original Message----- From: Russell Hires [mailto:rhires@earthlink.net] Sent: Monday, August 20, 2001 8:00 AM To: Farrell, Troy Cc: 'zope@zope.org' Subject: Re: [Zope] Invalid connection string

Well, I figured out why it's invalid: I didn't have the appropriate permissions to access the database itself. Once I checked the postgresql logs, I found that out. Then I changed the permissions in the pg_hba.conf file to allow local TCP/IP access, and I was able to connect.

I'm hoping the author of PoPy, Thierry Michel, can fix this and detect that there aren't adequate permissions in the db, rather than simply reporting the "Invalid connection string" error. Or is that a generic Zope problem?

Thanks for the suggestion, though.

Russell

On Monday 20 August 2001 08:47, Farrell, Troy wrote:

...

Try a variation on the following: user=troy password=password host=localhost port=5432 dbname=streamdatabase

Troy

...

-----Original Message----- From: Russell Hires [mailto:rhires@earthlink.net] Sent: Sunday, August 19, 2001 10:59 AM To: zope@zope.org Subject: [Zope] Invalid connection string

Hello everyone,

I've got PoPy running as a database adapter, except I must have a US plug to go into a European electrical outlet! When I follow the example for connecting PoPy to my PSQL database (which is empty), I get the "Invalid connection string" error. I saw a solution to this, but it looked like a hack. I followed the example, but no dice on this, either...

Anyone got any bright ideas on this?

Thanks!

Russell

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )