(RADIATOR) multiple AuthBy SQL clauses and temporary tables

[Hugh Irvine]

Hello Randy -

Radiator tries to keep the database connection open all the time, and 
all AuthBy clauses refering to the same database will share the one 
connection. If the connection drops for any reason Radiator will 
re-connect automatically.

BTW - a much handier way of passing this sort of information around is 
to add it to the current request, where subsequent AuthBy clauses can 
access it.

In an AuthBy SQL you would use an AuthColumnDef like this:

	AuthColumnDef n, What-Ever, request

You can use anything you like for "What-Ever" and it does not need to 
be defined in the dictionary.

See section 6.28.7 in the Radiator 3.8 reference manual 
("doc/ref.html").

Then in the later AuthBy clauses you can access the attribute in the 
same way you access any other attributes.

Also note that you can do *lots* of useful things with hooks - see 
"goodies/hooks.txt".

Hope that helps.

regards

Hugh


On 24 Jan 2004, at 13:13, Brown, Randy wrote:

> I am using AuthBy SQL with mysql 3.23. (Yes, it's old, but I don't 
> have the option to change now.) I need several AuthBy SQL clauses to 
> check for different authentication types, all querying the same 
> database. In order to simplify the specific AuthBy queries, I'd like 
> to create a temporary table in the first AuthBy SQL clause, and refer 
> to it in subsequent AuthBy SQL clauses. So, I have a question about 
> the lifetime of the connections, as the temporary table will disappear 
> when the connection is closed.
>
> When are database connections closed? Is it safe to refer to a 
> temporary table created in an early AuthBy SQL clause invoked for the 
> same request? Do I need to define an AuthSQLStatement "create 
> temporary table if not exist..." in each subsequent clause?
>
> ---
> Randy Brown
> Principal Security Engineer
> Cable & Wireless
> www.cw.com
>
> email     randy.brown at cw.com
> telephone +1-510-749-7035
> ===
> 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, MacOS X.
-
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.

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