Announcement

Collapse
No announcement yet.

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=sqlserver
          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