On Jan 29, 2010, at 12:29 AM, Serge Fonville wrote:
On Fri, Jan 29, 2010 at 9:19 AM, Bradley Giesbrecht
<bradley.giesbre...@gmail.com> wrote:
On Jan 28, 2010, at 12:35 PM, Serge Fonville wrote:
Hi,
I using virtual_alias_maps with mysql for storage. Working fine.
Does anyone have a suggestion on how to update a timestamp field
in the
mysql table when postfix finds a virtual_alias_maps match?
I'm looking for a way to measure alias usage and cull unused
aliases.
Have you considered a stored procedure?
I have but was hoping for something simpler like I do with dovecot
deliver
where you create a script that calls deliver after you do what you
want for
logging and then name your script in something like deliver_exec =
script.
Might be wrong with the names but thats more or less what takes
place.
I'd prefer to keep as much of this type of thing in the config
files. It
seems to be easier to quickly see what's up when there is a problem.
I'll try the stored procedure if nothing more attractive turns up.
Well, possibly you could edit your transport to use a script and pass
all the relevant variables to it, it can then also do an insert on
your database.
I was kinda hoping something like this was possible.
Does anyone have an example of something like this?
Maybe add a filter to my relay in master.cf?
http://www.postfix.org/FILTER_README.html
filter unix - n n - 10 pipe
flags=Rq user=filter null_sender=
argv=/path/to/script -f ${sender} -- ${recipient}
relay unix - - n - 10 smtp
-o content_filter=filter:dummy
OR
smtp unix - - n - 10 smtp
-o content_filter=filter:dummy
As everyone probably notices other then setting up postfix with
dovecot and virtual users in mysql I don't know postfix that well.
It's been working real well for over a year.
Thanks for any help. This isn't crucial, I'd just like to be able to
view counts of message passing through aliased users.
// Brad
