Enable SSL in ColdFusion 2018 Administrator

[jane24891281hzni]

I want to add a database (Microsoft SQL) to the website I'm working on, using Cold Fusion Administrator (latest version).

After entering all needed data, I got the issue:

Connection verification failed for data source: dbKantine
java.sql.SQLException: The sqlserver package is not installed. You can install the package through the CLI package manager (C:/Users/MYNAME/.CommandBox/server/C1EA019F5A81794693D0EA837C1622B4-PROJECTNAME/adobe-2021.0.2.328618/WEB-INF/cfusion/bin/cfpm.bat) by running the command : install sqlserver.

I tried to execute the *.bat file mentioned, but nothing happened.

I also tried install sqlserver in the CommandBox, but it says:

Error getting ForgeBox entry [sqlserver]

The entry slug sent is invalid or does not exist

EDIT:

I got it installed using cfpm.sh and wrote there "install sqlserver".

But now it tells me this inside of Cold Fusion Administrator:

Connection verification failed for data source: MYDB
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]An SSL socket connection could not be established because JRE 1.4 or above is required.

EDIT 2:

I setup everything again with ColdFusion 2018 (as I'm learning CF 2018 currently).

Now I get the issue:

Connection verification failed for data source: MYDB java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The SQL Server login requires an SSL connection. The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.

What I tried:

I created a *.keystore file and a *.cer file. I followed this https://usermanual.wiki/adobe/CF11Configen.762142204/html#pf2f/this instruction and tried to add the keystore file to the CF Administrator:

[Charlie Arehart]

Quite the spiral you're heading down. So sorry to see it, and I hope we can solve it quickly. 

First, you may not need to add any cert. Second, that screen you show is about flex, so not at all what you want to be using. 

For your cf2018, please try this simpler solution and let us know if it works. In the cf admin dsn, goto its advanced settings button, and in the connection string field, put in this value (or tell us of any other already there) :

EncryptionMethod=SSL;ValidateServerCertificate=false

You MAY still need set that arg to true and implement a cert, but maybe not. Let's take it one step at a time. And while the sql connection may be requiring tls rather than ssl, this should still be the right arg. 

Note also that if the sql server you're connecting to is one you control, like your own on your dev machine, you could also disable its requiring tls/ssl. But again let's focus on getting it working as is. 

Let us know how it goes. Then we can work on your 2021 if the same solution helps only in 2018.

[Charlie Arehart]

(moved down) 

[James25125256cxod]

Did you solve this? I am facing same for my site.

[Charlie Arehart]

James, which specific issue are you having (of several Jane mentioned in the original note and in the two indicated edits since)?

And FWIW, my first comment was the same day as the posting, before the edits, which had a reference to flex (now gone but which I'd mentioned in my comment) and spoke of cf2021 AND cf2018, though it focuses after the edits on 2018. This is all the more reason it's important that you clarify your exact problem and cf version. 

And to you both, please indicate the Java version that Cf is using. See the cf admin "settings summary" page. You should both be using Java 11, on either cf2021 or 2018. Besides confirming that, what update of 11? The original 11.0.1, which the first cf2021 installer came with? Something later? The latest is 11.0.15. 1, as I write. This can be important to your tls/ssl issue.

And in fact if you need to import a cert (you may not need to, to solve this), you would not be importing it into tomcat. That's for making the cf admin accessible via https. To solve the problem of how cf talks to something ELSE via https/tls, again that's about the JAVA version cf isnusing--and perhaps about a need to import certs to that. But that's not ALWAYS the solution. For more on that, see my post:

https://coldfusion.adobe.com/2019/06/error-calling-cf-via-https-solved-updating-jvm/

Let us know how things go/are going, both of you.