Hi,
Are you sure database called 'radacct' ? Usually it is something like
'radius'. If it is radius the call needs to be:
CALL update_radacct_record('radius', '2013-03-19 14:14:07','0', '',
'','MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.',
'df421e69','as287910d5');
Best regards,
--
Tijmen de Mes
AG Projects
On 03/19/2013 02:45 PM, [email protected] wrote:
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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
