The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
14 views

Unable to load SpatiaLite extension in SQLite 3

I've been building the SpatiaLite library and the GEOS library it's built upon, from source: wget http://download.osgeo.org/geos/geos-3.4.2.tar.bz2 tar jxf geos-3.4.2.tar.bz2 cd geos-3.4.2 ...
32
votes
7answers
81k 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 ...
1
vote
1answer
2k views

Graphite SQLite3 DatabaseError: attempt to write a readonly database

Running graphite under apache httpd, with slqite database, I have the correct folder permissions [root@liaan55 httpd]# ls -ltr /var/lib | grep graphite drwxr-xr-x. 2 apache apache 4096 ...
0
votes
4answers
2k 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
2answers
291 views

Inserting multiple lines into a sqlite column with bash script

I am trying to insert a value into my sqlite DB that consists of multiple lines and special characters. For example: { "foo"="$BAR" } I have been using the sqlite3 command but I dont know how to ...
0
votes
2answers
480 views

Database password error in Owncloud migrating from SQLite to MySQL/MariaDB

In a Fedora system, I need to convert the Owncloud's SQLite database into a MySQL/MariaDB database I started installing MySQL: # systemctl enable mysqld # systemctl start mysqld $ ...
3
votes
9answers
16k 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 ...
1
vote
1answer
349 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 ...
1
vote
1answer
653 views

Graphite SQLite3 DatabaseError: database is locked

While going through the initial installation and set up of Graphite on CentOS 6.4 using Apache mod_wsgi via the stock graphite-web rpm, I'm getting the following "DatabaseError: database is locked" ...
1
vote
1answer
57 views

Databbase file structure on disk [closed]

I'm an interested in the fundamentals of databases for a project that I am currently working on. Specifically the physical storage on disk and how rows and indexes are stored in a file. For the most ...
0
votes
1answer
163 views

Jenkins fighting with Django over permissions

I've got a Jenkins/Nginx server running. But I get the error from Django: attempt to write a readonly database So I solved this problem by changing the ownership of the project folder to the ...
1
vote
1answer
735 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 ...
0
votes
1answer
3k views

Unbuntu 14.04 + Nginx + PHP5-FPM + sqlite3 : pdo sqlite could not find driver

phpinfo() says I have SQLite 3.x driver for PDO. php.ini only mentions sqlite like so: [sqlite] ; http://php.net/sqlite.assoc-case ;sqlite.assoc_case = 0 [sqlite3] ;sqlite3.extension_dir = I ...
1
vote
1answer
410 views

yum list showing wrong version

I am trying to install freeswitch and while configuring it, it spits out the message. "checking for sqlite3 >= 3.6.20... Package sqlite3 was not found in the pkg-config search path. Perhaps you ...
0
votes
1answer
44 views

I cannot find the SQLite Instance on Haskell / Snap based server

I have inherited a Haskell based server (on Ubuntu) on which SQLite is being used for authentication through the Snap SQLite-Auth module. After searching the server I am unable to locate the SQLite ...
1
vote
1answer
54 views

Distributing load from Django App

I am currently approaching stages to move my first large-scale application out of development. I have talked with some CTOs who know what they're talking about, and I have been advised to do the ...
1
vote
2answers
202 views

How to force sqlite3 table to take next available id for auto increment in firefox sqlite3 manager?

We delete some records in a sqlite3 table (re-id record manually) and compact the db. However when adding a new record in firefox sqlite3 manager, the auto incremented id is not the next available id ...
1
vote
0answers
304 views

pysqlite for python 3.3.5 on Centos 6.5

I have compiled python 3.3.5 from source in the /opt folder as follows: yum install sqlite-devel ./configure --prefix=/opt/python3 make make install ln -s /opt/python3/bin/python3 /usr/bin/python3 ...
2
votes
1answer
1k views

How can I enable encryption for SQLite3 in PHP5.3? [closed]

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 ...
2
votes
1answer
6k views

