The mailing list for listmasters using Sympa

[Richard Gilbert <address@concealed>]

Using 5.3.4, I have found the following strange behaviour with regard to 
reinstantiation of a family containing an include_sql_query paragraph. 
After the first instantiation the include_sql_query paragraph in the 
config file contained user, passwd and host.  When I reinstantiated the 
family after a small change to its config.tt2 the paragraph also 
contained db_user, db_passwd and db_host, leading to "Unknown key" errors.

I wonder whether I have misunderstood the need for reinstantiation?  I 
apologise if I shouldn't be sending this to the list, and am happy to 
file a bug report, if it is a bug.

I can reproduce this by instantiating the family with a single list, and 
then instantiating it again...

1. Instantiate family containing an include_sql_query paragraph.

[root@mercure expl]# ~sympa/bin/sympa.pl --instantiate_family=acs-lists 
--input_file=/home/sympa/etc/families/acs-lists/tmp.xml
/etc/aliases: 8 aliases, longest 33 bytes, 218 bytes total
admin::install_aliases() admin::install_aliases : Aliases installed 
successfully


******************************************************************************

******************** INSTANTIATION of acs-lists FAMILY ********************

******************************************************************************


These lists have been created and aliases are ok :
  acs-staff

* acs-staff/config contains:

include_sql_query
passwd xxxxxxxx
db_name macl
db_type Oracle
user mailserver
name altmacl
sql_query ...
db_port 1522
host mrpink.shef.ac.uk

2. Reinstantiate family

[root@mercure expl]# ~sympa/bin/sympa.pl --instantiate_family=acs-lists 
--input_file=/home/sympa/etc/families/acs-lists/tmp.xml


******************************************************************************

******************** INSTANTIATION of acs-lists FAMILY ********************

******************************************************************************


These lists have been updated and aliases are ok :
  acs-staff

* acs-staff/config now contains:

include_sql_query
db_name macl
db_user mailserver              <====
db_host mrpink.shef.ac.uk       <====
name altmacl
db_port 1522
host mrpink.shef.ac.uk
passwd xxxxxxxx
db_type Oracle
user mailserver
sql_query ...
db_passwd xxxxxxxx              <====

* Here is the log extract for the second instantiation...

Dec 13 16:31:53 mercure sympa[17885]: Sympa 5.3.4 started
Dec 13 16:31:54 mercure sympa[17885]: admin::update_list() 
admin::update_list(acs-staff,acs-lists,ACS staff)
Dec 13 16:31:54 mercure sympa[17885]: admin::update_list() Synchronizing 
list members...
Dec 13 16:31:55 mercure sympa[17885]: List::sync_include() 
List:sync_include(acs-staff): 210 users added
Dec 13 16:31:55 mercure sympa[17885]: List::sync_include() 
List:sync_include(acs-staff): 0 users updated
Dec 13 16:32:35 mercure task_manager[6435]: List::_load_admin_file() 
Unknown key "db_user" in paragraph "include_sql_query" in 
/home/sympa/expl/acs-staff/config
Dec 13 16:32:35 mercure task_manager[6435]: List::_load_admin_file() 
Unknown key "db_host" in paragraph "include_sql_query" in 
/home/sympa/expl/acs-staff/config
Dec 13 16:32:35 mercure task_manager[6435]: List::_load_admin_file() 
Unknown key "db_passwd" in paragraph "include_sql_query" in 
/home/sympa/expl/acs-staff/config

Thank you

Richard
--
Richard Gilbert
Corporate Information and Computing Services
University of Sheffield, Sheffield, S10 2TN, UK
Phone: +44 114 222 3028   Fax: +44 114 222 3040