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 <tij...@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.ciu...@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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
