Re: [Zope] psycopg import error
Hey, I finally reverted all the changes and fixed it like you said editing the DA.py in ZPsycoDA. thought i let you know about it. through this if psycopg2.__version__[:6] not in ALLOWED_PSYCOPG_VERSIONS: and then if psycopg2.__version__.split(' ')[0] not in ALLOWED_PSYCOPG_VERSIONS: ps: in changelog it shows that changes have been done by the author on 2009-05-19. but doesn't say which version. Thanks Amir Tlc2 On Wed, Jul 1, 2009 at 8:51 PM, Thomas OConnor < thomas.ocon...@newcastle.edu.au> wrote: > Hi, > > I also experienced the problem this morning when trying to use the product > ZPsycopgDA version 2.0.11 on Zope. The error reported by Plone/Zope is: > > Error Value: psycopg version mismatch (imported 2.0.11 (dt dec ext pq3)) > > Due to the fact it is extracting the first 5 characters (2.0.1) and > comparing it to the full version (2.0.11), thus failing. > > Instead of changing the index to 6 (which would then break 2.0.8 versions, > etc.), you can explode the string by spaces, then extract the first part: > > so the only change would be to line 119 of DA.py, from: >if psycopg2.__version__[:5] not in ALLOWED_PSYCOPG_VERSIONS: > > to: >if psycopg2.__version__.split(' ')[0] not in > ALLOWED_PSYCOPG_VERSIONS: > > No other changes to the versions definition would be required. > > This will be both backwards and forwards compatible with all versions from > 0.0.0 to 999.999.999 (well, infinity really)! > > Keep up the good work. > > Cheers, > > Tom > > -- > Thomas O'Connor > Web developer > > (02) 498 54130 > thomas.ocon...@newcastle.edu.au > > Office of IT Services > Bar on the Hill Building > UoN Services Limited > University Drive > Callaghan NSW 2308 > ___ > 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 )
Re: [Zope] psycopg import error
Hi, I also experienced the problem this morning when trying to use the product ZPsycopgDA version 2.0.11 on Zope. The error reported by Plone/Zope is: Error Value: psycopg version mismatch (imported 2.0.11 (dt dec ext pq3)) Due to the fact it is extracting the first 5 characters (2.0.1) and comparing it to the full version (2.0.11), thus failing. Instead of changing the index to 6 (which would then break 2.0.8 versions, etc.), you can explode the string by spaces, then extract the first part: so the only change would be to line 119 of DA.py, from: if psycopg2.__version__[:5] not in ALLOWED_PSYCOPG_VERSIONS: to: if psycopg2.__version__.split(' ')[0] not in ALLOWED_PSYCOPG_VERSIONS: No other changes to the versions definition would be required. This will be both backwards and forwards compatible with all versions from 0.0.0 to 999.999.999 (well, infinity really)! Keep up the good work. Cheers, Tom -- Thomas O'Connor Web developer (02) 498 54130 thomas.ocon...@newcastle.edu.au Office of IT Services Bar on the Hill Building UoN Services Limited University Drive Callaghan NSW 2308 ___ 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 )
Re: [Zope] psycopg import error
looks like DA.py is using psycopg2.__version__ not psycopg2.__version__[:5] with the index of 5. You might want to check that. Also, psycopg2.__version__[:5] is 2.0.1 not 2.0.11 and 2.0.1 is not in the list on my install from today. The index should be 6 not 5 for versions higher than 2.0.9 . On my machine with python 2.5.2 >> import psycopg2 >>> psycopg2.__version__[:5] '2.0.1' >>> psycopg2.__version__ '2.0.11 (dt dec ext pq3)' You might want to undo all of your changes and change the index to 6. If this is the case let me know and I will send a bug report to the author. 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 AnalystP O Box 32026 University LibraryBoone, 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 )
Re: [Zope] psycopg import error
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 wrote: > Things that i have noticed > > 1)running and importing psycopg2 > > gives this error > > Traceback (most recent call last): > File "", 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 "", 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 > >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 AnalystP O Box 32026 >> >> University LibraryBoone, 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
Re: [Zope] psycopg import error
Ok, look at the error message again. It says raise ImportError("psycopg version mismatch (imported %s)" % ImportError: psycopg version mismatch (imported 2.0.11 (dt dec ext pq3)) so the version being reported back is '2.0.11 (dt dec ext pq3)' not '2.0.11' Rowan Amir wrote: > Things that i have noticed > > 1)running and importing psycopg2 > > gives this error > > Traceback (most recent call last): > File "", 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 "", 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 >> 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 AnalystP O Box 32026 University LibraryBoone, 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
Re: [Zope] psycopg import error
Things that i have noticed 1)running and importing psycopg2 gives this error Traceback (most recent call last): File "", 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 "", 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 >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 AnalystP O Box 32026 > >> University LibraryBoone, 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/li
Re: [Zope] psycopg import error
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 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 AnalystP O Box 32026 >> University LibraryBoone, 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 )
Re: [Zope] psycopg import error
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 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 AnalystP O Box 32026 > University LibraryBoone, 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 )
Re: [Zope] psycopg import error
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 AnalystP O Box 32026 University LibraryBoone, 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 )