[Zope] psycopg import error

[Amir]

Things that i have noticed

1)running and importing psycopg2

gives this error

Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python2.4/site-packages/psycopg2/__init__.py", line 60, in
?
    from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: /usr/lib/python2.4/site-packages/psycopg2/_psycopg.so:
undefined symbol: PyUnicodeUCS2_Decode

2) for some reason in the Python-2.4.3/lib/python2.4/site-packages/psycopg2
it has psycopg1.py so when i open it, it
says in order to import do:- "from psycopg2 import psycopg1 as psycopg"(also
says to run in psycopg1.1.x compatible mode) and if i do import it this way
it gives me this error

Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python2.4/site-packages/psycopg2/__init__.py", line 55, in
?
    from psycopg2 import tz
ImportError: cannot import name tz

I am thinking there is something in 2) is this normal?



ps : 2.0.11 is in the allowed psycopg ALLOWED_PSYCOPG_VERSIONS =
('2.0.7','2.0.8','2.0.9','2.0.10', '2.0.11')


Regards,
Amir

tlc2

On Wed, Jun 24, 2009 at 10:56 AM, Rowan Woodhouse <
rwoodhouse at wirelessmeasurement.com> wrote:

> I had the same problem but found that if I just modified the list of
> acceptable psycopg versions everything worked fine.
>
> Rowan
>
> Amir wrote:
> > Hey,
> >       yes i have it installed at
> > instance/Python-2.4.3/lib/python2.4/site-packages/psycopg2  and i had
> also
> > moved the adapter to the
> > instance/client1/Products folder, but still it is giving me the version
> > mismatch error. Also i checked the psycopg* in my system but
> > over there also i can see that it is correct version that has been
> installed
> > /usr/lib/python2.4/site-packages/psycopg2 .
> >
> > Regards,
> > Amir
> >
> > tlc2
> >
> > On Tue, Jun 23, 2009 at 3:41 PM, Thomas Bennett <bennetttm at appstate.edu
> >wrote:
> >
> >> Have you installed psycopg2 2.0.11, not the adapter but the library for
> >> python?  and is it in the python path for your Zope python?
> >>
> >> I'm thinking you have psycopg not psycopg2 installed as your python
> library
> >> and the psycopg2 adapter.  There is no psycopg 2.0.11.
> >>
> >> I am assuming this is still how psycopg is installed, the library and
> the
> >> DA
> >> product.
> >>
> >> http://initd.org/pub/software/psycopg/
> >>
> >>
> >> Thomas
> >>
> >>
> >>
> >> On Tuesday 23 June 2009 16:06:03 Amir wrote:
> >>> Hi,
> >>>    I have (Zope 2.9.4-final, python 2.4.3, linux2) and I have used
> >>> psycopg2.0.11 adapter to connect Zope to Postgresql but I am getting
> this
> >>> error when I try to add the connection object the error is :-
> >>>
> >>> Error Type: ImportError
> >>>
> >>> Error Value: psycopg version mismatch (imported 2.0.11 (dt dec ext
> pq3))
> >>>
> >>> while the event log traceback shows that :-
> >>>
> >>> 2009-06-23T10:55:49 ERROR Shared.DC.ZRDB.Connection Error connecting to
> >>> relational database.
> >>> Traceback (most recent call last):
> >>>   File "/opt/Plone-2.5/lib/python/Shared/DC/ZRDB/Connection.py", line
> 71,
> >>> in __setstate__
> >>>     try: self.connect(self.connection_string)
> >>>   File "/opt/Plone-2.5/zeocluster/client1/Products/ZPsycopgDA/DA.py",
> >> line
> >>> 120, in connect
> >>>     raise ImportError("psycopg version mismatch (imported %s)" %
> >>> ImportError: psycopg version mismatch (imported 2.0.11 (dt dec ext
> pq3))
> >>>
> >>> I would appreciate for an answer asap.
> >>>
> >>> Thanks
> >>> Amir
> >>>
> >>> tlc2
> >>>
> >>> ***
> >>> *
> >> --
> >>  Normally I'm against big things,
> >>  I think the world is going to be saved by millions of small things.
> >> Too many things can go wrong when they get big.
> >> - Pete Seeger  at his 90th birthday party Sunday May 3, 2009
> >>
> >> ==========================================
> >> Thomas McMillan Grant Bennett           Appalachian State University
> >> Operations & Systems Analyst            P O Box 32026
> >> University Library                                Boone, North Carolina
> >> 28608
> >> (828) 262 6587
> >>
> >> Library Systems Help Desk: https://www.library.appstate.edu/help/
> >> ==========================================
> >> _______________________________________________
> >> Zope maillist  -  Zope at zope.org
> >> http://mail.zope.org/mailman/listinfo/zope
> >> **   No cross posts or HTML encoding!  **
> >> (Related lists -
> >>  http://mail.zope.org/mailman/listinfo/zope-announce
> >>  http://mail.zope.org/mailman/listinfo/zope-dev )
> >>
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Zope maillist  -  Zope at zope.org
> > http://mail.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://mail.zope.org/mailman/listinfo/zope-announce
> >  http://mail.zope.org/mailman/listinfo/zope-dev )
>
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20090624/d9eb2375/attachment.html