How can I convert an MS Access database (.mdb) file to a Sqlite database (.db) file? [closed]

Can anybody help me convert an MS Access (.mdb) file to an Sqlite database (.db) file? I need to convert all the tables and dump the data inside. Are there any tools available, or is there any API ...
0
votes
1answer
232 views

Empty Asterisk 12 CDRs in SQLite3 database

Using: CentOS 6 Asterisk 12 cdr_sqlite3_custom.so cdr_sqlite3_custom.conf (deliberately simplified): [master] table=>cdr columns=>calldate, clid, test ...
0
votes
1answer
603 views

SQLite on latest PHP (>= 5.4)

http://www.php.net/manual/en/sqlite.installation.php Beginning with PHP 5.4, this extension is available only via PECL. http://pecl.php.net/package/SQLite This package is not maintained ...
0
votes
1answer
179 views

Which db managment software can copy from one sqlite3 table to another for fields which are common in both?

We are looking for db management software which can copy from one sqlite3 table to another for fields which are common to both tables. For example, if table A has column name and address. Table B has ...
0
votes
0answers
115 views

Can't listen to port 4445; sqlite3

So I have a dedicated machine running Ubuntu 12.04 server with FreePBX 2.9. Earlier I was attempting to familiarize myself with SQL via sqlite3, but I received this dreaded error: SQLite header and ...
2
votes
2answers
3k 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 ...
0
votes
0answers
189 views

Passwords imported from SQLite to MySQL don't work

When importing an SQLite database into MySQL I have repeatedly encountered the problem that encrypted passwords (even when copied manually) do not work anymore. Everything else works fine, but all ...
0
votes
3answers
2k 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
3answers
6k 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
2answers
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 ...
3
votes
2answers
389 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 ...
1
vote
0answers
150 views

thttpd slow and huge resource usage

I have a thttpd server with php, xml2 and sqlite3 running on an embedded arm linux system. In general the system is working, but my sites are loaded really slow (ca. 20s per site, doesn't matter if ...
6
votes
5answers
3k views

SQLite on a production server? [closed]

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. I was never able to find a solid estimate on how much traffic it could handle ...
0
votes
1answer
310 views

How do I back up my rails database on the fly?

I have been looking for a way to back up my app's database which is hosted by heroku. It uses an sqlite database. What I am looking for is a way to add a button on my site which will allow me to ...
0
votes
2answers
147 views

database on SSD: data only or the DBM program too?

I plan on moving the data I use for statistical analysis (100-ish Gb) onto an SSD. The data is either sqlite single-file db's, or postgresql-managed data. The SSD is 240 Gb, 550 MB/s read and 520 MB/s ...
1
vote
1answer
1k views

Not Installing Sqlite 3 on CentOS correctly

I need to get sqlite 3 installed for php on a CentOS but its still telling that it's not installed. I did the command and got this message: yum install sqlite Package sqlite-3.6.20-1.el6.x86_64 ...
1
vote
1answer
123 views

Sqlite enabling in PHP 5

I know similar questions have been posted but they don't answer my question as far as I can tell. I have PHP 5.3 that is supposed to have sqlite3 extension installed php.ini does NOT have sqlite3 ...
1
vote
0answers
426 views

Can you use SQLite 64 bit odbc from powershell

Basically, my question is "Does this combo work for anyone," and, "Can you see what I am doing wrong" I have installed 64 bit ODBC driver for sqlite, downloaded from this page. I am running ...
5
votes
5answers
59k 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 ...
1
vote
1answer
619 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 ...
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 ...
0
votes
1answer
657 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 ...
1
vote
2answers
914 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 ...
2
votes
3answers
3k 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 ...
1
vote
2answers
8k 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 ...
5
votes
7answers
3k 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 ...
5
votes
4answers
2k 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 ...
0
votes
1answer
716 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 ...
0
votes
1answer
414 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
1answer
2k 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
289 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 ...