From: eric.kolotyluk at gmail.com (Eric Kolotyluk) Date: Sun, 23 Jan 2011 15:19:01 -0800 Subject: [Pljava-dev] Windows binaries In-Reply-To: <4D3CB623.2060409@hogranch.com> References: <4D3A3076.4070905@gmail.com> <4D3C6777.10708@gmail.com> <4D3C6B11.3010706@gmail.com> <4D3C6F68.9060304@gmail.com> <4D3C7606.5080205@gmail.com> <4D3C7E10.7080906@gmail.com> <4D3CA4BD.3010206@gmail.com> <4D3CAF3D.2060802@hogranch.com> <4D3CB385.6010403@gmail.com> <4D3CB623.2060409@hogranch.com> Message-ID: <4D3CB765.709@gmail.com> 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