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.
