MYSQL error 1312
vignesh
vignesh at novanet.net
Mon Jun 12 15:00:16 CEST 2006
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
More information about the Freeradius-Users
mailing list