At 18:21 25.03.2003 -0600, Greg Fausak wrote:

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?

me as including the SER user base would be interested.

Also, we are migrating towards a Postgres shop here, so I would be very interested in Postgressifying the whole thing, accounting and SER itself.

There was a post a while ago that somebody set out to do a DB interface SER/Postgres; if this is under way, fine - if this project was abandoned, we might chip in and do it - pleas get in touch with me

-Michael
nic.at

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@lists.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