[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