[Zope] Re: ZPygres connection problem

Oleg Broytmann phd@phd.russ.ru
Sat, 15 Jul 2000 18:02:41 +0000 (GMT)


Followup2 to myself...

   I upgraded Postgres (7.0b5 to 7.0.2) and the problem magically went
away.

   Still, if anyone has an idea why Zope-PCGI could connect, while
Zope+ZServer couldn't - I'd be glad to hear.

On Sat, 15 Jul 2000, Oleg Broytmann wrote:
> Followup to myself...
> 
> On Sat, 15 Jul 2000, Oleg Broytmann wrote:
> >    I did an experiment (after having problems connecting Zope to Postgres)
> > - I stopped ZServer and restared Zope in PCGI-only mode.
> > 
> >    I opened connection successfully!
> > 
> >    I stopped PCGI and restarted ZServer. I again got BadRequest (cannot
> > connect to server).
> > 
> >    Anyone have an idea why Zope+ZServer cannot connect, while Zope-PCGI
> > can?
> > 
> >    Deeper investigation did not reveal any difference - environments are
> > the same, I can connect from command line, I can even import DB.py (from
> > the Database Adapter) and connect through it from command line...
> 
>    On different computer I did an experiment - and connected to MySQL
> pretty successfully from Zope+ZServer.
> 
>    Thoughts:
> 
> 1. MySQL vs. Postgres. No way - I can connect to Postgres from Zope-PCGI.
> 
> 2. MySQL DA vs. ZPygres DA. ZPygres DA is not ZServer (multithread) ready.
> 
> 3. Linux vs. Solaris; I run MySQL on Linux and Postgres on Solaris. But
> where is a difference? PyGreSQL compiled on Solaris with -R option and does
> not require LD_LIBRARY_PATH - the only difference I can think of.

Oleg.            (All opinions are mine and not of my employer)
---- 
    Oleg Broytmann      Foundation for Effective Policies      phd@phd.russ.ru
           Programmers don't die, they just GOSUB without RETURN.