Openfire Starts and Stops

Greetings! How do I stop Openfire from quitting on me. I get this:

 systemctl status openfire
? openfire.service - SYSV: Openfire is an XMPP server, which is a server that facilitates XML based communication, such as chat.
   Loaded: loaded (/etc/rc.d/init.d/openfire; bad; vendor preset: disabled)
   Active: inactive (dead) since Mon 2025-02-24 14:01:53 EST; 1min 18s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 27482 ExecStop=/etc/rc.d/init.d/openfire stop (code=exited, status=0/SUCCESS)
  Process: 27420 ExecStart=/etc/rc.d/init.d/openfire start (code=exited, status=0/SUCCESS)
 Main PID: 27434 (code=exited, status=0/SUCCESS)


Feb 24 14:01:47 xxx.xxx.net systemd[1]: Starting SYSV: Openfire is ....
Feb 24 14:01:47 xxx.xxx.net su[27432]: (to daemon) root on none
Feb 24 14:01:47 xxx.xxx.net openfire[27420]: Starting openfire:
Feb 24 14:01:48 xxx.xxx.net systemd[1]: Started SYSV: Openfire is a....
Feb 24 14:01:53 xxx.xxx.net openfire[27482]: Shutting down openfire

It was working and just stopped. How can I fix it, please?

Regards,
Quaz

Hi Quaz, sorry to hear that you’re running into issues!

Sadly, the data that you provided doesn’t explain why Openfire is shutting down. Can you investigate both syslog and the log files of Openfire please?

Guus,

Here is the all.log. Sorry about the size.

Last login: Wed Feb 26 09:40:22 2025 from 192.168.1.206

  O @ @    Issabel is a product meant to be configured through a web browser.
  @ @ O    Any changes made from within the command line may corrupt the system
  @ O O    configuration and produce unexpected behavior; in addition, changes
    O      made to system files through here may be lost when doing an update.

To access your Issabel System, using a separate workstation (PC/MAC/Linux)
Open the Internet Browser using the following URL:


Your opportunity to give back: http://www.patreon.com/issabel

System load:  0.00 (1min) 0.03 (5min) 0.07 (15min)        Uptime:  6 days
Asterisk:     Asterisk 16.16.1                      Active Calls:  0
Memory:       [===>---------------------------------------------]   8% 643/7890M
Usage on /:   [=============>-----------------------------------]  27% 226/909G
Swap usage:   0.0%
SSH logins:   1 open sessions
Processes:    194 total, 149 yours

[root@saturn ~]#  cd /opt/openfire/logs
[root@saturn logs]# ls
all.log    all.log-6    debug.log.4  info.log-2  nohup.out     warn.log.4
all.log-1  all.log-7    debug.log.5  info.log-3  openfire.log  warn.log.5
all.log-2  debug.log    error.log    info.log-4  warn.log
all.log-3  debug.log.1  error.log-1  info.log-5  warn.log.1
all.log-4  debug.log.2  info.log     info.log-6  warn.log.2
all.log-5  debug.log.3  info.log-1   info.log-7  warn.log.3
[root@saturn logs]# nano all.log

























  GNU nano 2.3.1               File: all.log

