[OpenSIPS-Users] opensips + freeradius + acc

[andrzej.ciupek at asterisk.edu.pl]

Hello

I don't know where was problem, but I have downloaded  
cdrtool_9.0.1squeeze.tar.gz

and after:

mysql -u root -p radius < radius_accounting.proc

it works fine, so I had to have some kind of bug in previous  
radius_accounting.proc.

Greetings
Andrzej C

Cytowanie Tijmen de Mes <tijmen at ag-projects.com>:

> 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