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