[OpenSIPS-Users] CDRTool 9.1.1

[Tijmen de Mes]

Hi,

This is all just basic setup. I don't know your exact setup,  I can only 
guess.

You see it FROM_UNIXTIME(), is empty , so that won't work. You have to 
find out why the event-timestamp attribute is now empty. To give you any 
hints, what is in the detail file, and in which format, is the attribute 
only defined once in the dictionaries?

As a side note, if you are using Debian, we have freeradius-xs package 
for sqeeuze and sid which is preconfigured with all these things.

-- 
Tijmen de Mes
AG Projects


On 03/25/2013 02:51 PM, Willian Mazzardo - SYSSVOIP wrote:
> 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 
> <http://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 
> <http://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 
> <http://280e1cb527443026017094174eee1d7c@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 <http://www.syssvoip.com.br>
> 55 3537 2030
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130325/aa3dc5d5/attachment.htm>