web stats
Need help with MS SQL with Encryption - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-12-2018, 09:08 AM
bbarnhorst bbarnhorst is offline
Mirth Newb
 
Join Date: Oct 2012
Posts: 21
bbarnhorst is on a distinguished road
Default Need help with MS SQL with Encryption

Need to connect to the mirth backend db using encryption. I have downloaded the driver, placed it into the custom-lib directory and added an entry to dbdrivers.xml file. The mirth.properties file states:
# if using a custom driver, specify it here
#database.driver =

I have not yet been able to determine what that should look like. May I ask someone please to post an example? I need to select sqlserver from mirth connect server manager, and supply it with the connection string. When I try to use the string that ms specifies (jdbc:sqlserver://localhost:1433;...) I get an error indicating no suitable driver found for jdbc.

Any suggestions appreciated, thanks!
Reply With Quote
  #2  
Old 09-12-2018, 09:57 AM
bbarnhorst bbarnhorst is offline
Mirth Newb
 
Join Date: Oct 2012
Posts: 21
bbarnhorst is on a distinguished road
Default Got it working. Detailed steps follow

1. Stop the mirth service

2. Downloaded MS SQL Server jdbc driver from here: https://docs.microsoft.com/en-us/sql...ql-server-2017

3. Extract the file from step 2, place the appropriate jar file in <the path>\Mirth Connect\server-lib\database

4. Edit <the path>\Mirth Connect\conf\dbdrivers.xml, add the following:
<driver class="org.sqlite.JDBC" name="SQLite" template="jdbc:sqlite:dbfile.db" selectLimit="SELECT * FROM ? LIMIT 1" />
<driver class="com.microsoft.sqlserver.jdbc.SQLServerDrive r" name="YOUR CONNECTOR NAME" template="jdbc:sqlserver://hostort/dbname" selectLimit="SELECT TOP 1 * FROM ?" />

5. Edit <the path>\Mirth Connect\conf\mirth.properties, add:
database.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
where the driver is equal to the class path used in step 4

6. Set the connection string in mirth connect server manager as appropriate per the article in step 2:
jdbc:sqlserver://hostname:1433;databaseName=theDBName

7. Restart mirth
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 12:15 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Mirth Corporation