473,725 Members | 2,422 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Cannot install pysqlite on Cygwin

I am trying to install sqlite for use with python on cygwin. I have
installed the sqlite packages from cygwin (that is libsqlite3-devel
and libsqlite3_0). When attempting to easy_install pysqlite I get:

$ easy_install pysqlite
Searching for pysqlite
Reading http://pypi.python.org/simple/pysqlite/
Reading http://pysqlite.org/
Reading http://initd.org/pub/software/pysqli...ses/2.3/2.3.3/
Reading http://pysqlite.sourceforge.net/
Reading http://initd.org/pub/software/pysqli...ses/2.3/2.3.4/
Reading http://initd.org/tracker/pysqlite/wi...qliteDownloads
Reading http://oss.itsystementwicklung.de/trac/pysqlite
Reading http://oss.itsystementwicklung.de/do...ite/2.5/2.5.0/
Reading http://initd.org/pub/software/pysqli...ses/2.3/2.3.5/
Reading http://oss.itsystementwicklung.de/do...ite/2.4/2.4.1/
Reading http://initd.org/pub/software/pysqli...ses/2.4/2.4.0/
Best match: pysqlite 2.5.0
Downloading http://oss.itsystementwicklung.de/do...e-2.5.0.tar.gz
Processing pysqlite-2.5.0.tar.gz
Running pysqlite-2.5.0/setup.py -q bdist_egg --dist-dir /cygdrive/c/
Users/Tilman/AppData/Local/Temp/easy_install-876nHz/pysqlite-2.5.0/egg-
dist-tmp-7mr3WS
warning: no files found matching 'doc/*.html'
warning: no files found matching 'doc/code/*.py'
src/statement.c: In function `pysqlite_state ment_recompile' :
src/statement.c:351 : warning: `sqlite3_transf er_bindings' is
deprecated (declared at /usr/include/sqlite3.h:3985)
build/temp.cygwin-1.5.25-i686-2.5/src/connection.o: In function
`pysqlite_enabl e_load_extensio n':
/cygdrive/c/Users/Tilman/AppData/Local/Temp/easy_install-876nHz/
pysqlite-2.5.0/src/connection.c:92 2: undefined reference to
`_sqlite3_enabl e_load_extensio n'
collect2: ld returned 1 exit status
error: Setup script exited with error: command 'gcc' failed with exit
status 1
$
It seems to me this is due to some missing library (undefined
reference...) but I have no idea what these missing files might be.
I've tried installing everything that made any reference to sqlite
form the cygwin interface. Does anyone know how I might get a working
install of sqlite for python on cygwin?
Sep 29 '08 #1
4 3278
Tilman Kispersky wrote:
I am trying to install sqlite for use with python on cygwin. I have
installed the sqlite packages from cygwin (that is libsqlite3-devel
and libsqlite3_0). When attempting to easy_install pysqlite I get:
[...]
build/temp.cygwin-1.5.25-i686-2.5/src/connection.o: In function
`pysqlite_enabl e_load_extensio n':
/cygdrive/c/Users/Tilman/AppData/Local/Temp/easy_install-876nHz/
pysqlite-2.5.0/src/connection.c:92 2: undefined reference to
`_sqlite3_enabl e_load_extensio n' [...]
It might be that Cygwin's SQLite doesn't support loading extensions.

Either:

Rebuild SQLite from source on Cygwin and be sure to include

--enable-load-extension when calling ./configure.

Or hack the pysqlite sources and remove these lines in src/connection.c:

#if SQLITE_VERSION_ NUMBER >= 3003008
#define HAVE_LOAD_EXTEN SION
#endif

I'm very interested how you can fix the problem.

-- Gerhar

Sep 29 '08 #2
Tilman Kispersky wrote:
I am trying to install sqlite for use with python on cygwin. I have
installed the sqlite packages from cygwin (that is libsqlite3-devel
and libsqlite3_0). When attempting to easy_install pysqlite I get:

