agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] PostgreSQL is unable to load the libpljava.so
8+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] PostgreSQL is unable to load the libpljava.so
@ 2005-10-27 06:55 
  2005-10-27 08:08 ` [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
  2005-10-27 11:31 ` [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
  0 siblings, 2 replies; 8+ messages in thread

From:  @ 2005-10-27 06:55 UTC (permalink / raw)

Hello
I?m trying to install PLJAVA in PostgreSQL 8.0 (Red hat 9) but I can?t install 
because I get an error loading libpljava.so.
I have defined the JAVA_HOME, the PATH, the LD_LIBRARY_PATH and CLASSPATH 
environment variables but I get the error

java.sql.SQLException :ERROR: could not load 
library "/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared 
object file: No such file or directory

JAVA_HOME=/usr/java/jre1.5.0_01
PATH=$PATH:.:$JAVA_HOME/lib/i386/server:$JAVA_HOME/bin
LD_LIBRARY_PATH=$JAVA_HOME/lib/i386:$JAVA_HOME/lib/i386/client:$JAVA_HOME/lib/i3
86/native_threads

Any help would be very appreciate becuase I have spent a lot of time trying to 
install and I don?t know what is wrong

Thanks in advance







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

* [Pljava-dev] PostgreSQL is unable to load the libpljava.so
  2005-10-27 06:55 [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
@ 2005-10-27 08:08 ` 
  1 sibling, 0 replies; 8+ messages in thread

From:  @ 2005-10-27 08:08 UTC (permalink / raw)

Hi Nacho,
Your LD_LIBRARY_PATH looks correct. Are you sure it's exported and 
available to the postmaster when it boots up?

Why do you have $JAVA_HOME/lib/i386/server in your PATH?

Regards,
Thomas Hallgren

Nacho wrote:
> Hello
> I?m trying to install PLJAVA in PostgreSQL 8.0 (Red hat 9) but I can?t install 
> because I get an error loading libpljava.so.
> I have defined the JAVA_HOME, the PATH, the LD_LIBRARY_PATH and CLASSPATH 
> environment variables but I get the error
>
> java.sql.SQLException :ERROR: could not load 
> library "/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared 
> object file: No such file or directory
>
> JAVA_HOME=/usr/java/jre1.5.0_01
> PATH=$PATH:.:$JAVA_HOME/lib/i386/server:$JAVA_HOME/bin
> LD_LIBRARY_PATH=$JAVA_HOME/lib/i386:$JAVA_HOME/lib/i386/client:$JAVA_HOME/lib/i3
> 86/native_threads
>
> Any help would be very appreciate becuase I have spent a lot of time trying to 
> install and I don?t know what is wrong
>
> Thanks in advance
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>   





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

* [Pljava-dev] PostgreSQL is unable to load the libpljava.so
  2005-10-27 06:55 [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
@ 2005-10-27 11:31 ` 
  1 sibling, 0 replies; 8+ messages in thread

From:  @ 2005-10-27 11:31 UTC (permalink / raw)


On 27 Oct 2005, at 01:55, Nacho wrote:

> Hello
> I?m trying to install PLJAVA in PostgreSQL 8.0 (Red hat 9) but I can 
> ?t install
> because I get an error loading libpljava.so.
> I have defined the JAVA_HOME, the PATH, the LD_LIBRARY_PATH and  
> CLASSPATH
> environment variables but I get the error
>
> java.sql.SQLException :ERROR: could not load
> library "/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot  
> open shared
> object file: No such file or directory
>
> JAVA_HOME=/usr/java/jre1.5.0_01
> PATH=$PATH:.:$JAVA_HOME/lib/i386/server:$JAVA_HOME/bin
> LD_LIBRARY_PATH=$JAVA_HOME/lib/i386:$JAVA_HOME/lib/i386/client: 
> $JAVA_HOME/lib/i3
> 86/native_threads

Do you have something similar to the following in your  
postgresql.conf file?

dynamic_library_path = '$libdir:/usr/local/pgsql/lib/pljava'



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

* [Pljava-dev] PostgreSQL is unable to load the libpljava.so
@ 2005-10-27 08:19 
  2005-10-27 11:23 ` [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
  0 siblings, 1 reply; 8+ messages in thread

From:  @ 2005-10-27 08:19 UTC (permalink / raw)

Hi Thomas

>Your LD_LIBRARY_PATH looks correct. Are you sure it's exported and 
>available to the postmaster when it boots up?
I have a shell script in which I define the environment variables and EXPORT them

>Why do you have $JAVA_HOME/lib/i386/server in your PATH?
Only other test

Regards Nacho


-----Mensaje original-----
De: Thomas Hallgren [mailto:thomas at tada.se]
Enviado el: jueves, 27 de octubre de 2005 9:56
Para: Ignacio L?zaro
CC: pljava-dev at gborg.postgresql.org
Asunto: Re: [Pljava-dev] PostgreSQL is unable to load the libpljava.so


Hi Nacho,
Your LD_LIBRARY_PATH looks correct. Are you sure it's exported and 
available to the postmaster when it boots up?

Why do you have $JAVA_HOME/lib/i386/server in your PATH?

Regards,
Thomas Hallgren

Nacho wrote:
> Hello
> I?m trying to install PLJAVA in PostgreSQL 8.0 (Red hat 9) but I can?t install 
> because I get an error loading libpljava.so.
> I have defined the JAVA_HOME, the PATH, the LD_LIBRARY_PATH and CLASSPATH 
> environment variables but I get the error
>
> java.sql.SQLException :ERROR: could not load 
> library "/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot open shared 
> object file: No such file or directory
>
> JAVA_HOME=/usr/java/jre1.5.0_01
> PATH=$PATH:.:$JAVA_HOME/lib/i386/server:$JAVA_HOME/bin
> LD_LIBRARY_PATH=$JAVA_HOME/lib/i386:$JAVA_HOME/lib/i386/client:$JAVA_HOME/lib/i3
> 86/native_threads
>
> Any help would be very appreciate becuase I have spent a lot of time trying to 
> install and I don?t know what is wrong
>
> Thanks in advance
>
>
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>   




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

* [Pljava-dev] PostgreSQL is unable to load the libpljava.so
  2005-10-27 08:19 [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
@ 2005-10-27 11:23 ` 
  0 siblings, 0 replies; 8+ messages in thread

From:  @ 2005-10-27 11:23 UTC (permalink / raw)

Ignacio L?zaro wrote:
> Hi Thomas
>
>   
>> Your LD_LIBRARY_PATH looks correct. Are you sure it's exported and 
>> available to the postmaster when it boots up?
>>     
> I have a shell script in which I define the environment variables and EXPORT them
>   
And this is the script that is used when you start the backend? I'm 
asking this because I've had discussions before where similar scripts 
was used on the client side. They don't have much effect there.

Regards,
Thomas Hallgren





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

* [Pljava-dev] PostgreSQL is unable to load the libpljava.so
@ 2005-10-27 12:05 
  0 siblings, 0 replies; 8+ messages in thread

From:  @ 2005-10-27 12:05 UTC (permalink / raw)

Hi
I have defined in postgresql.conf the dynamic_library_path variable
dynamic_library_path='$libdir:/var/lib/pgsql/pljava:/usr/java/jre1.5.0_01/bin/i386/client'

Nacho

-----Mensaje original-----
De: Rakesh Vidyadharan [mailto:rakesh at rakeshv.org]
Enviado el: jueves, 27 de octubre de 2005 13:31
Para: Ignacio L?zaro
CC: pljava-dev at gborg.postgresql.org
Asunto: Re: [Pljava-dev] PostgreSQL is unable to load the libpljava.so



On 27 Oct 2005, at 01:55, Nacho wrote:

> Hello
> I?m trying to install PLJAVA in PostgreSQL 8.0 (Red hat 9) but I can 
> ?t install
> because I get an error loading libpljava.so.
> I have defined the JAVA_HOME, the PATH, the LD_LIBRARY_PATH and  
> CLASSPATH
> environment variables but I get the error
>
> java.sql.SQLException :ERROR: could not load
> library "/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot  
> open shared
> object file: No such file or directory
>
> JAVA_HOME=/usr/java/jre1.5.0_01
> PATH=$PATH:.:$JAVA_HOME/lib/i386/server:$JAVA_HOME/bin
> LD_LIBRARY_PATH=$JAVA_HOME/lib/i386:$JAVA_HOME/lib/i386/client: 
> $JAVA_HOME/lib/i3
> 86/native_threads

Do you have something similar to the following in your  
postgresql.conf file?

dynamic_library_path = '$libdir:/usr/local/pgsql/lib/pljava'




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

* [Pljava-dev] PostgreSQL is unable to load the libpljava.so
@ 2005-10-27 12:12 
  2005-10-27 13:55 ` [Pljava-dev] Re: PostgreSQL is unable to load the libpljava.so 
  0 siblings, 1 reply; 8+ messages in thread

From:  @ 2005-10-27 12:12 UTC (permalink / raw)

Hi Thomas
This script is only used before invoke the Deployer java class in order to install PLJAVA in PostgreSQL
org.postgresql.pljava.deploy.Deployer -install -user optemi -database optemi

How can I start this script when start the backend?
Thanks in advance
Nacho


-----Mensaje original-----
De: Thomas Hallgren [mailto:thomas at tada.se]
Enviado el: jueves, 27 de octubre de 2005 13:23
Para: Ignacio L?zaro
CC: pljava-dev at gborg.postgresql.org
Asunto: Re: [Pljava-dev] PostgreSQL is unable to load the libpljava.so


Ignacio L?zaro wrote:
> Hi Thomas
>
>   
>> Your LD_LIBRARY_PATH looks correct. Are you sure it's exported and 
>> available to the postmaster when it boots up?
>>     
> I have a shell script in which I define the environment variables and EXPORT them
>   
And this is the script that is used when you start the backend? I'm 
asking this because I've had discussions before where similar scripts 
was used on the client side. They don't have much effect there.

Regards,
Thomas Hallgren




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

* [Pljava-dev] Re: PostgreSQL is unable to load the libpljava.so
  2005-10-27 12:12 [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
@ 2005-10-27 13:55 ` 
  0 siblings, 0 replies; 8+ messages in thread

From:  @ 2005-10-27 13:55 UTC (permalink / raw)

Hello

Finally I have defined in /etc/ld.so.conf file to load the libraries
/var/lib/pgsql/pljava
/usr/java/jre1.5.0_01/lib/i386/client

and after executing "/sbin/ldconfig -v" I can see the new loaded libraries
/var/lib/pgsql/pljava/libpljava.so
/usr/java/jre1.5.0_01/lib/i386/client/libjvm.so


Finally I have executed the Deployser java class and PLJAVA language is loaded 
in PostgreSQL.
Many thanks to everybody for your comments

Best Regards /Saludos /Gr?sses 
Nacho









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

end of thread, other threads:[~2005-10-27 13:55 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-27 06:55 [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
2005-10-27 08:08 ` 
2005-10-27 11:31 ` 
2005-10-27 08:19 [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
2005-10-27 11:23 ` 
2005-10-27 12:05 [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
2005-10-27 12:12 [Pljava-dev] PostgreSQL is unable to load the libpljava.so 
2005-10-27 13:55 ` 

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