[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