[Mageia-sysadm] Email change replication between identity and sympa

[Buchan Milne]

Please try and quote properly ...

On Thursday, 20 September 2012 00:07:10 Joerg Stephan wrote:

> Well i found a plugin page http://www.sympa.org/manual/ldap or manual to do
> it with ldap and if you access the puppet repository
> 
> 
> svn co svn://svn.mageia.org/svn/adm/puppet/
> 
> 
> you will find an puppet/modules/sympa/templates/auth.conf which does the
> ldap binding for auth in addition to that
> 
> 
> [root at x0 templates]# grep -ir ldap *
> auth.conf:ldap
> auth.conf:        host                            ldap.<%= domain %>
> auth.conf:        bind_password                   <%= ldap_password %>
> config:<% if subscriber_ldap_group and not subscription_open %>
> config:<% elsif sender_ldap_group %>
> config:send restricted_<%= sender_ldap_group %>
> config:<% if subscriber_ldap_group %>
> config:include_ldap_query
> config:    host ldap.<%= domain %>
> config:    filter (memberOf=cn=<%= subscriber_ldap_group %>,ou=Group,<%=
> dc_suffix %>) config:    passwd   <%= ldap_password %>
> data_sources/ldap_group.incl:include_ldap_2level_query
> data_sources/ldap_group.incl:        host     ldap.<%= domain %>
> data_sources/ldap_group.incl:        passwd   <%= ldap_password %>
> scenari/sender.ldap_group:search(<%= name %>.ldap)  smtp,md5,smime  -> do_it
> search_filters/group.ldap:host        ldap.<%= domain %>:636
> search_filters/group.ldap:bind_password <%= ldap_password %>
> 
> 
> so ldap is used at some spots in the config, currently i dont know the ldap
> design, or what identity sets on its site

The DIT layout is mostly the openldap-mandriva-dit one, we should probably 
actually import this package as a mageia package. See more info here:

http://wiki.mandriva.com/en/Projects/OpenLDAP_DIT

> 
> 
> From: Ross Wilson <ross.wilson at mail.com>
> To: Mageia Sysadmin discussions <mageia-sysadm at mageia.org>
> Sent: Thursday, September 20, 2012 8:56 AM
> Subject: Re: [Mageia-sysadm] Email change replication between identity and
> sympa
> 
> 
> 
> As far as I can see Sympa doesn't have a 'standard database'; it uses an
> RDBMS like Postgres, MySQL etc, or am I missing something?
> 

'standard sympa database' means, the standard sympa database schema running on 
a supported RDBMS database.

> 
> 
> ----- Original Message -----
> From: nicolas vigier
> Sent: 09/20/12 12:57 AM
> To: Mageia Sysadmin discussions
> Subject: Re: [Mageia-sysadm] Email change replication between identity and
> sympa> 
> On Wed, 19 Sep 2012, Ross Wilson wrote:
> > Hi,
> > 
> > I recently came across this:
> >    However there are many areas where it's possible to help without having
> >    root access. For instance :
> >    - we need to find a solution so that email changed on
> >    
> >       identity.mageia.org is automatically changed on sympa mailing lists.
> >       This require making some changes to identity and/or sympa.

You can:
-run identity on your own PC/VM/whatever
-make any changes to identity or other tools and submit a patch
without requring *any* access.

I did all identity development on my own laptop, other contributors (Michael 
Scherer, Maarten Vanraes, others) have done their development on non-project 
environments.

> > Has this issue been resolved? If not, I feel I may be able to resolve it;
> > it would most likely require some level of> > 
> >  access to the databases holding the email information, but I feel it
> >  would be pretty> > 
> > trivial to setup some sort of trigger which will update sympa if
> > identity.mageia.org> > 
> >  is updated (and vice versa?).

There is no database with "triggers" (per se) behind identity, and we should 
avoid allowing any changes from any non-LDAP-aware tools.

Please, please, please, read my response in this mail, and read the 
LDAP/identity portions until you understand them, or ask questions 
specifically about the options here, or we are all wasting time.

I have started cleaning up some current perl syncrepl code to provide as a 
starting point, but it requires at least another 30 minutes, so either I send 
this mail now, or it will wait in draft for a week or more.

> See
> http://www.mageia.org/pipermail/mageia-sysadm/2012-September/004717.html
> 
> > To this end, I have submitted an account request in bugzilla.
> 
> You don't need an account to develop an ldap trigger or identity plugin.
> 
> Identity sources are available on svn :
> http://svnweb.mageia.org/soft/identity/CatDap/trunk/
> 
> And database is standard sympa database.



Regards,
Buchan