Mailing List Archive

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/
________________________________________________________________________
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

HI,



I uninstalled Psycopg from my LINUX m/c & now zope is working fine.



Again I started installing psycopg-1.1.6 & in the first step itsef it gives
the following error:



[test@test psycopg-1.1.6]$. /configure

--prefix=/opt/zope/psycopg-1.1.6


--with-mxdatetime-includes=/home/test/egenix/2.0.6/mx/DateTime/mxDateTime


--with-postgres-includes=/home/postgres/7.4.13/src/include


--with-postgres-libraries=/home/postgres/7.4.13/lib

--with-zope=/opt/zope

loading cache ./config.cache

checking for python... /usr/bin/python

checking python version... 2.4

checking python installation prefix... /home/test/Python/2.4.4

checking python installation exec_prefix... /home/test/Python/2.4.4

checking definitions in Python library makefile... done

checking location of python library... $(prefix)/lib/python2.4/site-packages

checking location of python shared modules...
$(exec_prefix)/lib/python2.4/site-packages

checking for gcc... gcc -pthread

checking whether the C compiler (gcc -pthread ) works... yes

checking whether the C compiler (gcc -pthread ) is a cross-compiler... no

checking whether we are using GNU C... yes

checking whether gcc -pthread accepts -g... yes

checking how to run the C preprocessor... gcc -pthread -E

checking whether make sets ${MAKE}... yes

checking for inline... inline

*checking PostgreSQL version... configure: error: missing PostgreSQL headers
*



Is it because of this error that I am not able to solve the issue? Because
last time when I Installed Psycopg I faced the same error.



How shall I progress?



Please Note: Paths of the Directories where my installables are –



Zope --à /opt/zope

Python à /home/test/Python/2.4.4

Egenix -à /home/test/egenix

Postgresqlà /home/postgres/7.4.13

Psycopgà/opt/zope/psycopg-1.1.6

Are you sure that the header file are in /home/postgres/7.4.13/src/include? And are readable for the user "test"?

Normally I would expect to find them in something lik this

/home/postgres/7.4.13/include

M.

PS: Why don't you install everything as "root" in /opt/?


On Nov 19, 2010, at 14:40 , smita kamdar wrote:

>
>
>
> HI,
>
>
> I uninstalled Psycopg from my LINUX m/c & now zope is working fine.
>
>
> Again I started installing psycopg-1.1.6 & in the first step itsef it gives the following error:
>
>
> [test@test psycopg-1.1.6]$. /configure
>
> --prefix=/opt/zope/psycopg-1.1.6
>
> --with-mxdatetime-includes=/home/test/egenix/2.0.6/mx/DateTime/mxDateTime
>
> --with-postgres-includes=/home/postgres/7.4.13/src/include
>
> --with-postgres-libraries=/home/postgres/7.4.13/lib
>
> --with-zope=/opt/zope
>
> loading cache ./config.cache
>
> checking for python... /usr/bin/python
>
> checking python version... 2.4
>
> checking python installation prefix... /home/test/Python/2.4.4
>
> checking python installation exec_prefix... /home/test/Python/2.4.4
>
> checking definitions in Python library makefile... done
>
> checking location of python library... $(prefix)/lib/python2.4/site-packages
>
> checking location of python shared modules... $(exec_prefix)/lib/python2.4/site-packages
>
> checking for gcc... gcc -pthread
>
> checking whether the C compiler (gcc -pthread ) works... yes
>
> checking whether the C compiler (gcc -pthread ) is a cross-compiler... no
>
> checking whether we are using GNU C... yes
>
> checking whether gcc -pthread accepts -g... yes
>
> checking how to run the C preprocessor... gcc -pthread -E
>
> checking whether make sets ${MAKE}... yes
>
> checking for inline... inline
>
> checking PostgreSQL version... configure: error: missing PostgreSQL headers
>
>
> Is it because of this error that I am not able to solve the issue? Because last time when I Installed Psycopg I faced the same error.
>
>
> How shall I progress?
>
>
> Please Note: Paths of the Directories where my installables are –
>
>
> Zope --à /opt/zope
>
> Python à /home/test/Python/2.4.4
>
> Egenix -à /home/test/egenix
>
> Postgresqlà /home/postgres/7.4.13
>
> Psycopgà/opt/zope/psycopg-1.1.6
>
>
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> https://mail.zope.org/mailman/listinfo/zope-db

--
ETH Zürich
Michele Marcionelli
IT Support Gruppe D-MATH
HG G 32.1
Rämistrasse 101
CH–8092 Zürich

michele.marcionelli@math.ethz.ch
http://www.math.ethz.ch/~michele

+41 44 632 6193 Telefon
+41 44 632 1354 Fax

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

you are resistent reading advices.

We adviced you to use psycopg2 instead of psycopg1

psycopg2 is a *mandatory* requirements for using ZPsycopgDA.

