Bug 1369334 - Freeradius bug in v3.0.4 - duplicate acctuniqueid problem
Summary: Freeradius bug in v3.0.4 - duplicate acctuniqueid problem
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Red Hat Enterprise Linux 7
Classification: Red Hat
Component: freeradius
Version: 7.2
Hardware: x86_64
OS: Linux
high
medium
Target Milestone: rc
: ---
Assignee: Nikolai Kondrashov
QA Contact: BaseOS QE Security Team
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-08-23 07:35 UTC by SHAURYA
Modified: 2019-12-16 06:27 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-09-28 09:15:41 UTC
Target Upstream Version:

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

Description SHAURYA 2016-08-23 07:35:59 UTC 
Description of problem: After installing radius v3.0.4,following errors in our radius.log file

Tue Aug 16 10:26:45 2016 : Error: rlm_sql (sql): Duplicate entry 'af8faf1e25565bcd0c455eebac43c453' for key 'acctuniqueid'
Tue Aug 16 10:26:45 2016 : Error: rlm_sql_mysql: Cannot store result
Tue Aug 16 10:26:45 2016 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry 'af8faf1e25565bcd0c455eebac43c453' for key 'acctuniqueid''


freeradius developer (Alan DeKok) indicates:

http://lists.freeradius.org/pipermail/freeradius-users/2015-October/080546.html

> 6)
> 
> 
> Tue Oct 27 22:37:09 2015 : Error: rlm_sql (sql): Duplicate entry
> '30a1ada7fbf7328ec740200d6042f02b' for key 'acctuniqueid'
> Tue Oct 27 22:37:09 2015 : Error: rlm_sql_mysql: Cannot store result Tue Oct
> 27 22:37:09 2015 : Error: rlm_sql_mysql: MySQL error 'Duplicate entry
> '30a1ada7fbf7328ec740200d6042f02b' for key 'acctuniqueid''

  3.0.10 has updates to the queries which work around this issue.


Version-Release number of selected component (if applicable): 

freeradius-3.0.4-6.el7


How reproducible: Everytime


Steps to Reproduce: Not sure, Just install freeradius on rhel 7.2 and the error appears after som etime in radius.log file

Actual results: Error in radius.log file


Expected results: No error should come for Error: rlm_sql_mysql: MySQL error 'Duplicate entry
'30a1ada7fbf7328ec740200d6042f02b' for key 'acctuniqueid''


Additional info:
Comment 4 Nikolai Kondrashov 2016-08-23 13:02:29 UTC 
This seems to be fixed by https://github.com/FreeRADIUS/freeradius-server/commit/4cc1462780687a2cc0e949947e9f76830d97a063 and https://github.com/FreeRADIUS/freeradius-server/commit/ed971982f35855fd54398b484e81e1d7b495c316 included into v3.0.9 release. However, testing is needed for confirmation.
Note You need to log in before you can comment on or make changes to this bug.