[OpenSIPS-Users] radius SQL accounting of failed calls

[Jeff Pyle]

Ram,

Be sure to include the list in your reply, not only to me directly.

I¹m working towards the same goal you are, on CentOS 5.2 i386.  I installed
MySQL from RPMs, then unpacked cdrtool_6.6.10.tar.gz into /var/www per the
instructions.  I unpacked freeradius-server-2.1.3.tar.gz into a working area
(such as /usr/local/src).  I applied the
/var/www/CDRTool/contrib/freeradius-brandinger/freeradius_20080103.patch to
the freeradius source directory to allow the mysterious type-15 ³failed²
messages to me SQL-accounted.  I complied freeradius and installed it.

I downloaded unpacked radiusclient-ng-0.5.6.tar.gz, compiled and installed
it.

At this point for me the trick was to get the conflicting radius dictionary
attributes settled.  There were some conflicts from the freeradius-server
includes, the radiusclient-ng dictionary and the dictionary.ser included
with CDRTool.  I commented out all the freeradius-server vendor includes I
know I wouldn¹t need.  I ended up commenting out some of the RFCs at the top
as well; probably not smart but I did what I had to do.  I commented out a
few individual attributes (and maybe values) from the radiusclient-ng
dictionary file for things I felt wouldn¹t be needed by OpenSIPS.  So far,
so good.  It seems to me there should be an easier way, but I haven¹t found
it yet.

Now I have OpenSIPS accounting via radius, which is properly inserting and
updating records in MySQL.  The next step for me is to try the CDRTool
portion of it to see what that looks like, and make any accounting variable
adjustments in my opensips.cfg.

Hopefully you¹ll find this helpful.


- Jeff



On 12/15/08 1:25 AM, "ram" <talk2ram at gmail.com> wrote:

> Iam trying to install
>  
> CDRtools with opensips
> Do you have any document other than Install
> it mentioned over debian
>  
> even i would like to install on centos
>  
> Ram
> 
> On Sun, Dec 14, 2008 at 1:17 AM, Jeff Pyle <jpyle at fidelityvoice.com> wrote:
>> Adrian,
>> 
>> Thanks for the link.  Unfortunately this looks to be another Debian-specific
>> application.  I'm one of those that has to run CentOS for binary
>> compatibility with RHEL to support some Dell and HP specific server
>> monitoring drivers.  But that's a different discussion entirely...
>> 
>> After I wrote the email to the list found freeradius_20080103.patch in
>> contrib/freeradius-brandinger directory within the CDRTool 6.6.10 tarball.
>> It applied cleanly (maximum fuzz of 2) to freeradius-server-2.1.3.  It even
>> seems to work; I get SQL inserts now on OpenSIPS failed calls.  Excellent!
>> 
>> 
>> - Jeff 
>> 
>> 
>>  
>> 
>> On 12/13/08 6:26 AM, "Adrian Georgescu" <ag at ag-projects.com
>> <http://ag@ag-projects.com> > wrote:
>> 
>>> http://download.ag-projects.com/FreeRadius-XS/
>>> 
>>> Adrian
>>> 
>>> 
>>> On Dec 12, 2008, at 9:38 PM, Jeff Pyle wrote:
>>> 
>>>> Hello,
>>>>  
>>>>  It seems there was a long thread some time back about using the so-called
>>>> non-standard "Acct-Status-Type = Failed" in the radius packet.  The two
>>>> proposed solutions seemed to be 1) use a Stop type instead of Failed, or 2)
>>>> patch Freeradius.
>>>>  
>>>>  Since I'm still seeing the Failed type in the radius detail file, it
>>>> appears OpenSIPS didn't change to Stop.
>>>>  
>>>>  So, anyone know of a patch for current Freeradius sources?
>>>>  
>>>>  
>>>>  Thanks,
>>>>  Jeff
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20081215/fe8620ab/attachment.htm