<br><div class="gmail_quote">
<div lang="EN-US" link="blue" vlink="blue">
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">HI,</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I started zope from shell i.e. by using the following command – </span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">bin/zopectl fg</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">& it showed me the following error log:</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">/opt/zope/bin/runzope -X
debug-mode=on</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">2010-11-18 17:39:01 INFO
ZServer HTTP server started at Thu Nov 18 17:39:01 2010</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
Hostname: 0.0.0.0</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
Port: 8080</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">2010-11-18 17:39:01
ERROR Application Could not import Products.ZPsycopgDA </span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">Traceback (most recent
call last):</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/OFS/Application.py", line 709, in
import_product</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
product=__import__(pname, global_dict, global_dict, silly)</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Products/ZPsycopgDA/__init__.py", line 92, in?</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
import DA</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Products/ZPsycopgDA/DA.py", line 94, in?</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> from
db import DB</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Products/ZPsycopgDA/db.py", line 99, in?</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
import psycopg</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">ImportError: libpq.so.3:
cannot open shared object file: No such file or directory</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">Traceback (most recent
call last):</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Zope2/Startup/run.py", line 56, in ?</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> run()</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Zope2/Startup/run.py", line 21, in run</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
starter.prepare()</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Zope2/Startup/__init__.py", line 109, in
prepare</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
self.startZope()</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Zope2/Startup/__init__.py", line 300, in
startZope</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
Zope2.startup()</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Zope2/__init__.py", line 47, in startup</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
_startup()</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Zope2/App/startup.py", line 51, in startup</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
OFS.Application.import_products()</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/OFS/Application.py", line 686, in
import_products</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
import_product(product_dir, product_name, raise_exc=debug_mode)</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/OFS/Application.py", line 709, in
import_product</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
product=__import__(pname, global_dict, global_dict, silly)</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Products/ZPsycopgDA/__init__.py", line 92, in ?</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
import DA</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Products/ZPsycopgDA/DA.py", line 94, in ?</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> from
db import DB</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> File
"/opt/zope/lib/python/Products/ZPsycopgDA/db.py", line 99, in ?</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">
import psycopg</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold">ImportError: libpq.so.3:
cannot open shared object file: No such file or directory</span></font></b></p>
<p class="MsoNormal"><b><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon;font-weight:bold"> </span></font></b></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I am not able to understand from the above log what is going wrong with
ZPsycopgDA. </span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Can some one please guide me as to what is going wrong with it??</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">What do I need to do to solve this?</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">May be because of this error, I am not able to get the option ‘Add
ZPsycopg Database Connection’ in Add drop-down box of ZMI.</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Any help from you will be appreciated!</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">I urgently need help on this!</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Thanks a lot!!!!</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Regards,</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Smita Kamdar</span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<p class="MsoNormal"><font size="3" color="maroon" face="Times New Roman"><span style="font-size:12.0pt;color:maroon"> </span></font></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Message: 1<br>
Date: Wed, 17 Nov 2010 12:13:15 +0100<br>
From: Charlie Clark <<a href="mailto:charlie@egenix.com" target="_blank">charlie@egenix.com</a>><br>
Subject: Re: [Zope-DB] Fwd: Zope_Database_issue<br>
To: <a href="mailto:zope-db@zope.org" target="_blank">zope-db@zope.org</a><br>
Message-ID: <<a href="mailto:4CE3B8CB.7040204@egenix.com" target="_blank">4CE3B8CB.7040204@egenix.com</a>><br>
Content-Type: text/plain; charset=UTF-8<br>
<br>
Am 17.11.10 12:07, schrieb smita kamdar:</span></font></p><div class="im"><font size="3" face="Times New Roman"><br>
> Hi,<br>
><br>
> Thanks a lot for your suggestion!!<br>
><br>
> But I am specifically told to use ZPsycopgDA to connect zope &
postgres. I<br>
> am trying a lot to add a new ZPsycopg database connection from Zope<br>
> Management Interface screen, But that option does not exist in Add drop
-box<br>
> of Zope Management Interface screen. Should Zope software home & zope<br>
> Instance home be same?? If no then where should I install ZPsycopgDA??<br>
><br>
> Also do I need to install anything else other than ZPsycopgDA to connect<br>
> zope & postgres?<br>
><br>
> I am using Zope 2.11.4, python 2.4.4, Postgres 7.4.13, egenix 2.0.6 &<br>
> Psycopg 1.1.6<br>
><br>
> I am really in a mess! Really need your help!<br>
<br></font></div><font size="3" face="Times New Roman">
Hi Smita,<br>
<br>
if you can start Zope from the shell:<br>
<br>
bin/zopetcl fg<br>
<br>
You should get a Python traceback that says what is stopping the ZPsycopgDA<br>
starting.<br>
<br>
Charlie Clark<br>
--<br>
Charlie Clark<br>
eGenix.com<br>
<br>
Professional Python Services directly from the Source<br>
>>> >>> Python/Zope Consulting and Support ...
<a href="http://www.egenix.com/" target="_blank">http://www.egenix.com/</a><br>
>>> >>> mxODBC.Zope.Database.Adapter ...
<a href="http://zope.egenix.com/" target="_blank">http://zope.egenix.com/</a><br>
>>> >>> mxODBC, mxDateTime, mxTextTools ...
<a href="http://python.egenix.com/" target="_blank">http://python.egenix.com/</a><br>
________________________________________________________________________<br>
<br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 17 Nov 2010 11:29:16 +0000<br>
From: Richard Harley <<a href="mailto:richard@scholarpack.com" target="_blank">richard@scholarpack.com</a>><br>
Subject: Re: [Zope-DB] Zope-DB Digest, Vol 74, Issue 1<br>
To: <a href="mailto:zope-db@zope.org" target="_blank">zope-db@zope.org</a><br>
Message-ID: <<a href="mailto:4CE3BC8C.2070708@scholarpack.com" target="_blank">4CE3BC8C.2070708@scholarpack.com</a>><br>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>
<br>
Look at the event log and find out why psycopg is failing on startup. If<br>
you are using psycopg1, I think you need to put the psycopg in site<br>
packages.<br>
Whatever version of psycopg you are using you need to have the python<br>
module installed in the relevant python installation ie the one that is<br>
running Zope. But looking at the event log should help.<br>
<br>
Richard<br>
<br>
<br>
> Message: 2<div class="im"><br>
> Date: Tue, 16 Nov 2010 18:46:59 +0100<br>
> From: Andreas Jung<<a href="mailto:lists@zopyx.com" target="_blank">lists@zopyx.com</a>><br>
> Subject: Re: [Zope-DB] Zope_Database_issue<br>
> To: smita kamdar<<a href="mailto:smita.kamdar00@gmail.com" target="_blank">smita.kamdar00@gmail.com</a>><br>
> Cc: <a href="mailto:zope-db@zope.org" target="_blank">zope-db@zope.org</a><br></div>
> Message-ID:<br>
> <<a href="mailto:AANLkTimdhKoE_ur9tvP0keFOHQbz%2BqZ_x%2B61kbzhdPbT@mail.gmail.com" target="_blank">AANLkTimdhKoE_ur9tvP0keFOHQbz+qZ_x+61kbzhdPbT@mail.gmail.com</a>><br>
> Content-Type: text/plain; charset="windows-1252"<div class="im"><br>
><br>
> Try using Products.SQLAlchemyDA instead.<br>
><br>
> -aj<br>
><br>
> 2010/11/16 smita kamdar<<a href="mailto:smita.kamdar00@gmail.com" target="_blank">smita.kamdar00@gmail.com</a>><br>
><br>
><br>
>> Hi,<br>
>><br>
>><br>
>><br>
>> I am a beginner in zope with no prior experience. I am supposed to
setup a<br>
>> development environment with zope, postgres, python, openflow,
egenix&<br>
>> psycopg.<br>
>><br>
>><br>
>><br>
>> I have installed all of them on Red Hat Linux. All of them are
installed<br>
>> successfully.<br>
>><br>
>><br>
>><br>
>> I have properly installed Psycopg in the zope path i.e.<br>
>> (lib/python/Products)& that too with proper permissions.<br>
>><br>
>><br>
>><br>
>> Now after installing psycopg, when I restart zope, I am not able to
see the<br>
>> option ?Add ZPsycopg Database Connection? in the Zope Management
Screen.<br>
>><br>
>><br>
>><br>
>> And because of that I am not able to setup a database for the project.<br>
>><br>
>><br>
>><br>
>> I request you to please help me for this. Any advice from you will really<br>
>> help me in a great way.<br>
>><br>
>><br>
>><br>
>> Kindly suggest me something.<br>
>><br>
>><br>
>><br>
>> Thanks a lot!!<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> Thanks& Regards,<br>
>><br>
>> Smita Kamdar<br>
>><br>
>><br>
>> _______________________________________________<br>
>> Zope-DB mailing list<br>
>> <a href="mailto:Zope-DB@zope.org" target="_blank">Zope-DB@zope.org</a><br>
>> <a href="https://mail.zope.org/mailman/listinfo/zope-db" target="_blank">https://mail.zope.org/mailman/listinfo/zope-db</a><br>
>><br>
>><br>
>><br>
> </div></font><p></p>
</div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> </span></font></p>
</div>
</div>
</div>