General :: Running Sql Script Under Sqlite3?
Jun 16, 2010I have been given a sql script with SQL commands in it to set up a new sqlite3 db. How do I run such a thing?
View 1 Replies
ADVERTISEMENT
Software :: Get Sqlite3 Working With Wordpress 2.9.2?
Mar 20, 2010I am running Debian 5.0 (Lenny). I am trying to get Wordpress 2.9.2 to work with Sqlite3. I hear Sqlite is a better database server than MySql because it is lighter on resources and is much smaller. I am very new to Sqlite3, however, so I'm not totally sure what to do here. In my wp-config.php file (the Wordpress configuration file), I've set the database name and user name, and such. Now, I think I know how to create a database, but from that point forward, I'm lost. How do I add the password for Wordpress to access the database. By the way, I made a regular Unix user, called sqlite, for all Sqlite things.
View 1 Replies View RelatedSoftware :: Yum Fails With Sqlite3.OperationalError
Feb 22, 2010I am using fedora 10, and everything was working fine till yesterday, i was using yum and my system is updated with yum update as well. Then yesterday i build new kernel from source 2.6.32, and today i boot with that kernel. Now my yum doesnt work.
it gives following error message.
Code:
[root@localhost Download]# yum provides libpulse
Loaded plugins: refresh-packagekit
rpmfusion-free
[Code]....
Fedora :: Compile And Test Sqlite3 With DSQLITE_ENABLE_UNLOCK_NOTIFY?
Sep 11, 2010Whats best way to compile and test Sqlite3 with DSQLITE_ENABLE_UNLOCK_NOTIFY?
View 1 Replies View RelatedSoftware :: Can't Connect IReport To SQLite3 Database
Aug 13, 2009I am trying to replace my Widows work station with Linux, I am now down to two applications. One is close to being resolved (it's a hardware connector between two pieces of equipment) and the other is replacing Crystal Reports with JasperSoft iReports.
I have been progressively hammering away at this for several months now. And still no progress. All I need to do is connect the stupid report software to my SQLite database.
Now, no I cannot move to another database. This is the solution I have and that's it. I know someone will suggest MySQL or some other db... not in the cards not in this time frame. I have over a year invested in the application/database and have already deployed it for use. And I just don't have the time needed to re-write my application to connect to another database then move all my tables and data over to another database then go through the entire testing cycle again. Okay I think that horse is dead and the position clear.
System Specs:
OS: OpenSuSE 11.0 x86_64
Desktop: KDE 3.5.9 "release 49.1"
CPU: AMD Athlon 7750 Dual-Core
Drives: 3 SATA
[Code].....
And it shows up in iReport after I point to it... but then I get this error from iReport when I try to connect to my DB.
"Unable to add connection. Cannot establish a connection to using org.sqlite.JDBC (Unable to find a suitable driver)."
I have been all over the web and haven't found any clear instructions or directions on where these drivers are stored, how to properly add a driver or how to connect iReport to SQLite... and according the iReport web site I can...
Software :: Cross Compiling Sqlite3 For Arm 7 Processor?
Nov 22, 2010i am trying to cross compile sqlite3 with following options(i got these options from previous threads in these forum)./configure --host=arm-linux CC=/usr/local/arm-linux/bin/arm-linux-gcc AR=arm-linux-ar STRIP=arm-linux-strip RANLIB=arm-linux-ranlib while executing make command i am getting following error
rm -fr .libs/libsqlite3.so .libs/libsqlite3.so.0 .libs/libsqlite3.so.0.8.6
/usr/local/arm-linux/bin/arm-linux-gcc -shared .libs/sqlite3.o -ldl -lpthread -Wl,-soname -Wl,libsqlite3.so.0 -o .libs/libsqlite3.so.0.8.6
[code]....
Programming :: Can't Find Package Sqlite3 - Using TCL On Ubuntu
Jun 9, 2010I am programming with TCL on Ubuntu Linux. I need to access a SQLite3 database. I loaded the SQLite3 package using sudu apt-get install sqlite3. When I try to open the database in TCL I get the error "can't find package sqlite3"
The line of code is: "sqlite3 db /home/lana/CAL_development/databases/CpRoutine.db"
I also have "package require sqlite3" directive in the program.
Programming :: Have Sqlite3 Headers And Start Using In Programs?
Sep 10, 2010I'm new to database programming but I'm working in a project that makes use of sqlite3. I know I should #include <sqlite3.h> but it is not there.... i have just sqlite.h. can anyone tell me what to do to have the sqlite3 headers and start using them in my programs
View 9 Replies View RelatedDebian Configuration :: Setting Up Small Web Server With PHP And SQLite3
Apr 5, 2010I'm trying to set up a small web server with php and sqlite support. I installed lighttpd, php5, php-sqlite3 and php5-sqlite3. Then, I enabled sqlite and pdo extensions in php.ini:
extension=pdo.so
extension=sqlite.so
extension=pdo_sqlite.so
However, when I try to open a SQLite3 database from php:
$database = new SQLiteDatabase($myDB, 666, $error);
I get the following exception:
SQLiteDatabase::__construct() [sqlitedatabase.--construct]: file is encrypted or is not a database
Some readings in the net make me think that my php settings are not compatible with SQLite3 databases. Is anyone successfully working with SQLite3 databases from PHP5 under Debian? Have you any recommendations? Should I rebuild php maybe?
Software :: Error: Support Of At Least One Of Mysql Or Sqlite3 Must Be Configured
Jan 6, 2010First off I'm using OpenSUSE 11.2. I'm trying to compile mediatomb and I'm having difficulty when I run './configure' This is the message I get when it fails:
Code:
configure: error: Support of at least one of mysql or sqlite3 must be configured I have both sqlite3 and mysql installed.
Fedora :: YUM SQLite3 Database Error - Disk Image Malformed
Jun 29, 2010I have such trouble with YUM:
$ sudo yum update
Total 807 kB/s | 192 MB 04:03
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Traceback (most recent call last): .....
File "/usr/lib/python2.6/site-packages/yum/sqlutils.py", line 166, in executeSQLQmark
return cursor.execute(query)
sqlite3.DatabaseError: database disk image is malformed
I already try clean yum cache and remove checksum data, rebuild rpm db, check / partition,
but no luck, problem still occurs.
Ubuntu :: SQLite3, C++ & Ubuntu - Undefined Reference To `sqlite3_open'?
Jun 7, 2010SQLite3 newbie and C++ newbie. I have a little C++ program that I am attempting to connect to a test database.#include <iostream>using namespace std;#include <sqlite3.h>int main ()
View 1 Replies View RelatedGeneral :: Why Does Running A Program In Bash Work, When Running It In The Menu Doesn't?
Jul 26, 2010I presume there is something in the JWM window manager - or Puppy Linux Lupu 5.01 itself that is conflicting with the normal loading of GMPLAYER....
I would like to know how to troubleshoot, and fix this problem if possible (even a workaround would be great).
General :: Error:backend-not-running Backend Not Running As Expected (yumex Will Close)
Mar 9, 2010i installed yumex:yum -y install yumex, when i start yumex it came with this error:fatal error:backend-not-running backend not running as expected (yumex will close) how can i solve it?
View 10 Replies View RelatedFedora X86/64bit :: Running Emacs 22.3 Under An X86_64 Running FC10 - Stops Responding ?
Jul 19, 2009After "yum install emacs" & "yum install emacs-ess", I was able to install emacs on my X86_64 running Fedora 10.
If I run one session of emacs everything works fine.
Once I start a second session and try to resize or move the emacs window, the system stops responding.
Ubuntu Networking :: Cannot See Network Icon - Nm-applet Running - Notification Area Running
Dec 25, 2010Hi. I have Ubuntu 10.04, nm-applet is running in the background, my battery icon and sound icon are showing but my network icon has been missing for the past 2 days. It was working fine before but now it's not. How can I fix this issue if I don't have an ethernet cord? Is there a way to roll back the recent updates or do I need to reinstall my network manager?
I've tried restarting the system and I've tried killing nm-applet and reloading it using Alt F2. I get some Debug error.
When I try to run nm-applet --sm-disable
It says an instance is already running and then gives me a warning.
I tried removing "iface eth0 inet dhcp" from /etc/network/interfaces and then tried restarting by "sudo /etc/initi.d/networking restart"
It says:
What can I do to connect to the internet? I have a flash stick if its possible to download a .deb package on this mac and transfer it over to my other laptop to fix the problem. If its possible.
Debian :: Running Same Process Multiple Times(from Another Account) / An Instance Of Newsbeuter Is Already Running Error?
Aug 6, 2010Sometimes I connect to my Debian box from another computer (using SSH on Cygwin or Linux), and once ina while I want to run some console apps. And sometimes some of these apps might complain about "another intance, Error: an instance of newsbeuter is already running (PID: 2496)". Is there a work around for this issue at all(without killing the original instance") ? The reason I do not want to kill the app because there might be 2 users connected to the same machine that might be using the same app.
View 1 Replies View RelatedProgramming :: Suid Disabled From Running All Scripts Or Just From Running Them As Root ?
Sep 4, 2009Is suid disabled from running all home made bash scripts or just from running them as root or:
Who would know for sure.
I googled several combinations of Mandriva Linux how-to suid disabled setUID etc... so far all I found was "many distributions are disabling suid for security reasons" nothing specific.
Red Hat :: Running IPmonitor To Monitor The Disk Usage On Our Servers - Running Df -h
Mar 19, 2010We are running IPmonitor to monitor the disk usage on our Linux servers. It does not seem to coincide with what is reported when running df -h. For example on a Red Hat 5.3 server - our IPmonitor shows that 85% is used on the /usr partition, however when I do a df -h on the server it shows that 91% is used. Why there would be a discrepancy? IPmonitor uses SNMP.
View 5 Replies View RelatedUbuntu :: Processor Running At 100 Percent - Fan Is Running At Max Speed
Apr 5, 2011I can't figure out why but my processor is running at 100% on all four cores, and the fan is running at max speed. All I did was double click an a.out file created by g++, and it is running at full speed now.
[IMG]file:///tmp/moz-screenshot.png[/IMG][IMG]file:///tmp/moz-screenshot-1.png[/IMG]
Programming :: Cron And Fsarchiver Reportedly Running Not Actually Running?
Jun 1, 2010My root Vixie cron crontab is set to perform a system snapshot via fsarchiver: 0 0 * * * fsarchiver savefs -o -A /backups/p30_root.fsa /dev/sda2 /dev/sda3 The command itself works fine, generating about a 7G snapshot of my Suse server. I then wish to rsync this to a NAS I have located in another building: 0 3 * * * rsync -av -e ssh --delete /backups/ root{at address}:/DataVolume/os_backups/
(yes, I'm rsyncing as root. I absolutely loathe it, but I got thrown into an quasi-SA position with a ridiculous to-do list and no time to do it. I'm having to make things just work and then go back and try to improve them/learn how. I couldn't make it work in a non-root way quick enough, so for now I'm having to cron rsync jobs as root because of all the differing file permissions on this samba/MySql server. I set the NAS to only accepts ssh from the server IP, and we're behind a campus firewall... It's serious trial by fire.) The crontab also has rsync commands for the samba areas, our specialized chemistry software and affiliated MySQL databases............
Software :: Prevent Rsync From Running If Another Instance Is Running?
Mar 29, 2011On my crontab there is an entry to run a script I wrote that backs up my local files to my remote server. It was working great, running once a day. However, I now want to make the script run every hour.The problem is that if there are too manyfiles to transfer (Example:I ripped a DVD in the last hour) the actual backup may take longer than 60 minutes.So I want to modify the script to check if my backup script, based on rsync, is running. If rsync is still running then do nothing and exit the script. If it is not running, execute the script as normal.
View 5 Replies View RelatedGeneral :: Running Mac OS X In A VM On A Mac
Aug 30, 2011I have a 2011 MacBook Pro and I'm getting really frustrated with Lion. I was a long time Linux user prior to getting my first MacBook (I wanted the hardware, not the software, but stuck with it) and I'm thinking about returning, however, I do iPhone development so I need to have OS X available. Is there an easy solution to run Lion in a VM on Linux? It's not technically a Hackintosh because it's running on Mac hardware, but I'm afraid I'll end up having to do some Hackintoshing anyhow.
View 1 Replies View RelatedGeneral :: Running KDE As Root?
Aug 16, 2010KDE panels look strange with black colors when I login using root account.Is it possible to make KDE look normal? I am using root account because I spend most of the time performing administration tasks and I don't want to type my strong password so frequently.
View 1 Replies View RelatedGeneral :: Macbook Pro Running Only 3.6 GB RAM Available?
Nov 29, 2010I've happily installed Linux on my MacBook Pro with 4 GB of RAM, but I only get 3.6 GB available:
[Code]...
General :: Running Live Cd
Dec 5, 2009I have burned the Linux Mint 8 "Helena" iso image to a CD no problem but when i try to run the "Live CD" a login box appears and no matter what i do i keep getting "Authentication Failure"?So i can't proceed running the "Live CD".Could someone help me out here please and tell me what i am doing wrong. I just want to run the "Live CD" before i decide whether to install the OS to the hard drive.
View 1 Replies View RelatedGeneral :: Whats The OS For Running WoW
Jan 18, 2011I'm looking for an OS to run WoW on mainly.
View 4 Replies View RelatedGeneral :: See If A Binary Is Running?
Aug 19, 2010I'm trying to autodetect if certain applications (for example, Firefoxre running. I figured the easiest way would be by checking process names.
View 2 Replies View RelatedGeneral :: Get PAF 5 Running On (MEPIS Ver 8)
Mar 6, 2011I need to get PAF 5 Running on Linux (MEPIS Ver 8) The mepis systems works very well on Open Office,and with printers and scanners an all the games I have tried
View 2 Replies View RelatedGeneral :: Fan Keeps Running Once Started?
Feb 28, 2011My problem is that my fan will keep running quite quickly once started. It will keep running till reboot independently of CPU usage and temperature. To check the temperature I installed lm-sensors. Output of temperature related commands and kernel version are below. Shouldnt they all give the temperature? My machine is a Toshiba Satellite pro L300. Eg. at the moment my fan is running quite quickly although CPU usage is 3-4% and the temperature according to lm-sensors is approximately 40-45 degrees Celcius.
Code:
:~$ acpi --thermal
Battery 0: Full, 100%
Thermal 0: ok, 0.0 degrees C
:~$ cat /proc/acpi/thermal_zone/THRM/temperature
[Code].....