Re: (RADIATOR) Checking results of a AuthSQLStatment

Hugh Irvine Thu, 14 Aug 2003 11:30:32 -0700

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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) Checking results of a AuthSQLStatment

Reply via email to