I changed my JAVA, NOW, I have Database Issues getting to our SQL-Server over SSL

Question ID: 109316
1
0

Last week, we had trouble starting our ALM service because our (Oracle) JAVA decided to update itself and messed up the path to the JVM.

changed my JAVA:

https://eyeontesting.com/answers/alm-service-wont-start-error-in-wrapper-log-error-occurred-during-initialization-of-vm/

 

We resolved that, now, we have a “Database connection” error in our Wrapper Log.

 

INFO   | jvm 1    | 2020/02/10 15:41:10.770 | 2020-02-10 15:41 WrapperSimpleAppMain 
ERR com.hp.alm.platform.db.CConnectionManager 
Can't create a new database connection for 
url 'jdbc:mercury:sqlserver<strong>://almdb.mycompany.com:1433</strong>;EncryptionMethod=SSL' 
on getting connection to database server 
(jdbc:mercury:sqlserver://almdb.mycompany.com:1433;EncryptionMethod=SSL)

 

We use SQL-Server over SSL and it worked just fine before all of this mess from JAVA upgrading itself  to a newer build and changing the path to the JAVA.exe.

We checked basic connections to SQL-Server with PING, Telnet, ODBC, and SQL-Management Studio from the ALM Server PC.

Our usernames, rights and passwords are OK, WHY is it not connecting?

Marked as spam
Posted by (Questions: 70, Answers: 2)
Asked on February 11, 2020 5:17 pm
11 views
Answers
1
Private answer

You need a cert for SQL-Server/SSL in the JAVA cacerts file... BUT it was removed with the old JAVA and replace with a "blank" one from AdoptOpenJDK!

You need to add the cert (for the SQL-Server using SSL) with the keytool command as specified in the install guide and it should work.

SO, the JAVA Update caused all of this:
1) path to java.exe changed
2) needed to re-point micro focus_java_home to new path (as long as no other conflicting java.exe's), or
2a) needed to install substitute JAVA (AdoptJDK 8) and re-point micro focus_java_home to new path
3) cacerts (that had the correct SQL-Server/SSL cert) was removed with older JAVA, so needed to re-import cert(s)

Marked as spam
Posted by (Questions: 3, Answers: 447)
Answered on February 11, 2020 6:08 pm