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

[jbartels]

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?

[jbartels]

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:

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'

[jbartels]

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.