Changeset 3413 for pykota/trunk/initscripts/sqlite/README.sqlite
- Timestamp:
- 09/27/08 22:02:37 (16 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/sqlite/README.sqlite
r3279 r3413 27 27 for use with PyKota, in the case you don't want to use 28 28 either PostgreSQL, MySQL, or LDAP : 29 29 30 30 NB : an SQLite3 database can't be shared between several 31 31 PyKota managed print servers, contrarily to the other 32 32 database backends. 33 33 34 34 HowTo : 35 35 36 36 - Install SQLite v3.2.1 or higher, and its development files, 37 37 for example on my Debian box : 38 38 39 39 # apt-get install sqlite3 libsqlite3-dev 40 41 You can also download SQLite from http://www.sqlite.org 40 41 You can also download SQLite from http://www.sqlite.org 42 42 43 43 - Download and install PySQLite v2.0.5 or higher from : 44 44 45 45 http://www.pysqlite.org 46 46 … … 50 50 # cd pysqlite-2.0.5 51 51 # python setup.py install 52 52 53 53 Under Debian, if the package exists for your version of Debian, 54 54 simply do : 55 55 56 56 # apt-get install python-pysqlite2 57 57 58 58 - Create an SQLite3 database for PyKota : 59 59 … … 62 62 # chmod 660 ~pykota/pykota.db 63 63 # chown pykota.pykota ~pykota (seems to be necessary) 64 64 65 65 NB : adapt the permissions so that the user your printing 66 66 system runs as (e.g. user 'lp') can read and write 67 67 to the /etc/pykota/pykota.db file. 68 68 69 69 - In ~pykota/pykotadmin.conf, just comment out all the lines 70 70 … … 74 74 storagebackend : sqlitestorage 75 75 storagename : /etc/pykota/pykota.db 76 76 77 77 And comment out all other directives which name begins with 'storage'. 78 78 NB : feel free to use a different path to store pykota.db, and 79 79 adapt your configuration files and permissions accordingly. 80 81 Your PyKota setup is now ready to be used with an SQLite3 database. 80 81 Your PyKota setup is now ready to be used with an SQLite3 database. 82 82 83 83 IMPORTANT : with PyKota's SQLite backend there's no possibility to separate