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 [EMAIL PROTECTED] http://www.xorcom.com -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
