powered by Jive Software

Upgrading openfire from 4.2.3 to 4.5.3

When trying to update an existing install, I cannot get passed 4.2.3 x86 bundled jre without running into an exception

I am running Windows 2008 r2

Exception is as follows:

Java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required.

I feel this has to do with a java update starting in 4.3.0 but I do not know enough about Openfire to know where to safely change anything without “breaking” the product.

Any help with pointing me in the right direction would be much appreciated.

Can you please provide the full stack trace of the error? What database are you using? Is there a specific (user) action that triggers these errors?

The Database is MySQL5.0

I cannot get into the localhost:9090 after the upgrade it does not find the connection
The service shows as running. I have restarted the service as well as restaed the machine as I read in other forum posts no such luck

This is what shows when I Launch the OpenfireServer .exe

(sorry had to manually type all of the lines below)

Loading class· com.mysql.jdbc.Driver’. This is deprecated. The new driver class is ‘com.mysql.cj.jdbc.Driver’.

The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

Database setup or configuration error: Please verify your database settings and check the logs/ error. log
file for detailed error messages.

java.lang.lllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries.The exception from the last attempt is as follows: java.sql.SQLNonTransientConnectionException CLIENT_PLUGIN_AUTH is required.

at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServ er.java:955)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:647)

at org.jivesoftware.openfire.XMPPServer.(XMPPServ er.java:236)
tarror starting the server. Please check the log files for more information
sun.reflect.NativeConstructorAccessorlmpl.newlnstanceO(Nati ve Method)
at sun.reflect.NativeConstructorAccessorlmpl.newlnstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorlmpl.newlnstance (Unknown Source)
at java.lang.reflect.Constructor.newlnstance(Unknown Source)

at java.lang.Class.newlnstance(Unknown Source)

at org .jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56)
at sun.reflect.NativeMethodAccessor lmpl.invoke0(Native Method}

at sun.reflect.NativeMethodAccessorlmpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorlmpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)

at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:85)
at com.exe4j.runtime.Winlauncher.main(Winlauncher.java:94)

at com.instal14j.runtime.launcher.Winlauncher.main(Winlauncher .java: 25)

Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries.The exception from the last attempt is as follows: java.sql.SQLNonTransientConnectionException:


org.jivesoftware.database.DbConnectionManager.getConnection (DbConnectionManager.java:156)

at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:945)

… 16 more

Thank you