Hi Michael,

On Jul 9, 10:37am, Michael Gatti wrote:
> Subject: (RADIATOR) Accounting do Database via ODBC
>
> Ladies & Gentilmen:
>
> I'm trying to do something here that I'm not sure that it could work. I have
radiator working just fine here at my ISP and know I what to implement some new
functions to him. I'm trying to make radiator send the accounting information
to a Data Base (very simple one - Access) via an ODBC driver and still create
the accounting log files. bellow is my CONFIG FILE, I know it my be very wierd,
but that's why I'm asking for some help. When I run he command line:
> c:\> perl radiusd -confi_file=maxntdb.cfg I receive a lot of:

The basic problem with that config file, is that you are using = sign between
the parameters and arguments:

Identifier=NTSystem
should be
Identifier      NTSystem

>
> Sat Jul 10 10:28:45 1999: ERR: Unknown keyword 'Identifier=NTSystem' in
maxntdb.cfg line 39
> Sat Jul 10 10:28:45 1999: ERR: Unknown keyword 'Auth-Type=System' in
maxntdb.cfg line 40

That one does not belong here at all.


Here is how I think you should set it up:

<Realm DEFAULT>
# Limit all users in this realm to max of 1 session
 MaxSessions     1

 # Send accounting only to SQL
 <AuthBy SQL>
         # No authentication
         AuthSelect

         # Connect to ODBC on localhost
         DBSource  dbi:Acessos:localhost
         # Heres how you can convert Timestamps into a format that Oracle likes
         AcctColumnDef   TIME_STAMP,Timestamp,formatted-date,to_date('%e %m %Y
%H:%M:%S', 'DD MM YYYY HH24:MI:SS')
         # AcctColumnDef COLUMN,Attribute[,type][,format]
         AcctColumnDef   SessionID,Acct-Session-Id
         AcctColumnDef  TIME_STAMP,Timestamp
         AcctColumnDef  StatusType,Acct-Status-Type
         AcctColumnDef  UserName,User-Name
         AcctColumnDef  SessionTime,Acct-Session-Time,integer
# Store accounting records in Acessos
        AccountingTable    Acessos
 </AuthBy>

 # Now authenticate from NT
 <AuthBy NT>
         Domain mydomain
         DomainController       hostname
 </AuthBy>

# Log all accounting into daily log files in LogDir
 AcctLogFileName=%L\%Y%m%d.act

</Realm>


Hope that helps.

Cheers.

> Sat Jul 10 10:28:45 1999: ERR: Unknown keyword 'Domain=mydomain' in
maxntdb.cfg line 41
> Sat Jul 10 10:28:45 1999: ERR: Unknown keyword 'DomainController=hostname' in
maxntdb.cfg line 42
> Sat Jul 10 10:28:45 1999: ERR: Unknown keyword
'AcctLogFileName=%L\%Y%m%d.act' in maxntdb.cfg line 44
> Sat Jul 10 10:28:45 1999: ERR: Unknown keyword
'DBSource=dbi:Acessos:localhost' in maxntdb.cfg line 46
> Sat Jul 10 10:28:45 1999: ERR: Unknown keyword
'AcctColumnDef=TIME_STAMP,Timestamp,formatted-date,to_date('%e' in maxntdb.cfg
line 48
> Sat Jul 10 10:28:46 1999: ERR: Unknown keyword
'AcctColumnDef=SessionID,Acct-Session-Id' in maxntdb.cfg line 50
> Sat Jul 10 10:28:46 1999: ERR: Unknown keyword
'AcctColumnDef=TIME_STAMP,Timestamp' in maxntdb.cfg line 51
> Sat Jul 10 10:28:46 1999: ERR: Unknown keyword
'AcctColumnDef=StatusType,Acct-Status-Type' in maxntdb.cfg line 52
> Sat Jul 10 10:28:46 1999: ERR: Unknown keyword
'AcctColumnDef=UserName,User-Name' in maxntdb.cfg line 53
> Sat Jul 10 10:28:46 1999: ERR: Unknown keyword
'AcctColumnDef=SessionTime,Acct-Session-Time,integer' in maxntdb.cfg line 54
> Sat Jul 10 10:28:46 1999: ERR: Unknown keyword 'AccountingTable=Acessos' in
maxntdb.cfg line 56
> Sat Jul 10 10:28:47 1999: INFO: Server started
>
> ->> CONFIG FILE
>
>
>
> # maxntdb.cfg
>
> Foreground
> LogStdout
> Trace           5
> AuthPort        1645
> AcctPort        1646
> LogDir          c:\radiator\malbanet\log
> LogFile         %L\%Y%m%d.log
> DbDir           C:\winnt\profiles\administrator\personal
> DictionaryFile  %D\dictionary.nt
>
> # You will probably want to change this to suit your site.
>
> <Client localhost>
>  Secret  mysecret
>  DupInterval 0
> </Client>
>
> <Client XXX.YYY.ZZZ.xxx>
>  Secret  mysecret
>  DupInterval 0
> </Client>
>
> <Client XXX.YYY.ZZZ.xxx>
>  Secret  mysecret
>  DupInterval 0
> </Client>
>
> <Client XXX.YYY.ZZZ.xxx>
>  Secret  mysecret
>  DupInterval 0
> </Client>
>
> <Realm DEFAULT>
> # Limit all users in this realm to max of 1 session
>  MaxSessions     1
>  <AuthBy NT>
>  Identifier=NTSystem
>  Auth-Type=System
>  Domain=mydomain
>  DomainController=hostname
> # Log all accounting into daily log files in LogDir
>  AcctLogFileName=%L\%Y%m%d.act
> # Connect to ODBC on localhost
>  DBSource=dbi:Acessos:localhost
> # Heres how you can convert Timestamps into a format that Oracle likes
>  AcctColumnDef=TIME_STAMP,Timestamp,formatted-date,to_date('%e %m %Y
%H:%M:%S', 'DD MM YYYY HH24:MI:SS')
> # AcctColumnDef COLUMN,Attribute[,type][,format]
>  AcctColumnDef=SessionID,Acct-Session-Id
>  AcctColumnDef=TIME_STAMP,Timestamp
>  AcctColumnDef=StatusType,Acct-Status-Type
>  AcctColumnDef=UserName,User-Name
>  AcctColumnDef=SessionTime,Acct-Session-Time,integer
> # Store accounting records in Acessos
>  AccountingTable=Acessos
>  </AuthBy>
> </Realm>
>
> [ Attachment (text/x-html): 6192 bytes
>   Character set: iso-8859-1
>   Encoded with "quoted-printable" ]
>-- End of excerpt from Michael Gatti



-- 
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.

Reply via email to