[horde] Maintenance table imp_sentmail

[Jens Wahnes]

On Tue, Aug 11 2015, at 13:58:04 +0200, grupo correo wrote:

> i would like known "what" component is doing the maintenenace of table
> imp_sentmail. Now there are rows with timestamp of 6 June.

Cleaning up the imp_sentmail table is part of the login tasks that are
carried out when an admin user logs into Horde.  The period of time
that old entries should be kept is controlled by the

$conf['sentmail']['params']['threshold']

setting in .../imp/config/conf.php (i.e. it can be changed on the
Administration / Configuration / Mail (IMP) page on the "Compose Log"
tab).  But, as said before, it only happens when an admin user logs
in.  If no admin user ever logs in, no cleanup will be performed.

So if there is a good way to have that cleanup done in spite of no
admin user logging into Horde for a longer period of time, I'd be glad
to hear about it.  That scenario (no admin user logging into Horde on a
regular basis) is common here.  So far, we set up a cronjob to delete
the old entries directly from the imp_sentmail table using SQL queries,
but of course that's not as good a solution as to have Horde do it the
right way.


Jens