Sample TCCRadius.cfg Files - ODBC Mode

Sample Config File For ODBC MODE

# Configuration Information For TCCRadius
# Copyright 1999, Talon Computer Consulting, Inc.
#
# All Lines with a "#" are ignored.

## Start Server/Socket Information Section

# IP Address defaults to the first IP
# on the Ethernet Interface - Remove the # sign
# to specify an address.
# IPAddress = 192.168.0.1

# Auth And Accounting Ports For RFC 2138/2139
# Auth = 1812
# Acct = 1813

# Auth And Accounting Ports For RFC 2058/2059
Auth = 1645
Acct = 1646

## End Server/Socket Information Section
#########################################

## Start Logging Section

# Log File Information
LogFilePath = .\log
LogExtension = .log

# Auth Log Attributes ',' delimited
LogAttributes = 8,30,31

# Acct Summary Log Attributes ',' delimited
LogSummaryAttributes = 44,46,47,48

## End Logging Section
#########################################

## Start Authentication Section

# Configuration Options
# Available Options: Text, ODBC, NTSAM, NTSAM_ODBC
UserOption = ODBC

# Modules
EnablePools = No
LocalRealmSupport = No

# RealmModule
TruncateRealms = No

# User File Information For Text Mode
# Location of User Account Files
UserPath = .\users

# ODBC User File Information
# System DSN Information For ODBC
# (username and password optional)
DSN = TCCRadius
#DSNUser = testuser
#DSNPass = testpass
#DSNDBase = TCCRadius

# ODBC/SQL Information Authentication Information
# All fields must be in the same table
Table = UserInfo
UsernameField = Username
PasswordField = Password
AttributesField = Attributes

## End Authentication Section
#########################################

## Start ODBC Accounting Section

## ODBC Accounting Setup Information
## Can be Text, ODBC, or Both
AcctLogging = Text
AcctODBCTable = Accounting
AcctDSN = TCCRadius
#AcctDSNUser = testuser
#AcctDSNPass = testpass

## Attributes to Log and Field Names
## 1 = Username
## 4 = NAS IP Address
## 5 = NAS Port Number
## 8 = Framed IP Address (User)
## 31 = Calling-Station-ID
## 40 = Acct-Status-Type (START,STOP)
## 41 = Acct-Delay-Time
## 42 = Acct-Input-Octets
## 43 = Acct-Output-Octets
## 44 = Acct-Session-ID
## 45 = Acct-Authentic
## 46 = Acct-Session-Time
## 47 = Acct-Input-Packets
## 48 = Acct-Output-Packets
## 49 = Acct-Terminate-Cause
## 50 = Acct-Multi-Session-ID
## 51 = Acct-Link-Count
## TS = TimeStamp (Date/Time)

AcctODBCAttributes = TS,4,5,1,8,44,46,47,48,40,41,42,43,45,49,50,51,31

AFN-4 = NASID
AFN-5 = NASPort
AFN-1 = Username
AFN-8 = FramedIPAddress
AFN-31 = CallingStationID

AFN-40 = AcctStatusType
AFN-41 = AcctDelayTime
AFN-42 = AcctInputOctets
AFN-43 = AcctOutputOctets
AFN-44 = AcctSessionID
AFN-45 = AcctAuthentic
AFN-46 = AcctSessionTime
AFN-47 = AcctInputPackets
AFN-48 = AcctOutputPackets
AFN-49 = AcctTerminateCause
AFN-50 = AcctMultiSessionId
AFN-51 = AcctLinkCount
AFN-TS = TS

## End ODBC Accounting Section
#########################################

# END CONFIG FILE