Openfire don't restart after reboot

rix · August 24, 2020, 4:53pm

Hello,

I have restarted my server and openfire don’t want restart

 /etc/init.d/openfire start
best java alternative in:
Starting openfire: openfire.

i think java was not detected

 java -version
openjdk version "11.0.8" 2020-07-14
OpenJDK Runtime Environment (build 11.0.8+10-post-Debian-1deb10u1)
OpenJDK 64-Bit Server VM (build 11.0.8+10-post-Debian-1deb10u1, mixed mode)

i have update openfire, but it’s same.

dpkg -i openfire_4.5.3_all.deb
(Lecture de la base de données... 50264 fichiers et répertoires déjà installés.)
Préparation du dépaquetage de openfire_4.5.3_all.deb ...
Dépaquetage de openfire (4.5.3) sur (4.4.3) ...
Paramétrage de openfire (4.5.3) ...
Traitement des actions différées (« triggers ») pour systemd (241-7~deb10u4) ...

guus · August 25, 2020, 7:04am

That data that you’re providing does not contain much information that can be used to diagnose the problem. Please review the logfiles in <openfire_home>/logs/all.log

rix · August 25, 2020, 7:34am

2020.08.24 18:44:19 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.SQLException: The server time zone value 'CEST' 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.3.jar:4.5.3]
        at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1027) [xmppserver-4.5.3.jar:4.5.3]
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:680) [xmppserver-4.5.3.jar:4.5.3]
        at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:268) [xmppserver-4.5.3.jar:4.5.3]
        at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:?]
        at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:490) [?:?]
        at java.lang.Class.newInstance(Class.java:584) [?:?]
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:4.5.3]
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:4.5.3]
2020.08.24 18:44:19 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 'CEST' 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 'CEST' 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.3.jar:4.5.3]
        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:680) [xmppserver-4.5.3.jar:4.5.3]
        at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:268) [xmppserver-4.5.3.jar:4.5.3]
        at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:?]
        at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:?]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:490) [?:?]
        at java.lang.Class.newInstance(Class.java:584) [?:?]
        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:92) [startup.jar:4.5.3]
        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:4.5.3]
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 'CEST' 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.3.jar:4.5.3]
        at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1027) ~[xmppserver-4.5.3.jar:4.5.3]
        ... 9 more

thanks

guus · August 25, 2020, 8:11am

I expect that you’re using MySQL, which was recently upgraded. You will need to define (or change) a parameter in the JDBC connection string, to set the time zone to a recognized value, something like &serverTimezone=UTC

See https://discourse.igniterealtime.org/t/the-server-time-zone-value-cest-is-unrecognized-or-represents-more-than-one-time-zone/

rix · August 25, 2020, 10:41am

thanks now i can start openfire

but…

impossible to connect spark…
i open admin console http://localhost:9090 and i see setup page same as new install
i configure all the setup page and at and i have this message

Unable to save conf/openfire.xml file - check that it is writable

on my config, openfire.xml isn’t in conf/ directory

 find / -name "openfire.xml"
/etc/openfire/openfire.xml

in all.log

2020.08.25 12:09:14 ERROR [Jetty-QTP-AdminConsole-25]: org.jivesoftware.util.XMLProperties - Unable to save XML properties; no file specified
2020.08.25 12:09:20 ERROR [Jetty-QTP-AdminConsole-25]: org.jivesoftware.util.XMLProperties - Unable to save XML properties; no file specified
2020.08.25 12:11:30 ERROR [Jetty-QTP-AdminConsole-23]: org.jivesoftware.util.XMLProperties - Unable to save XML properties; no file specified

guus · August 25, 2020, 11:00am

It’s hard to tell what’s going on without having access to the machine. As the error says, this could be some kind of file permission error - but it could be anything.

It’s probably best to restore your environment from a backup, if you have any, and retry.

speedy · August 25, 2020, 11:21am

you can set the timezone in the my.conf file for the whole server.
simply add
default-time-zone = ‘TIMEZONE’
for example:
default-time-zone = ‘America/Chicago’

rix · August 25, 2020, 6:02pm

impossible to know why is unable to save ?

i do chmod -R 777 on /etc/openfire and it’s the same

why in conf/openfire.xml ?

and where is conf/openfire.xml ? in /etc/openfire/conf/openfire.xml ?

can i uninstall and reinstall openfire ? how ?

thanks for help me , i am in despear

rix · August 26, 2020, 7:06am

it’s ok for me !!!
i have do:

 apt-get --purge remove openfire

 rm -Rf /usr/share/openfire/

 dpkg -i openfire_4.5.3_all.deb

and reconfigure the webadmin setupd and it’s good