[RADIATOR] AuthBy SQL - multiple rows/attributes

[Michael]

I seem to remember reading somewhere in the Radiator manual that it will only process the first sql row received therefore I don't think it will process multiple row results.  I can't seem to find in the manual where i read that though. On the other hand, you could have all reply values on the same row in the table, or create an sql statement that returns them all on one row.

What is your sql table structure?  multiple tables?

mike


On 12-06-25 08:52 AM, Jim Tyrrell wrote:
> Hi,
>
> Is it possible for AuthBy SQL to return multiple attributes if the query
> returns multiple rows?
>
> I am currently using AuthBy SQL to return a Tunnel-Endpoint to a LAC
> with the following simplified config:
>
> <AuthBy SQL>
>           DBSource        dbi:mysql:databasename:192.168.10.3
>           DBUsername      DBuser
>           DBAuth          DBPass
>           AuthSelect SELECT Endpoint, Password FROM endpoints
>           AuthColumnDef   0,Tunnel-Server-Endpoint,reply
>           AuthColumnDef   1,Tunnel-Password,reply
> </AuthBy>
>
> This works fine at the moment as I only have 1 row in the table which
> represents 1 endpoint.  But I now want to return multiple endpoints so
> the Access-Accept would be something along the lines of:
>
> Code:       Access-Accept
> Attributes:
>           Tunnel-Server-Endpoint = 172.16.1.1
>           Tunnel-Password = "tunnelpass"
>           Tunnel-Server-Endpoint = 172.16.1.2
>           Tunnel-Password = "tunnelpass2"
>
> I had hoped to just add a 2nd row to the table, but the handler just
> returns the values from the 1st row of the result.  I'd like to be able
> to return additional attributes for each row returned so I can easily
> add/remove more endpoints to the table as and when I need to.
>
> Thanks.
>
> Jim.
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator
>
>