Hello Danny -
On Fri, 31 Dec 1999, Danny Whitesel wrote:
> I posted a while back regarding the MySQL/DBI/Perl compiler issue. I ended
> up re-compiling Perl and after a few hours and one massive headache, finally
> got Radiator talking to the MySQL server.
>
> I now need some input on configuration. I would like to, if possible, use
> the MySQL database for authentication, yet have the accounting info
> available to Rodopi. How would one go about this? Is it possible to point
> Radiator to the MySQL database for security and point it to the Rodopi
> database for accounting?
>
> I'm kinda new to the whole RADIUS thing right now and I'm still in the
> "crash course" stage of learning. Up to now, we have been using USR's RADIUS
> server and making the switch to Radiator is somewhat of a culture shock.
>
> Which brings me to one last question... As I understand it, Radiator uses
> one field in the database to hold all of the RADIUS attributes to reply to
> the RADIUS client with. The USR RADIUS database has one column for each
> attribute, which makes writing queries to, say, add multi-link capability
> much easier.
>
> Is there any way, with Radiator, to maintain multiple columns of RADIUS
> attributes which would be concatenated together for transmission to the
> requesting client?
>
It is quite simple to do what you wish with cascaded AuthBy's, something like
this would be close:
# configure two AuthBy clauses
# the first does accounting only (note empty AuthSelect)
# the second does authentication only (empty AccountingTable)
# and multiple AuthColumnDef's for reply items
<Handler ....>
AuthByPolicy ContinueAlways
<AuthBy RODOPI>
AuthSelect
DBSource ....
DBAuth ....
DBUsername ....
</AuthBy>
<AuthBy SQL>
AccountingTable
DBSource ....
DBAuth ....
DBUsername ....
AuthSelect select ....
AuthColumnDef .....
AuthColumnDef ....
....
</AuthBy>
</Handler>
Have a look at section 6.24 in the Radiator 2.14.1 reference manual for further
details. There are also examples in the Radiator distribution in the files
radius.cfg and goodies/sql.cfg.
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
