Announcement

Collapse
No announcement yet.

Mirth Service not starting with SQL Server 2005

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

  • Mirth Service not starting with SQL Server 2005

    I have set up Mirth before with the MIRTHDB database held in SQL Server and I didn't have any major problems.

    I'm now trying to install the Mirth service on another server running SQL Server 2005. I want to put the MIRTHDB into SQL Server. I ran the script to create the database and have created a SQL login to own the database. I can successfully connect to the database using this login.

    I can start the Mirth service if I use the default derby database.

    However when I try to run the Mirth service with SQL Server it fails to start. The connection information is as follows:

    Type: sqlserver2005
    URL: jdbc:jtds:sqlserver://localhost:1433/mirthdb
    Username: mydatabaseowner
    Password: mypassword

    The error log has a number of messages similar to the output below. I have monitored the SQL Server with the profile tools supplied by MS and I cannot see any sign that the Mirth Service is trying to establish a connection to the database server. I would be grateful if someone could help me solve this problem. Thanks.

    WARN 2008-06-20 12:54:58,308 [SslListener0-1] com.webreach.mirth.server.controllers.Configuratio nController: could not retrieve status of database
    java.sql.SQLException: I/O Error: DB server closed connection.
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2277)
    at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.ja va:599)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(C onnectionJDBC2.java:331)
    at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(C onnectionJDBC3.java:50)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.ja va:178)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.ibatis.common.jdbc.SimpleDataSource.popConnect ion(SimpleDataSource.java:580)
    at com.ibatis.common.jdbc.SimpleDataSource.getConnect ion(SimpleDataSource.java:222)
    at com.webreach.mirth.server.controllers.Configuratio nController.getStatus(ConfigurationController.java :631)
    at com.webreach.mirth.server.servlets.ConfigurationSe rvlet.doPost(ConfigurationServlet.java:50)
    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: java.io.IOException: DB server closed connection.
    at net.sourceforge.jtds.jdbc.SharedSocket.readPacket( SharedSocket.java:828)
    at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacke t(SharedSocket.java:707)
    at net.sourceforge.jtds.jdbc.ResponseStream.getPacket (ResponseStream.java:466)
    at net.sourceforge.jtds.jdbc.ResponseStream.read(Resp onseStream.java:103)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2172)
    ... 24 more

  • #2
    Re:Mirth Service not starting with SQL Server 2005

    I've found a solution to the problem myself. It is something to do with ssl certificates. To fix the problem amend the connection string by adding a ssl=request property. e.g.

    jdbc:jtds:sqlserver://localhost:1433/mirthdb;ssl=request

    Comment


    • #3
      Re:Mirth Service not starting with SQL Server 2005

      B) Thanks for posting your solution!
      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