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
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
MessageThanks Greg,
I am writing a Perl script for this. If it doesn't work ok then I will contact Andy.
Regards, Ricardo ----- Original Message ----- From: Greg Fausak To: 'Ricardo Villa' ; serusers@lists.iptel.org Cc: sip@august.net Sent: Tuesday, March 25, 2003 7:21 PM Subject: RE: [Serusers] Accounting Script
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
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 mailto:sip@august.netsip@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
Hello,
On 26-03 08:18, Michael Haberler wrote:
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
We are also very interested in postgres support, IIRC Greg Faustak wanted to develop the module but I don't know what is the current state, Greg, could you clarify, please ?
I am ready to give you support and we could distribute it along with ser if you decide to develop the module and release it under the terms of the GPL.
Jan.
Jan,
I've actually written the postgres module for SER twice now. It isn't working consistantly for me. Things run for while and eventually core dump. That is why I haven't released it.
I think I'm a pretty good coder. I can't believe I can't make this work! The layering in SER is very good, and it frustrates me that I cannot get the module to work for an extended period of time. I must be missing a fundamental concept.
I put debugs in the code, and printed a message every time any of the main modules were entered. My results were not conclusive, but it occurred to me that the init/open module wasn't being called before the channel was being used.
I also had another bug where the communication channel becomes corrupted...so I put some code in that closed and reopened the postgres bb com channel in the event an error occurs...this worked but it should not be necessary.
Anyway, I had a postgres module that worked for serveral hours at a time. I can dust it off and see if I can get it going again. Perhaps with your help we can finish it. I have every intention of releasing the code via GPL.
I too perfer postgres over mysql for many reasons. We are doing our SER accounting in postgres.
---greg
-----Original Message----- From: Jan Janak [mailto:jan@iptel.org] Sent: Wednesday, March 26, 2003 5:37 AM To: Michael Haberler Cc: Greg Fausak; 'Ricardo Villa'; serusers@lists.iptel.org; sip@august.net Subject: Re: [Serusers] Accounting Script
Hello,
On 26-03 08:18, Michael Haberler wrote:
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
We are also very interested in postgres support, IIRC Greg Faustak wanted to develop the module but I don't know what is the current state, Greg, could you clarify, please ?
I am ready to give you support and we could distribute it along with ser if you decide to develop the module and release it under the terms of the GPL.
Jan.
Greg,
thanks for the info. Could you tar the module and post it to the list ? Let's try to make it work together.
Jan.
On 26-03 08:40, Greg Fausak wrote:
Jan,
I've actually written the postgres module for SER twice now. It isn't working consistantly for me. Things run for while and eventually core dump. That is why I haven't released it.
I think I'm a pretty good coder. I can't believe I can't make this work! The layering in SER is very good, and it frustrates me that I cannot get the module to work for an extended period of time. I must be missing a fundamental concept.
I put debugs in the code, and printed a message every time any of the main modules were entered. My results were not conclusive, but it occurred to me that the init/open module wasn't being called before the channel was being used.
I also had another bug where the communication channel becomes corrupted...so I put some code in that closed and reopened the postgres bb com channel in the event an error occurs...this worked but it should not be necessary.
Anyway, I had a postgres module that worked for serveral hours at a time. I can dust it off and see if I can get it going again. Perhaps with your help we can finish it. I have every intention of releasing the code via GPL.
I too perfer postgres over mysql for many reasons. We are doing our SER accounting in postgres.
---greg
-----Original Message----- From: Jan Janak [mailto:jan@iptel.org] Sent: Wednesday, March 26, 2003 5:37 AM To: Michael Haberler Cc: Greg Fausak; 'Ricardo Villa'; serusers@lists.iptel.org; sip@august.net Subject: Re: [Serusers] Accounting Script
Hello,
On 26-03 08:18, Michael Haberler wrote:
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
We are also very interested in postgres support, IIRC Greg Faustak wanted to develop the module but I don't know what is the current state, Greg, could you clarify, please ?
I am ready to give you support and we could distribute it along with ser if you decide to develop the module and release it under the terms of the GPL.
Jan.
here is how i get the information of calls made by a user as identified by the user's nai (username + realm) from radius accounting records that i store in mysql database.
-- juha
/* Get call records of a user */ function vsp_getCalls($nai) { $calls = array(); $call = array(); vsp_connect(); $result = mysql_query("SELECT t1.fromUri, t1.toUri, t1.date, (sec_to_time(unix_timestamp(t2.date)-unix_timestamp(t1.date))) AS duration FROM radacct AS t1, radacct AS t2 WHERE t1.nai = '$nai' AND t1.method = 'INVITE' AND t2.method = 'BYE' and t1.callId = t2.callId ORDER BY t1.date DESC") or die ("<h1 align=center>Cannot access accounting information!</h1>"); while ( $call = mysql_fetch_array( $result ) ) { $calls[] = $call; } // print_r(array_values($calls)); vsp_close(); return $calls; }
At 03:40 PM 3/26/2003, Greg Fausak wrote:
Jan,
I've actually written the postgres module for SER twice now. It isn't working consistantly for me. Things run for while and eventually core dump.
A quick guess for a failure reason (occured to someone else) is an incorrect place to open DB. The proper place is mod_init with reopen from child_init -- otherwise the timer process is not initialized. Disregard if that is not the case -- I just tried a quick guess.
Perhaps with your help we can finish it. I
Sure -- post it, I'm sure [serusers] folks will be glad to test.
have every intention of releasing the code via GPL.
That's absolutely great.
-Jiri
-
'Jan Janak' -
Greg Fausak -
Jan Janak
-
jh＠lohi.eng.song.fi -
Jiri Kuthan -
Michael Haberler -
Ricardo Villa