[RADIATOR] AuthBy SQL Reject or Accept in the SQL results

[Michael]

I use a reject column in my user database, and SELECT it like this:
SELECT username, crypt, CONCAT('Reject:',reject), ....

and:
AuthColumnDef   2, Auth-Type, check

so, if the reject column is NULL, CONCAT returns NULL and it passed, but if the reject column has text in it, CONCAT returns 'Reject:reject reason', and the user is rejected.




On 12-02-08 12:40 PM, Lee Solway wrote:
> Is there a way I can set an access Accept or Reject in the MySQL results
> generated by AuthBy SQL?
>
> Currently I have a stored procedure that I call in the following.. I
> would like the SP to be able to reject the Access-Request with an error
> message also if possible..
>
>      AuthSelect            CALL get_reply_attr('%U')
>      AuthColumnDef     0, GENERIC, reply
>      AuthColumnDef     1, User-Password, check
>
> Thanks,
> Lee
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator
>
>