[OpenSIPS-Users] CDRTool 9.1.1

Willian Mazzardo - SYSSVOIP willian at syssvoip.com.br
Mon Mar 25 15:21:13 CET 2013


I have debian and installed freeradius-xs package ...

But the error persist...



Willian Mazzardo
Depto TI - SYSSVOIP
www.syssvoip.com.br
55 3537 2030


2013/3/25 Tijmen de Mes <tijmen at ag-projects.com>

>  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
> [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
>
>
> _______________________________________________
> 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/c3c26421/attachment-0001.htm>


More information about the Users mailing list