<HTML>
<HEAD>
<TITLE>Re: [OpenSIPS-Users] radius SQL accounting of failed calls</TITLE>
</HEAD>
<BODY>
<FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Ram,<BR>
<BR>
Be sure to include the list in your reply, not only to me directly.<BR>
<BR>
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.<BR>
<BR>
I downloaded unpacked radiusclient-ng-0.5.6.tar.gz, compiled and installed it.<BR>
<BR>
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.<BR>
<BR>
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.<BR>
<BR>
Hopefully you’ll find this helpful.<BR>
<BR>
<BR>
- Jeff<BR>
<BR>
<BR>
<BR>
On 12/15/08 1:25 AM, "ram" <<a href="talk2ram@gmail.com">talk2ram@gmail.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Iam trying to install<BR>
<BR>
CDRtools with opensips<BR>
Do you have any document other than Install<BR>
it mentioned over debian<BR>
<BR>
even i would like to install on centos<BR>
<BR>
Ram<BR>
<BR>
On Sun, Dec 14, 2008 at 1:17 AM, Jeff Pyle <<a href="jpyle@fidelityvoice.com">jpyle@fidelityvoice.com</a>> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Adrian,<BR>
<BR>
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...<BR>
<BR>
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!<BR>
<FONT COLOR="#888888"><BR>
<BR>
- Jeff</FONT> <BR>
<BR>
<BR>
<BR>
<BR>
On 12/13/08 6:26 AM, "Adrian Georgescu" <<a href="ag@ag-projects.com">ag@ag-projects.com</a> <<a href="http://ag@ag-projects.com">http://ag@ag-projects.com</a>> > wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><a href="http://download.ag-projects.com/FreeRadius-XS/">http://download.ag-projects.com/FreeRadius-XS/</a><BR>
<BR>
Adrian<BR>
<BR>
<BR>
On Dec 12, 2008, at 9:38 PM, Jeff Pyle wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Hello,<BR>
<BR>
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.<BR>
<BR>
Since I'm still seeing the Failed type in the radius detail file, it appears OpenSIPS didn't change to Stop.<BR>
<BR>
So, anyone know of a patch for current Freeradius sources?<BR>
<BR>
<BR>
Thanks,<BR>
Jeff<BR>
</SPAN></FONT></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
</SPAN></FONT></BLOCKQUOTE>
</BODY>
</HTML>