The mailing list for listmasters using Sympa

[address@concealed]

Hello,

I managed to include users by include_sql_query

config file mentions

> member_include
> source data
> source_parameters mysql,db,3306,USERNAME,USERPASSWD,DATABASE_NAME

include file data_source/data.incl (subdir of where config is)

> include_sql_query
> name user_data
> db_type [% param.0 %]
> db_host [% param.1 %]
> db_port [% param.2 %]
> db_user [% param.3 %]
> db_passwd [% param.4 %]
> db_name [% param.5 %]
> sql_query SELECT ...

I don't know where to put the include_sql_ca query. When I put it in the
same file data.incl like

> include_sql_ca
> name user_ca

then the data does not get read. The log files show

wwsympa[501]: info Sympa::List::_load_include_admin_user_file()
Expecting a single line for "include_sql_ca" parameter in data.incl
wwsympa[501]: debug3 Sympa::List::_load_list_param(Sympa::List
<address@concealed>, include_sql_ca, %s, HASH)

while for include_sql_query things work as expected:

wwsympa[501]: debug3 Sympa::List::_load_list_param(Sympa::List
<address@concealed>, db_type, %s, HASH)
wwsympa[501]: debug3 Sympa::List::_load_list_param(Sympa::List
<address@concealed>, db_host, %s, HASH)
wwsympa[501]: debug3 Sympa::List::_load_list_param(Sympa::List
<address@concealed>, db_port, %s, HASH)
wwsympa[501]: debug3 Sympa::List::_load_list_param(Sympa::List
<address@concealed>, db_user, %s, HASH)
wwsympa[501]: debug3 Sympa::List::_load_list_param(Sympa::List
<address@concealed>, db_passwd, %s, HASH)
wwsympa[501]: debug3 Sympa::List::_load_list_param(Sympa::List
<address@concealed>, db_name, %s, HASH)
wwsympa[501]: debug3 Sympa::List::_load_list_param(Sympa::List
<address@concealed>, sql_query, %s, HASH)

maybe someone can help?

regards,

Christoph Holtermann