Announcement

Collapse

NextGen (Mirth) Connect 3.11.0 Released!

NextGen (Mirth) Connect 3.11.0 is now available as an appliance update and on our GitHub page. This release contains improvements to licensing and the NCPDP data type. It also includes various security fixes, general bug fixes, and improvements to commercial extensions. See the release notes for the complete list of fixes and improvements.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Connecting to Local Mirthconnect Derby DB (Linux)

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

  • Connecting to Local Mirthconnect Derby DB (Linux)

    Hello Mirth community,

    I am attempting to connect to the local Mirth Derby database on a remote Linux server. I have tried to follow guides that show this type of connectivity when running Mirth on a local Windows machine, but no luck finding any documentation for accomplishing this on a Linux instance. Has anyone here had any luck doing this? I just want to prove there is a way to access the local database prior to pointing the database to an external SQL db.

    Here are some of the guides I've looked through siting the use of Squirrel SQL Client to accomplish this, but no luck so far:
    https://forums.mirthproject.io/forum...edded-database

    https://app.assembla.com/wiki/show/smart-cs/Connecting_to_Derby_via_Squirrel

    https://db.apache.org/derby/integrate/SQuirreL_Derby.html


    Mirthconnect version 3.10.1


    Thank you in advance.
    Last edited by darkmatter; 04-29-2021, 05:22 PM.

  • #2
    You are attempting that connection while on the remote box, right? Derby is a file-based database. So you have to connect to it local to the machine
    Diridium Technologies, Inc.
    https://diridium.com

    Comment


    • #3
      pacmano Thank you.

      Correct. The Mirthconnect Linux server is on a remote VM. I am attempting to connect via my Windows machine. I'm doing something similar to the image below, but instead of localhost I use the IP and port number 1527.

      What would be the best method to use to access Derby db data if ever needed? My goal is to make sure that data is still accessible post move to a remote SQL server.

      sq_alias_client.gif
      Last edited by darkmatter; 04-29-2021, 05:27 PM.

      Comment


      • #4
        Well I misspoke. The first thing I do when using mirth is connect to a real database not Derby. Derby can listen on a network port but I suspect it is not configured that way by default with a mirth install.
        Diridium Technologies, Inc.
        https://diridium.com

        Comment


        • #5
          Hi,
          I am new here.

          Current MSH message how it looks:

          ORC|RE||20210429074431-48^Facility|||||||^testuser^patagonia^^^^^^WI^^^^M D||^testuser^patagonia^^^^^^NDA^L^^^MD
          RXA|0|1|20210429|20210429|49281-0547-58^Hib (PRP-T)^NDC|0.5|mL^Milliliter^UCUM||00^New immunization record^NIP001|^testuser^patagonia^^^^^^|City of Milwaukee Health Department^^^21597||||AHIB15S|20251231|PMC^sanofi pasteur^MVX|||CP|A
          RXR|C28161^Intramuscular^NCIT|LA^Left Upper Arm^HL70163
          OBX|1|CE|64994-7^Vaccine funding program eligibility category^LN|1|V02^VFC eligible-Medicaid/Medicaid Managed Care^HL70064||||||F|||20210429|||VXC40^Eligibility captured at the immunization level^CDCPHINVS
          OBX|2|CE|30963-3^Vaccine purchased with^LN|1|PHC70^Private funds^CDCPHINVS||||||F|||20210429|||^^|
          OBX|3|CE|30956-7^vaccine type^LN|2|17^Haemophilus Influenzae type b VIS^CVX||||||F|||20210429
          OBX|4|TS|29768-9^Date vaccine information statement published^LN|2|20150402||||||F|||20210429
          OBX|5|TS|29769-7^Date vaccine information statement presented^LN|2|20210429||||||F|||20210429
          OBX|6|CE|75505-8^Contraindications^LN|3|341112003^Serology confirmed mumps^SCT^^^||||||F|||20210429
          OBX|7|CE|75505-8^Diseases with serological evidence of immunity^LN|3|341112003^Serology confirmed mumps^SCT^^^||||||F|||20210429
          OBX|8|CE|30945-0^Contraindications^LN|4|294847001^Allergy to gelatin (anaphylactic)^SCT^^^||||||F|||20210429
          OBX|9|CE|59784-9^Contraindications^LN|5|44^Immunity: Varicella – Laboratory-tested Confirmation^L^^^||||||F|||20210429
          OBX|10|CE|59784-9^Disease with presumed immunity^LN|5|44^Immunity: Varicella – Laboratory-tested Confirmation^L^^^||||||F|||20210429

          I need to display it as

          ORC|RE||20210429074431-48^Facility|||||||^testuser^patagonia^^^^^^WI^^^^M D||^testuser^patagonia^^^^^^NDA^L^^^MD
          RXA|0|1|20210429|20210429|49281-0547-58^Hib (PRP-T)^NDC|0.5|mL^Milliliter^UCUM||00^New immunization record^NIP001|^testuser^patagonia^^^^^^|City of Milwaukee Health Department^^^21597||||AHIB15S|20251231|PMC^sanofi pasteur^MVX|||CP|A
          RXR|C28161^Intramuscular^NCIT|LA^Left Upper Arm^HL70163
          OBX|1|CE|64994-7^Vaccine funding program eligibility category^LN|1|V02^VFC eligible-Medicaid/Medicaid Managed Care^HL70064||||||F|||20210429|||VXC40^Eligibility captured at the immunization level^CDCPHINVS
          OBX|2|CE|30963-3^Vaccine purchased with^LN|1|PHC70^Private funds^CDCPHINVS||||||F|||20210429|||^^|
          OBX|3|CE|30956-7^vaccine type^LN|2|17^Haemophilus Influenzae type b VIS^CVX||||||F|||20210429
          OBX|4|TS|29768-9^Date vaccine information statement published^LN|2|20150402||||||F|||20210429
          OBX|5|TS|29769-7^Date vaccine information statement presented^LN|2|20210429||||||F|||20210429

          ORC|RE||20210429074431-48^Facility|||||||^testuser^patagonia^^^^^^WI^^^^M D||^testuser^patagonia^^^^^^NDA^L^^^MD
          RXA|0|1|20210429|20210429|49281-0547-58^Hib (PRP-T)^NDC|0.5|mL^Milliliter^UCUM||00^New immunization record^NIP001|^testuser^patagonia^^^^^^|City of Milwaukee Health Department^^^21597||||AHIB15S|20251231|PMC^sanofi pasteur^MVX|||CP|A
          OBX|1|CE|75505-8^Contraindications^LN|3|341112003^Serology confirmed mumps^SCT^^^||||||F|||20210429
          OBX|2|CE|75505-8^Diseases with serological evidence of immunity^LN|3|341112003^Serology confirmed mumps^SCT^^^||||||F|||20210429

          ORC|RE||20210429074431-48^Facility|||||||^testuser^patagonia^^^^^^WI^^^^M D||^testuser^patagonia^^^^^^NDA^L^^^MD
          RXA|0|1|20210429|20210429|49281-0547-58^Hib (PRP-T)^NDC|0.5|mL^Milliliter^UCUM||00^New immunization record^NIP001|^testuser^patagonia^^^^^^|City of Milwaukee Health Department^^^21597||||AHIB15S|20251231|PMC^sanofi pasteur^MVX|||CP|A
          OBX|1|CE|30945-0^Contraindications^LN|4|294847001^Allergy to gelatin (anaphylactic)^SCT^^^||||||F|||20210429

          ORC|RE||20210429074431-48^Facility|||||||^testuser^patagonia^^^^^^WI^^^^M D||^testuser^patagonia^^^^^^NDA^L^^^MD
          RXA|0|1|20210429|20210429|49281-0547-58^Hib (PRP-T)^NDC|0.5|mL^Milliliter^UCUM||00^New immunization record^NIP001|^testuser^patagonia^^^^^^|City of Milwaukee Health Department^^^21597||||AHIB15S|20251231|PMC^sanofi pasteur^MVX|||CP|A
          OBX|1|CE|59784-9^Contraindications^LN|5|44^Immunity: Varicella – Laboratory-tested Confirmation^L^^^||||||F|||20210429
          OBX|2|CE|59784-9^Disease with presumed immunity^LN|5|44^Immunity: Varicella – Laboratory-tested Confirmation^L^^^||||||F|||20210429

          Comment


          • #6
            sairebel please first read the forum etiquette at https://forums.mirthproject.io/artic...orum-etiquette

            Your question has nothing to do with this thread. Start a new thread.

            Please describe your objective. You posted messages but did not explain the modification of the messages so you are making the reader figure it out.

            Please post your coding attempts that failed.

            Your messages are not complete HL7 messages, post full messages.
            Last edited by pacmano; 05-02-2021, 06:02 AM.
            Diridium Technologies, Inc.
            https://diridium.com

            Comment

            Working...
            X