The mailing list for listmasters using Sympa

[Gadi Vivier <address@concealed>]

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

> On 3/2/20 8:13 AM, Gadi Vivier wrote:
> > To get a list's subscribers from a remote MySQL database I can 
> > create/edit the needed files in Sympa and that works fine. But for 
> > list-owners who don't have shell access this is not an option.
> > I used Sympa many years ago and as far as I can remember the Data sources 
> > webpage in the list admin pages presented a number of form fields to fill 
> > in: db_type, db_host, db_passwd, etc. - so that the list owner could do 
> > this themselves.
> > This version of Sympa that I've installed only presents two fields in the 
> > admin Data sources setup:
> >
> > #Subscribers defined in an external data source
> > -   the data source (an empty drop-down menu)
> > -   data source parameters (a text input)
> >
> > Could somebody tell me how I can connect a list to a remote MySQL 
> > database to get subscribers, using these two fields on the admin webpage?
> > I think I may have missed a configuration setting somewhere.


>
> Hello Gadi,
>
> scroll down on the Data sources setup page (see screenshot) to get to the 
> SQL inclusion configuration.
>
> The data source widgets seem to refer to data inclusion files (see
> https://sympa-community.github.io/manual/customize/data-sources.html), but 
> it is weird that these are empty and also the
> help text is missing.
>
> Regards
> Racke
>

Hi Racke,

Your screenshot shows the section called "SQL query inclusion" with form 
inputs for db_type, db_host, db_passwd, etc which is what I was looking for.

That section is what is missing from my Data sources setup page. I've 
attached a screenshot of what I have.

Do I need to enable something so that the "SQL query inclusion" section 
displays?

Thanks
Gadi

Attachment: ScreenOfDataSourcesSetup.png
Description: PNG image