Accounting error

[ahmed adel]

The procedures work most of the time plus on the failing cases when I run the procedure by my self it works, anyway what about the other error:

radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'xxxxxx' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 6
rlm_sql_getvpdata: database query error
rlm_sql (sql): SQL query error; rejecting user

do you know what my cause this??

Best Regards
Ahmed Adel




________________________________
From: "tnt at kalik.net" <tnt at kalik.net>
To: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Sent: Wednesday, March 18, 2009 11:38:15 PM
Subject: Re: Accounting error

>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

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090318/404cd88c/attachment.html>