Changeset 2842

Show
Ignore:
Timestamp:
04/07/06 22:21:11 (17 years ago)
Author:
jerome
Message:

Now includes the documentation on how to setup an SQLite database

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • pykota/trunk/docs/installation.sgml

    r2835 r2842  
    426426       
    427427      <para> 
    428         <application>SQLite</application> is supported but not documented for now. 
     428        <application>SQLite</application> is an embeddable Relationnal DataBase 
     429        distributed under a Free Software 
     430        license from the  
     431        <ulink url="http://www.sqlite.org">http://www.sqlite.org</ulink> 
     432        web site.  
     433        If is very easy to configure and use, offers a very small memory footprint, 
     434        is very fast, but can only be used on the print server because it doesn't include 
     435        a server daemon : the database is directly embedded in the application. 
     436      </para> 
     437       
     438      <para> 
     439        To configure your database, you must have SQLite already working. 
     440        The complete installation of <application>SQLite</application> is not covered by 
     441        the present manual, please refer to your system's documentation or to  
     442        <ulink url="http://www.sqlite.org">http://www.sqlite.org</ulink> for 
     443        details. 
     444      </para> 
     445       
     446      <para> 
     447        Once <application>SQLite</application> is installed, you have to decide where 
     448        you'll put your database. A good idea is to store it into the <literal>pykota</literal> 
     449        user's home directory. Then to create the database, just type : 
     450<screen>         
     451# sqlite3 ~pykota/pykota.db &lt;pykota/initscripts/sqlite/pykota.sqlite 
     452# chown pykota.pykota ~pykota/pykota.db 
     453# chmod 660 ~pykota/pykota.db 
     454# chown pykota.pykota ~pykota 
     455</screen> 
     456      </para> 
     457      <para> 
     458        If user <literal>pykota</literal> doesn't exist yet, then please 
     459        follow the instructions a bit below which explain how to install PyKota on the print server. 
     460      </para> 
     461       
     462      <para> 
     463        Once this is done, you'll want to set in <filename>~pykota/pykota.conf</filename> the 
     464        following lines in the <literal>[global]</literal> section : 
     465<screen>         
     466storagebackend : sqlitestorage 
     467storagename : /etc/pykota/pykota.db 
     468</screen> 
     469      </para> 
     470      <para> 
     471        Of course you'll want to replace the path on the <literal>storagename</literal> line 
     472        with the full path to the newly created <application>SQLite</application> database. 
     473      </para> 
     474      <para> 
     475        That's all ! For more details, please refer to <filename>pykota/initscripts/sqlite/README.sqlite</filename>. 
    429476      </para> 
    430477    </sect2>   
     
    530577              <listitem> 
    531578                <para> 
    532                   SQLite backend : Supported but not documented yet. 
     579                  SQLite backend : SQLite is not a database server, but an embeddable database, so 
     580                  if you want to use it you MUST install SQLite on your print server. With  
     581                  <application>PostgreSQL</application>, <application>MySQL</application> or 
     582                  <application>OpenLDAP</application> you can store your datas on a different 
     583                  machine than the print server, but this is not possible with <application>SQLite</application>. 
     584                  <itemizedlist> 
     585                    <listitem> 
     586                      <para> 
     587                        <application>SQLite</application> version 3.2.1 or higher and its library. 
     588                        You can download it from  
     589                        <ulink url="http://www.sqlite.org">http://www.sqlite.org</ulink> 
     590                      </para> 
     591                    </listitem>   
     592                    <listitem> 
     593                      <para> 
     594                        The <application>Python-SQLite</application> python module version 2.0.5 or higher. 
     595                        You can download it from  
     596                        <ulink url="http://www.pysqlite.org">http://www.pysqlite.org</ulink> 
     597                      </para> 
     598                    </listitem>   
     599                  </itemizedlist> 
    533600                </para> 
    534601              </listitem> 
     
    864931         
    865932        <para> 
    866           You can now ask questions on IRC : 
     933          You can also ask questions on IRC : 
    867934          <screen> 
    868935/server irc.freenode.net