Subject: The mailing list for listmasters using Sympa
List archive
Re: [sympa-users] Recovering Database from Config Files
- From: Dave Page <address@concealed>
- To: address@concealed
- Subject: Re: [sympa-users] Recovering Database from Config Files
- Date: Thu, 30 Jan 2020 11:09:27 +0000
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
>
>
--
Dave Page (he/him)
http://davepage.me.uk/ https://www.facebook.com/davepagelibdem/
@davepage_mcr Tel: 07762 840 414
-
[sympa-users] Recovering Database from Config Files,
Dave Page, 01/29/2020
-
Re: [sympa-users] Recovering Database from Config Files,
David Verdin, 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
Dave Page, 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
David Verdin, 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
Dave Page, 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
David Verdin, 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
Dave Page, 01/30/2020
- Re: [sympa-users] Recovering Database from Config Files, David Verdin, 01/31/2020
-
Re: [sympa-users] Recovering Database from Config Files,
Dave Page, 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
David Verdin, 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
Dave Page, 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
David Verdin, 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
Dave Page, 01/30/2020
- Re: [sympa-users] Recovering Database from Config Files, Stefan Hornburg (Racke), 01/30/2020
-
Re: [sympa-users] Recovering Database from Config Files,
David Verdin, 01/30/2020
Archive powered by MHonArc 2.6.19+.