[OpenSIPS-Users] CDRTool 9.1.1
Tijmen de Mes
tijmen at ag-projects.com
Mon Mar 25 14:39:01 CET 2013
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 <http://www.syssvoip.com.br>
> 55 3537 2030
>
>
> 2013/3/25 Tijmen de Mes <tijmen at ag-projects.com
> <mailto: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 <http://www.syssvoip.com.br>
>> 55 3537 2030 <tel:55%203537%202030>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org <mailto: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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130325/e1dafc1c/attachment.htm>
More information about the Users
mailing list