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 sql (I

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 previous mail to this

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 to

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 rollback

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 (I actually

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 pages

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. The

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 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 instead of

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 shipped with

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 rotating

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,