My partner (Andy Fullford) wrote our code that does this.
We turned on SER accounting, deliver via SYSLOG, and have a script that scrapes all of that up and creates accounting records.
In addition, we apply the syslog accounting output from our gateway routers to verify the INVITE/BYE sequences. Finally, we populate a database with the results. We were going to use radius, but it didn't quite work right for us. I think what we have cobbled together works really well. We don't have any 'hanging' calls anymore....and even if we did we would catch them with the gateway accounting.
We did not think the SER user base would be interested. We use a postgres database and this doesn't seem to be mainstream. However, if there is interest for this sort of thing perhaps we could donate it?
Anyway, you could respond to sip@august.net and ask Andy if he can hack you out a piece of it to do what you want.
---greg Greg Fausak
-----Original Message----- From: serusers-admin@iptel.org [mailto:serusers-admin@lists.iptel.org] On Behalf Of Ricardo Villa Sent: Tuesday, March 25, 2003 3:53 PM To: serusers@lists.iptel.org Subject: [Serusers] Accounting Script
Hi,
Has anybody developed some sort of crude accounting script for SER that would match all BYEs with their respective INVITEs in the syslog file and say how many seconds each call lasted?
Thanks, Ricardo