Hi Fernando.
On May 21, 6:49pm, Fernando Martin wrote:
> Subject: (RADIATOR) Accounting by MS SQL 6.5/7.0
> Hi all,
>
> I have my Radiator 3.12.1 running properly over NT 4.0 SP3.
> I am using a flat text File for authentification named users.
>
> So my realm is like this:
>
> <Realm DEFAULT>
> PasswordLogFileName %L/%d-%m-%y-password.log
> <AuthBy FILE>
> FramedGroup 0
> Filename %D/users
> </AuthBy>
> AcctLogFileFormat %t %d %m %Y %n %a %{Acct-Status-Type}
> %{Called-Station-Id} %{NAS-Port} %{Acct-Input-Octets} %{Acct-Output-Octets}
> %{Connect-Rate} %{Connect-Info}
> </Realm>
>
> Now I want to make accounting using Microsoft SQL 6.5.
>
> I have read the manual but I have some questions:
>
> 1- Really could I have authentification by "users" file, a flat text file
> and accounting by MS SQL? or do I need to have both by MS SQL?
You can have auth from flat file and accounting to MS-SQL if you want. No
problem.
> 2- How could I do that? What is the right realm?
You need to chain your AuthBy FILE with an AuthBy SQL set up to do just
accounting. If you set AuthSelect to the empty string and Set AccountingTable
and some AcctColumnDef, AuthBy SQL will only do accounting, something like
this:
<Realm DEFAULT>
PasswordLogFileName %L/%d-%m-%y-password.log
AuthByPolicy ContinueAlways
<AuthBy SQL>
# This disables auth
AuthSelect
# This enables accounting
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
# etc....
</AuthBy>
<AuthBy FILE>
FramedGroup 0
Filename %D/users
</AuthBy>
AcctLogFileFormat %t %d %m %Y %n %a %{Acct-Status-Type}
%{Called-Station-Id} %{NAS-Port} %{Acct-Input-Octets} %{Acct-Output-Octets}
%{Connect-Rate} %{Connect-Info}
</Realm>
> ....
> ???
> DBSource dbi:ODBC:dsnname?
> DBUsername loginuser
> DBAuth pass
>
> ???
> ....
>
> I know that I need to install de DBM and DBI, and also SQL and the DSN to
> connect it.
Yes,
> Then I need to define AccountingTable and AcctColumnDef with the information
> that I need to store into.
Yes
>
>
> 3- In the case that accouting and Authentification could not be possible to
> do with different method, Could I use <Log SQL> but defining the short
> information that I want to store, no using trace 4 with all this
> information? How?
>
> I hope some one could help me.
>
> Thanks for your help and time.
Hope that helps.
Cheers.
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
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.
