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

Kilian Krause "Kilian Krause" <kk@verfaction.de>, 301883@bugs.debian.org
Mon, 04 Apr 2005 21:32:31 +0200


--=-ci4lGo4owhbjZqamcyLi
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Hi Jose,

> > Or simply: purge all records older than a month.
>=20
>  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.

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?

--=20
Best regards,
 Kilian

--=-ci4lGo4owhbjZqamcyLi
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: Dies ist ein digital signierter Nachrichtenteil

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)

iD4DBQBCUZZPvdkzt4X+wX8RAoXVAJ96CSNM8RP6TT0mg2mVJ7IwLgbYKACYuMut
jMht6mLrWwGdhh7sEirr5g==
=y+Xw
-----END PGP SIGNATURE-----

--=-ci4lGo4owhbjZqamcyLi--