Changeset 860

Timestamp:

03/22/03 15:06:02 (22 years ago)

Author:

jalet

Message:

Quota Storage Server installation is OK for PostgreSQL.

Files:

• pykota/trunk/docs/installation.sgml (modified) (5 diffs)

pykota/trunk/docs/installation.sgml

@@ -3 +3 @@
 <chapter>
   <title>Installation</title>
+  
+  <para>Last modified on $Date$</para>
+  
   <para>
     Before being able to use <application>PyKota</application>, you have of course to
@@ -10 +13 @@
   <para>
     First you have to determine which machine will be the <application>PyKota</application>
-    <glossaryterm>Storage Server</glossaryterm>. The Storage Server is the host responsible
+    <firstterm>Storage Server</firstterm>. The Storage Server is the host responsible
     for keeping a centralized database of print usage for all your printers, users and groups.
   </para>
   
   <para>
-    Then you have to list all the <glossaryterm>Print Servers</glossaryterm> for which
-    you plan to use <glossaryterm>print quota</glossaryterm> facilities.
+    Then you have to list all the <firstterm>Print Servers</firstterm> for which
+    you plan to use <firstterm>print quota</firstterm> facilities.
   </para>
   
@@ -44 +47 @@
       
       <para>
-        <application>PostgreSQL</application> is an <glossaryterm>Object Relationnal DataBase
-        Management System</glossaryterm> distributed under a <glossaryterm>Free Software</glossaryterm>
+        <application>PostgreSQL</application> is an <firstterm>Object Relationnal DataBase
+        Management System</firstterm> distributed under a <firstterm>Free Software</firstterm>
         license from the 
         <ulink url="http://www.postgresql.org">http://www.postgresql.org</ulink>
@@ -85 +88 @@
         server even if the configuration is correct. Sometimes your connections may be blocked by
         one or more network firewalls along the route from one machine to the other. If this
-        is the case, then the best thing you can do is to ask your <glossaryterm>Network Administrator</glossaryterm>
+        is the case, then the best thing you can do is to ask your <firstterm>Network Administrator</firstterm>
         to not filter the IP port used by <application>PostgreSQL</application>, which is
         usually port 5432/tcp.
+        <note>
+          <title>Note</title>
+          <para>
+            The TCP/IP network port used by PostgreSQL may be different. When in doubt, ask your 
+            <firstterm>System Administrator</firstterm> for the correct value. 
+          </para>
+        </note>  
+      </para>
+      
+      <para>
+        Now that your <application>PostgreSQL</application> server is up and running, and
+        is waiting for your connections, you have to create the Quota Storage DataBase.
+        To do so, you'll have to feed <application>PostgreSQL</application> with the
+        <filename>pykota-x.xx/initscripts/pykota-postgresql.sql</filename> file.
+        This file will create a Quota DataBase administrator and a Quota DataBase user
+        in the <application>PostgreSQL</application> system, then create an empty
+        Quota DataBase and set some permissions on it.
+      </para>
+      
+      <para>
+        To run this script, you can use the <application>psql</application> frontend to
+        <application>PostgreSQL</application>, but your priviledges must be sufficient
+        to be allowed to create users and databases. You can launch <application>psql</application>
+        as the <literal>postgres</literal> user which is <application>PostgreSQL</application>'s
+        default administrator, and connect to the default database named <literal>template1</literal>.
+        From a command line interpreter (i.e. shell), type the following commands :
+        <screen>
+jerome@nordine:~$ cd pykota-1.02-official/initscripts/
+jerome@nordine:~/pykota-1.02-official/initscripts$ psql -h localhost -U postgres template1
+Welcome to psql, the PostgreSQL interactive terminal.
+
+Type:  \copyright for distribution terms
+       \h for help with SQL commands
+       \? for help on internal slash commands
+       \g or terminate with semicolon to execute query
+       \q to quit
+
+template1=# \i pykota-postgresql.sql 
+            ... a lot of output lines
+template1=# \q      
+        </screen>
+      </para>
+      
+      <para>
+        If no error occured, then your Quota DataBase is ready to be used.
+        Now you can let the Quota Storage Server alone, the remaining work
+        will have to be done on each one of the print servers which will
+        use this particular Quota Storage Server.
         <tip>
           <title>Tip</title>
           <para>
-            The TCP/IP network port used by PostgreSQL may be different. When in doubt, ask your 
-            <glossaryterm>System Administrator</glossaryterm> for the correct value. 
+            If an error occured, maybe your PostgreSQL version is too old, or
+            an unexpected problem (like a bug) happened. Please send me an email so that I
+            can try to solve the problem. Thanks in advance.
           </para>
         </tip>  
-      </para>
-      
-      <para>
-        TODO.
       </para>
     </sect2>  
@@ -152 +200 @@
 
 $Log$
+Revision 1.6  2003/03/22 14:06:02  jalet
+Quota Storage Server installation is OK for PostgreSQL.
+
 Revision 1.5  2003/03/22 13:11:33  jalet
 The port on which the Quota Storage Sever is listening can now