Skip to Content.
Sympa Menu

en - Re: [sympa-users] Users from a DB

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Daniel Cortes <address@concealed>
  • To: Gwenaelle Bouteille <address@concealed>
  • Cc: address@concealed
  • Subject: Re: [sympa-users] Users from a DB
  • Date: Mon, 11 Apr 2005 16:31:44 +0200

This is my new list.xml

<?xml version="1.0" ?>
<list>
<listname>Prueba</listname>
<subject>Lista de Prueba</subject>
<status>open</status>
<shared_edit>editor</shared_edit>
<languaje>es</languaje>
<owner_include>
<source>owner</source>
</owner_include>
<editor_include>
<source>editor</source>
</editor_include>
<sql>
<type>mysql</type>
<host>daniol.fib.upc.edu</host>
<user>sympa</user>
<pwd>mypassword</pwd>
<name>test</name>
<query>SELECT DISTINCT email FROM gente</query>
</sql>
</list>

./bin/sympa.pl --create_list --robot=daniol.fib.upc.edu --input_file=/home/soft/sympa/prueba.xml
admin::create_list_old : missing param "template"
Could not create list with these xml data

why?
every source is a file .incl with a SQL, for exemple owner.incl

daniol sympa/expl> cat editor.incl
include_sql_query
db_type mysql
host daniol.fib.upc.edu
user sympa
passwd mypassword
db_name test
sql_query SELECT DISTINCT email FROM gente WHERE nombre="albert";





Archive powered by MHonArc 2.6.19+.

Top of Page