The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Normally, Sympa should reload all this automatically.

You can even delete the admin_table and Sympa will reload the configs 
and recreate it.

Now, if you have a post-6.2.34 version, then Sympa no longer uses the 
owners and editors in the config files. You need to run an upgrade to 
move these data to the database. (sympa.pl --upgrade --from 6.xxx --to 
6.yyy)

Regards,

David

On 30/01/2020 12:09, Dave Page wrote:
> That's great for populating the list_table, thanks David. Is there a way to
> populate the admin_table using the "owner" data in the list configs? I'm now
> getting lists in error_config state because they have no owner defined.
>
> https://sympa-community.github.io/manual/admin/list-members.html says:
>
> > List owners and moderators are defined in the list configuration file,
> > however, for performances reasons, list owners are also listed in the
> > admin_table DB table. This cache is updated by Sympa processes whenever the
> > list configuration has changed on disk.
> Is there a way to simulate that configuration change?
>
> Cheers,
> Dave
>
> On Thu, Jan 30, 2020 at 09:49:20AM +0100, David Verdin wrote:
> > Yes !
> >
> > Just run sympa.pl --sync_list_db. All your lists will be synced to the
> > database.
> >
> > Regards,
> >
> > David
> >
> > On 30/01/2020 00:59, Dave Page wrote:
> > > Hi all,
> > >
> > > So this is one of those stupid questions, I expect, but I'm trying to
> > > recover a list server from partial backups. I have the list configs from
> > > /var/lib/sympa/list_data which gives list names, and they're all at the
> > > same domain. However, I don't have a database dump.
> > >
> > > Is there a way I can recreate the list_table from this data? That'll at
> > > least let me regenerate aliases, and the list owners can do a password
> > > reset to gain access to their lists. For most of them they'll know who
> > > should be subscribed.
> > >
> > > I reckon I could script something from the config files to generate SQL
> > > to do this, but I am wondering if there's a better way.
> > >
> > > Cheers,
> > > Dave
> > --
> > "Mieux vaut viser la perfection et la rater que viser la médiocrité et 
> > l'atteindre."
> > - Francis Blanche
--
"Mieux vaut viser la perfection et la rater que viser la médiocrité et 
l'atteindre."
- Francis Blanche

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