Re: ZMySQL Database connection trouble
hi,
I am trying to add a ZMySQL database connection. Everything seems to go ok, but when I try to view the Products Management, it shows the ZMySQL as a broken product, when I view it, there is an error that says:
ImportError: /usr/lib/python1.5/site-package/MySQLmodule.so: undefined symbol: uncompress
If I try to go the the /opt/zope/lib ,etc. directory and start the db.py connection directly, python db.py, i get the same error.
If someone could provide some direction on how to recompile the .so file so that it can handle the uncompress problem, I would be most grateful.
btw, i've read the various howtos on the zope.org site, and i didn't find this particular problem there.
I am running MySQL 3.23, the most recent release of zope, on linux 2.2 running slackware 7.0
Many thanks.
ciao! greg.
Gregory Haley DBA/Web Programmer Venaca, LLC
Gregory, I got this a while back - here are my notes: NOTE: The first time I got a problem relating to umcompress: ImportError: ./_mysqlmodule.so: undefined symbol: uncompress You may need to add -lz to you Setup.in file per this: http://www.ravenbrook.com/project/p4dti/import/2000-08-09/python-mysqldb-0.2 .2/MySQLdb-0.2.2/doc/MySQLdb-FAQ-1.html Then I moved MySQLdb.py* to /usr/lib/python1.5/site-packages and I was able to run python and import _mysql After that, I copied the _mysqlmodule.so module up to the ZMySQLDA directory restarted Zope and was able to create a connection. Good luck ================================= Dave Woolston davew@digicool.com Digital Creations www.digicool.com (716) 262-4715
Hi Dave. Thank you! That was quite a chore. I recall having this problem last May, and am currently building a new Zope box to run on a laptop as a mobile demo platform. I specifically searched out these steps and could not find them anywhere. The joy of collective memory! I did notice that the link to the MySQLdb material that used to be on the zope.org site has gone away. I'm glad you had the current one handy with your answer. Have a great day! ciao! greg. Gregory Haley On Tue, 20 Mar 2001, Dave Woolston wrote:
hi,
I am trying to add a ZMySQL database connection. Everything seems to go ok, but when I try to view the Products Management, it shows the ZMySQL as a broken product, when I view it, there is an error that says:
ImportError: /usr/lib/python1.5/site-package/MySQLmodule.so: undefined symbol: uncompress
If I try to go the the /opt/zope/lib ,etc. directory and start the db.py connection directly, python db.py, i get the same error.
If someone could provide some direction on how to recompile the .so file so that it can handle the uncompress problem, I would be most grateful.
btw, i've read the various howtos on the zope.org site, and i didn't find this particular problem there.
I am running MySQL 3.23, the most recent release of zope, on linux 2.2 running slackware 7.0
Many thanks.
ciao! greg.
Gregory Haley DBA/Web Programmer Venaca, LLC
Gregory,
I got this a while back - here are my notes:
NOTE: The first time I got a problem relating to umcompress: ImportError: ./_mysqlmodule.so: undefined symbol: uncompress
You may need to add -lz to you Setup.in file per this: http://www.ravenbrook.com/project/p4dti/import/2000-08-09/python-mysqldb-0.2 .2/MySQLdb-0.2.2/doc/MySQLdb-FAQ-1.html
Then I moved MySQLdb.py* to /usr/lib/python1.5/site-packages and I was able to run python and import _mysql
After that, I copied the _mysqlmodule.so module up to the ZMySQLDA directory restarted Zope and was able to create a connection.
Good luck
================================= Dave Woolston davew@digicool.com Digital Creations www.digicool.com (716) 262-4715
hi, a follow up on this. one is required to add the -lz switch to the Setup file. This gets generated when you run make in the ZMySQLDA/src directory. I added the switch into the Setup.in file, but it did not copy to the Setup and had to be added. so, it looks like the sequence might be something like the following: follow the steps in the FAQ referenced in Dave's response to the original post plus the steps Dave outlines. then build the ZMySQLDA package. make -f Makefile.pre.in boot (edit Setup to add the -lz switch) make make install go up a level and run python db.py if everything has gone right, you should get back your prompt, if not, you will get the traceback errors. ciao! greg. On Tue, 20 Mar 2001, Dave Woolston wrote:
hi,
I am trying to add a ZMySQL database connection. Everything seems to go ok, but when I try to view the Products Management, it shows the ZMySQL as a broken product, when I view it, there is an error that says:
ImportError: /usr/lib/python1.5/site-package/MySQLmodule.so: undefined symbol: uncompress
If I try to go the the /opt/zope/lib ,etc. directory and start the db.py connection directly, python db.py, i get the same error.
If someone could provide some direction on how to recompile the .so file so that it can handle the uncompress problem, I would be most grateful.
btw, i've read the various howtos on the zope.org site, and i didn't find this particular problem there.
I am running MySQL 3.23, the most recent release of zope, on linux 2.2 running slackware 7.0
Many thanks.
ciao! greg.
Gregory Haley DBA/Web Programmer Venaca, LLC
Gregory,
I got this a while back - here are my notes:
NOTE: The first time I got a problem relating to umcompress: ImportError: ./_mysqlmodule.so: undefined symbol: uncompress
You may need to add -lz to you Setup.in file per this: http://www.ravenbrook.com/project/p4dti/import/2000-08-09/python-mysqldb-0.2 .2/MySQLdb-0.2.2/doc/MySQLdb-FAQ-1.html
Then I moved MySQLdb.py* to /usr/lib/python1.5/site-packages and I was able to run python and import _mysql
After that, I copied the _mysqlmodule.so module up to the ZMySQLDA directory restarted Zope and was able to create a connection.
Good luck
================================= Dave Woolston davew@digicool.com Digital Creations www.digicool.com (716) 262-4715
participants (2)
-
Dave Woolston -
ghaley＠mail.venaca.com