[Zope-DB] Zope_Database_issue

Mon Nov 22 05:06:52 EST 2010

 HI,

I downloaded Psycopg2-2.2.2.tar.gz , extracted it  & started installing it
as root user.

I followed the below steps:

[root at test psycopg2-2.2.2]# *which pg_config*

/home/postgres/7.4.13/bin/pg_config

[root at test psycopg2-2.2.2]# *python setup.py install*

running install

running build

running build_py

running build_ext

building 'psycopg2._psycopg' extension

…………………………………………..

……………………………………………..

…………………………………….

byte-compiling
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopg2/errorcodes.py
to errorcodes.pyc

byte-compiling
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopg2/__init__.py to
__init__.pyc

byte-compiling
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopg2/tz.py to tz.pyc

byte-compiling
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopg2/extras.py to
extras.pyc

byte-compiling
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopg2/pool.py to
pool.pyc

byte-compiling
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopg2/psycopg1.py to
psycopg1.pyc

byte-compiling
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopg2/extensions.py
to extensions.pyc.

But in the next step I faced the below error –

[root at test psycopg2-2.2.2]# *python*

Python 2.4.4 (#1, Nov 10 2010, 01:08:38)

[GCC 4.4.2 20091027 (Red Hat 4.4.2-7)] on linux2

Type "help", "copyright", "credits" or "license" for more information.

>>> import psycopg2

Traceback (most recent call last):

  File "<stdin>", line 1, in?

  File
"/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopg2/__init__.py",
line 69, in?

    from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID

*ImportError:
/home/test/Python/2.4.4/lib/python2.4/site-packages/psycopg2/_psycopg.so:
undefined symbol: PQserverVersion*

>>>

Can You please suggest as to how can I solve this issue?

Thanks & Regards,

Smita Kamdar | NGN-SOLNS |TechMahindra

Oberoi Estate Gardens, Chandivali, Andheri(E) Mumbai-72

Office: +91 22 66882000 | Extn: 6185

Email: smita.kamdar at techmahindra.com

-----Original Message-----
From: Andreas Jung [mailto:lists at zopyx.com]
Sent: Friday, November 19, 2010 7:18 PM
To: smita kamdar
Cc: zope-db at zope.org
Subject: Re: [Zope-DB] Fwd: Zope_Database_issue

-----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 at 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 at 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-----
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20101122/55863246/attachment-0001.html 