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

Kilian Krause Kilian Krause <kk@verfaction.de>, 301883@bugs.debian.org
Thu, 31 Mar 2005 10:04:08 +0200


--=-ijNIlJJpISyPNEtgZZVP
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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=C3=B3:
> > 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
>  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
> instead of a usual plain file.
>=20
>  We will have the same problem with cdr_mysql, if ever packaged.

...but in that case rotation would be part of MySQL's problem, not ours.
We just interface with MySQL in that mode and stuff our data into its
API.=20

For the same reason, i'm not entirely sure how to use the SQLite wisely,
for shutting down the entire live PBX only to rotate a cdr file sounds
like overkill to me.

Any comments why you need it rotated *automagically* in the first place?
Would you also rotate MySQL or PostgreSQL db files for the same reason
that they *COULD* theoretically explode when stuffing enough CDR data
into there?

--=20
Best regards,
 Kilian

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

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

iD8DBQBCS674vdkzt4X+wX8RAqWeAJ9ZLqUFica1f9F6e89MVrALw8VNRgCfbcgg
QhsqKkhV+rK3jux+rYiDAho=
=5OyE
-----END PGP SIGNATURE-----

--=-ijNIlJJpISyPNEtgZZVP--