Zope_Database_issue

smita kamdar <[email protected]> Thu, 18 Nov 2010 12:59:39 +0530
Newsgroups gmane.comp.web.zope.database
Message-ID <[email protected]>
--===============0382355413399988078==
Content-Type: multipart/alternative; boundary=000e0cd47d96b5a97b04954ec00c

--000e0cd47d96b5a97b04954ec00c
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

HI,



I started zope from shell i.e. by using the following command =96



bin/zopectl fg



& it showed me the following error log:



*/opt/zope/bin/runzope -X debug-mode=3Don*

*2010-11-18 17:39:01 INFO ZServer HTTP server started at Thu Nov 18 17:39:0=
1
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=3D__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=3Ddebug_mode)*

*  File "/opt/zope/lib/python/OFS/Application.py", line 709, in
import_product*

*    product=3D__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 =91Add ZPsyco=
pg
Database Connection=92 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 <[email protected]>
Subject: Re: [Zope-DB] Fwd: Zope_Database_issue
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=3DUTF-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 <[email protected]>
Subject: Re: [Zope-DB] Zope-DB Digest, Vol 74, Issue 1
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

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<[email protected]>
> Subject: Re: [Zope-DB] Zope_Database_issue
> To: smita kamdar<[email protected]>
> Cc: [email protected]
> Message-ID:
>       <[email protected]<AANLk=
TimdhKoE_ur9tvP0keFOHQbz%2BqZ_x%[email protected]>
>
> Content-Type: text/plain; charset=3D"windows-1252"

>
> Try using Products.SQLAlchemyDA instead.
>
> -aj
>
> 2010/11/16 smita kamdar<[email protected]>
>
>
>>    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 reall=
y
>> help me in a great way.
>>
>>
>>
>> Kindly suggest me something.
>>
>>
>>
>> Thanks a lot!!
>>
>>
>>
>>
>>
>> Thanks&  Regards,
>>
>> Smita Kamdar
>>
>>
>> _______________________________________________
>> Zope-DB mailing list
>> [email protected]
>> https://mail.zope.org/mailman/listinfo/zope-db
>>
>>
>>
>

--000e0cd47d96b5a97b04954ec00c
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

<br><div class=3D"gmail_quote">








<div lang=3D"EN-US" link=3D"blue" vlink=3D"blue">

<div>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">HI,</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">=A0</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">I started zope from shell i.e. by using the followin=
g command =96 </span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">=A0</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">bin/zopectl fg</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">=A0</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">&amp; it showed me the following error log:</span></=
font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">=A0</span></font></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">/o=
pt/zope/bin/runzope -X
debug-mode=3Don</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">20=
10-11-18 17:39:01 INFO
ZServer HTTP server started at Thu Nov 18 17:39:01 2010</span></font></b></=
p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0=A0=A0=A0=A0
Hostname: 0.0.0.0</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0=A0=A0=A0=A0
Port: 8080</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">20=
10-11-18 17:39:01
ERROR Application Could not import Products.ZPsycopgDA =A0</span></font></b=
></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">Tr=
aceback (most recent
call last):</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/OFS/Application.py&quot;, line 709, in
import_product</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
product=3D__import__(pname, global_dict, global_dict, silly)</span></font><=
/b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Products/ZPsycopgDA/__init__.py&quot;, line 92, =
in?</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
import DA</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Products/ZPsycopgDA/DA.py&quot;, line 94, in?</s=
pan></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0 from
db import DB</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Products/ZPsycopgDA/db.py&quot;, line 99, in?</s=
pan></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
import psycopg</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">Im=
portError: libpq.so.3:
cannot open shared object file: No such file or directory</span></font></b>=
</p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">Tr=
aceback (most recent
call last):</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Zope2/Startup/run.py&quot;, line 56, in ?</span>=
</font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0 run()</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Zope2/Startup/run.py&quot;, line 21, in run</spa=
n></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
starter.prepare()</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Zope2/Startup/__init__.py&quot;, line 109, in
prepare</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
self.startZope()</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Zope2/Startup/__init__.py&quot;, line 300, in
startZope</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
Zope2.startup()</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Zope2/__init__.py&quot;, line 47, in startup</sp=
an></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
_startup()</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Zope2/App/startup.py&quot;, line 51, in startup<=
/span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
OFS.Application.import_products()</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/OFS/Application.py&quot;, line 686, in
import_products</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
import_product(product_dir, product_name, raise_exc=3Ddebug_mode)</span></f=
ont></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/OFS/Application.py&quot;, line 709, in
import_product</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
product=3D__import__(pname, global_dict, global_dict, silly)</span></font><=
/b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Products/ZPsycopgDA/__init__.py&quot;, line 92, =
in ?</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
import DA</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Products/ZPsycopgDA/DA.py&quot;, line 94, in ?</=
span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0 from
db import DB</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0 File
&quot;/opt/zope/lib/python/Products/ZPsycopgDA/db.py&quot;, line 99, in ?</=
span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0=A0=A0
import psycopg</span></font></b></p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">Im=
portError: libpq.so.3:
cannot open shared object file: No such file or directory</span></font></b>=
</p>

