Re: socket problem - Mailing list pgsql-jdbc
| From | Scot P. Floess |
|---|---|
| Subject | Re: socket problem |
| Date | |
| Msg-id | 3E6CC7D4.2080805@mindspring.com Whole thread Raw |
| In response to | socket problem ("Brian Harris" <brian.harris@optdatainc.com>) |
| List | pgsql-jdbc |
Brian:
You have to make sure postgres will accept sockets. You can do this either by enabling in postgresql.conf (set tcpip_socket = true) or when you start postgress in your /etc/rc.d/init.d/postgres shell script.
Scot
PS: when you enable the socket setting, make sure you start/stop postgres...
Brian Harris wrote:
You have to make sure postgres will accept sockets. You can do this either by enabling in postgresql.conf (set tcpip_socket = true) or when you start postgress in your /etc/rc.d/init.d/postgres shell script.
Scot
PS: when you enable the socket setting, make sure you start/stop postgres...
Brian Harris wrote:
I can connect with psql and do anything I want locally. I ran netstat, but didn't see anything matching 5432. Would there be any reason it wouldn't be running on 5432? I am running redhat 7.3 advanced server.
----- Original Message -----From: Scot P. FloessTo: Brian HarrisSent: Monday, March 10, 2003 10:10 AMSubject: Re: [JDBC] socket problemBrian:
Can you connect using psql? Also, make sure you are using the default port where postgres is running - as I can see by your URI that you are using the default port. One other thing, you could try netstat on the machine where postgres is running to make sure it is listening on the port you assume it is.
Scot
Brian Harris wrote:
> when I try to connect via remote host I get this error:
>
> The connection attempt failed because Exception:
> java.net.SocketException: Connection reset by peer: connect
> Stack Trace:
> java.net.SocketException: Connection reset by peer: connect
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
> at
> java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
> at java.net.Socket.connect(Socket.java:426)
> at java.net.Socket.connect(Socket.java:376)
> at java.net.Socket.<init>(Socket.java:291)
> at java.net.Socket.<init>(Socket.java:119)
> at org.postgresql.PG_Stream.<init>(PG_Stream.java:38)
> at
> org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:160)
> at org.postgresql.Driver.connect(Driver.java:122)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:193)
> at optdata.zbeans.ZServerJdbc.createConnection(ZServerJdbc.java:85)
> at atrs.utility.dbclean.CvtReti.<init>(CvtReti.java:29)
> at atrs.utility.dbclean.CvtReti.main(CvtReti.java:161)
> End of Stack Trace
> at
> org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:171)
> at org.postgresql.Driver.connect(Driver.java:122)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:193)
> at optdata.zbeans.ZServerJdbc.createConnection(ZServerJdbc.java:85)
> at atrs.utility.dbclean.CvtReti.<init>(CvtReti.java:29)
> at atrs.utility.dbclean.CvtReti.main(CvtReti.java:161)
> java.lang.NullPointerException
> at atrs.utility.dbclean.CvtReti.<init>(CvtReti.java:30)
> at atrs.utility.dbclean.CvtReti.main(CvtReti.java:161)
> My connection string looks like this:
> jdbc:postgresql://190.85.90.37/test?user=BrianH
> postmaster started with -i
> Anybody seen anything like this before??Please help.-- Scot P. Floess - 27 Lake Royale - Louisburg, NC 27549 - 252-478-8087 Open Source Home Page -------------------------------------- http://javapim.sourceforge.net http://jplate.sourceforge.net http://jwaretechniques.sourceforge.net Open Source Project Host ----------------------------------------------- http://sourceforge.net/projects/javapim http://sourceforge.net/projects/jplate http://sourceforge.net/projects/jwaretechniques
-- Scot P. Floess - 27 Lake Royale - Louisburg, NC 27549 - 252-478-8087 Open Source Home Page -------------------------------------- http://javapim.sourceforge.net http://jplate.sourceforge.net http://jwaretechniques.sourceforge.net Open Source Project Host ----------------------------------------------- http://sourceforge.net/projects/javapim http://sourceforge.net/projects/jplate http://sourceforge.net/projects/jwaretechniques
pgsql-jdbc by date: