daily pastebin goal
75%
SHARE
TWEET

Untitled

a guest Jun 14th, 2018 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. james@pillbox:~/eureka; ls -l
  2. drwxr-xr-x 2 james james 4096 Feb  3 15:32 db
  3. james@pillbox:~/eureka; ls -l db
  4. -rw-rw-rw- 1 james james 3072 Feb  3 15:32 eureka.db
  5. james@pillbox:~/eureka; sqlite3 db/eureka.db
  6. SQLite version 3.7.3
  7. Enter ".help" for instructions
  8. Enter SQL statements terminated with a ";"
  9. sqlite> insert into ldap_cache values ('foo', 'bar', 'baz');
  10. sqlite> .quit
  11. james@pillbox:~/eureka; sudo -u www-data sqlite3 db/eureka.db
  12. SQLite version 3.7.3
  13. Enter ".help" for instructions
  14. Enter SQL statements terminated with a ";"
  15. sqlite> insert into ldap_cache values ('a', 'b', 'c');
  16. Error: unable to open database file
  17. sqlite> .dump
  18. PRAGMA foreign_keys=OFF;
  19. BEGIN TRANSACTION;
  20. CREATE TABLE ldap_cache (uid string primary key, retrieved_date date, ldap_data string);
  21. INSERT INTO "ldap_cache" VALUES('foo','bar','baz');
  22. COMMIT;
  23. sqlite> .quit
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top