On 06/11/2022 14.33, Noah wrote:
I am migrating my aliases file from a textfile to mysql.
One of the things I liked about the textfile is I could comment out a
line and put notes as to why I disabled the alias. is there a similar
method that I can do in mysql - disable the alias and put comments in an
extra field?
The docs describe which particular fields are required for particular
queries (my system uses the DB for postfix and dovecot).
(am assuming you've already 'holding your finger in the book')
There is no reason why you can't build a DB/tables which hold more
information than Postfix requires! Conversely, my system requires fewer
than one hundred mailboxes, aliases, etc - so they're all in one table
and several queries handle the different needs.
Add an extra field for "Active" (or "Disabled", if you prefer).
Adjust the query to only return active/not return disabled rows!
Add a further field, eg "Memo", to give space for your notes
- and perhaps another to be able to date the decision/change...
Double-check the postfix query to ensure that it only returns the
required data-field(s).
--
Regards =dn