2025.02.18 15:57:47 INFO  [main]: org.jivesoftware.database.DbConnectionManager$
java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specificat$
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.4.1$
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.4.1$
        at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) ~[hsqldb-2.4.1$
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) ~[hsqldb-2.$
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) ~[hsqldb-2.4.1.ja$
        at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8$
        at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8$
        at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnec$
        at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(Poolab$
        at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObject$
        at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(Generic$
        at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(Generic$
        at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingData$
        at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(E$
        at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnec$
        at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.jav$
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:648) [xmp$
                              [ Read 9470 lines ]
^G Get Help  ^O WriteOut  ^R Read File ^Y Prev Page ^K Cut Text  ^C Cur Pos
^X Exit      ^J Justify   ^W Where Is  ^V Next Page ^U UnCut Text^T To Spell




























































To access your Issabel System, using a separate workstation (PC/MAC/Linux)
Open the Internet Browser using the following URL:


Your opportunity to give back: http://www.patreon.com/issabel

System load:  0.00 (1min) 0.03 (5min) 0.07 (15min)        Uptime:  6 days
Asterisk:     Asterisk 16.16.1                      Active Calls:  0
Memory:       [===>---------------------------------------------]   8% 643/7890M
Usage on /:   [=============>-----------------------------------]  27% 226/909G
Swap usage:   0.0%
SSH logins:   1 open sessions
Processes:    194 total, 149 yours

[root@saturn ~]#  cd /opt/openfire/logs
[root@saturn logs]# ls
all.log    all.log-6    debug.log.4  info.log-2  nohup.out     warn.log.4
all.log-1  all.log-7    debug.log.5  info.log-3  openfire.log  warn.log.5
all.log-2  debug.log    error.log    info.log-4  warn.log
all.log-3  debug.log.1  error.log-1  info.log-5  warn.log.1
all.log-4  debug.log.2  info.log     info.log-6  warn.log.2
all.log-5  debug.log.3  info.log-1   info.log-7  warn.log.3
[root@saturn logs]# nano all.log

































































































  GNU nano 2.3.1               File: all.log

2025.02.18 15:57:47 INFO  [main]: org.jivesoftware.database.DbConnectionManager$
java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specificat$
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.4.1$
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.4.1$
        at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) ~[hsqldb-2.4.1$
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) ~[hsqldb-2.$
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) ~[hsqldb-2.4.1.ja$
        at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8$
        at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8$
        at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnec$
        at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(Poolab$
        at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObject$
        at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(Generic$
        at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(Generic$
        at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingData$
        at org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(E$
        at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnec$
        at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.jav$
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:648) [xmp$
                              [ Read 9470 lines ]
^G Get Help  ^O WriteOut  ^R Read File ^Y Prev Page ^K Cut Text  ^C Cur Pos
^X Exit      ^J Justify   ^W Where Is  ^V Next Page ^U UnCut Text^T To Spell




































  GNU nano 2.3.1                                            File: all.log

2025.02.18 15:57:49 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.SQ$
        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_202]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_202]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_202]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [?:1.8.0_202]
        at java.lang.Class.newInstance(Class.java:442) [?:1.8.0_202]
        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]
2025.02.18 15:57:49 ERROR [main]: org.jivesoftware.openfire.XMPPServer - java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 1$
java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the las$
        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_202]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_202]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_202]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [?:1.8.0_202]
        at java.lang.Class.newInstance(Class.java:442) [?:1.8.0_202]
        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: $
        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
2025.02.18 15:57:49 INFO  [Thread-2]: org.jivesoftware.openfire.XMPPServer - Server halted
2025.02.18 16:07:42 INFO  [main]: org.jivesoftware.openfire.XMPPServer - Registering shutdown hook (standalone mode)
2025.02.18 16:07:42 ERROR [main]: org.jivesoftware.database.DbConnectionManager - invalid authorization specification - not found: SA
java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specification - not found: SA
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
        at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
        at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
        at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) ~[hsqldb-2.4.1.jar:2.4.1]
        at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_202]
        at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_202]
        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.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:65) ~[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]

^G Get Help                 ^O WriteOut                 ^R Read File                ^Y Prev Page                ^K Cut Text                 ^C Cur Pos
^X Exit                     ^J Justify                  ^W Where Is                 ^V Next Page                ^U UnCut Text               ^T To Spell

Quaz

Hi Quaz,

Thanks! Next time, try using the commands less or cat which will dump the content of the log files to screen (instead of open it in a text editor like nano). That’s generally easier to copy/paste!

It appears that Openfire is using invalid credentials when trying to access its database. It also seems to be using the embedded database. I don’t think that even uses credentials that are configurable. That’s all quite puzzling.

Did you somehow modify the database or its configuration manually?

I believe I may have. I opened it once and I don’t know if I saved a password or not. But since then, it doesn’t open. Can I fix it or should uninstall and re-install? If so how would i uninstall? I’m new to linux as you know. Thank you for the less/cat tip. I did not know.

Quaz

Hmm, I’ve never dealt with that before. Do you have backups that you can restore? If not, then you may want to compare the content of your files with one of a fresh install, to see if you can manually revert any unwanted changes. The chances of that succeeding aren’t very high.

If the system isn’t in use yet, you could replace it completely, by uninstalling and reinstalling. I’m not sure how you installed it, but that procedure can typically be reverted. It depends a little on the package manager that your operating system uses. Afterwards, ensure that the installation directory (I’m guessing that this will be /opt/openfire/ in your system, but it might be different) is indeed empty.

Reinstalling would probably not entail more than running the installer again.

Thank You, Guus.

Guus,

How do I download directly from your site in Linux, please?

Danke,
Quaz

Do you want to download from a command-line interface? Typically, using tools like wget or curl will do the trick. It’s probably easiest to use that with the URLs for any of the downloads provided on Releases · igniterealtime/Openfire · GitHub