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?
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
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.
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.
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