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

2005-07-11 Thread Jose Carlos Garcia Sogo
On Mon, Jul 11, 2005 at 02:06:02PM +0300, Tzafrir Cohen wrote: > 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 > > > previo

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

2005-07-11 Thread 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 sq

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

2005-04-04 Thread Florian Weimer
* Jose Carlos Garcia Sogo: >> Or simply: purge all records older than a month. > > Yes, that should work, IMO. You should check that it actually keeps the database size bounded, though. Some B-tree implementations have problems with ever-increasing keys, and a perpetually growing number of page

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

2005-04-04 Thread Jose Carlos Garcia Sogo
El lun, 04-04-2005 a las 21:32 +0200, Kilian Krause escribiÃ: > 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

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

2005-04-04 Thread John Goerzen
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

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

2005-04-04 Thread Kilian Krause
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

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

2005-03-31 Thread Jose Carlos Garcia Sogo
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

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

2005-03-31 Thread John Goerzen
On Thu, Mar 31, 2005 at 10:04:08AM +0200, Kilian Krause wrote: > Am Donnerstag, den 31.03.2005, 00:07 +0200 schrieb Jose Carlos Garcia > Sogo: > > Well, the main problem I see is how can this be made without the need > > of stopping asterisk and restarting it again, as it is an sqlite file > > ins

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

2005-03-31 Thread 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

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

2005-03-31 Thread Kilian Krause
Hi, Am Donnerstag, den 31.03.2005, 00:07 +0200 schrieb Jose Carlos Garcia Sogo: > El lun, 28-03-2005 a las 17:05 -0600, John Goerzen escribiÃ: > > 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. >

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

2005-03-30 Thread Jose Carlos Garcia Sogo
El lun, 28-03-2005 a las 17:05 -0600, John Goerzen escribiÃ: > 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 r

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

2005-03-28 Thread John Goerzen
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, wha