[Modeling-cvs] ProjectModeling/Modeling/doc/UserGuide EnvironmentVariables.tex,1.4,1.5

[<sbi...@us...>]

Update of /cvsroot/modeling/ProjectModeling/Modeling/doc/UserGuide
In directory sc8-pr-cvs1:/tmp/cvs-serv22018/doc/UserGuide

Modified Files:
	EnvironmentVariables.tex 
Log Message:
RFE #726839: Added environment variable MDL_DB_CONNECTIONS_CFG; it
points to a single ini-file which centralizes the sensitive
informations contained in each model's database connection dictionary
(username, password). See tests/Postgresql.cfg for an example.


Index: EnvironmentVariables.tex
===================================================================
RCS file: /cvsroot/modeling/ProjectModeling/Modeling/doc/UserGuide/EnvironmentVariables.tex,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** EnvironmentVariables.tex	10 Mar 2003 17:02:50 -0000	1.4
--- EnvironmentVariables.tex	7 May 2003 11:22:07 -0000	1.5
***************
*** 4,9 ****
  
  \begin{tableiii}{p{1cm}p{11cm}|p{3cm}}{code}{Name}{Description}{Possible values} 
! \lineiii{MDL_ENABLE_DATABASE_LOGGING}{}{}
  
  \lineiii{}{DatabaseAdaptors for Postgresql and MySQL use a common logging
  mechanism, whose methods are located in module \module{Modeling.logging}. This
--- 4,38 ----
  
  \begin{tableiii}{p{1cm}p{11cm}|p{3cm}}{code}{Name}{Description}{Possible values} 
! \lineiii{MDL_DB_CONNECTIONS}{}{}
! \lineiii{}{It happens that a model can be written in different places:
! in an xml file, in a python file, and even in a pickle when you use
! \code{mdl_compile_model.py}. The consequence is that the connection
! dictionary itself for each model, containing the user and its password,
! is written two or three times in the filesystems. For security and
! administrative reasons, one would prefer that this sensitive information
! should be written in a single place.\newline
! ~\newline
! This environment variable allows you to externalize the connection
! dictionaries of all your models in a single file; you'll typically
! remove the user and password from your models, and add these
! informations to a single file, say
! \file{/full/path/to/db_conn_dicts.cfg}, in a dedicated section for each
! model, like this:\newline
! \begin{center}
! \code{[aModelName]~~~~}\newline
! \code{user: a_username}\newline
! \code{password: passwd}\end{center}
! Then, simply assign to the env. variable \code{MDL_DB_CONNECTIONS_CFG}
! the full path to your \file{db_conn_dicts.cfg}, and your models'
! connection dictionaries will automatically be updated when they are
! loaded.\newline Last, every parameter normally assigned to a connection
! dictionary can be defined in this file, such as: \code{host},
! \code{port}, etc. An extra field can be specified, \code{adaptor}, which
! overrides the adaptor's name in your model (example value:
! \code{Postgresql}, \code{MySQL}).\newline See also python documentation
! for \module{ConfigParser}.}{full path to an ini-file}
! \hline
  
+ \lineiii{MDL_ENABLE_DATABASE_LOGGING}{}{}
  \lineiii{}{DatabaseAdaptors for Postgresql and MySQL use a common logging
  mechanism, whose methods are located in module \module{Modeling.logging}. This
***************
*** 12,16 ****
--- 41,47 ----
  the \code{sys.stderr}. To disable it, just unset this variable, or set it to
  the empty string.}{e.g. '1', 'YES' (plus the empty string for de-activation)}
+ 
  \hline
+ 
  \lineiii{MDL_PERMANENT_DB_CONNECTION}{}{}
  \lineiii{}{By default, the database connection is closed each time the last