$ easy_install pysqlite
Searching for pysqlite
Reading http://pypi.python.org/simple/pysqlite/
Reading http://pysqlite.org/
Reading http://initd.org/pub/software/pysqli...ses/2.3/2.3.3/
Reading http://pysqlite.sourceforge.net/
Reading http://initd.org/pub/software/pysqli...ses/2.3/2.3.4/
Reading http://initd.org/tracker/pysqlite/wi...qliteDownloads
Reading http://oss.itsystementwicklung.de/trac/pysqlite
Reading http://oss.itsystementwicklung.de/do...ite/2.5/2.5.0/
Reading http://initd.org/pub/software/pysqli...ses/2.3/2.3.5/
Reading http://oss.itsystementwicklung.de/do...ite/2.4/2.4.1/
Reading http://initd.org/pub/software/pysqli...ses/2.4/2.4.0/
Best match: pysqlite 2.5.0
Downloading http://oss.itsystementwicklung.de/do...e-2.5.0.tar.gz
Processing pysqlite-2.5.0.tar.gz
Running pysqlite-2.5.0/setup.py -q bdist_egg --dist-dir /cygdrive/c/
Users/Tilman/AppData/Local/Temp/easy_install-876nHz/pysqlite-2.5.0/egg-
dist-tmp-7mr3WS
warning: no files found matching 'doc/*.html'
warning: no files found matching 'doc/code/*.py'
src/statement.c: In function `pysqlite_state ment_recompile' :
src/statement.c:351 : warning: `sqlite3_transf er_bindings' is
deprecated (declared at /usr/include/sqlite3.h:3985)
build/temp.cygwin-1.5.25-i686-2.5/src/connection.o: In function
`pysqlite_enabl e_load_extensio n':
/cygdrive/c/Users/Tilman/AppData/Local/Temp/easy_install-876nHz/
pysqlite-2.5.0/src/connection.c:92 2: undefined reference to
`_sqlite3_enabl e_load_extensio n'
collect2: ld returned 1 exit status
error: Setup script exited with error: command 'gcc' failed with exit
status 1
$
It seems to me this is due to some missing library (undefined
reference...) but I have no idea what these missing files might be.
I've tried installing everything that made any reference to sqlite
form the cygwin interface. Does anyone know how I might get a working
install of sqlite for python on cygwin?
I believe it's a glitch in the 2.5.1 distribution current on Cygwin - I
had to install the _sqlite DLL separately to get it to work, but no
recompilation was necessary AFAICR.

Chui Tey detailed the necessary steps in his blog post "Cygwin Python
and sqlite3", but sadly it got lost and he hasn't replenished it, so you
will have to stab around to see if there's a cached copy anywhere.

regards
Steve
--
Steve Holden +1 571 484 6266 +1 800 494 3119
Holden Web LLC http://www.holdenweb.com/

Sep 29 '08 #3
On Sep 29, 7:49*am, Steve Holden <st...@holdenwe b.comwrote:
Tilman Kispersky wrote:
I am trying to install sqlite for use with python oncygwin. I have
installed the sqlite packages fromcygwin(that is libsqlite3-devel
and libsqlite3_0). *When attempting to easy_install pysqlite I get:
$ easy_install pysqlite
Searching for pysqlite
Readinghttp://pypi.python.org/simple/pysqlite/
Readinghttp://pysqlite.org/
Readinghttp://initd.org/pub/software/pysqlite/releases/2.3/2.3.3/
Readinghttp://pysqlite.source forge.net/
Readinghttp://initd.org/pub/software/pysqlite/releases/2.3/2.3.4/
Readinghttp://initd.org/tracker/pysqlite/wiki/PysqliteDownloa ds
Readinghttp://oss.itsystement wicklung.de/trac/pysqlite
Readinghttp://oss.itsystement wicklung.de/download/pysqlite/2.5/2.5.0/
Readinghttp://initd.org/pub/software/pysqlite/releases/2.3/2.3.5/
Readinghttp://oss.itsystement wicklung.de/download/pysqlite/2.4/2.4.1/
Readinghttp://initd.org/pub/software/pysqlite/releases/2.4/2.4.0/
Best match: pysqlite 2.5.0
Downloadinghttp ://oss.itsystement wicklung.de/download/pysqlite/2.5/2.5.0/pysqlit...
Processing pysqlite-2.5.0.tar.gz
Running pysqlite-2.5.0/setup.py -q bdist_egg --dist-dir /cygdrive/c/
Users/Tilman/AppData/Local/Temp/easy_install-876nHz/pysqlite-2.5.0/egg-
dist-tmp-7mr3WS
warning: no files found matching 'doc/*.html'
warning: no files found matching 'doc/code/*.py'
src/statement.c: In function `pysqlite_state ment_recompile' :
src/statement.c:351 : warning: `sqlite3_transf er_bindings' is
deprecated (declared at /usr/include/sqlite3.h:3985)
build/temp.cygwin-1.5.25-i686-2.5/src/connection.o: In function
`pysqlite_enabl e_load_extensio n':
/cygdrive/c/Users/Tilman/AppData/Local/Temp/easy_install-876nHz/
pysqlite-2.5.0/src/connection.c:92 2: undefined reference to
`_sqlite3_enabl e_load_extensio n'
collect2: ld returned 1 exit status
error: Setup script exited with error: command 'gcc' failed with exit
status 1
$
It seems to me this is due to some missing library (undefined
reference...) but I have no idea what these missing files might be.
I've tried installing everything that made any reference to sqlite
form thecygwininterf ace. *Does anyone know how I might get a working
install of sqlite for python oncygwin?

I believe it's a glitch in the 2.5.1 distribution current onCygwin- I
had to install the _sqlite DLL separately to get it to work, but no
recompilation was necessary AFAICR.

Chui Tey detailed the necessary steps in his blog post "CygwinPyth on
and sqlite3", but sadly it got lost and he hasn't replenished it, so you
will have to stab around to see if there's a cached copy anywhere.

regards
*Steve
--
Steve Holden * * * *+1 571 484 6266 * +1 800 494 3119
Holden Web LLC * * * * * * *http://www.holdenweb.com/
Well, I haven't managed to solve the problem.

I tried following these instructions but get the same error:
http://initd.org/pub/software/pysqli...rce-win32.html

And I also tried downloading the dll from sqlite.org and putting it on
my path.

Since someone asked how I ended up solving this problem:
I'm just going to work on my Linux box where its relatively straight
forward to install
this stuff with the package manager.

If someone does have instructions for making this work on windows I'd
be very curious. I was unable to find an archived version of the blog
post referenced above.
Sep 29 '08 #4
On Sep 29, 12:37*pm, Tilman Kispersky <tilman...@gmai l.comwrote:
On Sep 29, 7:49*am, Steve Holden <st...@holdenwe b.comwrote:
Tilman Kispersky wrote:
I am trying to install sqlite for use with python oncygwin. I have
installed the sqlite packages fromcygwin(that is libsqlite3-devel
and libsqlite3_0). *When attempting to easy_install pysqlite I get:
$ easy_install pysqlite
Searching for pysqlite
Readinghttp://pypi.python.org/simple/pysqlite/
Readinghttp://pysqlite.org/
Readinghttp://initd.org/pub/software/pysqlite/releases/2.3/2.3.3/
Readinghttp://pysqlite.source forge.net/
Readinghttp://initd.org/pub/software/pysqlite/releases/2.3/2.3.4/
Readinghttp://initd.org/tracker/pysqlite/wiki/PysqliteDownloa ds
Readinghttp://oss.itsystement wicklung.de/trac/pysqlite
Readinghttp://oss.itsystement wicklung.de/download/pysqlite/2.5/2.5.0/
Readinghttp://initd.org/pub/software/pysqlite/releases/2.3/2.3.5/
Readinghttp://oss.itsystement wicklung.de/download/pysqlite/2.4/2.4.1/
Readinghttp://initd.org/pub/software/pysqlite/releases/2.4/2.4.0/
Best match: pysqlite 2.5.0
Downloadinghttp ://oss.itsystement wicklung.de/download/pysqlite/2.5/2.5.0/pysqlit...
Processing pysqlite-2.5.0.tar.gz
Running pysqlite-2.5.0/setup.py -q bdist_egg --dist-dir /cygdrive/c/
Users/Tilman/AppData/Local/Temp/easy_install-876nHz/pysqlite-2.5.0/egg-
dist-tmp-7mr3WS
warning: no files found matching 'doc/*.html'
warning: no files found matching 'doc/code/*.py'
src/statement.c: In function `pysqlite_state ment_recompile' :
src/statement.c:351 : warning: `sqlite3_transf er_bindings' is
deprecated (declared at /usr/include/sqlite3.h:3985)
build/temp.cygwin-1.5.25-i686-2.5/src/connection.o: In function
`pysqlite_enabl e_load_extensio n':
/cygdrive/c/Users/Tilman/AppData/Local/Temp/easy_install-876nHz/
pysqlite-2.5.0/src/connection.c:92 2: undefined reference to
`_sqlite3_enabl e_load_extensio n'
collect2: ld returned 1 exit status
error: Setup script exited with error: command 'gcc' failed with exit
status 1
$
It seems to me this is due to some missing library (undefined
reference...) but I have no idea what these missing files might be.
I've tried installing everything that made any reference to sqlite
form thecygwininterf ace. *Does anyone know how I might get a working
install of sqlite for python oncygwin?
I believe it's a glitch in the 2.5.1 distribution current onCygwin- I
had to install the _sqlite DLL separately to get it to work, but no
recompilation was necessary AFAICR.
Chui Tey detailed the necessary steps in his blog post "CygwinPyth on
and sqlite3", but sadly it got lost and he hasn't replenished it, so you
will have to stab around to see if there's a cached copy anywhere.
regards
*Steve
--
Steve Holden * * * *+1 571 484 6266 * +1 800 494 3119
Holden Web LLC * * * * * * *http://www.holdenweb.com/

Well, I haven't managed to solve the problem.

I tried following these instructions but get the same error:http://initd.org/pub/software/pysqli...rce-win32.html

And I also tried downloading the dll from sqlite.org and putting it on
my path.

Since someone asked how I ended up solving this problem:
I'm just going to work on my Linux box where its relatively straight
forward to install
this stuff with the package manager.

If someone does have instructions for making this work on windows I'd
be very curious. I was unable to find an archived version of the blog
post referenced above.
I also managed to get it to work by not using cygwin's python.
I suppose this is sort of the obvious solution.

Just download the windows installers for python, pysqlite.
You can still run the windows installed version of python from cygwin
(I prefer that over the 'cmd' terminal) by specifying
the executable you want to use explicity eg:
$ /cygdrive/c/Python25/python
Sep 29 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1643
by: Jari Aalto+usenet | last post by:
Hi, Where I can specify more linking search directories for a Python module that makes a gcc build? Setting the LD_LIBRARY_PATH on command line does not seem to propagate to the linker. Jari root@w2kpicasso:/usr/share/site-python/xmldiff-0.6.3# echo $LD_LIBRARY_PATH
0
1097
by: Hemanth P.S. | last post by:
I installed PySqlite 0.4.3 on my Mandrake Linux 9.1 which has Python2.2. But when I say "import sqlite" in the python interpreter, I get an error saying, "libsqlite.so.0 not found". I searched and found only the file _sqlite.so in /usr/lib/python2.2/site-packages/. Is there something obvious I am missing? I installed pysqlite using the command, "python setup.py build" and "python setup.py install" as root.
1
2820
by: F. GEIGER | last post by:
I've troubles to let my app take off using pysqlite. What I wonder most for now is that "pysqlite2.dbapi2.OperationalError: cannot commit transaction - SQL statements in progress" when I do this: t = time.time() n = len(self) while len(self): del self self.commit()
2
4818
by: James Hull | last post by:
Hi All: I am new in the Perl world. So far I have installed cygwin and Perl 5.8.0 along with Perl DBI and DBD::Oracle modules. NowI am trying to install Perl Tk on my PC (Windows 2K). I have tried both Tk804.025 and Tk804.025_beta2. However, both versions failed with following errors. It appeared that the command "perl Makefile.PL" ran successfully, but the "make" command failed. I also ran "perl -Mblib demos/widget". It was complaining...
11
2340
by: rg1008 | last post by:
SInce yesterday, i have been geeting the following error on pysqlite.org (and also on initd.org): Service Temporarily Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later. has anyone else also faced this or is it just my special connection? Also it would be helpful if someone could point out another location to get the python2.5 pysqlite install for...
1
2272
by: Thomas | last post by:
Hi there! Installing TurboGears out-of-the-box (egg-based) on Windows doesn't work because I can't compile the extensions needed for the required pysqlite (also egg- based): Installed c:\programme\python24\lib\site-packages\turbogears-1.0.1- py2.4.egg Processing dependencies for TurboGears>=1.0
5
2329
by: =?ISO-8859-1?Q?Gerhard_H=E4ring?= | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 pysqlite 2.5.0 released ======================= I'm pleased to announce the availability of pysqlite 2.5.0. This is a release with major new features. Go to http://pysqlite.org/ for downloads, online documentation and
4
19498
by: pizzetta72 | last post by:
Hi all, i just finish to install cygwin on windows XP adding also gcc compiler module. After I tried to execute a file called fstsg.0.3-sparc (www.fstha.com) used to cript a Unix shell, I receive an error saying : "cannot execute binary file". Someone can help me to solve this problem? I need configure/add some library/plugin in order to execute correctly this file? Here is a snapshot related to this error: $ ./fstsg.0.3-sparc ...
6
3071
by: Geon. | last post by:
hi everyone! when i install pysqlite i meet bellow error. ( use easy_install and source code building same problem ) ld: Can't find library for -lpython2.5 what mean this message? and what i do? my system is hp-ux 11i v3. and python2.5 is installed.
0
9250
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9165
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9097
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8079
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6699
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4776
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3216
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2626
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2153
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.