The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Yes, that's a perfectly valid solution!

I think we really should provide such list out of the box.

However, I wonder how we should name it... A lot of people have created such lists since the mong years in Sympa history, so we could see name collisions.
Maybe a parameter with a default to "address@concealed".

Regards,

David

Le 09/10/2015 11:11, Steve Shipway (via sympa-users Mailing List) a écrit :

As an aside to this discussion, I thought I'd mention one other thing we've done here.

I wanted to have a list that consisted of all the owners of any other list on the server -- so I could use this list for announcements of server outages, for example.

This was achieved by using the sql_query external datasource to look back into the Sympa database:

include_sql_query
name list_owners
host localhost
db_port 3306
db_name sympa
user sympa
passwd xxxxxx
db_type mysql
sql_query SELECT DISTINCT `user_admin`,`comment_admin` FROM `admin_table` WHERE
`robot_admin` = 'list.auckland.ac.nz' and `role_admin` = 'owner' and `visibility
_admin` = 'noconceal' order by `user_admin`

Note that we can even pull out the admin name in the second parameter which (in 6.2 or in our patches 6.1.24) will go into the subscriber name.

In addition to this, we have a separate external script which builds the subscriber custom field contents to be a list of the lists for which the admin is owner, so that it can be used in personalisation merges, but this is done externally.

Steve

Steve Shipway

University of Auckland ITS

UNIX Systems Design Lead

address@concealed

Ph: +64 9 373 7599 ext 86487

 

---

--
A bug in Sympa? Quick! To the bug tracker!

David Verdin Études et projets applicatifs
Tél : +33 2 23 23 69 71 Fax : +33 2 23 23 71 21   www.renater.fr	RENATER 263 Avenue du Gal Leclerc 35042 Rennes Cedex

Attachment: smime.p7s
Description: Signature cryptographique S/MIME