(RADIATOR) ERR: do failed for 'insert into Calls

[Hugh Irvine]

Hello Philip -

This is a problem with the indexes on your database, not with the 
Total Control. The database is refusing to insert a record into the 
"Calls" table because a unique index is being violated. You will need 
to check the indexes and change whichever one is causing the problem.

At 5:11 PM -1000 6/27/01, Philip Clever wrote:
>Hello,
>
>We are trying to toubleshoot a couple of problems.
>
>#1. We keep getting these error messages (below).  We looked through the
>archives and went ahead and set the retransmission timeout on our Total
>Control 1000 from 3 to 20 seconds.
>
>>From error log:
><snip>
>Wed Jun 27 16:34:18 2001: ERR: do failed for 'insert into Calls
>                 (UserName, CallDate, AcctStatusType, AcctInputOctets,
>AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPort,
>CallFromId)
>                 values
>                 ('unauthenticated', 'Jun 27, 2001 16:34', 2, 0, 0,
>'33554457', 51, '63.72.207.3', 513, '8083238406')': [OpenLink][ODBC][SQL
>Server]Violation of UNIQUE KEY constraint 'UNQ_Calls': Attempt to insert
>duplicate key in object 'Calls'. (SQL-S1000)(DBD: st_execute/SQLExecute
>err=-1)
>Wed Jun 27 16:34:21 2001: ERR: do failed for 'insert into Calls
>                 (UserName, CallDate, AcctStatusType, AcctInputOctets,
>AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPort,
>CallFromId)
>                 values
>                 ('unauthenticated', 'Jun 27, 2001 16:34', 2, 0, 0,
>'33619980', 39, '63.72.207.3', 514, '8089595681')': [OpenLink][ODBC][SQL
>Server]Violation of UNIQUE KEY constraint 'UNQ_Calls': Attempt to insert
>duplicate key in object 'Calls'. (SQL-S1000)(DBD: st_execute/SQLExecute
>err=-1)
>Wed Jun 27 16:35:19 2001: ERR: do failed for 'insert into Calls
>                 (UserName, CallDate, AcctStatusType, AcctInputOctets,
>AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPort,
>CallFromId)
>                 values
>                 ('unauthenticated', 'Jun 27, 2001 16:35', 2, 0, 0,
>'50397207', 4, '63.72.207.3', 770, '8088895755')': [OpenLink][ODBC][SQL
>Server]Violation of UNIQUE KEY constraint 'UNQ_Calls': Attempt to insert
>duplicate key in object 'Calls'. (SQL-S1000)(DBD: st_execute/SQLExecute
>err=-1)
>Wed Jun 27 16:35:31 2001: ERR: do failed for 'insert into Calls
>                 (UserName, CallDate, AcctStatusType, AcctInputOctets,
>AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPort,
>CallFromId)
>                 values
>                 ('unauthenticated', 'Jun 27, 2001 16:35', 2, 0, 0,
>'17956887', 51, '63.72.207.3', 275, '8083238406')': [OpenLink][ODBC][SQL
>Server]Violation of UNIQUE KEY constraint 'UNQ_Calls': Attempt to insert
>duplicate key in object 'Calls'. (SQL-S1000)(DBD: st_execute/SQLExecute
>err=-1)
>Wed Jun 27 16:36:44 2001: ERR: do failed for 'insert into Calls
>                 (UserName, CallDate, AcctStatusType, AcctInputOctets,
>AcctOutputOctets, AcctSessionId, AcctSessionTime, NASIdentifier, NASPort,
>CallFromId)
>                 values
>                 ('unauthenticated', 'Jun 27, 2001 16:36', 2, 0, 0,
>'51380239', 51, '63.72.207.3', 785, '8083238406')': [OpenLink][ODBC][SQL
>Server]Violation of UNIQUE KEY constraint 'UNQ_Calls': Attempt to insert
>duplicate key in object 'Calls'. (SQL-S1000)(DBD: st_execute/SQLExecute
>err=-1)
></snip>
>
>Besides 'unauthenticated' we get actual usernames as well but they aren't
>necessarily online which sems really weird.  They don't show up on the
>pass/fail logs, users online,  nor do they show up on the Total control
>failure log either.
>
>Problem #2. Our radwho.cgi seems to be working with the exception that the
>iPass logons do not go away.  We have one that is over 100 days old.
>
>Any ideas?
>

The only reason that this happens is if you do not receive an 
Accounting Stop record for the session. You can also remove the stale 
sessions by hand.

regards

Hugh

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.