The mailing list for listmasters using Sympa

[Steve Shipway <address@concealed>]

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

 

---