Tweet
Experiencing same difficulty running most recent version of Mirth on two desktop PCs running Windows XP Professional 2002; have the same version of Mirth successfully running on an IBM laptop also running Windows XP Professional 2002. All installs using default database, ports, etc. - - just want to get up and running to gain experience and demonstrate to colleagues.
Mirth is running as a service; Mirth Server Manager runs fine. When I hit the Administrator button on the Server Manager window i get a javaw.exe error window stating that javaw.exe must close; after clearing that window Webstart runs and the Mirth Administrator login window appears. I attempt to login with admin/admin and I get the message that "There was a problem authenticating the information that was entered. Please verify that the server is up and running and that the user information is valid."
wrapper.log and mirth.log both have some error messages and warnings in them. wrapper.log attached; mirth.log below:
ERROR 2007-11-19 11:57:38,649 [Thread-0] com.webreach.mirth.server.controllers.ChannelStati sticsController: Could not initialize channel statistics.
ERROR 2007-11-19 11:57:39,133 [Thread-0] com.webreach.mirth.server.controllers.ChannelStati sticsController: Could not initialize channel statistics.
ERROR 2007-11-19 11:57:39,164 [Thread-0] com.webreach.mirth.server.controllers.UserControll er: Could not reset user status.
WARN 2007-11-19 11:58:08,685 [SslListener0-1] org.mortbay.jetty.context./: /users:
com.webreach.mirth.server.controllers.ControllerEx ception: com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred in derby/derby-user.xml.
--- The error occurred while executing query.
--- Check the SELECT USERNAME, PASSWORD, SALT FROM PERSON WHERE USERNAME = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
Caused by: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
at com.webreach.mirth.server.controllers.UserControll er.authorizeUser(UserController.java:116)
at com.webreach.mirth.server.servlets.UserServlet.log in(UserServlet.java:114)
at com.webreach.mirth.server.servlets.UserServlet.doP ost(UserServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:428)
at org.mortbay.jetty.servlet.ServletHandler.dispatch( ServletHandler.java:666)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
at org.mortbay.http.HttpConnection.service(HttpConnec tion.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpCon nection.java:982)
at org.mortbay.http.HttpConnection.handle(HttpConnect ion.java:833)
at org.mortbay.http.SocketListener.handleConnection(S ocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedSer ver.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadP ool.java:534)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred in derby/derby-user.xml.
--- The error occurred while executing query.
--- Check the SELECT USERNAME, PASSWORD, SALT FROM PERSON WHERE USERNAME = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
Caused by: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryWithCallback(GeneralStatemen t.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForObject(GeneralStatement.j ava:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForObject(SqlMapExecutorDelegate.java:566)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForObject(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForObject(SqlMapClientImpl.java:83)
at com.webreach.mirth.server.controllers.UserControll er.authorizeUser(UserController.java:107)
... 16 more
Caused by: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(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.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. <init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement2 0.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement3 0.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedSta tement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepare Statement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepare Statement(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.ibatis.common.jdbc.SimpleDataSource$SimplePool edConnection.invoke(SimpleDataSource.java:958)
at $Proxy0.prepareStatement(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.pre pareStatement(SqlExecutor.java:494)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.exe cuteQuery(SqlExecutor.java:176)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.sqlExecuteQuery(GeneralStatement.java:20 5)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryWithCallback(GeneralStatemen t.java:173)
... 22 more
Thanks,
Joe Quinn
The Children's Hospital of Philadelphia
Mirth is running as a service; Mirth Server Manager runs fine. When I hit the Administrator button on the Server Manager window i get a javaw.exe error window stating that javaw.exe must close; after clearing that window Webstart runs and the Mirth Administrator login window appears. I attempt to login with admin/admin and I get the message that "There was a problem authenticating the information that was entered. Please verify that the server is up and running and that the user information is valid."
wrapper.log and mirth.log both have some error messages and warnings in them. wrapper.log attached; mirth.log below:
ERROR 2007-11-19 11:57:38,649 [Thread-0] com.webreach.mirth.server.controllers.ChannelStati sticsController: Could not initialize channel statistics.
ERROR 2007-11-19 11:57:39,133 [Thread-0] com.webreach.mirth.server.controllers.ChannelStati sticsController: Could not initialize channel statistics.
ERROR 2007-11-19 11:57:39,164 [Thread-0] com.webreach.mirth.server.controllers.UserControll er: Could not reset user status.
WARN 2007-11-19 11:58:08,685 [SslListener0-1] org.mortbay.jetty.context./: /users:
com.webreach.mirth.server.controllers.ControllerEx ception: com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred in derby/derby-user.xml.
--- The error occurred while executing query.
--- Check the SELECT USERNAME, PASSWORD, SALT FROM PERSON WHERE USERNAME = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
Caused by: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
at com.webreach.mirth.server.controllers.UserControll er.authorizeUser(UserController.java:116)
at com.webreach.mirth.server.servlets.UserServlet.log in(UserServlet.java:114)
at com.webreach.mirth.server.servlets.UserServlet.doP ost(UserServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:428)
at org.mortbay.jetty.servlet.ServletHandler.dispatch( ServletHandler.java:666)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
at org.mortbay.http.HttpConnection.service(HttpConnec tion.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpCon nection.java:982)
at org.mortbay.http.HttpConnection.handle(HttpConnect ion.java:833)
at org.mortbay.http.SocketListener.handleConnection(S ocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedSer ver.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadP ool.java:534)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred in derby/derby-user.xml.
--- The error occurred while executing query.
--- Check the SELECT USERNAME, PASSWORD, SALT FROM PERSON WHERE USERNAME = ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
Caused by: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryWithCallback(GeneralStatemen t.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForObject(GeneralStatement.j ava:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForObject(SqlMapExecutorDelegate.java:566)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForObject(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForObject(SqlMapClientImpl.java:83)
at com.webreach.mirth.server.controllers.UserControll er.authorizeUser(UserController.java:107)
... 16 more
Caused by: java.sql.SQLException: Column 'SALT' is either not in any table in the FROM list or appears within a join specification 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 'SALT' is not a column in the target table.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(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.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. <init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement2 0.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement3 0.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedSta tement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepare Statement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepare Statement(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.ibatis.common.jdbc.SimpleDataSource$SimplePool edConnection.invoke(SimpleDataSource.java:958)
at $Proxy0.prepareStatement(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.pre pareStatement(SqlExecutor.java:494)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.exe cuteQuery(SqlExecutor.java:176)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.sqlExecuteQuery(GeneralStatement.java:20 5)
at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryWithCallback(GeneralStatemen t.java:173)
... 22 more
Thanks,
Joe Quinn
The Children's Hospital of Philadelphia