After restarting the server, the administrator console was no longer available

baalbes · March 14, 2019, 2:52pm

Hello!
Did as it is written and everything turned out. All set up, users are connected. BUT as soon as I restarted openfire (or I restarted the server) everything collapses. Again I can not connect to the management console, users can not connect.
What is the problem I can not find.

baalbes · March 20, 2019, 5:28am

Hi! I did as the linuxman advised in this thread - performed “timedatectl set-timezone UTC”. Everything is perfectly established and earned. But after restarting the server, the administrator console was no longer available. Changed time in different ways, but nothing happens. Can someone help with the solution?

wroot · March 20, 2019, 5:43am

Are you using Ubuntu? What version exactly? How do you install and run Openfire? Can you make sure that Openfire process is running? Maybe check with ‘top’ is there java process up, also check with netstat -a if 9090, 9091 or 5222 ports are listening/established.

baalbes · March 21, 2019, 6:10am

Debian 9.4
I am updating openfire from version 4.2.3 to version 4.3.2. Update failed. After the upgrade, the admin console did not load. I turned to the forum topic and decided The question is how I advised linuxman - before installing the package, I performed “timedatectl set-timezone UTC”. Everything is updated and earned.
Now I checked everything again. Immediately after the update, everything works, BUT for some reason, only port 9090 listens. And everything works. After the reboot, the admin console did not load… The Openfire process is running, there is a process in Java, but none of the required ports are listening. I begin work in this direction.

wroot · March 21, 2019, 6:42am

Anything related in /openfire/logs/all.log?

baalbes · March 21, 2019, 7:57am

I have this in the log (sorry, I can’t upload it):

2019.03.21 07:46:12 INFO  [main]: org.jivesoftware.openfire.XMPPServer - Registering shutdown hook (standalone mode)
2019.03.21 07:46:13 ERROR [main]: org.jivesoftware.database.DbConnectionManager - Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: $
java.sql.SQLNonTransientConnectionException: Cannot load connection class because of underlying exception: com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to par$
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.12.jar:8.0.12]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.12.jar:8.0.12]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.12.jar:8.0.12]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.12.jar:8.0.12]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.12.jar:8.0.12]
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:79) ~[mysql-connector-java-8.0.12.jar:8.0.12]
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:131) ~[mysql-connector-java-8.0.12.jar:8.0.12]
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:227) ~[mysql-connector-java-8.0.12.jar:8.0.12]
        at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_171]
        at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_171]
        at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:90) ~[commons-dbcp2-2.5.0.jar:2.5.0]
        at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291) ~[commons-dbcp2-2.5.0.jar:2.5.0]
        at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:883) ~[commons-pool2-2.6.0.jar:2.6.0]
        at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:436) ~[commons-pool2-2.6.0.jar:2.6.0]
        at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365) ~[commons-pool2-2.6.0.jar:2.6.0]
        at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) ~[commons-dbcp2-2.5.0.jar:2.5.0]
        at org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnectionProvider.java:91) ~[xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectionManager.java:602) [xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.database.DbConnectionManager.ensureConnectionProvider(DbConnectionManager.java:99) [xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:121) [xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:438) [xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:90) [xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:66) [xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:556) [xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.util.cache.CacheFactory.<clinit>(CacheFactory.java:88) [xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:394) [xmppserver-4.3.2.jar:4.3.2]
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:640) [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_171]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_171]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_171]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [?:1.8.0_171]
        at java.lang.Class.newInstance(Class.java:442) [?:1.8.0_171]
        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: com.mysql.cj.exceptions.UnableToConnectException: Cannot load connection class because of underlying exception: com.mys

guus · March 21, 2019, 8:07am

Sadly, the last few letters are not included in your copy of the log, but still, this part is a strong indication of the problem:

It appears that the configuration of the database (that you provide during the setup) is incorrect. This URL is also saved in openfire.xml. Can you show a copy of that, please?

baalbes · March 21, 2019, 8:27am

I have this configuration before the upgrade:

<connectionProvider>
    <className>org.jivesoftware.database.DefaultConnectionProvider</className>
  </connectionProvider>
  <database>
    <defaultProvider>
      <driver>com.mysql.jdbc.Driver</driver>
      <serverURL>jdbc:mysql://localhost:3306/openfire?useUnicode=true&amp;amp;characterEncoding=UTF-8&amp;amp;characterSetResults=UTF-8</serverURL>
      <username encrypted="true">xxxxxxxxxxxxxxxxxxxxxxxxx</username>
      <password encrypted="true">xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</password>
      <testSQL>select 1</testSQL>
      <testBeforeUse>false</testBeforeUse>
      <testAfterUse>false</testAfterUse>
      <minConnections>5</minConnections>
      <maxConnections>25</maxConnections>
      <connectionTimeout>1.0</connectionTimeout>
    </defaultProvider>
  </database>
  <!-- sasl configuration -->
  <setup>true</setup>
</jive>

And I have this configuration after the upgrade:

<connectionProvider>
    <className>org.jivesoftware.database.DefaultConnectionProvider</className>
  </connectionProvider>
  <database>
    <defaultProvider>
      <driver>com.mysql.jdbc.Driver</driver>
      <serverURL>jdbc:mysql://localhost:3306/openfire?useUnicode=true&amp;amp;characterEncoding=UTF-8&amp;amp;characterSetResults=UTF-8</serverURL>
      <username encrypted="true">xxxxxxxxxxxxxxxxxxxxxxxxx</username>
      <password encrypted="true">xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</password>
      <testSQL>select 1</testSQL>
      <testBeforeUse>false</testBeforeUse>
      <testAfterUse>false</testAfterUse>
      <minConnections>5</minConnections>
      <maxConnections>25</maxConnections>
      <connectionTimeout>1.0</connectionTimeout>
      <testTimeout>500</testTimeout>
      <timeBetweenEvictionRuns>30000</timeBetweenEvictionRuns>
      <minIdleTime>900000</minIdleTime>
      <maxWaitTime>500</maxWaitTime>
    </defaultProvider>
  </database>
  <!-- sasl configuration -->
  <setup>true</setup>
  <fqdn>aaaaa.aaaaaaa.local</fqdn>
</jive>

wroot · March 21, 2019, 8:43am

instead of &amp; change it to &amp in the connection string
this is a bug https://issues.igniterealtime.org/browse/OF-1682

baalbes · March 21, 2019, 10:08am

Cool! That helped! Thank You! It all worked!