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

[Tzafrir Cohen]

On Mon, Apr 04, 2005 at 09:32:31PM +0200, Kilian Krause wrote:
> Hi Jose,
> 
> > > Or simply: purge all records older than a month.
> > 
> >  Yes, that should work, IMO. I though about using sql after writing my
> > previous mail to this bug. The problem with this is that I am quite bad
> > with sql (I actually don't know the language) so if someone could write
> > the "query" to use...
> 
> the query would be something like "delete from $mytable where
> $insertdate < $(today-1month)" with the variables holding the correct
> names etc.

So what's up with this?

I believe the command should be:

  echo "delete from cdr where julianday('now')-julianday(start) > 30;" \
	|sqlite /var/log/asterisk/cdr.db

One my system this seems to be off by an hour or two due to timezone 
issues. Not a big deal, I figure.

As someone has noted, this probably won't shrink the database. How do I
do that?


> 
> 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.
> 
> Does that sound ok for everybody?

If this is what you think, you should start by changing the default log
rotation of cdr-csv/Master.csv . Records there are deleted after about a
month.

-- 
Tzafrir Cohen     icq#16849755  +972-50-7952406
tzafrir.cohen@xorcom.com  http://www.xorcom.com