Hello Andrew -
The errors you show below are due to a unique index violation on the database
table in question. You will have to change the indexing to allow the insert,
or change the query to use a unique value.
hth
Hugh
On Friday 27 July 2001 08:39, Andrew Kaplan wrote:
> 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 [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
