[OpenSIPS-Users] CDRTool query to media_sessions table

[Dan Pascu]

On 8 Sep 2009, at 15:01, Jeff Pyle wrote:

> Dan,
>
> Unfortunately I'm not finding any references to escapaing characters  
> in
> Freeradius.  I realize this isn't your home turf, but having said  
> that, do
> you have any pointers?

There is some option in sql.conf, but I don't recall the option name.  
Look in the freeradius provided sample sql.conf, I'm sure the comments  
will help you find it.

>
>
> Thanks,
> Jeff
>
>
>
> On 9/7/09 8:02 AM, "Dan Pascu" <dan at ag-projects.com> wrote:
>
>>
>> On 5 Sep 2009, at 23:01, Jeff Pyle wrote:
>>
>>> Hello,
>>>
>>> On CDRTool v6.8.0 and Mediaproxy 2.3.6 I notice sometimes I get “No
>>> information available” when I click on the Media Information link.
>>>
>>> In one particular example, the query looks for
>>> “SDjui5c99-324092c7=2B1=2B2b6b0008=2B96cdd538” but the database has
>>> “SDjui5c99-324092c7+1+2b6b0008+96cdd538”.  Is there a way to
>>> encourage CDRTool to query with the non-modified version of the
>>> characters?  Or, is another solution preferable?
>>
>> CDRTool queries with the information available from the radius
>> accounting table. You should configure your radius server (I presume
>> freeradius) not to escape those characters.
>>
>> The difference appears from the fact that the information is inserted
>> unmodified in the media sessions table, but the radius server escapes
>> certain characters when inserting it in the accounting table.
>>
>>>
>>>
>>> - Jeff
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>> --
>> Dan
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users


--
Dan