[Pljava-dev] Windows binaries

On 2011-01-23 3:13 PM, John R Pierce wrote:
> On 01/23/11 3:02 PM, Eric Kolotyluk wrote:
>>
>> OK, I tried both 'C:/postgres/pljava.dll' and '/postgres/pljava.dll'
>> in the install.sql file and I get the same error message.
>>
>> C:\Program Files (x86)\PostgresPlus\9.0SS\share\pljava>psql -f
>> install.sql
>> Password:
>> CREATE SCHEMA
>> GRANT
>> psql:install.sql:6: ERROR: could not load library
>> "/postgres/pljava.dll": The specified module could not be found.
>>
>> I also used
>>
>> dynamic_library_path = 'C:/postgres;$libdir'
>>
>> in the config file and I still get the same message.
>>
>> Could it be that pljava.dll is just not a proper DLL file?
>
> or perhaps the postgres server user doesn't have 'execute' access to
> that specific file ? check its access rights with (windows cmd)
>
> cacl \postgres\pljava.dll
>
>
> it should look something like...
>
> C:\postgres\pljava.dll BUILTIN\Administrators:F
> NT AUTHORITY\SYSTEM:F
> BUILTIN\Users:R
>
> and you should verify that Postgres is a member of Users (via Local
> Users and Groups, in Windows control panel -> admin tools -> computer
> management)
>

And in what context do I execute the cacl command? Can you please give
an example.

Cheers, Eric