So please follow our recommendations instead of trying
the wrong things.

- From my experience: psycopg2 usually installs without major issues.

So use pyscopg2 *and* SQLAlchemyDA (as adviced already several times).

- -aj

smita kamdar wrote:
>
>
>
> HI,
>
>
>
> I uninstalled Psycopg from my LINUX m/c & now zope is working fine.
>
>
>
> Again I started installing psycopg-1.1.6 & in the first step itsef it
> gives the following error:
>
>
>
> [test@test psycopg-1.1.6]$. /configure
>
> --prefix=/opt/zope/psycopg-1.1.6
>
>
> --with-mxdatetime-includes=/home/test/egenix/2.0.6/mx/DateTime/mxDateTime
>
>
> --with-postgres-includes=/home/postgres/7.4.13/src/include
>
>
> --with-postgres-libraries=/home/postgres/7.4.13/lib
>
> --with-zope=/opt/zope
>
> loading cache ./config.cache
>
> checking for python... /usr/bin/python
>
> checking python version... 2.4
>
> checking python installation prefix... /home/test/Python/2.4.4
>
> checking python installation exec_prefix... /home/test/Python/2.4.4
>
> checking definitions in Python library makefile... done
>
> checking location of python library... $(prefix)/lib/python2.4/site-packages
>
> checking location of python shared modules...
> $(exec_prefix)/lib/python2.4/site-packages
>
> checking for gcc... gcc -pthread
>
> checking whether the C compiler (gcc -pthread ) works... yes
>
> checking whether the C compiler (gcc -pthread ) is a cross-compiler... no
>
> checking whether we are using GNU C... yes
>
> checking whether gcc -pthread accepts -g... yes
>
> checking how to run the C preprocessor... gcc -pthread -E
>
> checking whether make sets ${MAKE}... yes
>
> checking for inline... inline
>
> *checking PostgreSQL version... configure: error: missing PostgreSQL
> headers*
>
>
>
> Is it because of this error that I am not able to solve the issue?
> Because last time when I Installed Psycopg I faced the same error.
>
>
>
> How shall I progress?
>
>
>
> Please Note: Paths of the Directories where my installables are –
>
>
>
> Zope --à /opt/zope
>
> Python à/home/test/Python/2.4.4
>
> Egenix -à/home/test/egenix
>
> Postgresqlà/home/postgres/7.4.13
>
> Psycopgà/opt/zope/psycopg-1.1.6
>
>
>
>
>
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> https://mail.zope.org/mailman/listinfo/zope-db


- --
ZOPYX Limited | zopyx group
Charlottenstr. 37/1 | The full-service network for Zope & Plone
D-72070 Tübingen | Produce & Publish
www.zopyx.com | www.produce-and-publish.com
- ------------------------------------------------------------------------
E-Publishing, Python, Zope & Plone development, Consulting


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJM5n/5AAoJEADcfz7u4AZj86gLv2Grtv98HUMbESEX7D3dSO2Z
iJzOLDU0gs48MFkJdniFuzQ51JimGm0oWcYPN3syfRSwKAJX36gHAObj+RAI4pJP
XUQUFYEH17VkyE447xs7uaqodmvKSM8MMlpJ14rEc2TK7xtOPE+cF4g0ej07d7CR
6dABNDtz047mQ+OnDgPtFbMgVC39Mkj60mH1e0fwjZB+3as6vUZEmDPvAZ7r++0f
9D8BkSZwpwxkDSPRf+Qi/ddB5aR/tfu4FCU4v1TDb5Xre3b+vHm/7LdgtsHf1e86
SLUlJ8xvVVt84H6yApCYEsRr37hz2B6W6gp0USvDeOLCu6ujq8c+4f2rG8JNkByS
cqK1l8Puw5QGnw2GUJ7j29PDfPueeyYq3PsozPBtLI92VoD3Si0n3ofIqRBWJnD3
p58slqr7DoCkWwvJ7OFnSJCaHf3Kxf9USptyYb2aQu8ziuqClFYJZsba/BAuXLbW
1d2OlIwVjEDdYyLzt6ECUE6TxUy5xck=
=XZB7
-----END PGP SIGNATURE-----

Am 19.11.10 14:47, schrieb Andreas Jung:
> From my experience: psycopg2 usually installs without major issues.

Indeed

> So use pyscopg2 *and* SQLAlchemyDA (as adviced already several times).

As the ZPsycopgDA generally works without problems and assuming Smita needs
mxDateTime compatability it's probably best to pursue with that. I'm also
slightly worried about Postgres 7.4 being in there as it's been deprecated for
a while. However, I agree with you that so far Smita has demonstrated an
inability to take simple advice.

Smita, you need to find someone in your company with more experience in unix
to help you. I'm no unix whizz myself but installing Zope 2, psycopg2 and
ZPsycopgDA is pretty straightforward if you follow the instructions.

Charlie
--
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/
________________________________________________________________________
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db