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
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.eduwrote: 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
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 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 )
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**
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 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 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 -
[Zope] psycopg import error
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 *** * ___ 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 )
