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

[Hugh Irvine]

Hello Philip -

You will need to use the MS-SQL administration tool to check the 
table definitions for the database. That will tell you what indexes 
are present on which tables. Then you will be able to look at the 
contents of that table to see which value in the query below is 
causing the problem. Then you can decide what to do with the index.

BTW - Mike checked his installation of Platypus and didn't find any 
unique indexes, so we are a bit puzzled as to why you have such an 
index in your database.

hth

Hugh


At 10:34 AM -1000 6/28/01, Philip Clever wrote:
>Hi we're getting this error message in our logs:
>
>Thu Jun 28 10:28:52 2001: ERR: do failed for 'insert into RADONLINE
>(USERNAME,NASPORT,ACCTSESSIONID,TIME_STAMP,FRAMEDIPADDRESS,NASPORTTYPE,SERVI
>CETYPE,NASNAME,USRCONNECTSPEED,CALLFROMID,USRMODULATIONTYPE,USRCHASSISCALLSL
>OT,USRCHASSISCALLCHANNEL) values
>('blahblah','X.X.X.X',789,'51642386',993760132,'X.X.X.X','Async','Framed-Use
>r','','','','','')': Duplicate entry '63' for key 1
>
>I've run an ISAMCHK on the radonline table but it didn't help.  Any ideas?
>
>-Philip
>
>
>
>===
>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.

-- 

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.