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

[Philip Clever]

Hugh said:

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

Alright, newbie time ;)  How do I know which one is causing the problem?
When we do find out, in what way are we suppose o change it?

TIA

-Philip

----- Original Message -----
From: "Hugh Irvine" <hugh at open.com.au>
To: "Philip Clever" <philip at turquoise.net>; <radiator at open.com.au>
Sent: Wednesday, June 27, 2001 9:35 PM
Subject: Re: (RADIATOR) ERR: do failed for 'insert into Calls


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

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