cancel
Showing results for 
Search instead for 
Did you mean: 

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

oscar_2016
Champ in-the-making
Champ in-the-making

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)

1 REPLY 1

gluck113
Star Contributor
Star Contributor

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?