[OpenSIPS-Users] opensips + freeradius + acc

andrzej.ciupek at asterisk.edu.pl andrzej.ciupek at asterisk.edu.pl
Tue Mar 19 14:45:16 CET 2013


Hello

I have started to use freeradius for acc. Using scripts from cdr-tool.
I have problem with update procedure after BYE.
Insert after answered call goes to the table "radacct201303", but  
after BYE, when prodecure update_radacct_record is called, there is no  
result.
When I create UPDATE based on log from sqltrace log It works.
It looks like:

CALL update_radacct_record(                 'radacct',                  
'2013-03-19 14:14:07',                 '0',                 '',         
          '',                   
'MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.',                  
'df421e69',                 'as287910d5'                 );

doesn't update record but handmade UPDATE:

UPDATE radacct201303  SET AcctStopTime = '2013-03-19 14:14:07',  
AcctSessionTime = CONCAT( TIME_TO_SEC(TIMEDIFF('2013-03-19 14:14:07',  
AcctStartTime)), '.', MICROSECOND(TIMEDIFF('2013-03-19 14:14:07',  
AcctStartTime)) ),                AcctStopDelay = '', ConnectInfo_stop  
= '', RTPStatistics = '', Normalized = '0' WHERE AcctSessionId =  
'MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.' AND ((SipToTag =  
'as287910d5' AND SipFromTag = 'df421e69') OR (SipFromTag =  
'as287910d5' AND SipToTag = 'df421e69')) AND ConnectInfo_stop IS NULL  
AND (MediaInfo IS NULL OR MediaInfo != 'timeout');

does.

Has someone had same problem ?

Greetings
Andrzej







More information about the Users mailing list