We are running Alfresco Alfresco Enterprise v4.2.6 ans our authentication is Kerberos sso, the autenthication is failing for a few user and what we get on the log files is below, Could you help me with this...Thanks

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

oscar_2016

2017-09-18 10:04:44,276  DEBUG [app.servlet.KerberosAuthenticationFilter] [http-apr-8888-exec-19] New Kerberos auth request from 142.139.121.130 (142.139.121.130:57352)
 2017-09-18 10:04:44,276  DEBUG [app.servlet.KerberosAuthenticationFilter] [http-apr-8888-exec-19] Issuing login challenge to browser.
 Search Subject for Kerberos V5 ACCEPT cred (HTTP/alfresco.gnb.ca@GNB.CA, sun.security.jgss.krb5.Krb5AcceptCredential)
2017-09-18 10:04:44,307  DEBUG [app.servlet.KerberosAuthenticationFilter] [http-apr-8888-exec-9] New Kerberos auth request from 142.139.121.130 (142.139.121.130:57354)
 2017-09-18 10:04:44,307  DEBUG [app.servlet.KerberosAuthenticationFilter] [http-apr-8888-exec-9] Issuing login challenge to browser.
 Search Subject for Kerberos V5 ACCEPT cred (HTTP/alfresco.gnb.ca@GNB.CA, sun.security.jgss.krb5.Krb5AcceptCredential)
2017-09-18 10:05:25,990  DEBUG [app.servlet.KerberosAuthenticationFilter] [http-apr-8888-exec-11] Kerberos logon error
 org.springframework.dao.DuplicateKeyException:
### Error updating database.  Cause: java.sql.SQLException: Cannot insert duplicate key row in object 'dbo.alf_auth_status' with unique index 'idx_alf_auth_usr_stat'. The duplicate key value is (ChrisBr, 1).
### The error may involve alfresco.authorization.parameter_AuthorizationEntity
### The error occurred while setting parameters
### Cause: java.sql.SQLException: Cannot insert duplicate key row in object 'dbo.alf_auth_status' with unique index 'idx_alf_auth_usr_stat'. The duplicate key value is (ChrisBr, 1).
; SQL []; Cannot insert duplicate key row in object 'dbo.alf_auth_status' with unique index 'idx_alf_auth_usr_stat'. The duplicate key value is (ChrisBr, 1).; nested exception is java.sql.SQLException: Cannot insert duplicate key row in object 'dbo.alf_auth_status' with unique index 'idx_alf_auth_usr_stat'. The duplicate key value is (ChrisBr, 1).
 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)

gluck113

Hi Oscar,

I have the same issue error in my logs, but without Kerberos and when a user that has been imported from the LDAP want's to login.

Did you solve your issue?