Hello all I am trying to use MySQL 5.0.19 Stored Procedure with Free Radius 1.1. This is my Procedure
DELIMITER $$ DROP PROCEDURE IF EXISTS `radius`.`auth`$$ CREATE PROCEDURE `auth`(user1 varchar(100)) BEGIN SELECT id, UserName, Attribute, Value, op FROM radius.radcheck WHERE Username =user1 ORDER BY id; END$$ DELIMITER ; When I run this procedure from Query Browser the procedure runs fine but wen I run this procedure using Free Radius I get this error radius_xlat: 'CALL auth('202.80.61.42')' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_mysql: MYSQL check_error: 1312 received rlm_sql_getvpdata: database query error rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 is it some problem with the driver. What do u think is the problem Vignesh Bhaskar Novanet Technologies - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html