1. Mirth Connect
2. Home
3. Examples and Tutorials

Created by Kyle Weigel, last modified on Feb 10, 2015

The point of this wiki is to give step by step instructions on how to set up a new installation of PSQL with the free windows mirth connect server prepackaged on this site. It's not insanely difficult, but I'd like to break it down into pieces for those who may not be engineers or DBA's.

Warning: This method doesn't cover database security. If this is a public facing server then please seek out help on proper PSQL security practices.

• Purpose
• Table Of Contents 
• Download PostgreSQL
• Create New Mirth Database
• Mirth Connect Server Manager
• Conclusion

• http://www.enterprisedb.com/products-services-training/pgdownload#windows
• Install with all default settings, but the promotional app offered at the end you don’t need. Take note of the password you specified for the postgres user.

• Launch PGAdmin (the PSQL install will add it to your start menu)
• The server "PostgreSQL" should already be on the servers list.
• Double Click on the server name (When asked for the password use the same one you specified during the Postgresql install)
• Expand the tree until you see the "Databases (1)" item (it will be directly under the server name)
• Right click on "Databases" and select "New Database"

• On the new window that pops up, go to the "Properties" tab.
• Set Name: mirthdb
• Set Owner: postgres

• On the Privileges Tab
• Click on the public user
• Check the ALL box
• Make sure Role is set to “public”

• Click OK

 

Note: You can launch it from the start menu then right click on the system tray item, select Show Manager

• Go to the Database Tab
• Change type to postgres
• URL to: jdbc:postgresql://localhost:5432/mirthdb
• Username: postgres
• Password: (whatever you specified during the PostgreSQL install)

• Click Apply
• Go to the Service tab and click the Start or Restart button (depending on the current state)
• Try clicking the Administrator button to verify the database connection worked.
  • If not, you can check the log C:\Program Files\Mirth Connect\logs\mirth.log

 

The mirth's server manager is not very good at displaying error messages. If the URL is wrong or the user's password is wrong etc, it'll just hang or crash while trying to start up. In which case the log always says why even if a dialog box doesn't pop up. Thankfully it does automatically create the whole mirthdb table structure so you're not stuck trying to hunt a monster query down.

[image2015-2-10 21:22:11.png](attachments/33163407/33390821.png) (image/png) [image2015-2-10 21:29:30.png](attachments/33163407/33390822.png) (image/png) [image2015-2-10 21:31:54.png](attachments/33163407/33390823.png) (image/png) [image2015-2-10 21:33:5.png](attachments/33163407/33390824.png) (image/png) [dbuser.PNG](attachments/33163407/36241410.png) (image/png)

Document generated by Confluence on Nov 11, 2019 08:40

Atlassian