AnsweredAssumed Answered

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

Question asked by oscar_2016 on Sep 18, 2017
Latest reply on Jun 21, 2018 by gluck113

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)

Outcomes