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

[Tzafrir Cohen]

On Mon, Mar 28, 2005 at 05:05:07PM -0600, John Goerzen wrote:
> Package: asterisk
> Version: 1:1.0.7.dfsg.1-2
> Severity: normal
> 
> I have a file /var/log/asterisk/cdr.db that is a SQLite database file.
> The asterisk as shipped with Debian is creating this file by default,
> but nothing is ever rotating it.  This probably should be an important
> bug...
> 
> Incidentally, what this file is is not described anywhere.  It would be
> useful to do that, and to provide instructions for enabling or disabling
> SQLite CDR recording.

This is a sqlite database. So how about a weekly cron that runs
something like:

select all records older than a week, write them to a different db and
delete them from current db?

Or simply: purge all records older than a month.

Are there any other programs that "log" to sqlite?

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