[KYLIN-3531] Login failed with case-insensitive username

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v2.4.0
• Fix Version/s: v2.5.1
• Component/s: Metadata
• Assignee: Yichen Zhou
• Reporter: Yichen Zhou
• Created: 04/Sep/18 06:05
• Updated: 16/Sep/19 06:51
• Resolved: 27/Sep/18 09:17

Description

Username is case-insensitive in login authentication but case-sensitive in hbase metadata.  

org.apache.kylin.common.persistence.WriteConflictException: Overwriting conflict /user/Admin, expect old TS 1536031295060, but it is 0
 org.apache.kylin.storage.hbase.HBaseResourceStore.checkAndPutResourceImpl(HBaseResourceStore.java:325)
 org.apache.kylin.common.persistence.ResourceStore.checkAndPutResourceCheckpoint(ResourceStore.java:323)
 org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:308)
 org.apache.kylin.common.persistence.ResourceStore.putResource(ResourceStore.java:287)
 org.apache.kylin.metadata.cachesync.CachedCrudAssist.save(CachedCrudAssist.java:192)
 org.apache.kylin.rest.security.KylinUserManager.update(KylinUserManager.java:122)
 org.apache.kylin.rest.service.KylinUserService.updateUser(KylinUserService.java:85)
 org.apache.kylin.rest.security.KylinAuthenticationProvider.authenticate(KylinAuthenticationProvider.java:117)
 org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:174)
 org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:199)
 org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:180)
 org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Issue Links

• causes: KYLIN-4144 Cannot update user's info because of case-sensitive process
• relates to: KYLIN-4103 Make the user string in granting operation of project is case insensitive
• links to: GitHub Pull Request #235