Hi there! Listen Im just playing around with the access-log-format setting, I've not tried the access-log-clean. If you are going to use a DB anyway... why even bother with the eliminating timestamp? Might be useful!!
Alejandro -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Monchanin Eric Enviado el: Martes, 03 de Mayo de 2005 02:25 a.m. Para: kannel Asunto: Re: Statistics Sent / Received -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, Running kannel 1.4 patched with mbuni, I'm trying to format the access.log file as a CSV file. basically, something like that: access-log = "/var/log/kannel/access.log" access-log-clean = true access-log-format = "%t;%l;%i;%n;%A;%B;%p;%P;%L;%b" Here is what I'm getting when I try to start bearerbox: 2005-05-03 04:21:37 [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0 2005-05-03 04:21:37 [0] ERROR: Group 'smsbox' may not contain field 'access-log-clean'. 2005-05-03 04:21:37 [0] ERROR: Error found on line 68 of file `/etc/kannel/kannel.conf'. 2005-05-03 04:21:37 [0] PANIC: Couldn't read configuration from `/etc/kannel/kannel.conf'. so I moved the directives to the core group: 2005-05-03 04:22:30 [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0 2005-05-03 04:22:30 [0] ERROR: Group 'core' may not contain field 'access-log-clean'. 2005-05-03 04:22:30 [0] ERROR: Error found on line 15 of file `/etc/kannel/kannel.conf'. 2005-05-03 04:22:30 [0] PANIC: Couldn't read configuration from `/etc/kannel/kannel.conf'. and 2005-05-03 04:22:52 [0] INFO: Debug_lvl = -1, log_file = <none>, log_lvl = 0 2005-05-03 04:22:52 [0] ERROR: Group 'core' may not contain field 'access-log-format'. 2005-05-03 04:22:52 [0] ERROR: Error found on line 15 of file `/etc/kannel/kannel.conf'. 2005-05-03 04:22:52 [0] PANIC: Couldn't read configuration from `/etc/kannel/kannel.conf'. What could be the problem ? Thank you. Mohamed Sadok MOUHA a �crit : | Hi Alejandro, | | Thank you. I think that's the only solution available right now. | Do you have a sample of the perl script? | | Thanks again | - | Mohamed | | Le lun 02/05/2005 � 18:18, Alejandro Ramirez a �crit : | | /Im using the access log file... it works just fine. Im working a on a simple perl script using File::Tail which allows me to do billing to an SQL Server (using freetds..) in real time. Just try to set the access.log file to a more standard format (CSV compatible works well..)./// | //// | /It is really on my wish the CDR feature for Kannel!!/// | //// | //// | /Good Luck!/// | //// | /Alejandro/// | //// | /---------- Original Message ----------------------------------/// | /From: Mohamed Sadok MOUHA <[EMAIL PROTECTED]>/// | /Date: 02 May 2005 10:35:25 +0100/// | //// | />Hi to all,/// | />/// | />I need to establish statistics for sent / received SMS messages for/// | />billing purposes. Any recommendation please? Right now I'm analyzing/// | />Kannel access log file, any tool to make this easier?/// | />/// | />Thanks,/// | />/// | />Sadok/// | />/// | />/// | //// | | -- | ------------------------------------ | | Mohamed Sadok MOUHA | | ------------------------------------ | | Progress Engineering | | Tel : +216 71 856 360 | | Fax : +216 71 856 820 | | WWW : http://www.progress.com.tn | | ------------------------------------ | | Progress Engineering Dynamise LE WEB | -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCd0NrSsKGeccfQmgRAq6aAKCsPZQ4EOL19eacq49PeQqJnuNaZACaAzck 2BLr5qnjpQwWBRcH/PF2G6c= =t0ro -----END PGP SIGNATURE-----
