Ask a Question

Admin login for new server setup not working

+2 votes
10.9k views

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.

in LCA Collaboration Server by (5.3k points)
recategorized by
by (5.3k points)
I forgot to mention that I'm running this on Windows Server 2012 R2.
by (23.7k points)
I added this to your question. You can alway edit and improve the accuracy and informational value of your question at any time.

1 Answer

+2 votes
by (8.9k points)
selected by
 
Best answer
It seems that you have a previous version of the installer, because a field that was added shortly before the release candidate build is missing in the database schema. It was updated very soon after the initial upload. I checked the current version of the installer and it contains the correct schema. Can you download it again and rerun the installation to see if that solves it?

You were downloading it from the provided link at share.greendelta.com, correct?
by (5.3k points)
I did. I downloaded it when the link was first sent out (April 13). Looks like it was updated after that. Looks like everything is running fine now.
Based on Snow Theme - Modified by GreenDelta
Powered by Question2Answer
...