[RADIATOR] Too much DB queries with SessionDatabase

[Hugh Irvine]

Hello Jan -

You can access any attributes in the outer request from your inner  
Handler like this:

	%{OuterRequest:What-Ever-Attribute}

See section 5.2 of the Radiator 4.4 reference manual ("doc/ref.pdf").

hope that helps

regards

Hugh


On 15 Apr 2009, at 17:39, Jan Tomasek wrote:

> Hi Hugh
>> I think I would put the session checking in the Inner Handler(s)  
>> rather than the outer Handler.
>
> But in Inner Handler are user identity, AcctSessionID, ... unknown:
>
>> Wed Apr 15 09:34:12 2009: DEBUG: do query is: 'DELETE FROM  
>> RadOnline WHERE NASIdentifier="195.113.150.2" AND  
>> lower(UserName)=lower("anonymous") AND AcctSessionID="NULL"': Wed  
>> Apr 15 09:34:12 2009: DEBUG: Query is: 'select NASIdentifier,  
>> NASPort, AcctSessionID, FramedIPAddress from RadOnline where  
>> lower(UserName)=lower("anonymous")':
>
>> Otherwise, instead of using the standard session database you could  
>> use an AuthBy SQL clause in the outer Handler, but I would prefer  
>> my first suggestion.
>
> Thanks for tip. goodies/blocktime.txt seams to be interesting
> alternative. I'll try to adapt this to my needs.
>
> -- 
> -----------------------
> Jan Tomasek aka Semik
> http://www.tomasek.cz/



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.