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