Bug 1369334

Summary: Freeradius bug in v3.0.4 - duplicate acctuniqueid problem
Product: Red Hat Enterprise Linux 7 Reporter: SHAURYA <sshaurya>
Component: freeradiusAssignee: Nikolai Kondrashov <nikolai.kondrashov>
Status: CLOSED NOTABUG QA Contact: BaseOS QE Security Team <qe-baseos-security>
Severity: medium Docs Contact:
Priority: high    
Version: 7.2CC: pkis
Target Milestone: rc   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-09-28 09:15:41 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

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.