Hello Paul -
The error is a MySQL error which is complaining about a duplicate entry for a unique key.
The unique key for the RADONLINE table is the combination of the NAS-Identifier and NAS-Port which is what Radiator bases its session database and simultaneous use checking on - the assumption being that there are unique ports on each NAS.
The theory behind Radiator's use of the session database is that every NAS is uniquely identified by the NAS-Identifier and every port on every NAS is also uniquely identified by the NAS-Port attribute. When Radiator receives an access request, it performs a delete on the session database using the NAS-Identifier and NAS-Port combination as preventative maintenance in case we have missed an accounting stop for the port in question. When Radiator receives an accounting start a new record is inserted into the session database and when an accounting stop is received the record is removed.
Obviously if in your situation the NAS-Identifier + NAS-Port combination is not unique, you will have a problem with the session database (and it will be impossible to enforce simultaneous use limits).
regards
Hugh
On Friday, Jul 25, 2003, at 11:49 Australia/Melbourne, Paul wrote:
Hi All,
We are using Radiator 3.6 with latest patches but we are seeing an issue
when a new session is added. We're getting Duplicate key which appears to be
coming from the internal handler code rather than MySQL itself. Below is the
error when it occurs. We've modified our "delete from RADONLINE" query to
match the details more accurately and we don't appear to be having any
problems with this, it's just "Adding session for %s" is where it seems to
go astray.
Thu Jul 24 20:57:37 2003: DEBUG: Adding session for [EMAIL PROTECTED], 1.2.3.4, 6256
Thu Jul 24 20:57:37 2003: DEBUG: do query is: 'delete from RADONLINE where
NASIDENTIFIER='1.2.3.4' and NASPORT=6256 and ACCTSESSIONID = '00062398'':
Thu Jul 24 20:57:37 2003: DEBUG: do query is: 'INSERT INTO RADONLINE
(USERNAME, NASIDENTIFIER, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
NASPORT, NASPORTTYPE, SERVICETYPE, DNIS, PHONENO, SESSIONKEY,
ACCTSESSIONTIME, INPUTOCTETS, OUTPUTOCTETS, POPID,targetid, DOWNLOADRATE,
UPLOADRATE, ORIGUSER)
VALUES('myuser','1.2.3.4','00062398','1059044257','5.6.7.8','6256','Asy nc','
Framed-User','0312345678','03912345678', '6F419DF2',
'2185','346903','2410144','61', '15', '45333', '26400', '[EMAIL PROTECTED]')':
Thu Jul 24 20:57:37 2003: ERR: do failed for 'INSERT INTO RADONLINE
(USERNAME, NASIDENTIFIER, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
NASPORT, NASPORTTYPE, SERVICETYPE, DNIS, PHONENO, SESSIONKEY,
ACCTSESSIONTIME, INPUTOCTETS, OUTPUTOCTETS, POPID, targetid, DOWNLOADRATE,
UPLOADRATE, ORIGUSER)
VALUES('myuser','1.2.3.4','00062398','1059044257','5.6.7.8','6256','Asy nc','
Framed-User','0312345678','03912345678', '6F419DF2',
'2185','346903','2410144','61', '15', '45333', '26400', '[EMAIL PROTECTED]')':
Duplicate entry '1.2.3.4-6256' for key 1
If you have any ideas that'd be great. Thanks
Regards,
Paul Rivoli [EMAIL PROTECTED] K B S I N T E R N E T
=== 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.
NB: have you included a copy of your configuration file (no secrets), together with a trace 4 debug showing what is happening?
-- 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.
