Bug#301883: asterisk: sqlite logging enabled by default and never rotated

John Goerzen John Goerzen <jgoerzen@complete.org>, 301883@bugs.debian.org
Mon, 4 Apr 2005 15:03:02 -0500

On Mon, Apr 04, 2005 at 09:32:31PM +0200, Kilian Krause wrote:
> the query would be something like "delete from $mytable where
> $insertdate < $(today-1month)" with the variables holding the correct
> names etc.
> Yet I strongly disagree with this behaviour for a default. At least the
> 1 month rollback sounds like too few from a data-warehouse point of view
> and too much from a duty of secrecy point of view. The only real
> alternative sounds to be a debconf asking for the proper length.

The alternative could be to do a rotation scheme; SELECT records from
the source, INSERT them into the destination, then DELETE from the
source.  But that gets more complex.

> Does that sound ok for everybody?

Sounds fine to me.

> -- 
> Best regards,
>  Kilian