patch - support for stored procedures (MySQL 5.0.25 and later) - Freeradius-Devel

20 Oct 2006

      This patch adds support for stored procedures for
those who use MySQL 5.0.25+
(http://bugs.mysql.com/bug.php?id=15752)

eg. in sql.conf you can do:

authorize_check_query = "CALL Pradcheck('%{SQL-User-Name}');"

with procedure declaration:

SET AUTOCOMMIT=0;
DELIMITER |
DROP PROCEDURE IF EXISTS Pradcheck |
CREATE PROCEDURE Pradcheck (
  `SQL-User-Name` varchar(256)
)BEGIN
START TRANSACTION;
  SELECT id, UserName, Attribute, Value, op
           FROM radcheck
           WHERE Username = `SQL-User-Name`
           ORDER BY id;
COMMIT;
  END;
|
DELIMITER ;

etc.

Tested on FreeBSD 6.1 freeradius port 1.1.2

patch - support for stored procedures (MySQL 5.0.25 and later)

Nenad Kljajic

tags

participants (1)