SQLite database adapter
After trashing around and making a bunch of guesses I put a folder called ZSQLiteDA into the E:\Program Files\WebSite\lib\python\Products\ directory and now ZOPE startup recognizes the folder and attempts to load the product. It failed with ImportError: No module named sqlite. I tried putting the sqlite folder in the products directory, then the ZSQLiteDA directory. Now it fails with ImportError: No module named _sqlite. I have run out of ideas. What should I do? Is there some place that explains how all this is supposed to work, or are we all on our own? Bob Gailer bgailer@alum.rpi.edu 303 442 2625 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003
It looks like Zope can't find the SQLite libraries it needs in order to make the connection. I'm not familiar with SQLite, but I know in the case of MySQL one needs to install the MySQL-python libraries in order for the Zope database adapter to be able to talk to MySQL. This looks like the same issue. I searched on zope.org for SQLite, found the ZSQLLiteDA product, and it mentions that it works with pysqlite. This omitted software is most likely causing the error you are experiencing. Get the software at: http://pysqlite.sourceforge.net/index-old.html and see if you have better luck after installing the product. Make certain that you compile the pysqlite libraries with the same python you are using to run Zope. Kevin Bob Gailer wrote:
After trashing around and making a bunch of guesses I put a folder called ZSQLiteDA into the E:\Program Files\WebSite\lib\python\Products\ directory and now ZOPE startup recognizes the folder and attempts to load the product.
It failed with ImportError: No module named sqlite. I tried putting the sqlite folder in the products directory, then the ZSQLiteDA directory. Now it fails with ImportError: No module named _sqlite.
I have run out of ideas. What should I do?
Is there some place that explains how all this is supposed to work, or are we all on our own?
Bob Gailer bgailer@alum.rpi.edu 303 442 2625
------------------------------------------------------------------------
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003
------------------------------------------------------------------------
_______________________________________________ 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 )
At 05:18 PM 9/25/2003, Kevin Carlson wrote:
It looks like Zope can't find the SQLite libraries it needs in order to make the connection. I'm not familiar with SQLite, but I know in the case of MySQL one needs to install the MySQL-python libraries in order for the Zope database adapter to be able to talk to MySQL. This looks like the same issue.
I searched on zope.org for SQLite, found the ZSQLLiteDA product, and it mentions that it works with pysqlite. This omitted software is most likely causing the error you are experiencing. Get the software at: http://pysqlite.sourceforge.net/index-old.html and see if you have better luck after installing the product. Make certain that you compile the pysqlite libraries with the same python you are using to run Zope.
When I look at my ZOPE control panel I see Zope Version (Zope 2.6.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32) Python Version 2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit (Intel)] I installed pysqlite (a while ago) under Python2.2. When I go to reinstall it only Python2.2 shows up in the list of Python versions from which to choose. Does this mean I need to get and install Python 2.1.3? Or is there a later version of ZOPE based on 2.2? Bob Gailer bgailer@alum.rpi.edu 303 442 2625 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003
Bob Gailer wrote:
When I look at my ZOPE control panel I see Zope Version (Zope 2.6.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32) Python Version 2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit (Intel)]
I installed pysqlite (a while ago) under Python2.2. When I go to reinstall it only Python2.2 shows up in the list of Python versions from which to choose. Does this mean I need to get and install Python 2.1.3? Or is there a later version of ZOPE based on 2.2?
My guess is that you got a bundled binary, one that came with python. Search your Zope installation directory (and subdirs) for python in a bin dir; when you find it, from a command window, run 'python -V' to check the version. It should match the version listing in the control panel ;-) At that point, you probably want to setup your path variable such that the 2.1.3 version of python is found before your 2.2 python binary. When that's done, you can install python libs to your heart's content, and Zope will find them (barring other outstanding issues). Hang in there and keep the questions coming ;-) Duncan
Bob Gailer wrote:
When I look at my ZOPE control panel I see Zope Version (Zope 2.6.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32) Python Version 2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit (Intel)]
I installed pysqlite (a while ago) under Python2.2. When I go to reinstall it only Python2.2 shows up in the list of Python versions from which to choose. Does this mean I need to get and install Python 2.1.3? Or is there a later version of ZOPE based on 2.2?
You need to compile and install pysqlite using the exact instance of python with which you are running Zope. In other words, if your Zope installation is running python 2.1 and is located at /zope/bin/python, use that python to compile and install the package. Kevin
participants (3)
-
Bob Gailer -
Duncan McGreggor -
Kevin Carlson