[Pljava-dev] Re: Deployer error.

The deployer will attempt to connect to a postmaster on 'localhost' and
port 5432 if you don't specify something else (using -host and -port
options)
Apparently, that fails. Is the postmaster running? Do you see any
messages in the postmaster log? Can you use the psql command?

Regards,
Thomas Hallgren

Mncedisi Kheswa wrote:

> Hi all,
>
> After I run this commnad "$ java org.postgresql.pljava.deploy.Deployer
> -install" I get these errors :
>
>
> 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:65)
>
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:117)
>
> at
> org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
>
> at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
>
> at org.postgresql.Driver.connect(Driver.java:235)
>
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
>
> at java.sql.DriverManager.getConnection(DriverManager.java:171)
>
> at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:259)
>
> Caused by: java.net.ConnectException: Connection timed out
>
> 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:452)
>
> at java.net.Socket.connect(Socket.java:402)
>
> at java.net.Socket.<init>(Socket.java:309)
>
> at java.net.Socket.<init>(Socket.java:124)
>
> at org.postgresql.core.PGStream.<init>(PGStream.java:58)
>
> at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
>
> ... 8 more
>
> The java version is 1.4. I have included pljava.jar in CLASSPATH and
> its also in pljava.classpath in postgresql.conf.
>
> Thanks in advance.
> Paul Kheswa.
>
> */Thomas Hallgren <thhal at mailblocks.com>/* wrote:
>
> Right. And I just saw that the usage string printed by the deployer
> states that the -jar option should be used. It won't work since
> running
> java with a -jar option ignores a remote classpath setting. It
> assumes
> that the classpath has been set in the manifest. It isn't since I
> have
> no way of knowing what PostgreSQL driver that will be used or
> where it's
> located.
>
> So, please ignore the "java -jar" suggestion printed by the deployer
> command usage string. It's incorrect.
>
> - thomas
>
> Edward Yakop wrote:
>
> >Whoops,
> >
> >He actually need the deploy.jar. But you're right. I made a
> mistake on
> >the java -jar option.
> >
> >Sorry,
> >Edward Yakop
> >
> >On 9/5/05, Thomas Hallgren wrote:
> >
> >
> >>Sorry, let me correct that. You don't use the -jar option. That
> was in
> >>Edward's example :-)
> >>
> >>Please tell me the exact error message and provide a stack
> backtrace.
> >>
> >>- thomas
> >>
> >>Thomas Hallgren wrote:
> >>
> >>
> >>
> >>>Actually, that advice is incorrect. pljava.jar is not needed by the
> >>>deployer client program. It must only be seen by the backend
> server.
> >>>
> >>>The problem is that you use the -jar option. You should not use the
> >>>-jar option when running the deployer. Given that the CLASSPATH
> is set
> >>>the way you describe you should try this instead:
> >>>
> >>>java org.postgresql.pljava.deploy.Deployer -install
> >>>
> >>>Regards,
> >>>Thomas Hallgren
> >>>
> >>>
> >>>Edward Yakop wrote:
> >>>
> >>>
> >>>
> >>>>Hi,
> >>>>
> >>>>You need to add pljava.jar inside the $CLASSPATH
> >>>>`java -jar org.postgresql.pljava.deploy.Deployer -install`,
> otherwise
> >>>>`java -cp ${DIR_TO_PLJAVA_JAR}/pljava.jar
> >>>>org.postgresql.pljava.deploy.Deployer -install`
> >>>>
> >>>>Regards,
> >>>>Edward Yakop
> >>>>
> >>>>On 9/5/05, Mncedisi Kheswa wrote:
> >>>>
> >>>>
> >>>>
> >>>>>Hi all,
> >>>>>If anyone can help. I have installed Java with Postgres SQL
> Server
> >>>>>on Linux
> >>>>>8.0 and when trying to run # java
> >>>>>org.postgresql.pljava.deploy.Deployer -install I get
> >>>>>"NoClassDef in main error". Written a simple java program and it
> >>>>>runs fine.
> >>>>>Here's my /etc/profile environment variables :
> >>>>>JAVA_HOME=/usr/local/j2sdk1.4.2
> >>>>>POSTGRES_HOME=/usr/local/pgsql
> >>>>>PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$POSTGRES_HOME/bin:$PATH
> >>>>>CLASSPATH=.:/usr/local/pljava/deploy.jar:/usr/local/pgsql/share/java/postgresql-8.0-312.jdbc3.jar
> >>>>>
> >>>>>LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/client:$JAVA_HOME/jre/lib/i386/server:$JAVA_HOME/jre/lib/i386/native_threads
> >>>>>
> >>>>>
> >>>>>/usr/local/pgsql/data/postgresql.conf file :
> dynamic_library_path =
> >>>>>'$libdir:/usr/local/pljava/'
> >>>>>custom_variable_classes = 'pljava'
> >>>>>log_min_messages = info
> >>>>>pljava.classpath = '/usr/local/pljava/pljava.jar'
> >>>>>pljava.statement_cache_size = 10
> >>>>>pljava.release_lingering_savepoints = true
> >>>>>pljava.vmoptions = '-Xmx64M'
> >>>>>pljava.debug = false
> >>>>>
> >>>>>Postgres database and Java are both installed and working.
> pljava is
> >>>>>installed under /usr/local/ - can check pljava.classpath value
> >>>>>above.
> >>>>>Maybe I'm missing something, please help.
> >>>>>Thanks in advance.
> >>>>>
> >>>>>__________________________________________________
> >>>>>Do You Yahoo!?
> >>>>>Tired of spam? Yahoo! Mail has the best spam protection around
> >>>>>http://mail.yahoo.com
> _______________________________________________
> >>>>>Pljava-dev mailing list
> >>>>>Pljava-dev at gborg.postgresql.org
> >>>>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>_______________________________________________
> >>>Pljava-dev mailing list
> >>>Pljava-dev at gborg.postgresql.org
> >>>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
> >>>
> >>>
> >>
> >>
> >>
> >>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>