so I was able to fix instance/Python-2.4.3/bin/python errors that I was
getting by editing the psycopg1.py file and changing the following statement
:-
import _psycopg as _2psycopg
to
import _2psycopg
now I am able to import psycopg2 @ zope python level but not yet on zope
because when I add the connection object it gives the same mismatch version
error.
Regards,
Amir
tlc2
On Wed, Jun 24, 2009 at 11:23 AM, Amir <fixer.sol...@gmail.com> wrote:
> 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 <
> rwoodho...@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 <bennet...@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@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@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@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@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 )
