Re: [PostgreSQL-Brasil] Java + PostGre

Wed, 23 Aug 2006 11:30:35 -0700

Vc precisa falar par o PostgreSQL que ele deve aceitar conexões de outras máquinas da rede, só isso.
 
Abra o arquivo DATA/pg_hba.conf
 
Coloque essa linha nele. Procure na documentação o que significa cada parametro.
 
#Para aceitar conexões de dos ips 10.0.0.x e dos ips 192.168.0.x
host  all  all  10.0.0.0  255.255.255.0  md5
host  all  all  192.168.0.0  255.255.255.0  md5
 
Depois, no DATA/postgresql.conf verifique se o postgres esta configurado para "escutar" este IP alterando o parâmetro:
 
listen_addresses = '*'
 
Além disso, certifique-se de que o servidor do postgreSQL está sendo inicializado com o parâmetro "-i" que aceita conexões TCP/IP.
 
Alem é claro de ver se nao tem nenhum firewall bloqueando o acesso a porta do postgres (normalmente a 5432) no micro onde esta instalado o postgres e no micro onde está rodando a aplicação.
 
Abraços.
 
Nelson Pereira Júnior
 
----- Original Message -----
Sent: Wednesday, August 23, 2006 2:24 PM
Subject: Re: [PostgreSQL-Brasil] pg e delphi 7 + ADO + ODBC

e no postgresql.conf verifique se o postgres esta configurado para "escutar" neste IP ( listen_addresses = '*' , habilita o postgres em todos os ips da maquina)
alem é claro de ver se nao tem nenhum firewall bloqueando o acesso a porta do postgres (normalmente a 5432) no micro onde esta instalado o postgres

Em 23/08/06, Nelson Pereira Júnior <[EMAIL PROTECTED]> escreveu:
 
Abraços,
----- Original Message -----
Sent: Wednesday, August 23, 2006 3:16 PM
Subject: [PostgreSQL-Brasil] Java + PostGre

Olá pessoal!
Banco de Dados: PosteGreSQL 8
Linguagem de programação: Java
 
Estou tentando rodar meu arquivo .jar em um micro e o banco de dados está em outro micro, porém ocorre o seguinte erro:
Se alguém puder me ajudar agradeço!
 
***********

C:\Transferência_Zu\Sistema SSTintas>java -jar sstintas.jar
org.postgresql.util.PSQLException: ConexÒo negada. Verifique se o nome da mßquin
a e a porta estÒo corretos e se o postmaster estß aceitando conex§es TCP/IP.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne
ctionFactoryImpl.java:122)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor
y.java:65)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Conn
ection.java:117)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Conn
ection.java:30)
        at org.postgresql.jdbc3.Jdbc3Connection .<init>(Jdbc3Connection.java:24)
        at org.postgresql.Driver.connect(Driver.java:195)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at br.com.sstintas.modelo.bd.GerenciadorBD.getConexao(GerenciadorBD.java
:19)
        at br.com.sstintas.modelo.bd.GerenciadorBDFuncionario.consultaUsuarioSen
ha(GerenciadorBDFuncionario.java:293)
        at br.com.sstintas.view.AcessoView$2.actionPerformed(AcessoView.java:154
)
        at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
        at javax.swing.AbstractButton$Handler.actionPerformed (Unknown Source)
        at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased (Unknown Sour
ce)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent (Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent (Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect (Unknown Source)
        at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
        at java.net.PlainSocketImpl.connect(Unknown Source)
        at java.net.SocksSocketImpl.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.connect(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at java.net.Socket.<init>(Unknown Source)
        at org.postgresql.core.PGStream.<init>(PGStream.java:58)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne
ctionFactoryImpl.java:77)
        ... 34 more
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
        at br.com.sstintas.modelo.bd.GerenciadorBDFuncionario.consultaUsuarioSen
ha(GerenciadorBDFuncionario.java:293)
        at br.com.sstintas.view.AcessoView$2.actionPerformed(AcessoView.java :154
)
        at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
        at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.fireActionPerformed (Unknown Source)
        at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
ce)
        at java.awt.Component.processMouseEvent (Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent (Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl (Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)
**************

 




--
---------------------------
Márcia Regina

_______________________________________________
Grupo de Usuários do PostgreSQL no Brasil
Antes de perguntar consulte o manual
http://pgdocptbr.sourceforge.net/

Para editar suas opções ou sair da lista acesse a página da lista em:
http://pgfoundry.org/mailman/listinfo/brasil-usuarios
_______________________________________________
Grupo de Usuários do PostgreSQL no Brasil
Antes de perguntar consulte o manual
http://pgdocptbr.sourceforge.net/

Para editar suas opções ou sair da lista acesse a página da lista em:
http://pgfoundry.org/mailman/listinfo/brasil-usuarios

Responder a