Announcement

Collapse
No announcement yet.

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