agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] problem installing pljava 1.4.0
4+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] problem installing pljava 1.4.0
@ 2008-04-09 20:04
2008-04-09 20:51 ` [Pljava-dev] problem installing pljava 1.4.0
0 siblings, 1 reply; 4+ messages in thread
From: @ 2008-04-09 20:04 UTC (permalink / raw)
Hi All,
I try to install pljava. I am using:
binari pljava-i686-pc-linux-gnu-pg8.2-1.4.0
java1.5_015
postgresql-8.2.6
When I run the deployer with the command:
java org.postgresql.pljava.deploy.Deployer -install
following error message is displayed:
org.postgresql.util.PSQLException: ERROR: could not load library
"/usr/local/pljava/libpljava.so": /usr/local/pljava/libpljava.so:
undefined symbol: SetUserId
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1499)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1284)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:429)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:334)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:326)
at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:432)
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)
and the error message in the log is:
<postgresql%dspace%CREATE FUNCTION%47fb41b4.cf5%2008-04-08 11:58:12
CEST%>ERROR: could not load library "/usr/local/pljava/libpljava.so":
/usr/local/pljava/libpljava.so: undefined symbol: SetUserId
<postgresql%dspace%CREATE FUNCTION%47fb41b4.cf5%2008-04-08 11:58:12
CEST%>STATEMENT: CREATE FUNCTION sqlj.java_call_handler() RETURNS
language_handler AS 'libpljava' LANGUAGE C
<postgresql%dspace%idle%47fb41b4.cf5%2008-04-08 11:58:12 CEST%>LOG:
unexpected EOF on client connection
Any ideas, or anything I could try?
I will appreciate any help!!!
--------------------------------------------
Teresa Quintanilla
Universidad Carlos III de Madrid
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] problem installing pljava 1.4.0
2008-04-09 20:04 [Pljava-dev] problem installing pljava 1.4.0
@ 2008-04-09 20:51 `
2008-04-10 12:16 ` [Pljava-dev] problem installing pljava 1.4.0
0 siblings, 1 reply; 4+ messages in thread
From: @ 2008-04-09 20:51 UTC (permalink / raw)
On Wed, 9 Apr 2008, Teresa Quintanilla wrote:
> I try to install pljava. I am using:
> binari pljava-i686-pc-linux-gnu-pg8.2-1.4.0
> java1.5_015
> postgresql-8.2.6
Are you sure you have postgresql-8.2.6 and not a previous release. The
8.2-1.4 pljava binary will only work with 8.2.6 and up and this is the
error message I'd expect when trying to load it into a previous release.
Maybe we can make the deployer do some kind of "SELECT version();" check
for the future?
Kris Jurka
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] problem installing pljava 1.4.0
2008-04-09 20:04 [Pljava-dev] problem installing pljava 1.4.0
2008-04-09 20:51 ` [Pljava-dev] problem installing pljava 1.4.0
@ 2008-04-10 12:16 `
2008-04-10 16:06 ` [Pljava-dev] problem installing pljava 1.4.0
0 siblings, 1 reply; 4+ messages in thread
From: @ 2008-04-10 12:16 UTC (permalink / raw)
Hi Kris
Many thanks for your prompt reply.
I checked postgresql release that it is running in my computer:
PostgreSQL 8.2.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2
20061115 (prerelease) (Debian 4.1.1-21)
The message error I obtain when I try to install pljava is:
org.postgresql.util.PSQLException: ERROR: could not load library
"/usr/local/pljava/libpljava.so": /usr/local/pljava/libpljava.so:
undefined symbol:SetUserId
Could the problem be library release libpljava.so? Where could I
downlaod another library release?
best regards
Kris Jurka <books at ejurka.com> dijo:
>
>
> On Wed, 9 Apr 2008, Teresa Quintanilla wrote:
>
>> I try to install pljava. I am using:
>> binari pljava-i686-pc-linux-gnu-pg8.2-1.4.0
>> java1.5_015
>> postgresql-8.2.6
>
> Are you sure you have postgresql-8.2.6 and not a previous release.
> The 8.2-1.4 pljava binary will only work with 8.2.6 and up and this
> is the error message I'd expect when trying to load it into a
> previous release.
>
> Maybe we can make the deployer do some kind of "SELECT version();"
> check for the future?
>
> Kris Jurka
>
--
--------------------------------------------
Teresa Quintanilla Universidad Carlos III de Madrid
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] problem installing pljava 1.4.0
2008-04-09 20:04 [Pljava-dev] problem installing pljava 1.4.0
2008-04-09 20:51 ` [Pljava-dev] problem installing pljava 1.4.0
2008-04-10 12:16 ` [Pljava-dev] problem installing pljava 1.4.0
@ 2008-04-10 16:06 `
0 siblings, 0 replies; 4+ messages in thread
From: @ 2008-04-10 16:06 UTC (permalink / raw)
Teresa Quintanilla wrote:
>
> org.postgresql.util.PSQLException: ERROR: could not load library
> "/usr/local/pljava/libpljava.so": /usr/local/pljava/libpljava.so:
> undefined symbol:SetUserId
>
> Could the problem be library release libpljava.so? Where could I
> downlaod another library release?
>
Yes, it is a library problem, but not a problem with the download. The
pljava-8.2-1.4 release contains pljava.so, not libpljava.so, so you're
trying to load another version of pljava that does not match your server
version.
Kris Jurka
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-04-10 16:06 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-09 20:04 [Pljava-dev] problem installing pljava 1.4.0
2008-04-09 20:51 `
2008-04-10 12:16 `
2008-04-10 16:06 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox