Announcement

Collapse

Mirth Connect 4.1.0 Released!

Mirth Connect 4.1.0 is now available as an appliance update and on our GitHub page. Mirth Connect 4.1.0 includes new features such as new event log messages, additional fields to the Welcome to Mirth Connect screen, new information included in alerts as well as many smaller changes, updates, and improvements. This release also contains several 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

How do I get Mirth 1.5 on Linux to use MySQL?

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

  • How do I get Mirth 1.5 on Linux to use MySQL?

    I'm pretty sure the docs for this were staring me in the face, but how do I set Mirth 1.5 Linux to use MySQL.

    I've already run the creation scripts, how do I get the Mirth server to use it?
    Jon Bartels

    Zen is hiring!!!!
    http://consultzen.com/careers/
    Talented healthcare IT professionals wanted. Engineers to sales to management.
    Good benefits, great working environment, genuinely interesting work.

  • #2
    Re:How do I get Mirth 1.5 on Linux to use MySQL?

    Ok. I've updated mirth.properties to use mysql and mysql-SQL*.properties with the username and pass.

    Mirth.log reads:
    Code:
    WARN  2007-06-15 19:06:32,911 [SslListener0-1] org.mortbay.jetty.context.Mirth Server: /users:
    com.webreach.mirth.server.controllers.ControllerException: java.sql.SQLException: Unknown database 'mirthdb'
            at com.webreach.mirth.server.controllers.UserController.authorizeUser(UserController.java:100)
            at com.webreach.mirth.server.servlets.UserServlet.login(UserServlet.java:114)
            at com.webreach.mirth.server.servlets.UserServlet.doPost(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(ServletHolder.java:428)
            at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
            at com.osmoticweb.gzipfilter.GZIP2WayFilter.doFilter(GZIP2WayFilter.java:54)
            at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
            at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
            at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
            at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
            at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
            at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
            at org.mortbay.http.HttpServer.service(HttpServer.java:909)
            at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
            at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
            at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
            at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
            at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
            at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
    Caused by: java.sql.SQLException: Unknown database 'mirthdb'
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
            at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)
            at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
            at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
            at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
            at java.sql.DriverManager.getConnection(DriverManager.java:582)
            at java.sql.DriverManager.getConnection(DriverManager.java:185)
            at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:580)
            at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222)
            at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)
            at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
            at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
            at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
            at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
            at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
            at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:83)
            at com.webreach.mirth.server.controllers.UserController.authorizeUser(UserController.java:91)
            ... 20 more
    ERROR 2007-06-15 19:14:13,157 [WrapperSimpleAppMain] com.webreach.mirth.server.controllers.ChannelStatisticsController: Could not initialize channel statistics.
    ERROR 2007-06-15 19:14:13,174 [WrapperSimpleAppMain] com.webreach.mirth.server.controllers.MessageObjectController: java.sql.SQLException: Unknown database 'mirthdb'
    Jon Bartels

    Zen is hiring!!!!
    http://consultzen.com/careers/
    Talented healthcare IT professionals wanted. Engineers to sales to management.
    Good benefits, great working environment, genuinely interesting work.

    Comment


    • #3
      Re:How do I get Mirth 1.5 on Linux to use MySQL?

      Fixed it. The MySQL scripts call the database MIRTHDB and not mirthdb.
      Jon Bartels

      Zen is hiring!!!!
      http://consultzen.com/careers/
      Talented healthcare IT professionals wanted. Engineers to sales to management.
      Good benefits, great working environment, genuinely interesting work.

      Comment

      Working...
      X