<p class=3D"MsoNormal"><b><font size=3D"3" color=3D"maroon" face=3D"Times N=
ew Roman"><span style=3D"font-size:12.0pt;color:maroon;font-weight:bold">=
=A0</span></font></b></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"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=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">Can some one please guide me as to what is going wro=
ng with it??</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">What do I need to do to solve this?</span></font></p=
>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">May be because of this error, I am not able to get t=
he option =91Add
ZPsycopg Database Connection=92 in Add drop-down box of ZMI.</span></font><=
/p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">=A0</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">Any help from you will be appreciated!</span></font>=
</p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">I urgently need help on this!</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">=A0</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">Thanks a lot!!!!</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">=A0</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">Regards,</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">Smita Kamdar</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">=A0</span></font></p>

<p class=3D"MsoNormal"><font size=3D"3" color=3D"maroon" face=3D"Times New =
Roman"><span style=3D"font-size:12.0pt;color:maroon">=A0</span></font></p>

<p class=3D"MsoNormal" style=3D"margin-bottom:12.0pt"><font size=3D"3" face=
=3D"Times New Roman"><span style=3D"font-size:12.0pt">=A0</span></font></p>

<div>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">Message: 1<br>
Date: Wed, 17 Nov 2010 12:13:15 +0100<br>
From: Charlie Clark &lt;<a href=3D"mailto:[email protected]" target=3D"_bl=
ank">[email protected]</a>&gt;<br>
Subject: Re: [Zope-DB] Fwd: Zope_Database_issue<br>
To: <a href=3D"mailto:[email protected]" target=3D"_blank">[email protected]<=
/a><br>
Message-ID: &lt;<a href=3D"mailto:[email protected]" target=3D"_b=
lank">[email protected]</a>&gt;<br>
Content-Type: text/plain; charset=3DUTF-8<br>
<br>
Am 17.11.10 12:07, schrieb smita kamdar:</span></font></p><div class=3D"im"=
><font size=3D"3" face=3D"Times New Roman"><br>
&gt; Hi,<br>
&gt;<br>
&gt; Thanks a lot for your suggestion!!<br>
&gt;<br>
&gt; But I am specifically told to use ZPsycopgDA to connect zope &amp;
postgres. I<br>
&gt; am trying a lot to add a new ZPsycopg database connection from Zope<br=
>
&gt; Management Interface screen, But that option does not exist in Add dro=
p
-box<br>
&gt; of Zope Management Interface screen. Should Zope software home &amp; z=
ope<br>
&gt; Instance home be same?? If no then where should I install ZPsycopgDA??=
<br>
&gt;<br>
&gt; Also do I need to install anything else other than ZPsycopgDA to conne=
ct<br>
&gt; zope &amp; postgres?<br>
&gt;<br>
&gt; I am using Zope 2.11.4, python 2.4.4, Postgres 7.4.13, egenix 2.0.6 &a=
mp;<br>
&gt; Psycopg 1.1.6<br>
&gt;<br>
&gt; I am really in a mess! Really need your help!<br>
<br></font></div><font size=3D"3" face=3D"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>
&gt;&gt;&gt; &gt;&gt;&gt; Python/Zope Consulting and Support ... =A0 =A0
=A0 =A0<a href=3D"http://www.egenix.com/" target=3D"_blank">http://www.egen=
ix.com/</a><br>
&gt;&gt;&gt; &gt;&gt;&gt; mxODBC.Zope.Database.Adapter ... =A0 =A0 =A0
=A0 =A0 =A0 <a href=3D"http://zope.egenix.com/" target=3D"_blank">http://zo=
pe.egenix.com/</a><br>
&gt;&gt;&gt; &gt;&gt;&gt; mxODBC, mxDateTime, mxTextTools ... =A0 =A0
=A0 =A0<a href=3D"http://python.egenix.com/" target=3D"_blank">http://pytho=
n.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 &lt;<a href=3D"mailto:[email protected]" target=
=3D"_blank">[email protected]</a>&gt;<br>
Subject: Re: [Zope-DB] Zope-DB Digest, Vol 74, Issue 1<br>
To: <a href=3D"mailto:[email protected]" target=3D"_blank">[email protected]<=
/a><br>
Message-ID: &lt;<a href=3D"mailto:[email protected]" target=
=3D"_blank">[email protected]</a>&gt;<br>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed<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>
&gt; Message: 2<div class=3D"im"><br>
&gt; Date: Tue, 16 Nov 2010 18:46:59 +0100<br>
&gt; From: Andreas Jung&lt;<a href=3D"mailto:[email protected]" target=3D"_bl=
ank">[email protected]</a>&gt;<br>
&gt; Subject: Re: [Zope-DB] Zope_Database_issue<br>
&gt; To: smita kamdar&lt;<a href=3D"mailto:[email protected]" target=
=3D"_blank">[email protected]</a>&gt;<br>
&gt; Cc: <a href=3D"mailto:[email protected]" target=3D"_blank">zope-db@zope=
.org</a><br></div>
&gt; Message-ID:<br>
&gt; =A0 =A0 =A0 &lt;<a href=3D"mailto:AANLkTimdhKoE_ur9tvP0keFOHQbz%2BqZ_x=
%[email protected]" target=3D"_blank">AANLkTimdhKoE_ur9tvP0keFOHQ=
[email protected]</a>&gt;<br>
&gt; Content-Type: text/plain; charset=3D&quot;windows-1252&quot;<div class=
=3D"im"><br>
&gt;<br>
&gt; Try using Products.SQLAlchemyDA instead.<br>
&gt;<br>
&gt; -aj<br>
&gt;<br>
&gt; 2010/11/16 smita kamdar&lt;<a href=3D"mailto:[email protected]"=
 target=3D"_blank">[email protected]</a>&gt;<br>
