[OpenSIPS-Users] CDRTool 9.1.1
Willian Mazzardo - SYSSVOIP
willian at syssvoip.com.br
Mon Mar 25 14:46:18 CET 2013
With that attribute commented out, when I try start freeradius, i have this
error:
including dictionary file /etc/freeradius/dictionary
Errors reading dictionary: dict_init:
/etc/freeradius/dictionary.opensips[93]: dict_addattr: Duplicate attribute
name Event-Timestamp
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br
55 3537 2030
2013/3/25 Willian Mazzardo - SYSSVOIP <willian at syssvoip.com.br>
> Damn it!!
>
> #ATTRIBUTE Event-Timestamp 230 string
>
> Its commented !!
>
> I will try comment this out and make a test.
>
>
>
>
> Willian Mazzardo
> Depto TI - SYSSVOIP
> www.syssvoip.com.br
> 55 3537 2030
>
>
> 2013/3/25 Tijmen de Mes <tijmen at ag-projects.com>
>
>> Hi,
>>
>> Please check if the following is present in the OpenSIPS dictionary:
>>
>> ### Attributes added by AG Projects ###
>> ATTRIBUTE Source-IP 214 string
>> ATTRIBUTE Source-Port 215 string
>> ATTRIBUTE Canonical-URI 216 string
>> ATTRIBUTE Delay-Time 217 string
>> ATTRIBUTE Divert-Reason 219 string
>> ATTRIBUTE X-RTP-Stat 220 string
>> ATTRIBUTE From-Header 221 string
>> ATTRIBUTE User-Agent 222 string
>> ATTRIBUTE Contact 223 string
>> ATTRIBUTE Event 224 string
>> ATTRIBUTE Event-Timestamp 230 integer
>> ATTRIBUTE SIP-Proxy-IP 231 string
>> ATTRIBUTE ENUM-TLD 232 string
>>
>>
>> Best regards,
>>
>> --
>> Tijmen de Mes
>> AG Projects
>>
>> On 03/25/2013 02:26 PM, Willian Mazzardo - SYSSVOIP wrote:
>>
>> Hi ..
>>
>> about date/time issue, what can I do to test? because the %S is
>> "working" and give me the right duration time of a call.
>>
>> My freeradius is FreeRADIUS Version 2.1.10, for host
>> x86_64-pc-linux-gnu, built on Jan 7 2013 at 17:11:42
>>
>> the dictionaries loaded are:
>>
>> $INCLUDE /usr/share/freeradius/dictionary
>>
>> # OpenSER dictionary
>> $INCLUDE /etc/freeradius/dictionary.opensips
>>
>> # MediaProxy dictionary
>> $INCLUDE /etc/freeradius/dictionary.mediaproxy
>>
>>
>>
>>
>> Willian Mazzardo
>> Depto TI - SYSSVOIP
>> www.syssvoip.com.br
>> 55 3537 2030
>>
>>
>> 2013/3/25 Tijmen de Mes <tijmen at ag-projects.com>
>>
>>> Hi,
>>>
>>> As I said the event-timestamp should be a 'timestamp', not at date. If
>>> it is a date, from_unixtime will not work. If the timestamp is datetime,
>>> like in your case, the FROM_UNIXTIME conversions are not needed. The
>>> question is, why is the timestamp a datetime?
>>>
>>> If you use %S it will take the date/time from the sql server. Please be
>>> aware that this is not the start/stop date of the request.
>>>
>>> Which radius version are you running? Are you sure the right
>>> dictionaries are loaded? If you specify the application type manually it
>>> will be always audio. In SIP more types are possible, like message.
>>>
>>>
>>> Best regards,
>>>
>>> --
>>> Tijmen de Mes
>>> AG Projects
>>>
>>>
>>> On 03/25/2013 12:52 PM, Willian Mazzardo - SYSSVOIP wrote:
>>>
>>> Hi ... it was like this ... but the date what the script was getting
>>> "2013-04-24 00:33 BRT blablabla" and this is wrong ...
>>>
>>> Yesterday I tried another sql.conf from other CDRTool version I had in
>>> my server, wich is:
>>>
>>> accounting_start_query = "\
>>> CALL insert_radacct_record( \
>>> 'radius', \
>>> '%{Acct-Session-Id}', \
>>> '%{Acct-Unique-Session-Id}', \
>>> '%{Billing-Party}', \
>>> '%{Billing-Party}', \
>>> '%{SIP-Proxy-IP}', \
>>> '%{NAS-Port}', \
>>> * '%S', \*
>>> '0', \
>>> '0', \
>>> '0', \
>>> '0', \
>>> '%{Called-Station-Id}', \
>>> '%{Calling-Station-Id}', \
>>> '%{Sip-Response-Code}', \
>>> '%{Service-Type}', \
>>> '%{ENUM-TLD}', \
>>> '%{Framed-IP-Address}', \
>>> '%{Acct-Delay-Time}', \
>>> '0', \
>>> '%{Sip-Response-Code}', \
>>> '%{Sip-Method}', \
>>> '%{Sip-Translated-Request-URI}', \
>>> '%{Sip-To-Tag}', \
>>> '%{Sip-From-Tag}', \
>>> '%{Sip-RPId}', \
>>> '%{Source-IP}', \
>>> '%{Source-Port}', \
>>> '%{Canonical-URI}', \
>>> '', \
>>> '', \
>>> 'audio', \
>>> '%{User-Agent}', \
>>> '%{From-Header}' \
>>> )"
>>>
>>> accounting_stop_query = "\
>>> CALL update_radacct_record( \
>>> 'radius', \
>>> * '%S', \*
>>> '%{Acct-Delay-Time}', \
>>> '%{Connect-Info}', \
>>> '%{X-RTP-Stat}', \
>>> '%{Acct-Session-Id}', \
>>> '%{Sip-To-Tag}', \
>>> '%{Sip-From-Tag}' \
>>> )"
>>>
>>> accounting_update_query = "\
>>> CALL update_raddact_record_mediaproxy( \
>>> 'radius', \
>>> '%{Acct-Session-Time}', \
>>> '%{Acct-Input-Octets}', \
>>> '%{Acct-Output-Octets}', \
>>> '%{Sip-User-Agents}', \
>>> '%{Media-Codecs}', \
>>> '%{Sip-Application-Type}', \
>>> '%{Media-Info}', \
>>> '0', \
>>> '%{Acct-Session-Id}', \
>>> '%{Sip-To-Tag}', \
>>> '%{Sip-From-Tag}' \
>>> )"
>>>
>>> accounting_failed_query = "\
>>> CALL insert_radacct_record( \
>>> 'radius', \
>>> '%{Acct-Session-Id}', \
>>> '%{Acct-Unique-Session-Id}', \
>>> '%{Billing-Party}', \
>>> '%{Billing-Party}', \
>>> '%{SIP-Proxy-IP}', \
>>> '%{NAS-Port}', \
>>> * '%S', \*
>>> * '%S', \*
>>> '0', \
>>> '0', \
>>> '0', \
>>> '%{Called-Station-Id}', \
>>> '%{Calling-Station-Id}', \
>>> '%{Sip-Response-Code}', \
>>> '%{Service-Type}', \
>>> '%{ENUM-TLD}', \
>>> '%{Framed-IP-Address}', \
>>> '%{Acct-Delay-Time}', \
>>> '0', \
>>> '%{Sip-Response-Code}', \
>>> '%{Sip-Method}', \
>>> '%{Sip-Translated-Request-URI}', \
>>> MD5(RAND()), \
>>> '%{Sip-From-Tag}', \
>>> '%{Sip-RPId}', \
>>> '%{Source-IP}', \
>>> '%{Source-Port}', \
>>> '%{Canonical-URI}', \
>>> '', \
>>> '', \
>>> 'audio', \
>>> '%{User-Agent}', \
>>> '%{From-Header}' \
>>> )"
>>> }
>>>
>>> See the field wich have DATE-TIME, in this sql.conf file, have only
>>> '%S', where the original sql.conf file has
>>> FROM_UNIXTIME(%{Event-Timestamp}), \
>>> FROM_UNIXTIME(%{Event-Timestamp}), \
>>>
>>> In field ${Sip-Application-Type}, I had to put "audio" manually to
>>> work too ...
>>>
>>> Now CDRTool is working good, getting Date-Time correctly.
>>>
>>>
>>> Willian Mazzardo
>>> Depto TI - SYSSVOIP
>>> www.syssvoip.com.br
>>> 55 3537 2030 <55%203537%202030>
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>>
>> _______________________________________________
>> Users mailing listUsers at lists.opensips.orghttp://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
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130325/60dd027a/attachment-0001.htm>
More information about the Users
mailing list