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

[Jose Carlos Garcia Sogo]

--=-718YBiJbnFt+UnfmYpwj
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

El jue, 31-03-2005 a las 11:26 +0200, Tzafrir Cohen escribi=C3=B3:
> 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
> >=20
> > 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...
> >=20
> > Incidentally, what this file is is not described anywhere.  It would be
> > useful to do that, and to provide instructions for enabling or disablin=
g
> > SQLite CDR recording.
>=20
> This is a sqlite database. So how about a weekly cron that runs
> something like:
>=20
> select all records older than a week, write them to a different db and
> delete them from current db?
>=20
> 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...

>=20
> Are there any other programs that "log" to sqlite?
>=20

 Not that I know about.

--=20
Jose Carlos Garcia Sogo
   jsogo@debian.org

--=-718YBiJbnFt+UnfmYpwj
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada
	digitalmente

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

iD8DBQBCTGH/S+BYJZB4jhERAr17AJ99+rNVyt1OSAxKA+itzrQkJ6XAbQCcCgjL
dnj46vPVbdcudq4vRdnKD9w=
=j6C/
-----END PGP SIGNATURE-----

--=-718YBiJbnFt+UnfmYpwj--