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