Koozali.org: home of the SME Server

Observation re db configuration entries after upgrades

Offline sages

  • *
  • 182
  • +0/-0
    • http://www.sages.com.au
Observation re db configuration entries after upgrades
« on: May 04, 2021, 03:25:40 PM »
Whilst convincing dragons that I let escape I have observed that over the years my configuration database has acquired various unused and/or incorrect entries. For various reasons as the system has been upgraded entries have been made redundant and/or had their names changed as packages have been updated. Comparing fresh database entries to the older imported database shows new entries that aren't present in the older database or what seems like name changes.
As an example my qpsmtpd database entry had entries for qmail-amavis and spamassassin is now VirusScan etc.
I don't know if there is any automated way of cleansing  the database (apart from starting with a clean config and not importing previous config databases ).
I don't know if its feasible to have some sort of comparison script that compares a database entry to the associated templates, of if it anything to worry about.
...

Offline Jean-Philippe Pialasse

  • *
  • 2,743
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Observation re db configuration entries after upgrades
« Reply #1 on: May 04, 2021, 07:13:29 PM »
for core stuff we use migrate script and normally this should be kept uptodate from SME 7 at least or even before.

for contribs, custom templates related stuff you are on your own.


usually what i would do is what you have already started : compare fresh new with yours.

i would also grep /sbin/e-smith /etc/e-smith and /usr/share/perl5/ for the properties to see if still in uses.

but is it worth the effort ?

Offline sages

  • *
  • 182
  • +0/-0
    • http://www.sages.com.au
Re: Observation re db configuration entries after upgrades
« Reply #2 on: May 05, 2021, 01:56:57 AM »
It was more an observation. It probably isn't worth the grief to do it. I just observed some things that I didn't think existed anymore and got sidetracked on the clutter.
Probably just something to do while the dragons are finishing being cremated.  8)
...

Offline TerryF

  • grumpy old man
  • *
  • 1,821
  • +6/-0
Re: Observation re db configuration entries after upgrades
« Reply #3 on: May 05, 2021, 10:06:42 AM »
Probably just something to do while the dragons are finishing being cremated.  8)

Dont forget Ripleys experience, dont leave any eggs behind :-)
--
qui scribit bis legit