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 <tij...@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@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@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users