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@kalik.net" <tnt@kalik.net> To: FreeRadius users mailing list <freeradius-users@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@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