The mailing list for listmasters using Sympa

[Olivier Salaun <address@concealed>]

Justin Wood wrote:
> 
> I have a question about including subscribers from a mysql database.  Do
> you have to use the standard tables described in the sympa docs, or can
> I include users from another table, as long as there is an email column?
> 
> I have the following in my expl/family-all/config file:
> 
> user_data_source database
> include_sql_query
> user ****
> passwd ****
> db_type mysql
> db_name woodfamily
> host localhost
> sql_query SELECT DISTINCT email1 FROM members

> however, when I tail the mysql log file as I edit the config (via wws)
> of the list, it doesn't look in the table I specified, rather the
> default.

I notice 2 mistakes in your config file :

1st
You need to set 'user_data_source' to 'include'
to make Sympa use your 'include_sql_query' source.

2nd
'user_data_source' and 'include_sql_query' paragraphs
should be separated by a blank line 

--
Olivier Salaün
Comité Réseaux des Universités