Lists: | pljava-dev |
---|
From: | blakemiller at cdmplus(dot)com (Blake Miller) |
---|---|
To: | |
Subject: | [Pljava-dev] Windows cannot access file pljava file |
Date: | 2007-04-10 16:29:40 |
Message-ID: | B16355EE-CB9F-4B79-B3E8-EEC89FD71535@cdmplus.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pljava-dev |
I've done a lot of searching around and followed the advice of nearly
every post out there and I still cannot get pljava installed.
I am installing on PostgreSQL 8.2 on Windows XP.
The settings in postgresql.conf are:
dynamic_library_path = '$libdir;C:\\Documents and Settings\\All Users\
\Documents\\Sandbox\\tools\\pljava\\pljava.dll'
pljava.classpath = 'C:\\Documents and Settings\\All Users\\Documents\
\Sandbox\\tools\\pljava\\pljava.jar'
custom_variable_classes = 'pljava'
The environment variables are set as:
System level:
CLASSPATH
%CLASSPATH%;C:\Documents and Settings\All Users\Documents\Sandbox
\drivers\postgresql-8.2-504.jdbc3.jar;C:\Documents and Settings\All
Users\Documents\Sandbox\tools\pljava\deploy.jar;C:\Documents and
Settings\All Users\Documents\Sandbox\tools\pljava\pljava.jar;.;C:
\Program Files\Java\jre1.5.0_06\lib\ext\QTJava.zip
PATH
%PATH%;%JAVA_HOME%\bin;%JAVA_HOME%\bin\client;%SystemRoot%\system32;%
SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\QuickTime
\QTSystem\;C:\Program Files\MySQL\MySQL Server 5.0\bin
JAVA_HOME
C:\Program Files\Java\jre1.5.0_11
I've tried running the install.sql script AND tried using the
deploy.jar method and both return the same error:
ERROR: could not access file "pljava": No such file or directory
Additional info:
The postgres service runs as a user called 'postgres'
When I log onto my database to run the install script, I log on as admin
The admin user has a normal windows account; however, it does not
seem that the postgres user does (because he doesn't show up under
user accounts, although when I tried to create a postgres account
implicitly, windows says that user already exists).
Any ideas?
Thanks for any help,
Blake Miller
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20070410/5b6a183b/attachment.html>