[RADIATOR] Example of AuthSelect MySQL stored procedure/function

[Hugh Irvine]

Hello Mike -

I don’t have a complete example, however the MySQL documentation is here:

	http://dev.mysql.com/doc/refman/5.7/en/call.html

So your AuthSelect would look like this:

	AuthSelect CALL ……

Perhaps someone else on the list has an example?

BTW - there are a couple of Oracle examples in the “goodies” directory that might give you some ideas.

regards

Hugh


> On 12 May 2016, at 20:40, Mike Puchol <puchol at me.com> wrote:
> 
> Greetings,
> 
> I've found a few posts on the mailing lists regarding use of stored procedures or functions on MySQL against an AuthSelect, but none show the actual MySQL declaration, and how it can return multiple AuthColumnDef parameters - for example, I would like to do an select on username and MAC address, and return Idle-Timeout and Session-Timeout parameters, plus some NAS-specific attributes.
> 
> Does anyone have a full example of both AuthSelect clause + MySQL procedure code they can share?
> 
> Thanks,
> 
> Mike
> 
> 
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator


--

Hugh Irvine
hugh at open.com.au

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER, SIM, etc. 
Full source on Unix, Linux, Windows, MacOSX, Solaris, VMS, NetWare etc.