[OpenSIPS-Users] opensips + freeradius + acc

Tijmen de Mes tijmen at ag-projects.com
Tue Mar 19 16:47:12 CET 2013


Hi,

Something is not right. I used the exact same query as you did and here 
it is successful:
mysql> CALL update_radacct_record( 'radius', '2013-03-19  14:14:07', 
'0',                 '', '',  
'MmJiNjRiYTNkNjBmNWM3YmZhNGRhOWRkZWJiMDA4ZmU.', 
'df421e69',                 'as287910d5'                 );
Query OK, 0 rows affected (0.00 sec)

That zero rows affected is because I don't have that session. Nothing 
about wrong arguments or any other error.

Are you sure you have the right procedure and table layout? FYI we are 
running  mysql 5.1.49-3

Best regards,

-- 
Tijmen de Mes
AG Projects


On 03/19/2013 04:05 PM, andrzej.ciupek at asterisk.edu.pl wrote:
> Hello
>
> Yes database is radius, table is radacct. But when I change it to 
> database name I get error:
>
> ERROR 1210 (HY000): Incorrect arguments to EXECUTE
>
> But @v_db_name = var_db_name, is not used in procedure, after that:
>
> table name is from:
>
> @var_tbl_begin = (SELECT set_radacct_table_name()),
>
> with concat of month.
>
> Greetings
> Andrzej
>
> Cytowanie Tijmen de Mes <tijmen at ag-projects.com>:
>
>> 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
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users 



More information about the Users mailing list