powered by Jive Software

Estava na Versão 4.0 migrei para 4.5

boa tarde, fiz a atualização do Openfire … No Linux Centos 7. Estava na versão 4.0 migrei para 4.5. Porém, o serviço gera erro no Start.

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)
Active: inactive (dead) since Sex 2020-01-17 12:02:47 BRST; 48min ago
Docs: man:systemd-sysv-generator(8)
Process: 51570 ExecStop=/etc/rc.d/init.d/openfire stop (code=exited, status=0/SUCCESS)
Process: 51512 ExecStart=/etc/rc.d/init.d/openfire start (code=exited, status=0/SUCCESS)
Main PID: 51524 (code=exited, status=0/SUCCESS)

Jan 17 12:02:40 serv_arquivo systemd[1]: Starting SYSV: Openfire is an XMPP server, which is a server that facilitates XML based communication, such as chat…
Jan 17 12:02:40 serv_arquivo su[51522]: (to daemon) root on none
Jan 17 12:02:40 serv_arquivo openfire[51512]: Starting openfire:
Jan 17 12:02:41 serv_arquivo systemd[1]: Started SYSV: Openfire is an XMPP server, which is a server that facilitates XML based communication, such as chat…
Jan 17 12:02:47 serv_arquivo openfire[51570]: Shutting down openfire: [FALHOU]

ERROR.LOG
2020.01.17 12:02:47 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 ‘BRST’ 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 ‘BRST’ 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.0.jar:4.5.0]
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:680) [xmppserver-4.5.0.jar:4.5.0]
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:268) [xmppserver-4.5.0.jar:4.5.0]
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.5.0]
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56) [startup.jar:4.5.0]
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 ‘BRST’ 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.0.jar:4.5.0]
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:1027) ~[xmppserver-4.5.0.jar:4.5.0]

Alguem pode ajudar?

Bom dia,

verifica o link abaixo

parece-me que é um problema no fuso horário, vê se resolve.

Fala fera blz? cara pode me ajudar preciso atualizar meu openfire da versão 4.1.6 para a 4.5 você tem algum step by step que seguiu? se sim pode me passar por favor? obrigado!