Hi,
Peter Galbavy wrote :
> If it helps, the requirement is more one of code study at this stage, since
> we are going to implement a mailing list management system that sits on top
> of a (out) provisioning database. If any of the existing packages are
> flexible enough to do this with a small amount of integration work, then
> great;
Sympa relies on a RDMS (MySQL / PostgreSQL / Oracle / Sybase) it uses
for its internal
usage. But it can also have MLs with subscribers extracted from external
databases (any DBMS or LDAP). A list may have multiple data sources.
Here is a sample list config :
## subscribers' emails are dynamically extracted from external
## data sources
user_data_source include
## First source : an Oracle database
include_sql_query
db_type oracle
host sqlserv.admin.univ-x.fr
user banalise
passwd mysecret
db_name scolarship
sql_query SELECT DISTINCT email FROM student
## Second source : an LDAP directory
include_ldap_query
host ldap.cru.fr
suffix dc=cru, dc=fr
filter (&(cn=aumont) (c=fr))
attrs mail
select first
You should be able to set your provisioning database as an "include"
data source.
Rachel Blackman wrote :
> SYMPA
> Written in Perl, Sympa's main strength is that it's amazingly easy to
> localize into other languages.
Sympa is easy to translate indeed (it has just been translated to
chinese and polish).
But as far as we know it has many other features other MLMs don't have :
- S/MIME signature recognition and message encryption
- Complete web interface with unique authentication (not per list)
- "Scenari" are a scripting language that allows you to extend the
behavior of commands (without patching the code)
- Web document repository (per list)
--
Olivier Salaün
Comité Réseaux des Universités
Sympa http://www.sympa.org/
