Problem installing on Windows

[jjeffery]

I am unable to install on Windows. I'm a bit new at this, but it looks like binding.cc is using some constants from evlib (EV_READ, EV_WRITE, EV_ERROR), but the windows build does not have access to these constants.

See following session for details.

I understand that not everyone is interested in the Windows port. If you are able to point me in the right direction, I am happy to have a go at resolving this, but I am a bit stuck at the moment.

C:\Users\john> npm install pg
npm http GET https://registry.npmjs.org/pg
npm http 304 https://registry.npmjs.org/pg
npm http GET https://registry.npmjs.org/generic-pool/1.0.9
npm http 304 https://registry.npmjs.org/generic-pool/1.0.9

> pg@0.8.1 install C:\Users\john\node_modules\pg
> node-gyp rebuild || (exit 0)


C:\Users\john\node_modules\pg>node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" rebuild 
  binding.cc
c:\users\john\.node-gyp\0.8.5\src\node_object_wrap.h(57): warning C4251: 'node::ObjectWrap::handle_' : class 'v8::Persistent<T>' needs to have dll-interface to be used by clients of class 'node::ObjectWrap' [C:\Users\john\node_modules\pg\build\binding.vcxproj]
          with
          [
              T=v8::Object
          ]
..\src\binding.cc(117): warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) [C:\Users\john\node_modules\pg\build\binding.vcxproj]
..\src\binding.cc(383): error C2065: 'EV_ERROR' : undeclared identifier [C:\Users\john\node_modules\pg\build\binding.vcxproj]
..\src\binding.cc(394): error C2065: 'EV_READ' : undeclared identifier [C:\Users\john\node_modules\pg\build\binding.vcxproj]
..\src\binding.cc(433): error C2065: 'EV_WRITE' : undeclared identifier [C:\Users\john\node_modules\pg\build\binding.vcxproj]
gyp ERR! build error 
gyp ERR! stack Error: `msbuild` failed with exit code: 1
gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:215:23)
gyp ERR! stack     at ChildProcess.EventEmitter.emit (events.js:91:17)
gyp ERR! stack     at Process._handle.onexit (child_process.js:674:10)
gyp ERR! System Windows_NT 6.1.7601
gyp ERR! command "node" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
gyp ERR! cwd C:\Users\john\node_modules\pg
gyp ERR! node -v v0.8.5
gyp ERR! node-gyp -v v0.6.3
gyp ERR! not ok 
pg@0.8.1 node_modules\pg
??? generic-pool@1.0.9

C:\Users\john>

[booo]

Maybe you can try my fork?

[jjeffery]

Thanks for the suggestion. I created a tarball from your fork and got the following error. Did I do something wrong?

C:\Users\john>npm install d:\Downloads\booo-node-postgres-9132075.tar.gz
npm http GET https://registry.npmjs.org/generic-pool/1.0.9
npm http 304 https://registry.npmjs.org/generic-pool/1.0.9

> pg@0.7.1 install C:\Users\john\node_modules\pg
> node-gyp rebuild || (exit 0)


C:\Users\john\node_modules\pg>node "C:\Program Files\nodejs\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.
js" rebuild
  binding.cc
..\src\binding.cc(1): fatal error C1083: Cannot open include file: 'libpq-fe.h': No such file or directory [C:\Users\john\node_modules\
pg\build\binding.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: `msbuild` failed with exit code: 1
gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:215:23)
gyp ERR! stack     at ChildProcess.EventEmitter.emit (events.js:91:17)
gyp ERR! stack     at Process._handle.onexit (child_process.js:674:10)
gyp ERR! System Windows_NT 6.1.7601
gyp ERR! command "node" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
gyp ERR! cwd C:\Users\john\node_modules\pg
gyp ERR! node -v v0.8.5
gyp ERR! node-gyp -v v0.6.3
gyp ERR! not ok
pg@0.7.1 node_modules\pg
+-- generic-pool@1.0.9

C:\Users\john>

[booo]

Our gyp-file is a bit minimalistic and does not support windows so far. We will have to include a windows section that points to the right location of the header files. I will try to add this as soon as possible.

Have you installed the libpq developer files?

You are aware of the fact that you can use the javscript code without compiling the native binding?

[booo]

http://www.postgresql.org/docs/9.2/static/install-windows-libpq.html

[image72]

I build node-postgre like above
but, throw some error now
postgresql-v8.4 x86/win7 vc++10 Node-v0.8.0
pgsql env in path

LINK : fatal error LNK1104: cannot open file 'pq -LD:\PROGRA~1\POSTGR~1\8.4\lib
.obj' [F:\brianc-node-postgres-ba733f5\build\binding.vcxproj]
gyp ERR! build error Error: `msbuild` failed with exit code: 1
gyp ERR! build error     at ChildProcess.onExit (C:\Users\Vernice\node_modules\n
ode-gyp\lib\build.js:214:23)
gyp ERR! build error     at ChildProcess.EventEmitter.emit (events.js:91:17)
gyp ERR! build error     at Process._handle.onexit (child_process.js:674:10)
gyp ERR! not ok

[booo]

@image72 Seems to bee a linking problem. I was able to fix the problem and build the binding on windows. But if I try to load the binding/native code I get a strange error without any useful description. As soon as I find a solution I let you know.

Are there any good resource about windows and node extensions out there?

[indus]

any progress on that?

[booo]

@indus No sorry. I don't have access to a windows machine anymore. I can try to add my changes to the gyp file and you give it a try?

[indus]

yes i would test it. but i allready invested 3-4 hours of testing. I solved one error after the other. And "after all" i got it installed... but it doesn´t work correctly. After some hours i askted my teammate for a linux-server.

[booo]

What do you mean by "installed" and "doesn't work correctly"?

[booo]

I pushed my changes. https://github.com/booo/node-postgres/tree/uv_events

Not sure if they work at all. I do not have a machine for testing at the moment :/

[CnApTaK]

..\src\binding.cc(309): warning C4800: 'int' : forcing value to bool 'true' or 'false' (performance warning) [D:\work\development\PhpstormProjects\NodeJS\booo-node-postgres-eedc5a9\build\binding.vcxproj]
C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\Microsoft.CppBuild.targets(991,5): warning MSB8012: TargetExt(.dll) does not match the Linker's OutputFile property value (.node). This may cause your project to build incorrectly. To correct this, please make sure that $(OutDir), $(TargetName) and $(TargetExt) property values match the value specified in %(Link.OutputFile). [D:\work\development\PhpstormProjects\NodeJS\booo-node-postgres-eedc5a9\build\binding.vcxproj]
C:/PROGRA1/POSTGR1/9.2/lib\libpq.dll : fatal error LNK1107: invalid or corrupt file: cannot read at 0x2F0 [D:\work\development\PhpstormProjects\NodeJS\booo-node-postgres-eedc5a9\build\binding.vcxproj]
ERR! Error: C:\Windows\Microsoft.NET\Framework\v4.0.30319\msbuild.exe failed with exit code: 1

[CnApTaK]

https://github.com/booo/node-postgres/tree/uv_events this code is working fine. about previous error. renaming "libpq.dll" to "libpq.lib" in project file solve the problem.