Hi Toni -
On Sat, 11 Nov 2000, Toni Riekkinen wrote:
> Hello,
>
> I'm setting radiator up for the first time.
> We have Oracle 8i database, I've just configured AuthBy SQL authentication
> and it works ok, (..after patching :).
>
> I've left AccountingTable blank for now and I'm wondering that is it
> possible to configure usage statistics to go in whole different database
> (Oracle too) than our primary customer database (from where authentication
> is searched).
>
Easy -
# configure AuthBy SQL for authentication only
# note empty AccountingTable
<AuthBy SQL>
Identifier SQLAuthOnly
DBSource ....
DBUsername ....
DBAuth ....
AuthSelect ......
AuthColumnDef ....
.....
AccountingTable
</AuthBy>
# configure AuthBy SQL for accounting only
# note empty AuthSelect
<AuthBy SQL>
Identifier SQLAcctOnly
DBSource ....
DBUsername ....
DBAuth ....
AuthSelect
AccountingTable ACCOUNTING
AcctColumnDef ....
.....
</AuthBy>
# configure your Realms or Handlers
# note - accounting must appear before authentication
<Realm ....>
AuthByPolicy ContinueAlways
AuthBy SQLAcctOnly
AuthBy SQLAuthOnly
</Realm>
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
