[OpenSIPS-Users] CDRTool query to media_sessions table

[Norman Brandinger]

#  $Id: mysql-dialup.conf,v 1.1 2006/08/31 22:10:41 pnixon Exp $
#
# FreeRADIUS "dialup" SQL Queries for the MySQL Dialect
    # Safe characters list for sql queries. Everything else is replaced
    # with their mime-encoded equivalents.
    # The default list should be ok
    #safe-characters = 
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"

Regards,
Norm

Dan Pascu wrote:
> 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
>
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>