[OpenSIPS-Users] CDRTool 9.1.1
Willian Mazzardo - SYSSVOIP
willian at syssvoip.com.br
Mon Mar 25 14:43:14 CET 2013
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/de804c78/attachment-0001.htm>
More information about the Users
mailing list