El jue, 31-03-2005 a las 11:26 +0200, Tzafrir Cohen escribiÃ: > 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.
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... > > Are there any other programs that "log" to sqlite? > Not that I know about. -- Jose Carlos Garcia Sogo [EMAIL PROTECTED]
signature.asc
Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada digitalmente
