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