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 <puc...@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@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