Re: [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  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@open.com.au
> http://www.open.com.au/mailman/listinfo/radiator


--

Hugh Irvine
h...@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.

___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator

[RADIATOR] Example of AuthSelect MySQL stored procedure/function

[Mike Puchol]

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@open.com.au
http://www.open.com.au/mailman/listinfo/radiator