See attached screenshot. The installation begins. this begs the question if you want to keep the openfire.xml configuration file. I answer N (default) to keep the currently installed version. It then shows 3 steps and it stops like this. Openfire stops responding, you can not connect spark to it, or connect to the admin console.
Can someone tell me what is the problem?
I have already made updates to Openfire without any problems so far by following the same method;
The openfire.xml was changed with comments to describe about this feature. And the same file was changed during installation. Therefore apt don’t know what it should do. You can ignore changes and choose the ‘N’ choice to save your configuration.
In fact it is not a problem of login to access the console. But the console is not accessible at all (Openfire does not restart, no response from the openfire web interface and can not connect spark no more).
And I chose “N” to keep the current configuration file (default) during the update.
ma1uta was not telling you that you have login problem. He just explained why upgrade process asks to do something with openfire.xml (because new option was added in 4.3.1 to reset login access).
After you complete installation (with N option), how do you start Openfire? Also check its logs at /openfire/logs/all.log
Openfire on previous updates would reboot alone at the end. There nothing starts. I tried a /etc/init.d/openfire start, but it does not help.
Below is an excerpt from the logs where we obviously see 11 connection attempts that fall into error (I can not attach a file to this message as a new user, so I put below the 11th and last attempt). Obviously the way of connecting to the database (deported to another server) has changed and apparently there is something missing for him to communicate with the database.
MySQL version is 14.12 Distr. 5.0.96 but I did not see anything in the prerequisites that would require a newer version …
What can I do?
2019.02.13 23:28:37 ERROR [main]: org.jivesoftware.openfire.XMPPServer - Database could not be accessed
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.database.DbConnectionManager.getConnection(DbConnectionManager.java:156) ~[xmppserver-4.3.2.jar:4.3.2]
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:946) [xmppserver-4.3.2.jar:4.3.2]
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:648) [xmppserver-4.3.2.jar:4.3.2]
at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:236) [xmppserver-4.3.2.jar:4.3.2]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [?:1.8.0_191]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_191]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_191]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [?:1.8.0_191]
at java.lang.Class.newInstance(Class.java:442) [?:1.8.0_191]
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:4.3.2]
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:4.3.2]
2019.02.13 23:28:37 ERROR [main]: org.jivesoftware.openfire.XMPPServer - 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
java.lang.IllegalArgumentException: 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(XMPPServer.java:956) ~[xmppserver-4.3.2.jar:4.3.2]
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:648) [xmppserver-4.3.2.jar:4.3.2]
at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:236) [xmppserver-4.3.2.jar:4.3.2]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [?:1.8.0_191]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_191]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_191]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [?:1.8.0_191]
at java.lang.Class.newInstance(Class.java:442) [?:1.8.0_191]
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:4.3.2]
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:4.3.2]
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: CLIENT_PLUGIN_AUTH is required
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:156) ~[xmppserver-4.3.2.jar:4.3.2]
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:946) ~[xmppserver-4.3.2.jar:4.3.2]
... 9 more
I suppose you are talking about the file of my machine under 4.2.3 (which works)?
See below (I changed the IP (it is that of the server where the database is stored) and the loggin / password even if they are encrypted).
I specify that I use this installation for years, that I updated it every time without problem and that there was never any problem of connection to the database.
I remember now what i meant to say earlier today and forgot. MySQL 5.0 won’t work. MySQL connector in 4.3 has been updated to the latest version and it only supports 5.5 and higher. 5.0 is very very old (it is not even mentioned here as old… https://en.wikipedia.org/wiki/MySQL).
You mentioned that you checked the prerequisites. Where exactly were you looking for this? Changelog, database documentation? It was mentioned in 4.3.0 release blog post (last note). We have also updated database installation guide and removed exact version numbers and state that DB should be supported by Oracle. Maybe we should put it somewhere else.
Hi,
My mariadb is
mysql Ver 15.1 Distrib 10.1.37-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Is support for 4.3.2
Because I try to install the 4.3.0 not connect to mariadb and today try to install 4.3.2 not connect
when install the old 4.2.3 is connect well to mariadb and AD.
Hi to all I successfully install the openfire 4.3.2 and connect to mariadb well.
The problem with not connect is for me time zone.
For test I setup and openfire 4.3.0 with the same way.
But before install the openfire from deb I run command
timedatectl set-timezone UTC
After change the timezone setup and run openfire 4.3.2 is ok.
I think is not good when to install new version on Debian/Ubuntu and connect Mysql/Mariadb need to change timezone.
If I understand correctly, I have to upgrade to 4.3.2 and replace “mysql-connector-8.0.12.jar” by “mysql-connector-java-5.1.42.jar”? Should I rename it to mysql-connector-8.0.12.jar? It will be in /usr/share/openfire/lib/ ?
That’s right?
The version of mysql that openfire is connecting to is 14.12 Distr. 5.0.96
It is done! I restart openfire then and it works !!
On the other hand, I obviously have flaws in some titles in the genre ??? index.cs_blog ??? on the home page in the yellow box instead of “Ignite Realtime News” (there are plenty of other; ??? plugin.admin.upload_plugin ???, ??? plugin.available.file_size ???, etc. …). But it only happens when I’m in French. As soon as I switch to English it is displayed well. So I think it’s a problem when translating? It does not seem to be a problem with the operation of openfire anyway.
I keep the procedure as it seems logical that I should do it on the next updates where the connector will be changed every time.
Thank you for your help anyway!
Have a good day!
Stéphane
Yes, you would have to remove new connector after every update (maybe old one will be left in place by the installer as it didn’t come with the installer).
Yes, French translation file is missing some strings and then it shows ???.
