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. 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...
> >
> > the query would be something like "delete from $mytable where
> > $insertdate < $(today-1month)" with the variables holding the correct
> > names etc.
>
> So what's up with this?
>
> I believe the command should be:
>
> echo "delete from cdr where julianday('now')-julianday(start) > 30;" \
> |sqlite /var/log/asterisk/cdr.db
>
> One my system this seems to be off by an hour or two due to timezone
> issues. Not a big deal, I figure.
>
> As someone has noted, this probably won't shrink the database. How do I
> do that?
>
>
> >
> > Yet I strongly disagree with this behaviour for a default. At least the
> > 1 month rollback sounds like too few from a data-warehouse point of view
> > and too much from a duty of secrecy point of view. The only real
> > alternative sounds to be a debconf asking for the proper length.
> >
> > Does that sound ok for everybody?
>
> If this is what you think, you should start by changing the default log
> rotation of cdr-csv/Master.csv . Records there are deleted after about a
> month.
Yes, this needs to be looked at again. I have yet a server up and
running, so I can check stuff again. I want to take a look at VoIP
bugs we have lately in BTS during Debconf. I think I will ask about
this late in the hacklab here at debconf.
--
Jose Carlos Garcia Sogo
[EMAIL PROTECTED]
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
