Re: trying to connect to pg from within a local network

["Albretch Mueller" <lbrtchx(at)gmail(dot)com>]

 Now, I am also getting "connection refused" messages even though I do
know  tc is running since I can check it with pdAdmin3
~
~
org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting
TCP/IP connections.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:18)
	at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:382)
	at org.postgresql.Driver.connect(Driver.java:260)
	at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:649)
	at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:713)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:3620)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1148)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:697)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1148)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:311)
	at org.apache.catalina.core.StandardService.start(StandardService.java:450)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:2213)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:459)
	at org.apache.catalina.startup.Catalina.execute(Catalina.java:346)
	at org.apache.catalina.startup.Catalina.process(Catalina.java:130)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:151)
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
	at java.net.Socket.connect(Socket.java:518)
	at java.net.Socket.connect(Socket.java:468)
	at java.net.Socket.<init>(Socket.java:365)
	at java.net.Socket.<init>(Socket.java:179)
	at org.postgresql.core.PGStream.<init>(PGStream.java:59)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
	... 24 more
~
 and this is the part that matters in my server.xml file:
~
        <Context path="/fileupload"

docBase="Z:\BEGIN\ESL\RLopez\GWB\prjx\GWB02\webapps12\fileupload"
                 debug="4"
                 reloadable="true"
                 crossContext="true"
                 workDir="Z:\BEGIN\ESL\RLopez\GWB\prjx\tc-4.1.36_workDir"
                 swallowOutput="true">

          <Logger className="org.apache.catalina.logger.FileLogger"
                  directory="Z:\BEGIN\ESL\RLopez\GWB\prjx\logs"
                  prefix="tc-4.1.36_localhost_FileUpload_log."
                  suffix=".txt"
                  timestamp="true"/>

                 <Realm  className="org.apache.catalina.realm.JDBCRealm"
                         driverName="org.postgresql.Driver"
                         connectionURL="jdbc:postgresql://10.0.31.5/postgres"
                         connectionName="postgres"
connectionPassword="gwbpsswrd"
                         userTable="users"
                         userNameCol="user_name"
                         userCredCol="user_pass"
                         userRoleTable="user_roles" roleNameCol="role_name"/>

        </Context>
~