The mailing list for listmasters using Sympa

["Silvers, Tim" <address@concealed>]

Hi Gadi,

 

Take a look at edit_list.conf. Several of the ‘include’ options are hidden from owners by default. You could find the one(s) related to the MySQL data source and set them to write for privileged owners. Hopefully, you have a non-production environment in which you can test it. Best of luck!

 

Tim

 

 

From: address@concealed <address@concealed> on behalf of Gadi Vivier <address@concealed>
Date: Sunday, November 13, 2022 at 6:06 PM
To: address@concealed <address@concealed>
Subject: [External] [en@sympa] Data sources setup - MySQL

This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources.
-------

Hi

I have a question about "Data sources setup" for Listmaster and
Priviledged Listowner.

# Edit List Configuration > Data sources setup

When I am logged in to the list's Admin as the Listmaster, the form-page
allowed me to create a remote MySQL source of list members by entering
information for a "SQL query inclusion" such as database host, user,
port etc.

  I named this new source as "Source-A". It all works well and the list
gets successfully populated with members from the remote database.

However, when a Priviledged Listowner is logged in, they are unable to
create a remote MySQL source of list members. The form-page only allows
presents a drop-down menu for "Subscribers defined in an external data
source > The data source". The drop-down menu is empty. I was expecting
to see at least "Source-A" as an option.

So my questions is:

Is it possible to change the list configuration somewhere to allow 
Priviledged Listowners to create a  remote MySQL source of list members
by entering the database information (in the same way the Listmaster
can)?

Thanks
Gadi