Announcement

Collapse

Mirth Connect 4.3.0 Released!

Mirth Connect 4.3.0 is now available as an appliance update and on our GitHub page.

This is a major release containing new features like adding new functionality to the Mirth Connect Setup Wizard, adding the ability for resource and channel-specific classloaders to load child-first or parent-first, and added a default implementation of the getObjectsForSwaggerExamples() method in the ServicePlugin class. This release also contains enhancements for the Mirth Connect Administrator Launcher, the Mirth Connect Docker images, and several bug fixes and security improvements.

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
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    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?
    Tags: None
  • #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'

    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.

      Comment

      Previous template Next
      Working...
      X

      We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.

      By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.

      I Agree