root / pykota / trunk / initscripts / sqlite / README.sqlite @ 2593

Revision 2593, 2.8 kB (checked in by jerome, 19 years ago)

Added support for SQLite3 database backend.
NEEDS TESTERS !

  • Property svn:keywords set to Author Date Id Revision
RevLine 
[2593]1# $Id$
2
3PyKota - Print Quotas for CUPS and LPRng
4
5(c) 2003, 2004, 2005 Jerome Alet <alet@librelogiciel.com>
6This program is free software; you can redistribute it and/or modify
7it under the terms of the GNU General Public License as published by
8the Free Software Foundation; either version 2 of the License, or
9(at your option) any later version.
10
11This program is distributed in the hope that it will be useful,
12but WITHOUT ANY WARRANTY; without even the implied warranty of
13MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
14GNU General Public License for more details.
15
16You should have received a copy of the GNU General Public License
17along with this program; if not, write to the Free Software
18Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
19
20
21============================================================
22
23        NB : FOR NOW SQLITE SUPPORT IS EXPERIMENTAL
24
25        USE AT YOUR OWN RISK !!!
26
27============================================================
28
29Documentation :
30---------------
31
32pykota.sqlite :
33
34    This file can be used to create an empty SQLite3 database
35    for use with PyKota, in the case you don't want to use
36    either LDAP or PostgreSQL.
37   
38    NB : an SQLite3 database can't be shared between several
39    PyKota managed print servers, contrarily to LDAP or
40    PostgreSQL.
41   
42    HowTo :
43   
44      - Install SQLite v3.2.7 or higher, and its development files,
45        for example on my Debian box :
46       
47                # apt-get install sqlite3 libsqlite3-dev
48
49      - Download and install PySQLite v2.0.5 or higher from :
50     
51                http://initd.org/tracker/pysqlite
52
53        Install it this way :
54
55                # tar -zxf pysqlite-2.0.5.tar.gz
56                # cd pysqlite-2.0.5
57                # python setup.py install
58               
59      - Create an SQLite3 database for PyKota :
60
61                # sqlite3 /etc/pykota/pykota.db <pykota.sqlite
62                # chown pykota.pykota /etc/pykota/pykota.db
63                # chmod 660 /etc/pykota/pykota.db
64               
65        NB : adapt the permissions so that the user your printing
66             system runs as (e.g. user 'lp') can read and write
67             to the /etc/pykota/pykota.db file.
68               
69      - In pykotadmin.conf, just comment out all the lines
70
71      - In pykota.conf, set :
72
73                storagebackend : sqlitestorage
74                storagename : /etc/pykota/pykota.db
75               
76        And comment out all other directives which name begins with 'storage'.
77        NB : feel free to use a different path to store pykota.db, and
78             adapt your configuration files accordingly.
79               
80Your PyKota setup is now ready to be used with an SQLite3 database.             
81
82Please report bugs to : alet@librelogiciel.com
83
84===================================================================
Note: See TracBrowser for help on using the browser.