james@pillbox:~/eureka; ls -l
drwxr-xr-x 2 james james 4096 Feb  3 15:32 db
james@pillbox:~/eureka; ls -l db
-rw-rw-rw- 1 james james 3072 Feb  3 15:32 eureka.db
james@pillbox:~/eureka; sqlite3 db/eureka.db
SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> insert into ldap_cache values ('foo', 'bar', 'baz');
sqlite> .quit
james@pillbox:~/eureka; sudo -u www-data sqlite3 db/eureka.db
SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> insert into ldap_cache values ('a', 'b', 'c');
Error: unable to open database file
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE ldap_cache (uid string primary key, retrieved_date date, ldap_data string);
INSERT INTO "ldap_cache" VALUES('foo','bar','baz');
COMMIT;
sqlite> .quit