Software :: Connect To Sqlite Via Perl?
Apr 22, 2011I am trying to connect to sqlite via perl:
Code:
#! /usr/bin/perl
use LWP::Simple;
use XML::DOM;
use DBI;
[Code]....
ADVERTISEMENT
CentOS 5 Server :: Move 5.5 To /usr/bin/perl So Root Based On Perl 5.12.1?
Aug 11, 2010I am new here and want to lern CentOS. Current I have installed CentOS 5.5 x64 and Perl 5.8.8. Now i have install Perl 5.12.1 which located to /usr/local/bin/perl. But how I can move it to /usr/bin/perl so root based on Perl 5.12.1?
View 7 Replies View RelatedDebian :: Launch The Perl Config \ Seems To Be That It Does Not Regonize Perl?
Jul 7, 2010I am trying to launch the perl config, but when I do so I can an weird error.It seems to be that it does not regonize perl ?
conf.pl: line 11: =: command not found
conf.pl: line 19: my: command not found
conf.pl: line 20: syntax error near unexpected token `{'
[code]...
Ubuntu :: Switch Back To /usr/bin/perl After Installing Second Perl?
Aug 14, 2010I recently reinstalled the B module for perl. Now I found out it didn't just do that, it installed a whole new copy of perl into /usr/local/bin/perl. When I type 'which perl' at the terminal, it says '/usr/local/bin/perl' instead of '/usr/bin/perl'. Normally, this wouldn't bother me. But I installed the one in local/bin without threading support. The one that comes with the system already is build with threading support, which is why I want to switch back to the system perl, and possibly remove the one in /usr/local/bin.
So how do I change it so that the result of 'which perl' returns as '/usr/bin/perl'? And what do I have to do to remove /usr/local/bin/perl?
The reason I need threading support is because I'm designing a file copier that copies several chunks of a file simultaneously to speed up the copying process. Guaranteed a useful script if it works.
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 Replies View RelatedFedora Servers :: Enabling Sqlite In 12?
Feb 4, 2010I'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?
Fedora :: SQLite Browser - Binary Available Somewhere?
Jan 29, 2011Is there a binary available somewhere, even if it's a non-Fedora repo?
View 8 Replies View RelatedOpenSUSE :: Install Gnucash 2.4 In 11.4 To Use Sqlite?
Apr 18, 2011Based 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 RelatedOpenSUSE :: Zimbra Cannot Find Sqlite?
Sep 13, 2011When 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]....
Ubuntu :: Sqlite Query Syntax ?
Feb 27, 2010With this sqlite query ? I have these tables:
what is the query to list all cities and its neighboring cities like this?
Programming :: Execute SQLite Db Commands From C++?
Jun 10, 2010Anyone know how to execute SQLite db commands from C++?
View 1 Replies View RelatedOpenSUSE :: Difference Between Perl And Perl-devel?
Jun 28, 2010I'm new in perl programming and linux OS. What is the difference between perl and perl-devel? What does mean devel? Iwant to install Catalyst and before install as required I have to check if make, gcc and perl-devel are installed in my system. make and gcc are installed. But I have to install perl-devel. First I searched for make, gcc and perl-devel in YAST Software Management and search did not find perl-devel. I visited the software.opensuse.org and wrote "perl-devel" and searched. The result was many similar zips with a prefix perl-devel and I can not choose one for needed perl-devel.
[Code]...
Fedora Installation :: How To Install Php-sqlite Extension On F14
Apr 15, 2011How do I install php-sqlite extension on fedora 14.
View 5 Replies View RelatedProgramming :: Load Multiple Records Into SQLite?
Nov 19, 2008I 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
Software :: Cross Compiling Sqlite On Arm9
May 28, 2010i am trying to compile too the sqlite for arm9 - mini2440.could you please tell me what was the steps you make? im read that book but im still having some trouble while i compile i have been trying to do the compilation.
View 3 Replies View RelatedGeneral :: Unable Command Line Autocomplete After Sqlite?
Jun 3, 2010Once upon a time when I started sqlite from the command line I could using the tabbing autocomplete to enter the database name. This has not worked for a while now.
View 1 Replies View RelatedGeneral :: Delete Old Records From Firefox Sqlite Databases?
May 23, 2010I have some big sqlite3 databases in ~/.mozilla/firefox/profilename Notably places.sqlite (12 MB) and urlclassifier3.sqlite (33 MB). Is it possible to truncate them and wipe out the oldest records in them? Of course I could just wipe them completely, but that's not my goal - I just want to minimize the size of those files while keeping the newest records.
View 2 Replies View RelatedGeneral :: Sqlite Query To Retrieve Browser History?
May 24, 2010This query is giving "Unable to open data base" can anybody suggest what's wrong with this query.
sudo echo "SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id;" | sqlite3 moz_places.sqlite, moz_historyvisits.sqlite
Software :: Unable To Create An RPM That Will Install Python 2.7.1 Along With Sqlite 3.7.3?
Mar 8, 2011I 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.
Programming :: Variable Substitution In Sqlite Open Db Command?
Jun 15, 2010I have the following TCL code:
if{ [catch {sqlite3 db /path/to/db/file} result] } {
puts stderr $result
} else {
do something
}
What I want is to use a variable for the file name/path. When I put in a variable instead of the absolute path, I get an error: "missing close-brace: possible unbalanced brace in comment while executing"
This is weird because when I run the code with the fully qualified pathname, it works fine. I substitute out the pathname for a variable containing the pathname ($variable) and I get this error.
Debian :: Deleting Data Before Specific Date In SQLite Database
Jun 22, 2015This is a continuation of the post in [URL].... . What has happened is that I have a huge log of 600 MB + and do not know from when the data is in there.
Code: Select all┌─[shirish@debian] - [~/.config/quassel-irc.org] - [9714]
└─[$] ll -h quassel-storage.sqlite
-rw------- 1 shirish shirish 647M Jun 22 21:15 quassel-storage.sqlite
So I need to know if there is a way to get just the first five or ten entries listed as one can do using head, tail etc. I did try just using head but it was unsuccessful. The second thing would be deleting some days, weeks or months data from the existing sqlite log. I did see URL... but in my case I am deleting old entries in the sqlite log and also do not know if sqlite makes backups of the data or not ?
Ubuntu :: Synaptics Tomahawk: Depends: Libqt4-sql-sqlite But It Is Not Going To Be Installed?
Jun 10, 2011I get the error when trying to mark tomahawk for installation using synaptics. I googled the error but couldn't find anything on it. could some one help me figure out what's going on?
View 3 Replies View RelatedProgramming :: Python / Sqlite - Database Locked Despite Large Timeouts?
Apr 8, 2010I'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
Programming :: SQLite Read, Write, Select, Compare Statements For C++
Jun 9, 2010I am using C++ with SQLite db in a program that will read read a sub set of records, compare records and write different records to another database. I have a SQLite book, but it only shows examples for the C API. Anyone have code samples in C++ for the following:
Open database
Close
Select *
Read
Write
Or, just show me how to execute a SQL statement with C++ and I can then figure out the various SQL statements I need.
Fedora :: Failure: Repodata-primary.sqlite.bz2 From Updates: [Errno 256] No More Mirrors To Try?
Jun 10, 2010Fresh 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 RelatedCentOS 5 :: /primary.sqlite.bz2: [Errno -1] Metadata File Does Not Match Checksum?
May 10, 2011I have several CentOS 5.5 machines running on my network; yum works just fine for them. I used the 5.5 cds to install them. I decided to grab the DVD of 5.6 and build a new machine. Can't run yum.
http://mirrors.finalasp.com/CentOS/5.6/updates/x86_64/repodata/primary.sqlite.bz2: [Errno -1] Metadata file does not match checksum
Trying other mirror.
[code]....
Fedora Networking :: /usr/bin/perl: Symbol Lookup Error: /usr/bin/perl: Undefined Symbol: PL_use_safe_putenv
Apr 8, 2009I am trying to setup the wlan access for my Fedora 9 system. I installed ndiswrapper. But when I run
Code:
ndiswrapper -l
i am getting the error
Code:
/usr/bin/perl: symbol lookup error: /usr/bin/perl: undefined symbol: PL_use_safe_putenv
CentOS 5 Server :: Unable To Give "Perl Path" To Run Perl CGI Script
Jun 2, 2011I am unable to run perl-cgi script in my cent os Apache server. I have used locate perl command in terminal window and it gives following result:
[code]....
tell which is the path to perl for example "usr/bin perl"
General :: Use "#!/usr/bin/perl" In The Beginning Of A Perl Script
Dec 17, 2010I have a small problem with Perl and Apache.
If I use "#!/usr/bin/perl" in the beginning of a perl script the script won't work if the script is at all complicated. Simple scripts like "Hello World" works.
But if I use "#!/usr/bin/perl -w" in the beginning all scripts work?
If I don't use the -w this is whats in the logs:
(2)No such file or directory: exec of '/home/test.net/html/cgi-bin/uh/meny.pl' failed
Premature end of script headers: meny.pl
When I use the -w in the script the error-log shows me this.
meny.pl: Name "main::http_path_cgi" used only once: possible typo at /home/test.net/html/cgi-bin/uh/meny.pl line 24.
Software :: ERROR "global Name 'sqlite' Is Not Defined" When Install Apache + Subversion + Trac
Oct 3, 2010ERROR "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]....