(RADIATOR) Checking results of a AuthSQLStatment

[Hugh Irvine]

Hello John -

Your configuration below is the cause of the problem, as the 
AuthColumnDef only operates on the results of the AuthSelect statement. 
There is also no way to operate on the results of the AuthSQLStatement 
in the AuthBy SQL clause - it will only operate on the database in the 
same fashion as the AcctSQLStatement.

Perhaps if you describe what you want to do I can make some suggestions.

regards

Hugh


On Friday, Aug 8, 2003, at 05:57 Australia/Melbourne, John McFadden 
wrote:

> I'm trying to take advantage of the AuthSQL feature.
>
> At this point I'm just trying to make sure my AuthSQLStatement is 
> working correctly before I try to use it.
>
> Here is the AuthBy SQL I was hoping this would populate TEST with the 
> value of the USERID column.
>
> <AuthBy SQL>
> # Change to suit your system:
>    No Authorization
>    DBSource dbi:Oracle:raprd
>     DBUsername    xxxxxx
>     DBAuth            yyyyyy
>    # This next one stops it doing auths from SQL:
>    AuthSelect
>    # Define a field for column
>    AuthColumnDef 0,TEST,request
>    # Define the select
>    AuthSQLStatement select USERID from USERS where USER_ID=4
> </AuthBy>
>
>
> But when I get and display the value in a PostAuthHook and log TEST it 
> shows up as a blank.
>
>
> PostAuthHook sub {\
>        &main::log($main::LOG_DEBUG, "Entering postauth");\
>         my $request = ${$_[0]};\
>         my $reply = ${$_[1]};\
>         my $result = ${$_[2]};\
>         my $TEST = $request->get_attr('TEST');\
>         &main::log($main::LOG_DEBUG, $TEST);\
>         &main::log($main::LOG_DEBUG, "Exiting postauth");\
>         }
>
>
> I assume I'm just missing something basic.
>
> Any hints would be appreciated?
>
>
> Thanks in advance
> John McFadden
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.