26 Mar
2003
26 Mar
'03
2:53 a.m.
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
26 Mar
26 Mar
5:21 a.m.
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(a)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(a)iptel.org [mailto:serusers-admin@lists.iptel.org] On
Behalf Of Ricardo Villa
Sent: Tuesday, March 25, 2003 3:53 PM
To: serusers(a)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
6:09 a.m.
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(a)lists.iptel.org
Cc: sip(a)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(a)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(a)iptel.org [mailto:serusers-admin@lists.iptel.org] On Behalf Of
Ricardo Villa
Sent: Tuesday, March 25, 2003 3:53 PM
To: serusers(a)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
12:18 p.m.
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.net>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(a)iptel.org [mailto:serusers-admin@lists.iptel.org] On Behalf
Of Ricardo Villa
Sent: Tuesday, March 25, 2003 3:53 PM
To: serusers(a)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
4:37 p.m.
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.
7:40 p.m.
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(a)lists.iptel.org; sip(a)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.
8:22 p.m.
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(a)lists.iptel.org; sip(a)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.
27 Mar
27 Mar
12:30 a.m.
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;
}
6:28 a.m.
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
7703
days inactive
7705
days old
8 comments
7 participants
participants (7)
-
'Jan Janak' -
Greg Fausak -
Jan Janak
-
jh＠lohi.eng.song.fi -
Jiri Kuthan -
Michael Haberler -
Ricardo Villa