[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