Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sqlite]

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format.

Think of SQLite not as a replacement for Oracle but as a replacement for fopen()

Executive Summary

102 questions
0
votes
1 answer

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 apache/passenger fail to open the database, throwing a…
sendos
  • 21
  • 2
0
votes
1 answer

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 to install php5-sqlite3 (sudo aptitude install…
richard
0
votes
2 answers

Does exim4's `${sqlite_quote ... }` expansion de-taint the expanded value?

I'm upgrading an exim4 installation which has some custom filters, to Debian 11. (Specifically, the filters are this.) Since that uses Exim 4.94, I've now run into the new-ish "tainted variables" feature, which has broken my filter. Checking Exim in…
wu-lee
  • 105
  • 3
0
votes
0 answers

Particular Email DB In Users Folder In Roundcube

I am trying to make db for every particular mail in user folder but when I use getenv('HOME') and getenv('_RCUBE') it shows me unable to connect with db. This is how I use it $config['db_dsnw'] = 'sqlite:///' . $_SERVER['HOME'] . '/etc/' .…
be MrZulf
  • 1
  • 2
0
votes
1 answer

Cannot execute sqlite statement with Ansible command module - [Errno 2] No such file or directory: b'sqlite3'"

I am trying to run a simple query on many servers. I know 100% that the file and directory in question exist. I can do simple commands, such as ls, pwd, whoami, etc, and I can run the sqlite command on the remote host itself. The playbook task: -…
DevOpsSauce
  • 288
  • 4
  • 13
0
votes
1 answer

script backups sqlite database, when ran as a cron the db and names are mangled

I have a crontab: * * * * * /home/ipa/web/backup.sh > /dev/null 2>&1 (No it doesn't run every minute just testing here) The backup.sh has this: #!/usr/bin/env sh sqlite3 /home/ipa/web/ipa_django/mysite/db.sqlite3 ".backup…
Codejoy
  • 67
  • 3
  • 13
0
votes
1 answer

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 configured svn with SQLite
vinayrks
  • 157
  • 1
  • 8
0
votes
1 answer

A (cron) job to run if file has changed

I need to backup a live sqlite db by running a command once a day. Only if the db file has changed since last backup. How could it be achieved on Centos 8 ?
Boppity Bop
  • 722
  • 3
  • 11
  • 29
0
votes
1 answer

Postfix + SASL SQLite gives auxprop error on CentOS 7

I am receiving an unknown password verifier(s) auxprop error when trying to use SQLite for SASL authentication in Postfix on CentOS 7. It seems that the SQLite SQL engine is not found. Contents of /etc/sasl2/smtp.conf: log_level:…
tater
  • 1,395
  • 2
  • 9
  • 12
0
votes
1 answer

How can I use the django shell while the server is running?

I have a django server deployed on digitalocean with gunicorn and nginx. I followed a tutorial, I think it was this one. Because of the tutorial I have django only installed in a virtualenv. When I developed the server, I used to do stuff in the…
Sven
  • 125
  • 1
  • 5
-2
votes
1 answer

PHP 7.4 with last version of sqlite3

CentOS8 is distributed with sqlite3 version 3.26. I would like to build a php 7.4 RPM with the version 3.35 of sqlite3. Do you any advice to do so ?
fxbois
  • 97
  • 2
-3
votes
1 answer

Teamspeak 3 Database Error

I am working on a project for a 'redudant' teamspeak server wtih aws. Ive got most of what I need done, however I'm running into a snag. Teamspeak A is the primary server, and is running fine. I need to copy the database from server A to server…
Travis N
  • 1
1 2 3 4 5 6
7