[OpenSIPS-Users] CDRTool query to media_sessions table

Jeff Pyle jpyle at fidelityvoice.com
Wed Sep 9 16:30:54 CEST 2009


Norman and Dan,

And there it is.  I won't tell you how many times I looked right past this.
Thank you.


- Jeff



On 9/9/09 10:10 AM, "Norman Brandinger" <norm at goes.com> wrote:

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




More information about the Users mailing list