(RADIATOR) random contect problems

[Andrew Kaplan]

I'm still having randon connect problems with my Total Control Server. I
suspect that's perhaps Radiator is having issues. The radiator is filled
with the following:


DBD::mysql::dgb do failed: Duplicate entry "63.112.159.254-526' for key 1 at
/usr/local/lib/site_perl/Radius/SqlDb.pm line 247. DBD::mysql::dgb do
failed: Duplicate entry "63.112.159.254-1290' for key 1 at
/usr/local/lib/site_perl/Radius/SqlDb.pm line 247. DBD::mysql::dgb do
failed: Duplicate entry "63.112.159.254-1289' for key 1 at
/usr/local/lib/site_perl/Radius/SqlDb.pm line 247.


Below is my radius.cfg. I have made no changes to SqlDb.pm


Trace 4

AuthPort	1645
AcctPort	1646
LogDir		/usr/local/radius/log
# The line below was remmed out 11/7/00 in efforts to turn logging ON!
#LogFile
DbDir		/usr/local/radius/raddb
DictionaryFile	/usr/local/radius/dictionary.ascend
PidFile		/var/run/radiusd.pid

#<SNMPAgent>
#	Community TeekieUptiC
#</SNMPAgent>

RewriteUsername        tr/[A-Z]/[a-z]/

#the following will strip out the realms
RewriteUsername        s/^([^@]+).*/$1/


<Client	63.112.159.252>
	Secret	XXXXX
	NasType	TotalControlSNMP
	SNMPCommunity	xxx
</Client>


<Client	63.112.159.254>
	Secret	XXXXX
	NasType	TotalControlSNMP
	SNMPCommunity	XXX
</Client>

# added second HiPer ARC 2-20-01
<Client 63.112.157.254>
        Secret  XXXXX
        NasType TotalControlSNMP
        SNMPCommunity   XXX
</Client>


# added to run radpwtst 2-27-01
<Client 63.237.136.8>
        Secret  XXXXX
        NasType TotalControlSNMP
        SNMPCommunity   XXX
</Client>


<Client 63.237.136.2>
	Secret	XXXXX
	NasType	TotalControlSNMP
	SNMPCommunity	XXX
</Client>
<Client 209.206.60.133>
	Secret XXXX
</Client>
#test for ntplex
<Client 204.213.176.6>
	Secret XXXXX
</Client>
<Client 204.213.176.7>
	Secret XXXXX
</Client>
<Client 204.213.179.30>
	Secret XXXXX
</Client>
<Client 204.213.176.152>
	Secret XXXXX
	IgnoreAcctSignature
</Client>


#added 6/01/01
<Client 216.126.128.9>
	Secret XXXXX
</Client>

#added 6/07/01
<Client 216.126.128.10>
	Secret XXXXX
</Client>




# MegaPop Radius Servers
<Client 204.178.185.222>
	Secret XXXXX
</Client>
<Client	204.178.185.3>
	Secret XXXXX
</Client>
<Client 204.178.185.221>
	Secret XXXXX
</Client>
<Client	204.178.185.220>
	Secret XXXXX
</Client>
<Client 204.178.185.218>
	Secret XXXXX
</Client>
<Client	204.178.185.219>
	Secret XXXXX
</Client>
<Client 216.126.128.8>
	Secret XXXXX
</Client>
# End of MegaPop Servers
<Client 63.237.136.100>
	Secret testing123
</Client>

<Client 127.0.0.1>
	Secret testing123
	DupInterval 0
</Client>

<Realm DEFAULT>
#	AuthByPolicy ContinueUntilAccept

	AcctLogFileName %L/%Y/%m/%d-details
        <AuthBy RODOPI>
                DBSource        dbi:Sybase:server=AbacBill
                DBUsername      rodopi
                DBAuth          rodopi
        </AuthBy>

	<AuthBy FILE>
		Filename /etc/acctmgr/users
	</AuthBy>
</Realm>


<Realm cshore.com>
#	AuthByPolicy ContinueUntilAccept

	AcctLogFileName %L/%Y/%m/%d-details
        <AuthBy RODOPI>
                DBSource        dbi:Sybase:server=AbacBill
                DBUsername      rodopi
                DBAuth          rodopi
        </AuthBy>

	<AuthBy FILE>
		Filename /etc/acctmgr/users
	</AuthBy>
</Realm>


<SessionDatabase SQL>
	DBSource dbi:mysql:Radius
	DBUsername Radius
	DBAuth KnubbyDo
	AddQuery \
		insert into Sessions (UserName, NASIdent, NASPort, \
		SessionID, TimeStamp, FramedIPAddress, NASPortType, \
		ServiceType) values ('%n', '%N', %{NAS-Port}, \
		'%{Acct-Session-Id}', %{Timestamp}, '%{Framed-Address}', \
		'%{NAS-Port-Type}', '%{Service-Type}')
        DeleteQuery \
		delete from Sessions where Username='%n' and \
	NASIdent='%N' and NASPort=%{NAS-Port}
       ClearNasQuery \
		delete from Sessions where NASIdent='%N'
        CountQuery \
		select NASIdent, NASPort, SessionID from Sessions \
		where Username='%n'
</SessionDatabase>

++++++++++++++++++++++++++++++++++++++



Andrew P. Kaplan
Network Administrator
CyberShore, Inc. -- Premium Internet Services -- http://www.cshore.com

"Outlook not so good"
That magic 8-ball knows everything, next I'll ask it about Exchange Server.


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