Обсуждение: BUG #13521: refused connection to host and port

Поиск
Список
Период
Сортировка

BUG #13521: refused connection to host and port

От
adfuser321@gmail.com
Дата:
The following bug has been logged on the website:

Bug reference:      13521
Logged by:          guestUser
Email address:      adfuser321@gmail.com
PostgreSQL version: 9.4.4
Operating system:   Linux
Description:

Hi,

Trying to connect to Postgresql database running on remote machine using
jdeveloper.

Using 8.1 jdbc driver and exception noticed is below, tried latest and old
driver for all the drivers it gives same error.

Test failed: Connection refused. Check that the hostname and port are
correct and that the postmaster is accepting TCP/IP connections.
Exception: java.net.ConnectException: Connection refused
Stack Trace:
java.net.ConnectException: Connection refused
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
    at java.net.Socket.connect(Socket.java:529)
    at java.net.Socket.connect(Socket.java:478)
    at java.net.Socket.<init>(Socket.java:375)
    at java.net.Socket.<init>(Socket.java:189)
    at org.postgresql.core.PGStream.<init>(PGStream.java:60)
    at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
    at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
    at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
    at org.postgresql.jdbc2.Jdbc2Connection.<init>(Jdbc2Connection.java:24)
    at org.postgresql.Driver.makeConnection(Driver.java:369)
    at org.postgresql.Driver.connect(Driver.java:245)
    at
oracle.jdeveloper.db.adapter.AbstractConnectionCreator.getConnection(AbstractConnectionCreator.java:172)
    at sun.reflect.GeneratedMethodAccessor272.invoke(Unknown Source)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at
oracle.jdevimpl.db.extension.DatabaseConnectionHook$ConnectionType$1.invoke(DatabaseConnectionHook.java:205)
    at $Proxy2.getConnection(Unknown Source)
    at
oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:331)
    at
oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:260)
    at
oracle.jdeveloper.db.DatabaseConnections.testConnection(DatabaseConnections.java:1077)
    at
oracle.jdevimpl.db.panels.ConnectionEditorPanel$ConnectionTester.doWork(ConnectionEditorPanel.java:749)
    at oracle.ide.dialogs.ProgressRunnable.run(ProgressRunnable.java:161)
    at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
    at java.lang.Thread.run(Thread.java:662)
End of Stack Trace

Re: BUG #13521: refused connection to host and port

От
Venkata Balaji N
Дата:
On Tue, Jul 28, 2015 at 5:56 PM, <adfuser321@gmail.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13521
> Logged by:          guestUser
> Email address:      adfuser321@gmail.com
> PostgreSQL version: 9.4.4
> Operating system:   Linux
> Description:
>
> Hi,
>
> Trying to connect to Postgresql database running on remote machine using
> jdeveloper.
>
> Using 8.1 jdbc driver and exception noticed is below, tried latest and old
> driver for all the drivers it gives same error.
>
> Test failed: Connection refused. Check that the hostname and port are
> correct and that the postmaster is accepting TCP/IP connections.
> Exception: java.net.ConnectException: Connection refused
> Stack Trace:
> java.net.ConnectException: Connection refused
>         at java.net.PlainSocketImpl.socketConnect(Native Method)
>         at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
>         at
> java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
>         at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
>         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
>         at java.net.Socket.connect(Socket.java:529)
>         at java.net.Socket.connect(Socket.java:478)
>         at java.net.Socket.<init>(Socket.java:375)
>         at java.net.Socket.<init>(Socket.java:189)
>         at org.postgresql.core.PGStream.<init>(PGStream.java:60)
>         at
>
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
>         at
>
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
>         at
>
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:116)
>         at
> org.postgresql.jdbc2.Jdbc2Connection.<init>(Jdbc2Connection.java:24)
>         at org.postgresql.Driver.makeConnection(Driver.java:369)
>         at org.postgresql.Driver.connect(Driver.java:245)
>         at
>
> oracle.jdeveloper.db.adapter.AbstractConnectionCreator.getConnection(AbstractConnectionCreator.java:172)
>         at sun.reflect.GeneratedMethodAccessor272.invoke(Unknown Source)
>         at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at
>
> oracle.jdevimpl.db.extension.DatabaseConnectionHook$ConnectionType$1.invoke(DatabaseConnectionHook.java:205)
>         at $Proxy2.getConnection(Unknown Source)
>         at
>
> oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:331)
>         at
>
> oracle.jdeveloper.db.adapter.DatabaseProvider.getConnection(DatabaseProvider.java:260)
>         at
>
> oracle.jdeveloper.db.DatabaseConnections.testConnection(DatabaseConnections.java:1077)
>         at
>
> oracle.jdevimpl.db.panels.ConnectionEditorPanel$ConnectionTester.doWork(ConnectionEditorPanel.java:749)
>         at
> oracle.ide.dialogs.ProgressRunnable.run(ProgressRunnable.java:161)
>         at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
>         at java.lang.Thread.run(Thread.java:662)
> End of Stack Trace
>

PostgreSQL database connections fails due to several reasons. Assuming that
the database is running and you are providing the correct host and port
number, what is the listen_address parameter value ? The PostgreSQL port
needs to be opened in-order to accept remote connections.

Regards,

Venkata B N
Fujitsu Australia