Accounting error

tnt at kalik.net tnt at kalik.net
Wed Mar 18 22:38:15 CET 2009


>radius_xlat:  'EXEC acct_update '2009-03-18 22:45:44', '17096', '253790', '426579', '', '', 'Acct-Update', '0', '153354240', '0002380B', 'xxxxxxx at xxxx', 'xxx.xxx.xxx.xxx', '2aa4d04abb7544a1', 'DEFAULT', '0', 'Virtual', 'RADIUS', '', '', 'Framed-User', 'PPP', 'xxx.xxx.xxx.xxx';'
>rlm_sql (sql): Reserving sql socket id: 18
>rlm_sql (sql): Couldn't update SQL accounting ALIVE record - 00000
>rlm_sql (sql): Released sql socket id: 18

>
>most of the output of the debug is normal but every now and then I get these errors also the authentications sometimes takes long time, about 30 seconds to get the accept packet from the radius
>
>I really appreciate your help
>

But you are not using freeradius queries for accounting. You are using
some custom stored procedure. It's failing sometimes. We have no idea
what does that procedure do. Ask someone who does.

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list