powered by Jive Software

Openfire connection issue with oracle ssl

My oracle is started in SSL mode.

I had made below change in openfire\bin\openfire.bat file for oracle ssl.

-Doracle.net.ssl_cipher_suites=SSL_DH_anon_WITH_3DES_EDE_CBC_SHA,SSL_DH_anon_WI TH_RC4_128_MD5,SSL_DH_anon_WITH_DES_CBC_SHA

and update openfire\conf\openfire.xml for jdbc below connection string

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=)(PORT=2484 ))(CONNECT_DATA=(SERVICE_NAME=orcl)))

openfire starts without any error and make database connection successfully. But after some time I am getting below error -

java.sql.SQLRecoverableException: IO Error: Remote host closed connection during handshake

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:467)

at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546)

at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

at java.sql.DriverManager.getConnection(DriverManager.java:579)

at java.sql.DriverManager.getConnection(DriverManager.java:190)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

Caused by: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake

at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:946)

at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1328)

at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:702)

at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:122)

at oracle.net.ns.Packet.send(Packet.java:403)

at oracle.net.ns.ConnectPacket.send(ConnectPacket.java:198)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:293)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)

… 10 more

Caused by: java.io.EOFException: SSL peer shut down incorrectly

at sun.security.ssl.InputRecord.read(InputRecord.java:352)

at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:927)

… 18 more

Is there a fitewall between Openfire and Oracle?

This may be an SSL issue, Openfire is not really involved there.