root / pykota / branches / 1.26_fixes / initscripts / mysql / README.mysql @ 3527

Revision 3133, 2.7 kB (checked in by jerome, 18 years ago)

Changed copyright years.

  • Property svn:eol-style set to native
  • 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, 2007 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 for the pykota-mysql.sql script :
23-----------------------------------------------
24
25This script is to be used to create an empty Quota Storage
26DataBase using MySQL as a backend.
27
28        - edit the pykota-mysql.sql file and modify the passwords at
29          the end of the 'GRANT USAGE' lines.
30         
31        - As MySQL's administrative user, usually root,
32          do the following :
33         
34            # mysql <pykota-mysql.sql
35           
36        - If no error message appear, your MySQL PyKota storage
37          is now ready for use.
38         
39        - In ~pykota/pykota.conf, ensure that the following lines
40          are present and unique inside the [global] section :
41       
42            storagebackend : mysqlstorage
43            storageserver : localhost
44            storagename : pykota
45            storageuser : pykotauser
46            storageuserpw : readonlypw
47           
48            NB : replace 'readonlypw' with the password you chose
49            for user 'pykotauser' when you modified pykota-mysql.sql
50           
51        - In ~pykota/pykotadmin.conf ensure that the following lines
52          are present and unique inside the [global] section :
53       
54            storageadmin : pykotaadmin
55            storageadminpw : readwritepw
56           
57            NB : replace 'readwritepw' with the password you chose
58            for user 'pykotaadmin' when you modified pykota-mysql.sql
59           
60        - IMPORTANT : if your database is not located on the print server,
61          replace 'localhost' in the lines above with your database server's
62          hostname or IP address. If your database server doesn't listen on
63          its standard port, add the port number at the end of the hostname
64          with a colon to separate the hostname from the port.
65          See pykota/conf/pykota.conf.sample for examples.
66       
67============================================================
Note: See TracBrowser for help on using the browser.