Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many 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

Changing internal Database

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

  • Changing internal Database

    I have searched the forum, but couldn't find the answer.

    I want a clean mirth install on a sqlserver 2005 database.

    How do i proceed?
    1: Use de mirth-windows-installer (and the default database is used)
    2: Than run the script sqlserver2005-database.sql
    is this correct?

    than what?
    Questions:
    1: how do i tell mirth to use the sqlserver database?

  • #2
    Re:Changing internal Database

    Worked it out......

    Comment


    • #3
      Re:Changing internal Database

      boesboes wrote:
      Worked it out......
      Can you post your solution? It may help someone else in the future or help the WebReach team improve Mirth.
      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


      • #4
        Re:Changing internal Database

        Of course,

        -Instal mirth with default options.
        -Run de (sqlserver2005) database script. (within the sql server management studio of course).
        -Add a dbuser in sql server.
        -Make it db-owner of the mirthdb.
        -Start the mirth server manager
        With the mirth server manager:
        -On tabpage Database, change the type and added username/passwd of the database
        -On tappage Service pressed the restart button

        Et Voila!

        (had one minor problem, it didn't work, read the mirth.log on the server-tabpage -> a typo in de passwd, and corrected it)

        But if anyone has a better solution/or sees an improvement, please respond!!

        Post edited by: boesboes, at: 11/12/2008 07:03

        Comment


        • #5
          Re:Changing internal Database

          Hi !
          Have you modified the mirth.properties file to explicitly tell Mirth what DB to use ... something like that or did you use the mirth server manager to do that ?
          Code:
          jmx.port=1099
          https.keypassword=abc12345
          mule.config=mule-config.xml
          https.port=8443
          https.keystore=keystore
          mule.queue=${mirthHomeDir}/.mule
          mule.boot=mule-boot.xml
          server.url=
          http.port=8080
          https.password=abc12345
          configuration.id=MirthConfiguration
          database=[b]sqlserver[/b]
          mule.template=mule-template.xml
          http.htdocs=public
          (of course before that initiate the SQL DB in SQL Server ...)

          Best Regards

          Antaris

          Comment


          • #6
            Re:Changing internal Database

            My mirth.properties looks like this:

            Code:
            #Wed Nov 12 11:19:54 CET 2008
            jmx.port=1099
            https.keypassword=abc12345
            mule.config=mule-config.xml
            https.port=8443
            https.ciphers=SSL_RSA_WITH_RC4_128_MD5,SSL_RSA_WITH_RC4_128_SHA,TLS_RSA_WITH_AES_128_CBC_SHA,TLS_DHE_RSA_WITH_AES_128_CBC_SHA,TLS_DHE_DSS_WITH_AES_128_CBC_SHA,SSL_DHE_RSA_WITH_3DES_EDE_CBC_SHA,SSL_DHE_DSS_WITH_3DES_EDE_CBC_SHA
            https.keystore=keystore
            mule.queue=${mirthHomeDir}/.mule
            context.path=/
            jmx.password=admin
            mule.boot=mule-boot.xml
            server.url=
            http.port=8081
            https.password=abc12345
            configuration.id=MirthConfiguration
            database=sqlserver2005
            mule.template=mule-template.xml
            http.htdocs=public
            So i think the mirth server manager does that....

            It also stores the sql-server info in the sqlserver2005-SqlMapConfig.properties - file

            Code:
            #Wed Nov 12 11:19:54 CET 2008
            url=jdbc:jtds:«»sqlserver://localhost:8080/mirthdb
            password=*********
            database=sqlserver2005
            driver=net.sourceforge.jtds.jdbc.Driver
            username=mirthdbuser

            so the mirth server manager works fine!!!
            i didn't have to -vi- any text file :laugh:

            o, the mirt version is: Mirth 1.8.0 RC

            Post edited by: boesboes, at: 11/12/2008 07:11

            Comment


            • #7
              Re:Changing internal Database

              Ok boesboes thx for your reply.
              Have nice day (lol i think it is :-D)
              Cheers
              Antaris

              Comment

              Working...
              X