From: thhal at mailblocks.com (Thomas Hallgren)
Date: Tue, 06 Sep 2005 08:30:08 +0200
Subject: [Pljava-dev] Re: Deployer error.
In-Reply-To: <20050906052515.69034.qmail@web60215.mail.yahoo.com>
References: <20050906052515.69034.qmail@web60215.mail.yahoo.com>
	<431D3770.9010505@mailblocks.com>
	<thhal-08s/4Axuw8LQ7N8Gd6Ra3R1PaDo4RxD@mailblocks.com>
Message-ID: <thhal-088/4Ax2w8LQ8NxiwK2RHoKbqlCoT98@mailblocks.com>

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
>