Do not connect to openfire server

General Discussion Brasil
1

I have the problem:

Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.

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: org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)

at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:423)

at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:163)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reErro iniciando o servidor. Por favor verifique os arquivos de log para mais informações.

flect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)

at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65)

at com.exe4j.runtime.WinLauncher.main(WinLauncher.java:101)

at com.install4j.runtime.launcher.WinLauncher.main(WinLauncher.java:26)

Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: org.postgresql.util.PSQLException: Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:156)

at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:690)

… 16 more

Server halted

2

Hi, you are a brazilian person aren’t you?

If you are not, tell me i’ll write in English.

Sobre o erro: Connection to 127.0.0.1:5432 refused

Então, como é sua instalação, está usando banco de dados interno, externo, tem antivírus ou outros programas que possam estar usando a mesma porta?

3

sempre funcionou normal, hoje que deu esse erro. O openfire trabalha dentro do servidor da minha empresa.

4

Boa tarde, então:

Connection to 127.0.0.1:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Conexão recusada, verificar hostname, porta, e se está aceitando conexões tcp/ip, o que poderia estar causando isso seria algum Software de antivírus bloqueando a conexão, ou algum outro programa usando a porta 5432, assim dando conflito. Você tem outros serviços rodando junto do openfire, já tentou reiniciar o servidor, desabilitar o firewall do Windows, roda o comando net stat -a no cmd para ver as portas em escuta e garantir que não seja conflito.

5

No outro dia, o firewall no servidor que executamos o openfire removeu a regra que estava abrindo as portas para o Openfire sem motivo. Certifique-se de que as portas ainda estão abertas.