I changed my JAVA, NOW, I have Database Issues getting to our SQL-Server over SSL
| ♥ 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:
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 |
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: Marked as spam
 Posted by pt-barnum (Questions: 4, Answers: 509) Answered on February 11, 2020 6:08 pm
|