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?

Getting started

Explore our Alfresco products with the links below. Use labels to filter content by product module.