(RADIATOR) Radiator + Mysql.

[Hugh Irvine]

Hello Wesley -

On 9 Feb 2004, at 18:29, Wesley Hof wrote:

> Hi List,
>
> I have 2 questions:
>
> 1) Assume radiator has to handle a lot accounting requests, stored in
>    a mysql database. Will radiator open up more then one connection
>    to the mysql database ? Or will it use one connection to store
>    everything. In the second case, is there a way to force radiator
>    to open more then one connection then?
>

Radiator will only use a single connection to the database.

To use more than one connection you should use multiple instances of 
radiusd.

> 2) I strip realms with the RewriteUsername option, is there a way to 
> put the
>    realm in a variable. I store my accounting in a mysql database, but 
> I would like to store the username and the realm in a seperate field. 
> Is this possible?
>

Both the username and the realm from the original username are 
available with "%w" and "%W' respectively.

You can use one or the other or both in your AcctColumnDef's:

	AcctColumnDef ORIGINAL_USERNAME, %w, formatted
	AcctColumnDef ORIGINAL_REALM, %W, formatted

See sections 6.2 and 6.28.14 in the Radiator 3.8 reference manual 
("doc/ref.html").


regards

Hugh


> Thanks in advance.
> W.
>
> --
> (o_  Wesley Hof
> //\  UNIX System Engineer
> V_/_ UNInet ))) A Scarlet Company
> ===
> 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.