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
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
* 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
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
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
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
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
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
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
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.
>
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
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
12 matches
Mail list logo