(RADIATOR) SQLRADIUS - im missing the obvious

[Frank Danielson]

First off you have your log level at 3 or higher which is why you are
getting the INFO level messages. At this log level every failure to forward
a request in one of the AuthBy RADIUS variants will generate a message. The
simplest solution is to run at log level 2 if you don't like the messages.

My gut feeling is that your config may not be doing what you want it to. The
AuthBy SQLRADIUS will return immediately after forwarding the request
without waiting for a response and the ContinueUntilAccept will then cause
the request to be handled by the AuthBy SQL. If you get a response from the
remote server that will also be sent back to the client but since the AuthBy
SQL has already replied it really doesn't matter. So in this config _all_
authorization requests are decided by the AuthBy SQL clause. Read that last
sentence again.

There's probably a good solution depending on what you really want to
happen. My guess is that you want to try the AuthBy SQLRADIUS and if no host
is selected you want to use AuthBy SQL. In that case you can run another
instance of Radiator on the same host on some odd port that just does the
AuthBy SQL and then define a default host in your AuthBy SQLRADIUS clause
that points to that instance.

Of course I may have not guessed correctly what you are trying to do. How
about sharing what your goal is and I bet someone on the list will have
already worked it out in the past. Maybe seeing your HostSelect statement
may give some insight as well.

Frank Danielson
Infrastructure Architect

ClearSky Mobile Media
56 E. Pine St. Suite 200
Orlando, FL 32801
USA

-----Original Message-----
From: Steve Lalonde [mailto:steve at enta.net]
Sent: Monday, November 29, 2004 7:14 PM
To: radiator at open.com.au
Subject: (RADIATOR) SQLRADIUS - im missing the obvious


Hi all

annoying problem - config works as intended but i get lots of warnings 
in the logfile :(



here is the config snipit

<Handler Client-Identifier=******>
     AuthByPolicy ContinueUntilAccept
     <AuthBy SQLRADIUS>
         DBSource        dbi:mysql:radius:localhost
         DBUsername      *****
         DBAuth          *****
         FailureBackoffTime 10
         NumHosts        2
         HostSelect .....
         HostColumnDef 0, Host
         HostColumnDef 1, Secret
         HostColumnDef 2, Retries
         HostColumnDef 3, AuthPort
         HostColumnDef 4, failurePolicy
     </Authby>
     <AuthBy SQL>
         DBSource        dbi:mysql:radius:localhost
         DBUsername      ******
         DBAuth          ******
         .....
         AuthColumnDef 0, User-Password, check
         AuthColumnDef 1, GENERIC, reply
     </AuthBy>
     AuthLog myauthlogger
</Hander>



what happens is this

if <AuthBy SQLRADIUS> does not get a valid return from the DB it 
generates a log line like this

Mon Nov 29 20:44:46 2004: INFO: AuthRADIUS could not find a working host 
to forward to. Ignoring

then it goes on to do the <AuthBy SQL>

thats how i want it to work but the log lines are 99% of the log - some 
  100+ meg of garbage logged daily :(


I have tried defining a host as a default but that just ends up with 
different errors being logged.

Any Ideas?



-- 
Steve Lalonde RTFM
Chief Technical Officer
Entanet International Ltd
http://www.enta.net/

--
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.

--
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.