Hello Andy -
On Fri, 28 Jan 2000, Andy Dills wrote:
> Ok, I'm about to dive headfirst into Radiator, and I wanted to ask a few
> questions in advance. I'm somewhat competent, so this isn't a "I haven't
> tried this yet but I need help before I even get started" post, more like
> "hopefully somebody has been in this situation before and can offer some
> advice".
>
> I've got some sparc stations that I want to do the authentication from.
> Right now, I use cistron, so the users file will transition quite nicely.
> This isn't a problem. The session DB will be handled by our mysql server,
> so I don't anticipate that being a problem either.
>
> The interesting part: I want to log the authentication to my platypus
> billing server, running on NT with MS SQL. I don't want to authenticate,
> just store the logging, so we can get usage reports integrated with the
> billing.
>
> So, what's the best way to do this? Is there a stable and free interface
> from Unix to MS SQL? I started downloading some perl modules and reading
> web pages, and the only two drivers I found cost money. So, it looks like
> FreeTDS is the only way to fly, but just looking at it makes me shiver a
> little bit.
>
> Plus, I was thinking it my be somewhat pointless in the first place. Would
> it not be better to disable accounting on the Unix servers, and set up
> radiator on the NT server, and have it do nothing but inject accounting
> records into the SQL db?
>
> However, I'm not sure if that will break any functionality. Most
> importantly, will it in any way hinder the session support? Does perl
> under NT easily communicate with MySQL?
>
> So, I just need a little advice. Go with FreeTDS under Solaris (and if so,
> how do I authby users and send accounting to platypus?), or keep the auth
> and acct servers seperate, each on their own platform (but each
> communicating with the mysql server for session support)?
>
> Lastly, a side question. Our main pop has an Assured Access X1000. Has
> anybody written support for it as a NasType?
>
We have lots of customers using FreeTDS successfully, please note however that
you need the Perl module from here:
ftp://freetds.internetcds.com/pub/freetds_dbd/freetds_dbd.snapshot.tgz
Also have a look at the FAQ for other options:
http://www.open.com.au/radiator/faq.html#13
We have also had excellent results with the OpenLink product mentioned above.
One way to set up Radiator to do what you require is something like this:
# AuthBy SQL has an empty AuthSelect for no authentication
# AccountingTable must be set to the correct table in mssql
# AuthBy FILE will handle authentication
<Realm ....>
AuthByPolicy ContinueAlways
<AuthBy SQL>
DBSource ....
DBUsername ....
DBAuth ....
AuthSelect
AccountingTable ....
....
</AuthBy>
<AuthBy FILE>
Filename .....
</AuthBy>
</Realm>
Alternatively you could set up different Handler's for the authentication and
accounting packets.
I don't know anything about an "Assured Access X1000" - anyone else?
If you need any more help, feel free to ask.
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.
