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

Revision 2840, 3.4 kB (checked in by jerome, 18 years ago)

Improved documentation

  • Property svn:keywords set to Author Date Id Revision
Line 
1# $Id$
2
3PyKota - Print Quotas for CUPS and LPRng
4
5(c) 2003, 2004, 2005, 2006 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
22Documentation :
23---------------
24
25pykota.sqlite :
26
27    This file can be used to create an empty SQLite3 database
28    for use with PyKota, in the case you don't want to use
29    either PostgreSQL, MySQL, or LDAP :
30   
31    NB : an SQLite3 database can't be shared between several
32    PyKota managed print servers, contrarily to the other
33    database backends.
34   
35    HowTo :
36   
37      - Install SQLite v3.2.7 or higher, and its development files,
38        for example on my Debian box :
39       
40                # apt-get install sqlite3 libsqlite3-dev
41               
42        You can also download SQLite from http://www.sqlite.org       
43
44      - Download and install PySQLite v2.0.5 or higher from :
45     
46                http://www.pysqlite.org
47
48        Install it this way :
49
50                # tar -zxf pysqlite-2.0.5.tar.gz
51                # cd pysqlite-2.0.5
52                # python setup.py install
53               
54        Under Debian, if the package exists for your version of Debian,
55        simply do :
56       
57                # apt-get install python-pysqlite2
58               
59      - Create an SQLite3 database for PyKota :
60
61                # sqlite3 ~pykota/pykota.db <pykota.sqlite
62                # chown pykota.pykota ~pykota/pykota.db
63                # chmod 660 ~pykota/pykota.db
64                # chown pykota.pykota ~pykota       (seems to be necessary)
65               
66        NB : adapt the permissions so that the user your printing
67             system runs as (e.g. user 'lp') can read and write
68             to the /etc/pykota/pykota.db file.
69               
70      - In ~pykota/pykotadmin.conf, just comment out all the lines
71
72      - In ~pykota/pykota.conf, ensure that the following lines
73        are present and unique inside the [global] section :
74
75                storagebackend : sqlitestorage
76                storagename : /etc/pykota/pykota.db
77               
78        And comment out all other directives which name begins with 'storage'.
79        NB : feel free to use a different path to store pykota.db, and
80             adapt your configuration files and permissions accordingly.
81               
82Your PyKota setup is now ready to be used with an SQLite3 database.             
83
84IMPORTANT : with PyKota's SQLite backend there's no possibility to separate
85readonly accesses from readwrite accesses for now, so don't set your
86permissions too loosely if untrusted users have local shell access on
87your print server.
88
89Please report bugs to : alet@librelogiciel.com
90
91===================================================================
Note: See TracBrowser for help on using the browser.