The mailing list for listmasters using Sympa

[address@concealed]

Hello,

I came a step further by including

> include_sql_ca
> name user_ca
> ...

into config file instead of data.incl. I don't understand why it is does
not work there and would be grateful for a good doc on that topic.

Custom attributes still don't get included but the log file looks more
promising.

regards,

Christoph Holtermann

Am 2021-02-07 19:03, schrieb 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