-
Bug
-
Resolution: Fixed
-
Major
-
None
-
None
-
None
With hight security level, the table USERS_FORMCONNECTIONFAILED should be used.
But when the SQL table USERS_FORMCONNECTIONFAILED does not exists, it is not created and throw the following error :
Category: org.ametys.plugins.core.impl.authentication.FormCredentialProvider Message: Error during the connection to the database Location: org.ametys.plugins.core.impl.authentication.FormCredentialProvider._deleteAllPastLoginFailedBDD(FormCredentialProvider.java:573) Thrown: java.sql.SQLSyntaxErrorException: Table/View 'USERS_FORMCONNECTIONFAILED' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:293) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:293) at org.ametys.plugins.core.impl.authentication.FormCredentialProvider._deleteAllPastLoginFailedBDD(FormCredentialProvider.java:565) at org.ametys.plugins.core.impl.authentication.FormCredentialProvider.requestNbConnectBDD(FormCredentialProvider.java:592) at org.ametys.plugins.core.impl.authentication.FormCredentialProvider._getUserIdentityFromRequest(FormCredentialProvider.java:408) at org.ametys.plugins.core.impl.authentication.FormCredentialProvider.blockingGetUserIdentity(FormCredentialProvider.java:342) at org.ametys.core.authentication.CredentialProvider.getUserIdentity(CredentialProvider.java:130) at org.ametys.core.authentication.AuthenticateAction._doProcess(AuthenticateAction.java:555) at org.ametys.core.authentication.AuthenticateAction._process(AuthenticateAction.java:523) at org.ametys.core.authentication.AuthenticateAction.act(AuthenticateAction.java:204) at org.ametys.runtime.workspaces.admin.authentication.AdminAuthenticateAction.act(AdminAuthenticateAction.java:67)
