The mailing list for listmasters using Sympa

[Gadi Vivier <address@concealed>]

Many thanks Tim.

That's perfect. Here is what I edited.

/usr/local/share/sympa/default/edit_list.conf
...
#include_sql_query      owner,privileged_owner  hidden
include_sql_query               owner,privileged_owner  write
...
#include_sql_ca         owner,privileged_owner  hidden
include_sql_ca          owner,privileged_owner  write
...

Best
Gadi


On 2022-11-14 13:14, Silvers, Tim wrote:
> 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