[OpenSIPS-Users] opensips + freeradius + acc

[andrzej.ciupek at asterisk.edu.pl]

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