FR with MySQL - Stored Procedures

[Alan DeKok]

Gunther wrote:
> I forgot to mention that the problem I reported previously is actually not
> 'Stored Procedure' related, but related to the MySQL client_flag
> 'CLIENT_MULTI_STATEMENTS'. This flag is required to support Stored
> Procedures and is causing the problem  (at least with my operating system
> (CentOS 4.4)). So no need to create any stored procedures ... just compile
> FR with CLIENT_MULTI_STATEMENTS in the
> rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c module.

  OK.

> Looking forward using Stored Procedures (no more 253 byte limit for my SQL
> statements!!!).

  Huh?  From the changelog in 1.1.5:

	* Increase buffer size for dynamic expansion, which allows
	  longer SQL qeuries.  (close: #405)

  1.1.5 and 1.1.6 allow SQL queries up to 4k in length.  The only limit
of 253 bytes is the data that has to go into a RADIUS packet.

  Alan DeKok.
--
  http://deployingradius.com       - The web site of the book
  http://deployingradius.com/blog/ - The blog