<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>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:<br><br>radius_xlat: 'SELECT
id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'xxxxxx' ORDER BY id'<br>rlm_sql (sql): Reserving sql socket id: 6<br>rlm_sql_getvpdata: database query error<br>rlm_sql (sql): <span style="background: transparent none repeat scroll 0% 0%; cursor: pointer; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" class="yshortcuts" id="lw_1237411572_8">SQL query error</span>; rejecting user<br><br>do you know what my cause this??<br><br>Best Regards<br>Ahmed Adel <br></div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> "tnt@kalik.net" <tnt@kalik.net><br><b><span style="font-weight: bold;">To:</span></b> FreeRadius users mailing list
<freeradius-users@lists.freeradius.org><br><b><span style="font-weight: bold;">Sent:</span></b> Wednesday, March 18, 2009 11:38:15 PM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: Accounting error<br></font><br>
>radius_xlat: 'EXEC acct_update '2009-03-18 22:45:44', '17096', '253790', '426579', '', '', 'Acct-Update', '0', '153354240', '0002380B', 'xxxxxxx@xxxx', 'xxx.xxx.xxx.xxx', '2aa4d04abb7544a1', 'DEFAULT', '0', 'Virtual', 'RADIUS', '', '', 'Framed-User', 'PPP', 'xxx.xxx.xxx.xxx';'<br>>rlm_sql (sql): Reserving sql socket id: 18<br>>rlm_sql (sql): Couldn't update SQL accounting ALIVE record - 00000<br>>rlm_sql (sql): Released sql socket id: 18<br><br>><br>>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<br>><br>>I really appreciate your help<br>><br><br>But you are not using freeradius queries for accounting. You are using<br>some custom stored procedure. It's failing sometimes. We have no idea<br>what does that procedure do. Ask someone who does.<br><br>Ivan Kalik<br>Kalik
Informatika ISP<br><br>-<br><span>List info/subscribe/unsubscribe? See <a target="_blank" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></span><br></div></div></div><br>
</body></html>