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 <char...@egenix.com>
Subject: Re: [Zope-DB] Fwd: Zope_Database_issue
To: zope-db@zope.org
Message-ID: <4ce3b8cb.7040...@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 <rich...@scholarpack.com>
Subject: Re: [Zope-DB] Zope-DB Digest, Vol 74, Issue 1
To: zope-db@zope.org
Message-ID: <4ce3bc8c.2070...@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<li...@zopyx.com>
> Subject: Re: [Zope-DB] Zope_Database_issue
> To: smita kamdar<smita.kamda...@gmail.com>
> Cc: zope-db@zope.org
> Message-ID:
>       
> <aanlktimdhkoe_ur9tvp0kefohqbz+qz_x+61kbzhd...@mail.gmail.com<aanlktimdhkoe_ur9tvp0kefohqbz%2bqz_x%2b61kbzhd...@mail.gmail.com>
>
> Content-Type: text/plain; charset="windows-1252"

>
> Try using Products.SQLAlchemyDA instead.
>
> -aj
>
> 2010/11/16 smita kamdar<smita.kamda...@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@zope.org
>> https://mail.zope.org/mailman/listinfo/zope-db
>>
>>
>>
>
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Reply via email to