[Zope] Invalid connection string

[Farrell, Troy]

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 )
>