The mailing list for listmasters using Sympa

[Justin Wood <address@concealed>]

That did it.  Thank you.

-Justin.

Olivier Salaun wrote:
> 
> 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

-- 
---------------------------------------------------
Justin Wood                      address@concealed
Systems Administrator
FlipDog.com                 http://www.flipdog.com/
---------------------------------------------------