&gt;<br>
&gt;<br>
&gt;&gt; =A0 =A0Hi,<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; I am a beginner in zope with no prior experience. I am supposed to
setup a<br>
&gt;&gt; development environment with zope, postgres, python, openflow,
egenix&amp;<br>
&gt;&gt; psycopg.<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; I have installed all of them on Red Hat Linux. All of them are
installed<br>
&gt;&gt; successfully.<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; I have properly installed Psycopg in the zope path i.e.<br>
&gt;&gt; (lib/python/Products)&amp; =A0that too with proper permissions.<br=
>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; Now after installing psycopg, when I restart zope, I am not able t=
o
see the<br>
&gt;&gt; option ?Add ZPsycopg Database Connection? in the Zope Management
Screen.<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; And because of that I am not able to setup a database for the proj=
ect.<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; I request you to please help me for this. Any advice from you will=
 really<br>
&gt;&gt; help me in a great way.<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; Kindly suggest me something.<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; Thanks a lot!!<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; Thanks&amp; =A0Regards,<br>
&gt;&gt;<br>
&gt;&gt; Smita Kamdar<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; _______________________________________________<br>
&gt;&gt; Zope-DB mailing list<br>
&gt;&gt; <a href=3D"mailto:[email protected]" target=3D"_blank">Zope-DB@zope=
.org</a><br>
&gt;&gt; <a href=3D"https://mail.zope.org/mailman/listinfo/zope-db" target=
=3D"_blank">https://mail.zope.org/mailman/listinfo/zope-db</a><br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt; </div></font><p></p>

</div>

<p class=3D"MsoNormal"><font size=3D"3" face=3D"Times New Roman"><span styl=
e=3D"font-size:12.0pt">=A0</span></font></p>

</div>

</div>



</div>

--000e0cd47d96b5a97b04954ec00c--

--===============0382355413399988078==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Zope-DB mailing list
[email protected]
https://mail.zope.org/mailman/listinfo/zope-db

--===============0382355413399988078==--