[OpenSIPS-Users] opensips + freeradius + acc

[Tijmen de Mes]

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, andrzej.ciupek at asterisk.edu.pl 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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users