(RADIATOR) Totalcontrol Manager entries

[Gib Salisbury]

Hello again all,

I'm working on the configuration for using Radiator 3.1 with Total Control 
modem racks.  The problem is that the TC rack is putting several Manager 
entries into my SQL table, so that in a period of a day or two there are 
several thousand bogus accounting entries in my table.  I read through all 
of my documentation and it seems like this is the TC's way of making sure 
that the accounting server is still active, is there any way to have the 
accouting server respond but not place all the entries in the table?  If 
anyone else has encountered anything like this please let me know.

Gib Salisbury
Technician
Quantum Connections, LLC
211 Hilltop Ave
St. Joseph, MI 49085
http://www.qtm.net
Phone (616) or (888) 926-4242 x 215

Radiator Configuration
Top File: /usr/local/etc/raddb/radius.cfg
------------------------------------------------------------------------  
--------

# Radiator configuration file.
# Produced by /~kenreicj/radconfig.cgi Thu Jun 13 12:54:42 2002
#REMOTE_USER: , REMOTE_ADDR: 216.163.33.250

DbDir /raddb
DictionaryFile /raddb/dictionary
LogDir /raddb
LogFile %L\radius
PidFile radius.pid
SnmpgetProg /usr/local/bin/snmpget
RewriteUsername s/^([^@]+).*/$1/
RewriteUsername tr/[A-Z]/[a-z]/
RewriteUsername s/\s+//g
Trace 4
LogStdout

<AuthBy UNIX>
  DefaultSimultaneousUse 1
  Description unix pw auth
  Filename /etc/master.passwd
  GroupFilename /etc/group
  Identifier password
</AuthBy>

<AuthBy FILE>
  DefaultSimultaneousUse 1
  Description users std
  Filename %D/users
  Identifier users
</AuthBy>

<AuthBy FILE>
  DefaultSimultaneousUse 1
  Description tc8 users
  Filename %D/tc8.users
  Identifier tc8users
</AuthBy>

<AuthBy FILE>
  DefaultSimultaneousUse 1
  Description dsl
  Filename %D/dsl.users
  Identifier dslusers
</AuthBy>

<AuthBy FILE>
  DefaultSimultaneousUse 1
  Description x2 user auth
  Filename %D/x2.users
  Identifier x2users	
</AuthBy>

<AuthBy SQL>
  DBSource dbi:mysql:radius
  DBUsername radius
  DBAuth XXXX
  AuthSelect
  Identifier sqlacct
        AcctColumnDef   USERNAME,User-Name
        AcctColumnDef   TIME_STAMP,Timestamp,integer
        AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
        AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
        AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
        AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
        AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
        AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
        AcctColumnDef   ACCTTERMINATECAUSE,Acct-Terminate-Cause
        AcctColumnDef   NASIDENTIFIER,NAS-Identifier
        AcctColumnDef   NASPORT,NAS-Port,integer
	  AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
        AcctColumnDef   CALLINGSTATION,Calling-Station-Id,integer
</AuthBy>

<ClientListSQL>
  DBSource  dbi:mysql:radius
  DBUsername radius
  DBAuth XXXX
</ClientListSQL>

<Log SQL>
  DBSource dbi:mysql:radius
  DBUsername radius
  DBAuth XXXX
</Log>

<StatsLog SQL>
  DBSource	dbi:mysql:radius
  DBUsername	radius
  DBAuth	XXXX
  Interval 86400
</StatsLogSQL>

<Realm realmusers>
  RewriteUsername s/^([^@]+).*/$1/
  AuthByPolicy null
  AuthBy sqlacct
  AuthBy users
  PasswordLogFileName pwd.log
  SessionDatabase
</Realm>

<Realm x2realm>
  RewriteUsername s/^([^@]+).*/$1/
  AuthByPolicy Null
  AuthBy sqlacct
  AuthBy x2users
  PasswordLogFileName pwd.log
  SessionDatabase
</Realm>

<Realm dslrealm>
  RewriteUsername s/^([^@]+).*/$1/
  AuthByPolicy Null
  AuthBy sqlacct
  AuthBy dslusers
  PasswordLogFileName pwd.log
  SessionDatabase
</Realm>

<Realm tc8realm>
  RewriteUsername s/^([^@]+).*/$1/
  AuthByPolicy Null
  AuthBy sqlacct
  AuthBy tc8users
  PasswordLogFileName pwd.log
  SessionDatabase
</Realm>

<SessionDatabase SQL>
  AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, 
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) va  
lues ('%u', '%N', 0%{NAS-Port}, '%{Acct-Session-Id}', %{Timestamp}, 
'%{Framed-IP-Address}', '%{NAS-Port-Type}', '%{Service-Type}')
  ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
  CountNasSessionsQuery select ACCTSESSIONID from RADONLINE where 
NASIDENTIFIER='%N'
  CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE 
where USERNAME='%u'
  DBAuth XXXX
  DBSource dbi:mysql:radius
  DBUsername radius
  DeleteQuery delete from RADONLINE where NASIDENTIFIER='%N' and 
NASPORT=0%{NAS-Port}
  Description Current Session database
  Identifier SessionSQL
</SessionDatabase>

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.