agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] install problems
2+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] install problems
@ 2008-04-16 06:24  
  0 siblings, 1 reply; 2+ messages in thread

From:  @ 2008-04-16 06:24 UTC (permalink / raw)

Deployer is failing on the following call.  Any ideas?


CREATE FUNCTION sqlj.java_call_handler() 
RETURNS language_handler 
AS 'pljava' 
LANGUAGE C


ERROR:  could not access file "pljava": No such file or directory

********** Error **********

ERROR: could not access file "pljava": No such file or directory
SQL state: 58P01

My setup:

ld.so.conf (+ ldconfig ran):
 
/home/snowch/Apps/java/jdk1.6.0_10/jre/lib/i386
/home/snowch/Apps/java/jdk1.6.0_10/jre/lib/i386/client
/home/snowch/Apps/java/jdk1.6.0_10/jre/lib/i386/native_threads
/home/snowch/Apps/java/jdk1.6.0_10/jre/lib/i386/server

postgresql.conf:

dynamic_library_path =
'$libdir:/home/snowch/Apps/pljava-i686-pc-linux-gnu-pg8.3-1.4.0'
custom_variable_classes = 'pljava'
pljava.classpath =
'/home/snowch/Apps/pljava-i686-pc-linux-gnu-pg8.3-1.4.0/pljava.jar'





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* [Pljava-dev] install problems
@ 2008-04-19 22:21  
  parent: 
  0 siblings, 0 replies; 2+ messages in thread

From:  @ 2008-04-19 22:21 UTC (permalink / raw)



On Wed, 16 Apr 2008, Christopher Snow wrote:

> Deployer is failing on the following call.  Any ideas?
>
> CREATE FUNCTION sqlj.java_call_handler()
> RETURNS language_handler
> AS 'pljava'
> LANGUAGE C
>
> ERROR: could not access file "pljava": No such file or directory
>
> dynamic_library_path =
> '$libdir:/home/snowch/Apps/pljava-i686-pc-linux-gnu-pg8.3-1.4.0'

Is there any chance your home directory isn't accessible to the user the 
postgresql server is running as?  That would explain why it couldn't load 
the file.

Also there is additional dynamic library loading information available at 
the debug3 level of log_min_messages.  This will likely produce a lot of 
debug information, but may point to the problem.

Kris Jurka




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2008-04-19 22:21 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-16 06:24 [Pljava-dev] install problems 
2008-04-19 22:21 ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox