Fedora :: How To Install Sqlite-python
Nov 18, 2009I am trying to install sqlite-python package in my FC11 machine. I couldn't find an rpm to install.
View 2 RepliesI am trying to install sqlite-python package in my FC11 machine. I couldn't find an rpm to install.
View 2 RepliesI want to be able to create an RPM that will install python 2.7.1 along with sqlite 3.7.3, MySQL-Python-1.2.3 on a CentOS 5.5 x86_64 host(s) in a directory (e.g. /opt/python2.7). Once that's done, I want to be able to alias the new python binary in .bash_profile so that my developers can begin using it.
I understand 2.7.1 can't be installed on a CentOS host but I've done the above using a shell script successfully. If you search hard enough, I posted my script on line . However, I need to create the RPM for political reasons. Besides placing the source file(s) in the SOURCES directory, what do I need to do in the spec to be able to successfully create an RPM installer?
Please be gentle with me. I've been drinking the Windows cool-aid for most of my IT career so, this is one of my first attempts of becoming a better DevOps Admin.
I'm sure I'm missing something pretty obvious, but I can't for the life of me stop my pysqlite scripts crashing out with a database is locked error. I have two scripts, one to load data into the database, and one to read data out, but both will frequently, and instantly, crash depending on what the other is doing with the database at any given time.I've got the timeout on both scripts set to 30 seconds: cx = sqlite.connect("database.sql", timeout=30.0)and think I can see some evidence of the timeouts in that i get what appears to be a timing stamp (e.g 0.12343827e10 1) dumped occasionally in the middle of my curses formatted output screen, but no delay that ever gets remotely near the 30 second timeout, but still one of the other keeps crashing again and again from this. I'm running RHEL5.4 on a 64 bit HS21 IBM blade, and have heard some mention about issues about multi-threading and am not sure if this might be relevant.
Packages in use are sqlite-3.3.6-5 and python-sqlite-1.1.7-1.2.1, and upgrading to newer versions outside of RedHat's official provisions is not a great option for me. Possible, but not desirable due to the environment in general.I have had autocommit=1 on previously on both scripts, but have since disabled on both, and am now cx.commit()ing on the inserting script and not committing on the select script. Ultimately as I only ever have one script actually making any modifications, I don't really see why this locking should ever ever happen
How do I install php-sqlite extension on fedora 14.
View 5 Replies View RelatedBased on Product highlights - openSUSE, it would appear that using sqlite3 in gnucash would be available. However, I do not have an option to save an existing book to the database format, nor is it available when creating a new book - only xml is available. Is there anything special that I need to do to enable the sqlite backend?
View 2 Replies View Relatedin ubuntu 10.10, I have installed python 2.7. I would like to use apt-get to install packages to this version of python but I haven't been able to figure out howThings I have tried without success:changing the symlink at /usr/bin/python to point to /usr/bin/python2.7 - even after doing this apt-get still installs stuff to python2.6.Set up python2.7 as the primary alternative using update-alternatives - doesn't work
View 3 Replies View RelatedI'm having a bit of trouble with a web server running Fedora 12. Apache works fine, and serves up php content without a hitch. My problem is SQLite -- I thought that it was built into php5, but support is disabled in the repo version. phpinfo shows this as part of the configure command:
Code:
'--without-sqlite' ... '--disable-pdo' ... '--without-sqlite3'
The only solution I've read anywhere is "compile php from source," but I'd like to avoid that if possible, for ease of future upgrades. Is there a way to convince php to use sqlite despite its current state?
Is there a binary available somewhere, even if it's a non-Fedora repo?
View 8 Replies View Relatedi want IDLE on my Fedora 15, is this possible?
View 2 Replies View RelatedI can't install Python 2.6 on Fedora 15 - I have only Python 2.7. Also I can't add EPEL repository to try to install: yum install python26 I didn't find any info about how can I solve this problem.
View 12 Replies View Relatedhow can i install python 3 and idle in fedora 12? yum search for any plausible variation on python3 (python-3, Python-3.1, etc.) that i could think of yields nothing, same in add/remove software. so i got the tarball from python.org and followed book instructions on it (summerfield's python 3, p. 4), namely unpack it, run './configure', run 'make' and finally run 'make install'
in my add/remove programs window, for idle, it says i have the one for python 2.6 installed, but i can't find where to open the program. but i'd like to use 3.1.2 python anyway. additional note: if i type python -V i get Python 2.6.x (can't remember the last digit, i think it's 2), and if i type python3 -V i get Python 3.1.2. so, how do i get python 3 installed and idle for python 3 running?
i got per default python 2.6.2 on my fedora 12. how can i install the newest version python 3.1.2?
View 2 Replies View RelatedI get an error when trying to install python-virtualenv package:
Quote:
# yum install python-virtualenv
Loaded plugins: presto, refresh-packagekit
Setting up Install Process
Resolving Dependencies
--> Running transaction check
[Code]...
AFAIK, python-virtualenv package does not really require any development packages (at least in ubuntu, debian, opensuse). Is it a bug? I didn't find anything with search engines...
I'm trying to install python spider monkey. I already have pkgconfig and nspr installed however when I runeasy_install python-spidermonkey it says
Running python-spidermonkey-0.0.10/setup.py -q bdist_egg --dist-dir /tmp/easy_install-hjTAdp/python-spidermonkey-0.0.10/egg-dist-tmp-sbqzO9
Traceback (most recent call last):
[code]....
Fresh install of F13, just went to update and I get the following error:Code:failure: repodata-primary.sqlite.bz2 from updates: [Errno 256] No more mirrors to try.
View 7 Replies View Relatedi wanted to install screenlets under fedora 11 but python wont let me, is there a way to do it i keep getting the Python(abi) dependency missing message I've tryed both 32 and the 64 bits version, even the noarch i found here with no results at all
View 14 Replies View RelatedI was trying to install MySQLbd (a module for python to connect and access MySQL) I followed these steps for installation[URL].. but while I am getting some installation errors. When I try to run $ python set.py build I am getting the following errors (I removed few errors as I can post more than 10000 characters here)
[Code]...
ERROR "global name 'sqlite' is not defined" when install Apache + Subversion + Trac
Apache+Subversion+Trac
httpd-2.2.16
Python-2.6
swig-1.3.31
sqlite-3.6.13
subversion-1.6.12
mod_python-3.3.1
[Code]....
i often got transaction error problems by the package "sqlite" in my fedora x86_64 system.so, i issued rpm -e --nodeps sqlite.
after this,
i am getting,
Code:
There was a problem importing one of the Python modules required to run yum. The error leading to this problem was:
[Code]...
Fedora 12 officially uses Python 2.6, good. But the Google AppEngine still goes by Python 2.5 and is showing import errors while i try to start the SDK. Here is the stack trace.
[URL]
I want to be able to do
sudo ./program.py
instead of always having to do
sudo python program.py
What do I need to change?
I've already used line split stuff to transform my data into something like this in a text file:
Code:
['1', '1', '3', '20.7505207']
['2', '1', '3', '23.0488319']
['3', '1', '3', '-1.5768747']
['4', '1', '3', '-26.4772491']
[code]....
How can I get this on a python program so I can manipulate it as an array?
I have logged into root via SSHI followed instructions from here[URL]And here[URL]
View 1 Replies View RelatedWhen I try to install Zimbra 7.1.2, the installation fails because it cannot find sqlite. I used strace and found that it uses "rpm -q sqlite" to find the package. But it fails-"package sqlite is not installed". Although I have sqlite installed:
Code:
#rpm -qa | grep sqlite
mono-data-sqlite-2.6.4-2.13.x86_64
[code]....
With this sqlite query ? I have these tables:
what is the query to list all cities and its neighboring cities like this?
I am trying to connect to sqlite via perl:
Code:
#! /usr/bin/perl
use LWP::Simple;
use XML::DOM;
use DBI;
[Code]....
Anyone know how to execute SQLite db commands from C++?
View 1 Replies View RelatedPython 3 want situation for python 2?Python 2 become stop?
View 1 Replies View Relatedyum dependency problem please? I am running Centos 5.5. I need to install python-devel, but when I do so I get:
[Code]....
I am using SQLite as my database for some portable cross platform applications I am working on with REALBasic as my IDE. I have an old Sybase 8.0 database that I can access via Microsoft Access and thereby extract the data I need from each table.
Now I know I can create .csv files from each table and load them into SQLite using the import tool, but then I can't define the primary key and other field attributes. So the other option is to load each file via SQL.
Now with most SQL editors I can create multiple queries and they will run just fine. But I can't seem to do that with the SQLite interfaces. I can paste multiple queries but I can only run one at a time. And by that I mean I have to click run.
Ummm that's not acceptable since my biggest table contains over 600,000 records. I have the queries all written, that was easy using a simple interface I wrote in Access.
Code:
INSERT INTO tblMeters(recordId,meterId,meterName,meterSerNum,registerSerNum,mxuSerNum,meterType,manufacture,meterModel,readType,groupId,multiplier,rollover,vendorId,xfrmerCode,bldgCode,CATEGORY,energyType,unitOfMeasure,location,access,comments,dateInstalled,dateCalibrate,pipeSizeIn,pipeSizeOut,elecMeterSpecs)
[Code]...
So is there another method I can use? I can't seem to find anything relating to my particular question at the SQLite web site