The sqlite tag has no wiki summary.
0
votes
0answers
25 views
PHP sqlite3 : INSERT statement works in command line but not in browser
When I execute the following script via the command line (php5 script.php), it works fine, but when I run it via the web browser, only the first statement is executed.
<?
$DBNAME='astbase.db';
...
1
vote
0answers
73 views
DB encryption for Django web app without storing key on server
We are setting up a virtual private server (not hosted by us), on which we will be user testing our Django-based web application. The user-generated content produced in these tests will be very ...
0
votes
1answer
129 views
Why can't I install sqlite-devel package?
I'm try to install the sqlite-devel package on a Red Hat 4.1.2-51 x86_64 Linux server with rpm command:
# rpm -i ftp://ftp.muug.mb.ca/mirror/fedora/epel/4/x86_64/sqlite-devel-3.3.6-0.3.el4.x86_64.rpm
...
0
votes
2answers
759 views
PHP install sqlite3 extension
We are using PHP 5.3.6 here, but we used the --without-sqlite3 command when compiling PHP. (It stands in the 'Configure Command' column). But, it is very risky to recompile PHP on that server; there ...
0
votes
1answer
289 views
PHP enable sqlite phpinfo states --without-sqlite
I've seen similar questions but none that address my situation adequately. I'm running Apache and PHP 5.3.6 on a amazon cloud server.
phpinfo keeps stating that sqlite is disabled. At least that ...
0
votes
1answer
195 views
undefined symbol: sqlite3_initialize
When I try to deploy my Rails application to an Apache server using Passenger, I get the following error in the logs:
undefined symbol: sqlite3_initialize
I get the same error when just running ...
0
votes
0answers
72 views
Problem with paths in Tomcat and Birt Viewer; please help!
I'm at the stage of this tutorial, "Testing a more complex report", here:
http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php#testing
And I'm having trouble when it asks me to enter this url ...
0
votes
0answers
76 views
Mediawiki and SQLite3 not working
I have MediaWiki installed and configured and running under sqlite setting when I had MySQL installed (windows 7). However, after I uninstalled mysql, my mediawiki wiki fails to load. I don't know why ...
0
votes
2answers
269 views
How to dump sqlite database to ascii?
For some reason Firefox won't let me see more than 1 month of history, despite I have set to to remember for 90 days.
places.sqlite is 18MB so I would like to dump the content of it, and see if I can ...
1
vote
3answers
564 views
How to convert a postgres database to sqlite
We're working on a website, and when we develop locally (one of us from Windows), we use sqlite3, but on the server (linux) we use postgres. We'd like to be able to import the production database into ...
0
votes
2answers
143 views
How to install precompiled binaries in linux
I am trying to install a pre-compiled sqlite version 3 (sqlite3) binary in linux. I created a directory /home/username/src and I placed the zip file in the directory then unzipped the file. What I was ...
0
votes
1answer
118 views
cron to merge xml into sqlite every two hours - lamp
I'm looking to auto pull an xml file from an offsite url and merge it into a sqlite db every two hours. The server is lamp. (If it is too difficult to do for sqlite, then merging the xml into a mysql ...
1
vote
1answer
466 views
How do I install php with sqlite support in AWS EC2?
I'm trying to run an AWS EC2 instance for a facebook app. I chose the micro Amazon linux 32-bit as my OS. I'm able to SSH in and install PHP with yum, but when I run phpinfo() I see --without-sqlite ...
0
votes
1answer
359 views
How can I enable encryption for SQLite3 in PHP5.3?
The php manual for SQLite3::open has this information:
public bool SQLite3::open (
string $filename
[, int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE
[, string $encryption_key ...
1
vote
2answers
422 views
Installing sqlite gem fails on AWS Linux instance with sqlite-devel libraries installed
I'm running an instance built off ami-595a0a1c. I am trying to install the sqlite3 (or sqlite) gem and it's failing with the below error:
$ sudo gem install sqlite3
Building native extensions. This ...
4
votes
7answers
842 views
Is this idea about distributed database server with centralized storage feasible?
I often use SQLite for creating simple programs in companies. The database is placed on a file server. This works fine as long as there are not more than about 50 users working towards the database ...
0
votes
1answer
886 views
How do I activate SQLite3 on PHP 5.3.3 Centos 5?
I have reviewed the previous questions on this and they don't seem to cover what exactly I'm looking for, before I start, I'm no server admin. I'm trying to help get this server up and active and I ...
0
votes
1answer
2k views
Install PHP5 with SQLite3 on Debian Lenny
There is no apt-get install php5-sqlite3, as its refereed by php5-sqlite
thus, i did:
apt-get install sqlite3
and then
apt-get install php5-sqlite
Restarted apache2.
When I run echo ...
0
votes
4answers
590 views
Installing newer version of installed RPM from source (CentOS)
I've got sqlite 3.3.6 installed through ''yum'', but I need 3.6+. There's no RPM to be found for it, so I decided to install from source. That was simple enough, but now I have both versions ...
0
votes
3answers
2k views
sqlite3 support on centos with PECL?
i just realized that the rpm version of php that i have installed on the server don't have sqlite support (well it have the PDO support but for some reason don't work)
so i installed as a PECL ...
8
votes
2answers
1k views
How to Link an SQL Server 2008 Server to an SQLite Server?
I want to "Link" an SQLite server with an SQL Server 2008 server. E.g. using the sp_addlinkedserver command. How do I do this?
I have searched far and wide, but found no solution for this problem. ...
0
votes
1answer
394 views
sqlite and php enabling
I have a fresh install of fedora 12 and am trying to get php and sqlite working I installed php through: yum install php php-devel php-pdo and restarted apache. Php pages are working just fine but ...
1
vote
2answers
791 views
Enabling Sqlite3 for php on fedora
I am trying to get php with sqlite working on my fedora server. In the phpinfo is see that ./configure was set with the option --without-sqlite3. From what I have read these means that I might have to ...
2
votes
2answers
98 views
What database app is best for including in a distributable app?
MySQL versus SQLite, for example? I understand that MySQL is harder to setup and configure... Would SQLite or another db be better suited in this regard?
1
vote
1answer
236 views
Request Tracker sqlite to mysql migration
I'm planning to migrate request tracket 3.6 from present server. The rt is running on sqlite and the new one will be mysql. Is there any way to migrate sqlitedb to mysql server.
Thanks in Advance.
0
votes
3answers
332 views
An SQLite/STDIN Conundrum, Specific to AIX
I'm been playing around with SQlite at work, specifically with trying to get the sqlite3 command line tool to accept stdin instead of a file. Sounds easy enough, on linux you can execute a command ...
0
votes
1answer
687 views
sqlite : Fatal error: Call to undefined function sqlite_escape_string()
I use a script that requires SQLITE,
On my previous host, it worked. On localhost it works. On my new dedicaced server, it doesn't.
I use PHP5 of course, you can access phpinfo() of the server.
...
1
vote
1answer
385 views
Can't get php+sqlite working
I'm struggling all morning to make php work with an sqlite database. Here is a piece of php code that I try to execute:
#less /var/www/html/test.php
<?php
$db=new ...
2
votes
2answers
367 views
Why do I get a PHP 5.2.6 segmentation fault when using PDO_SQlite?
This is an installation on ModWest's shared hosting. I have enabled both PDO and PDO_sqlite on the server and phpinfo() verifies both are running. When I access PDO itself, I'm fine, and getting a ...
0
votes
1answer
551 views
Why is apache/passenger unable to open the sqlite3 rails database file?
I'm running apache2/passenger2.0.3 (ubuntu 9.10 packages).
I can start up Webrick in the rails folder and run the app perfectly as I do on my development box with
script/server
Why then does ...
1
vote
1answer
368 views
svnadmin: SQLite is required to be compiled and run in thread-safe mode
I've used apt-get to install Subversion and SQLite on my Ubuntu VPS, however, I'm getting this error when I try to use svn:
svnadmin: SQLite is required to be compiled and run in thread-safe mode
...
1
vote
1answer
229 views
weird text appearing when using PHPBB >v3.0.1 XAMPP windows SQLite
This is the strangest, most baffling problem I have ever encountered.
Basically when I use any PHP forum software other than phpbb it works fine but when I use any version of phpbb greater than 3.0.1 ...
0
votes
1answer
2k views
What should I change in php.ini to enable usage of sqlite from PHP?
At the moment I cannot use sqlite from PHP. Probably I need to change something in my php.ini file. In my php.ini file I found 2 lines containing "sqlite":
[sqlite]
;sqlite.assoc_case = 0
Does ...
1
vote
5answers
5k views
Why class 'SQLiteDatabase' is not found in /var/www/*.php?
I am trying to use sqlite from PHP. I have the following simple code:
<?php
$db = new SQLiteDatabase("test2.sdb");
unset($db);
?>
As the result of this code (which I execute in the command ...
3
votes
5answers
812 views
Sqlite on a production server?
I have known about Sqlite for a long time and I know it is blazing fast, but I have never tried it in a production server because I was never able to find a solid estimate on how much traffic it could ...
0
votes
1answer
3k views
How to install PHP5.3 and SQLite3 on Ubuntu 8.04
I got a Ubuntu Hardy VPS and I am trying to install PHP5.3 with SQLite.
I added the dotdeb PHP5.3 repository and succeeded in installing PHP5.3. But I need to install SQLite as well. When I'm trying ...
3
votes
2answers
301 views
Adobe Acrobat Sqlite errors with Mac OS X network accounts
We have set up network accounts for our Snow Leopard Users on several Macs, which work great except for applications that use a local Sqlite database for their preferences/cache. The biggest problem ...
0
votes
1answer
544 views
svnadmin: SQLite is required to be compiled and run in thread-safe mode
I am getting this error when trying to use svn on my shared hosting account [hostmonster]
svnadmin: SQLite is required to be compiled and run in thread-safe mode
My SQLite is in /usr/bin
How can i ...
1
vote
3answers
341 views
Dump Trac DB on Windows/XAMPP
I have a Trac instance running on a WindowsXP machine with XAMPP. I am trying to migrate the trac instance to a newer Linux-based machine. However, I'm having a hard time getting the database to ...
0
votes
3answers
617 views
Rsync / Sqlite database
Does anyone have ever tried rsync'ing sqlite database?
Is it possible to access the data while it gets syncronised?
0
votes
1answer
316 views
JDBCRealm can't find sqlite file
My authentication fails with
java.sql.SQLException: no such table: credentials
where credentials is the name of the user/password table. I have checked the db file and the table is there. I ...
1
vote
1answer
117 views
SQLite question? Podcast Producer server failure
Suddenly this morning none of my recording machines can connect to the server. There were no software updates on the client or server side this weekend. It looked like a firewall issue at first, but ...
1
vote
4answers
219 views
Best system to serve sqlite databases to webservers over a network?
I am helping in setting up a web service in which user data will be stored in sqlite databases on a server running perhaps Samba, and one or more web servers will read and write to those databases on ...
3
votes
4answers
805 views
Can SQLite be used with GlusterFS?
I want to build a distributed storage based on GlusterFS with Automatic File Replication (AFR) to store users files in a fault-tolerant way.
But I also want to access an SQLite3 database stored on ...
8
votes
3answers
15k views
Why do I get sqlite error, “unable to open database file”?
Using my Django app, I'm able to read from the database just fine. When the application didn't have permission to access the file, it gave me this error:
attempt to write a readonly database
...
3
votes
6answers
22k views
How do I enable SQLite on Linux/Apache/PHP?
To enable SQLite on my Windows/Apache/PHP setup, I uncomment the following lines in the php.ini file and restart Apache:
extension=php_pdo.dll
extension=php_pdo_sqlite.dll
Now I have a VPS with ...
0
votes
1answer
1k views
Oracle to SQLite “export/sync” (with inclusions/conditions)
For test/development I need to (repeatedly, e.g. daily) create a portable (partial) copy of an oracle database using SQLite.
By "copy" I mean: table structure and a subset of the data. No indexes, ...
