Forum

This content is now out of date.

Visit Our Community

Yellowfin unable to connect to the SQL Server running under ForceEncryption

we have encountered a typical problem with Yellowfin connecting to SQL Server running under ForcedEncryption (in SSL Mode).


Environment details.

Host Operation System : Window 2012 64 bit Operation System.
Yellowfin Version: Yellowfin 7.1
JDK Verison : Java 1.8 (customer had to migrate to this JDK because of their Security regulations, this cannot be reverted).
SQL Server : SQLServer 2012 (running on ForceEncryption), refer to the below screenshot for more details.


Forum image



While connecting to the SQLServer the following error is getting reported in the JDBC log

2015-07-31 19:26:30 NOTICE: 2015-07-31 19:26:30
2015-07-31 19:26:30 NOTICE: Starting DBConnectionPool
2015-07-31 19:26:30 NOTICE: sourceId: 0
2015-07-31 19:26:30 NOTICE: sourceName: Application Configuration Database
2015-07-31 19:26:30 NOTICE: connectionMethod: JDBC
2015-07-31 19:26:30 NOTICE: authAdapter: Standard Authentication(GENERICUSER)
2015-07-31 19:26:30 NOTICE: driver: net.sourceforge.jtds.jdbc.Driver
2015-07-31 19:26:30 NOTICE: url: jdbc:jtds:sqlserver://localhost:1433/safereports71
2015-07-31 19:26:30 NOTICE: username: sa
2015-07-31 19:26:30 NOTICE: min connections: 2
2015-07-31 19:26:30 NOTICE: max connections: 25
2015-07-31 19:26:30 NOTICE: maxOpenTime: 4 h
2015-07-31 19:26:30 NOTICE: maxCheckoutTime: 5 min
2015-07-31 19:26:30 NOTICE: psCacheSize: 20
2015-07-31 19:26:30 NOTICE: FetchSize: 0
2015-07-31 19:26:30 NOTICE: Verify connections: false
2015-07-31 19:26:30 NOTICE: Application Version: 7.1
2015-07-31 19:26:30 NOTICE: Build Version: 20140923
2015-07-31 19:26:30 NOTICE: Pooling Enabled: true
2015-07-31 19:26:30 NOTICE: -----------------------------------------
2015-07-31 19:26:30 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 1). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.
2015-07-31 19:26:45 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 2). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.
2015-07-31 19:27:00 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 3). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.
2015-07-31 19:27:15 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 4). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.
2015-07-31 19:27:30 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 5). Will try again in 15 seconds. java.sql.SQLException: I/O Error: DB server closed connection.

Doing some research we found that the problem can be solved by following the steps mentioned in (http://stackoverflow.com/questions/11497530/jdbc-jtds-sql-server-connection-closed-after-ssl-authentication).

All the steps works fine, as long as we are working on JRE7, the moment we change the JRE version from 7 to 8 the following error gets reported in the JDBC log

2015-07-31 19:33:04 NOTICE: 2015-07-31 19:33:04
2015-07-31 19:33:04 NOTICE: Starting DBConnectionPool
2015-07-31 19:33:04 NOTICE: sourceId: 0
2015-07-31 19:33:04 NOTICE: sourceName: Application Configuration Database
2015-07-31 19:33:04 NOTICE: connectionMethod: JDBC
2015-07-31 19:33:04 NOTICE: authAdapter: Standard Authentication(GENERICUSER)
2015-07-31 19:33:04 NOTICE: driver: net.sourceforge.jtds.jdbc.Driver
2015-07-31 19:33:04 NOTICE: url: jdbc:jtds:sqlserver://localhost:1433/safereports71;ssl=require
2015-07-31 19:33:04 NOTICE: username: sa
2015-07-31 19:33:04 NOTICE: min connections: 2
2015-07-31 19:33:04 NOTICE: max connections: 25
2015-07-31 19:33:04 NOTICE: maxOpenTime: 4 h
2015-07-31 19:33:04 NOTICE: maxCheckoutTime: 5 min
2015-07-31 19:33:04 NOTICE: psCacheSize: 20
2015-07-31 19:33:04 NOTICE: FetchSize: 0
2015-07-31 19:33:04 NOTICE: Verify connections: false
2015-07-31 19:33:04 NOTICE: Application Version: 7.1
2015-07-31 19:33:04 NOTICE: Build Version: 20140923
2015-07-31 19:33:04 NOTICE: Pooling Enabled: true
2015-07-31 19:33:04 NOTICE: -----------------------------------------
2015-07-31 19:34:54 WARN: Failed to create initial connection at DBConnectionPool startup (attempt 1). Will try again in 15 seconds. java.sql.SQLException: Network error IOException: Connection reset

request to provide a solution with JRE8 as our customer cannot revert back to JRE7 because of security policies.

Thanks
Nitin
Hi Nitin,

We are experiencing the same problem... I would be interested to see the resolution to this issue?

Brad
While looking into the war files we found that, yf uses �Jtds-1.2.jar�, to connect to the database server.

we further referenced this url -
http://sourceforge.net/p/jtds/bugs/725/


Thanks
Nitin
Hi Nitin/Brad,

Have you tried using the Microsoft JDBC driver?
Microsoft JDBC Driver for SQL Server
I know this has helped in the past with similar issues.

Regards,
David

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.