[OpenSIPS-Users] CDRTool 9.1.1
Willian Mazzardo - SYSSVOIP
willian at syssvoip.com.br
Mon Mar 25 14:51:54 CET 2013
Ok .. changed and freeradius is UP.
But, when I do some call, this is the trace:
[detail] expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d ->
/var/log/freeradius/radacct/127.0.0.1/detail-20130325
[detail] /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to /var/log/freeradius/radacct/127.0.0.1/detail-20130325
[detail] expand: %t -> Mon Mar 25 10:50:02 2013
++[detail] returns ok
[sql] expand: CALL update_radacct_record( 'radius',
FROM_UNIXTIME(%{Event-Timestamp}),
UNIX_TIMESTAMP('%S') - '%{Event-Timestamp}',
'', '%{X-RTP-Stat}', '%{Acct-Session-Id}',
'%{Sip-To-Tag}', '%{Sip-From-Tag}' )
-> CALL update_radacct_record( 'radius',
FROM_UNIXTIME(),
UNIX_TIMESTAMP('2013-03-25 10:50:02') - '',
'', '', '
280e1cb527443026017094174eee1d7c at 187.53.208.106:5060',
'9309094362166693758', 'as18ead01f' )
[sql] expand: /var/log/freeradius/sqltrace-%Y%m%d.log ->
/var/log/freeradius/sqltrace-20130325.log
rlm_sql (sql): Reserving sql socket id: 13
rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN
rlm_sql (sql): Attempting to connect rlm_sql_mysql #13
rlm_sql_mysql: Starting connect to MySQL server for #13
rlm_sql (sql): Connected new DB handle, #13
rlm_sql_mysql: MYSQL check_error: 1582 received
rlm_sql (sql): failed after re-connect
[sql] Couldn't update SQL accounting STOP record - Incorrect parameter
count in the call to native function 'FROM_UNIXTIME'
rlm_sql_mysql: MYSQL check_error: 1582 received
rlm_sql_mysql: Cannot store result
rlm_sql_mysql: MySQL error 'Incorrect parameter count in the call to native
function 'FROM_UNIXTIME''
rlm_sql (sql): Released sql socket id: 13
++[sql] returns fail
Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br
55 3537 2030
2013/3/25 Tijmen de Mes <tijmen at ag-projects.com>
> Hi,
>
> Yes I noticed the sample provided by CDRTool is outdated. I will update it.
>
> It should be:
>
>
> ### 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
> ATTRIBUTE SIP-Application-Type 237 string
>
> So including the timestamp and Application type. Also event-timestamp
> should be integer.
>
>
> Best regards,
>
> --
> Tijmen de Mes
> AG Projects
>
>
> On 03/25/2013 02:43 PM, Willian Mazzardo - SYSSVOIP wrote:
>
>> 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 <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,
>>
>> 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 <tel:55%203537%202030>
>>>
>>>
> ______________________________**_________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-**bin/mailman/listinfo/users<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/ab879cce/attachment-0001.htm>
More information about the Users
mailing list