Openfire will not stay running on CentOS 8 Server

[root@cloud ~]# systemctl status openfire.service
● 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; generated)
Active: inactive (dead) since Thu 2020-03-26 23:44:02 PDT; 23s ago
Docs: man:systemd-sysv-generator(8)
Process: 10924 ExecStop=/etc/rc.d/init.d/openfire stop (code=exited, status=0/SUCCESS)
Process: 10723 ExecStart=/etc/rc.d/init.d/openfire start (code=exited, status=0/SUCCESS)
Main PID: 10756 (code=exited, status=0/SUCCESS)

Mar 26 23:43:53 cloud systemd[1]: Starting SYSV: Openfire is an XMPP server, which is a server that facilitates XML based communication, such as chat…
Mar 26 23:43:53 cloud su[10737]: (to daemon) root on none
Mar 26 23:43:53 cloud su[10737]: pam_unix(su:session): session opened for user daemon by (uid=0)
Mar 26 23:43:53 cloud su[10737]: pam_unix(su:session): session closed for user daemon
Mar 26 23:43:53 cloud openfire[10723]: Starting openfire:
Mar 26 23:43:54 cloud systemd[1]: Started SYSV: Openfire is an XMPP server, which is a server that facilitates XML based communication, such as chat…
Mar 26 23:44:02 cloud openfire[10924]: Shutting down openfire: [FAILED]

Please check the log files for problems. You’ll find them in /opt/openfire/logs/ or /var/log/openfire.

Here is what the latest all.log shows. I checked the timedatectl and is set for PDT and ran to change to UTC I have posted the results of that also. This is my first time installation of this application. It worked for several days until a reboot. Now it will start for 3 secs and stop. Thanks

2020.03.27 16:24:29 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.SQLException: The server time zone value ‘PDT’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
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.SQLException: The server time zone value ‘PDT’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1037) ~[xmppserver-4.5.1.jar:4.5.1]
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:680) [xmppserver-4.5.1.jar:4.5.1]
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:268) [xmppserver-4.5.1.jar:4.5.1]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_242]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_242]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_242]
at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [?:1.8.0_242]
at java.lang.Class.newInstance(Class.java:442) [?:1.8.0_242]
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:4.5.1]
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:4.5.1]
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.SQLException: The server time zone value ‘PDT’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:204) ~[xmppserver-4.5.1.jar:4.5.1]
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1027) ~[xmppserver-4.5.1.jar:4.5.1]
… 9 more

root@cloud logs]# timedatectl
Local time: Fri 2020-03-27 16:29:32 UTC
Universal time: Fri 2020-03-27 16:29:32 UTC
RTC time: Fri 2020-03-27 16:29:31
Time zone: UTC (UTC, +0000)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no
Thanks.

Thanks for monitoring and responding to the original question. I was able to fix with the following changes to the /etc/my.cnf I added the following default-time-zone = ‘+00:00’ and restart mysql and openfire and works. Thanks

2 Likes