Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Trouble installing Mirth 1.6.1 on Windows XP Pro

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Trouble installing Mirth 1.6.1 on Windows XP Pro

    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
Working...
X