Apache tomcat version 8.5.31
Elasticsearch version 6.2.4 (running as a service)
Java SE runtime environment build 1.8.0_172-b11
Windows Server 2012 R2.
I used lca-collaboration-installer.jar to setup the initial database. I've tried using different types of email addresses and using a password with only lowercase letters to during the setup routine.
I'm reaching the server fine at localhost:8080/lca-collaboration. When I go to login to the server in the web interface I get the error: "Server error, please contact your admin".
Here is some of the output from tomcat:
Caused by: org.apache.derby.iapi.error.StandardException: Column 'DATA_MANAGER' is either not in any table in the FROM list or appears within a join s
pecification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or
ALTER TABLE statement then 'DATA_MANAGER' is not a column in the target table.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) ~[derby-10.14.1.0.jar:?]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1590) ~[org.eclipse.persistence.cor
e-2.7.1.jar:?]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1539) ~[org.eclipse.persistence.cor
e-2.7.1.jar:?]
at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:804) ~[org.eclipse.persistence.core-2.7.1.j
ar:?]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:625) ~[org.eclipse.persistence.core
-2.7.1.jar:?]
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:564) ~[org.eclipse.persistence.core-2.7.
1.jar:?]
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2093) ~[org.eclipse.persistence.core-2.7.1.
jar:?]
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:600) ~[org.eclipse.persistence.core-2.7.1.jar:?]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:270) ~[org.eclipse.pers
istence.core-2.7.1.jar:?]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:256) ~[org.eclipse.pers
istence.core-2.7.1.jar:?]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:327) ~[org.eclips
e.persistence.core-2.7.1.jar:?]
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:722) ~[org.eclipse.pe
rsistence.core-2.7.1.jar:?]
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740) ~[org.eclipse.
persistence.core-2.7.1.jar:?]
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693) ~[org.eclipse.persisten
ce.core-2.7.1.jar:?]
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:563) ~[org.eclipse.persistence.core-2.7.1.jar:?]
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1221) ~[org.eclipse.persistence.core-2.
7.1.jar:?]
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:911) ~[org.eclipse.persistence.core-2.7.1.jar:?]
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1180) ~[org.eclipse.persistence.core-2.7.1.jar:?]
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:464) ~[org.eclipse.persistence.core-2.7.1.jar:?]
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1268) ~[org.eclipse.persistence.core-2.7
.1.jar:?]
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2979) ~[org.eclipse.persistence.core-2.7.
1.jar:?]
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1892) ~[org.eclipse.persistence.core-2.7.1.jar:
?]
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1874) ~[org.eclipse.persistence.core-2.7.1.jar:
?]
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) ~[org.eclipse.persistence.core-2.7.1.jar:
?]
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260) ~[org.eclipse.persistence.jpa-2.7.1.jar:?]
at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:480) ~[org.eclipse.persistence.jpa-2.7.1.jar:?]
at com.greendelta.collaboration.service.Dao.getAll(Dao.java:65) ~[classes/:?]
at com.greendelta.collaboration.service.Dao.getAll(Dao.java:48) ~[classes/:?]
at com.greendelta.collaboration.service.Dao.getForAttributes(Dao.java:120) ~[classes/:?]
at com.greendelta.collaboration.service.Dao.getFirstForAttributes(Dao.java:143) ~[classes/:?]
at com.greendelta.collaboration.service.Dao.getFirstForAttribute(Dao.java:135) ~[classes/:?]
at com.greendelta.collaboration.service.user.UserService.getForUsername(UserService.java:51) ~[classes/:?]
at com.greendelta.collaboration.platform.shiro.JpaRealm.getAccount(JpaRealm.java:55) ~[classes/:?]
at com.greendelta.collaboration.platform.shiro.JpaRealm.doGetAuthenticationInfo(JpaRealm.java:46) ~[classes/:?]
at org.apache.shiro.realm.AuthenticatingRealm.getAuthenticationInfo(AuthenticatingRealm.java:568) ~[shiro-core-1.3.2.jar:1.3.2]
at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doSingleRealmAuthentication(ModularRealmAuthenticator.java:180) ~[shiro-core-1.3.2.jar
:1.3.2]
at org.apache.shiro.authc.pam.ModularRealmAuthenticator.doAuthenticate(ModularRealmAuthenticator.java:267) ~[shiro-core-1.3.2.jar:1.3.2]
at org.apache.shiro.authc.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:198) ~[shiro-core-1.3.2.jar:1.3.2]
... 71 more
Thanks,
Matt
P.S. for what it's worth I never did get it to run right using tomcat version 9.0.8 and java 10.0.1. Kept getting errors about not being able to access the database.