Self host install errors

[piersonjarvis]

Hello, I'm trying to get this installed on a server for personal use. I've installed git, npm, node.js, and sqlite, however I keep getting errors when trying to npm install. I'm fairly new to node.js so a lot of this is going over my head.

Below are the errors I am getting.

npm ERR! code 1
npm ERR! path /home/timeoff/timeoff-management/node_modules/sqlite3
npm ERR! command failed
npm ERR! command sh -c -- node-pre-gyp install --fallback-to-build
npm ERR! make: Entering directory '/home/timeoff/timeoff-management/node_modules/sqlite3/build'
npm ERR! ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c
npm ERR! make: Leaving directory '/home/timeoff/timeoff-management/node_modules/sqlite3/build'
npm ERR! Failed to execute '/usr/bin/node /usr/share/nodejs/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/timeoff/timeoff-management/node_modules/sqlite3/lib/binding/node-v108-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/timeoff/timeoff-management/node_modules/sqlite3/lib/binding/node-v108-linux-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v108' (1)
npm ERR! node-pre-gyp info it worked if it ends with ok
npm ERR! node-pre-gyp info using node-pre-gyp@0.11.0
npm ERR! node-pre-gyp info using node@18.7.0 | linux | x64
npm ERR! node-pre-gyp WARN Using request for node-pre-gyp https download
npm ERR! node-pre-gyp info check checked for "/home/timeoff/timeoff-management/node_modules/sqlite3/lib/binding/node-v108-linux-x64/node_sqlite3.node" (not found)
npm ERR! node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v108-linux-x64.tar.gz
npm ERR! node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v108-linux-x64.tar.gz
npm ERR! node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v108-linux-x64.tar.gz
npm ERR! node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@18.7.0 (node-v108 ABI, glibc) (falling back to source compile with node-gyp)
npm ERR! node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v108-linux-x64.tar.gz
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.1.0
npm ERR! gyp info using node@18.7.0 | linux | x64
npm ERR! gyp info ok
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.1.0
npm ERR! gyp info using node@18.7.0 | linux | x64
npm ERR! gyp info find Python using Python version 3.10.7 found at "/usr/bin/python3"
npm ERR! gyp info spawn /usr/bin/python3
npm ERR! gyp info spawn args [
npm ERR! gyp info spawn args '/usr/share/nodejs/node-gyp/gyp/gyp_main.py',
npm ERR! gyp info spawn args 'binding.gyp',
npm ERR! gyp info spawn args '-f',
npm ERR! gyp info spawn args 'make',
npm ERR! gyp info spawn args '-I',
npm ERR! gyp info spawn args '/home/timeoff/timeoff-management/node_modules/sqlite3/build/config.gypi',
npm ERR! gyp info spawn args '-I',
npm ERR! gyp info spawn args '/usr/share/nodejs/node-gyp/addon.gypi',
npm ERR! gyp info spawn args '-I',
npm ERR! gyp info spawn args '/usr/include/nodejs/common.gypi',
npm ERR! gyp info spawn args '-Dlibrary=shared_library',
npm ERR! gyp info spawn args '-Dvisibility=default',
npm ERR! gyp info spawn args '-Dnode_root_dir=/usr/include/nodejs',
npm ERR! gyp info spawn args '-Dnode_gyp_dir=/usr/share/nodejs/node-gyp',
npm ERR! gyp info spawn args '-Dnode_lib_file=/usr/include/nodejs/<(target_arch)/node.lib',
npm ERR! gyp info spawn args '-Dmodule_root_dir=/home/timeoff/timeoff-management/node_modules/sqlite3',
npm ERR! gyp info spawn args '-Dnode_engine=v8',
npm ERR! gyp info spawn args '--depth=.',
npm ERR! gyp info spawn args '--no-parallel',
npm ERR! gyp info spawn args '--generator-output',
npm ERR! gyp info spawn args 'build',
npm ERR! gyp info spawn args '-Goutput_dir=.'
npm ERR! gyp info spawn args ]
npm ERR! gyp info ok
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.1.0
npm ERR! gyp info using node@18.7.0 | linux | x64
npm ERR! gyp info spawn make
npm ERR! gyp info spawn args [ 'BUILDTYPE=Release', '-C', 'build' ]
npm ERR! /bin/sh: 1: python: not found
npm ERR! make: *** [deps/action_before_build.target.mk:13: Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c] Error 127
npm ERR! gyp ERR! build error
npm ERR! gyp ERR! stack Error: make failed with exit code: 2
npm ERR! gyp ERR! stack at ChildProcess.onExit (/usr/share/nodejs/node-gyp/lib/build.js:201:23)
npm ERR! gyp ERR! stack at ChildProcess.emit (node:events:513:28)
npm ERR! gyp ERR! stack at ChildProcess._handle.onexit (node:internal/child_process:291:12)
npm ERR! gyp ERR! System Linux 5.19.0-29-generic
npm ERR! gyp ERR! command "/usr/bin/node" "/usr/share/nodejs/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/home/timeoff/timeoff-management/node_modules/sqlite3/lib/binding/node-v108-linux-x64/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/timeoff/timeoff-management/node_modules/sqlite3/lib/binding/node-v108-linux-x64" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v108"
npm ERR! gyp ERR! cwd /home/timeoff/timeoff-management/node_modules/sqlite3
npm ERR! gyp ERR! node -v v18.7.0
npm ERR! gyp ERR! node-gyp -v v9.1.0
npm ERR! gyp ERR! not ok
npm ERR! node-pre-gyp ERR! build error
npm ERR! node-pre-gyp ERR! stack Error: Failed to execute '/usr/bin/node /usr/share/nodejs/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/timeoff/timeoff-management/node_modules/sqlite3/lib/binding/node-v108-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/timeoff/timeoff-management/node_modules/sqlite3/lib/binding/node-v108-linux-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v108' (1)
npm ERR! node-pre-gyp ERR! stack at ChildProcess. (/home/timeoff/timeoff-management/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
npm ERR! node-pre-gyp ERR! stack at ChildProcess.emit (node:events:513:28)
npm ERR! node-pre-gyp ERR! stack at maybeClose (node:internal/child_process:1091:16)
npm ERR! node-pre-gyp ERR! stack at ChildProcess._handle.onexit (node:internal/child_process:302:5)
npm ERR! node-pre-gyp ERR! System Linux 5.19.0-29-generic
npm ERR! node-pre-gyp ERR! command "/usr/bin/node" "/home/timeoff/timeoff-management/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
npm ERR! node-pre-gyp ERR! cwd /home/timeoff/timeoff-management/node_modules/sqlite3
npm ERR! node-pre-gyp ERR! node -v v18.7.0
npm ERR! node-pre-gyp ERR! node-pre-gyp -v v0.11.0
npm ERR! node-pre-gyp ERR! not ok

npm ERR! A complete log of this run can be found in:
npm ERR! /root/.npm/_logs/2023-01-17T18_30_29_985Z-debug-0.log

[aamador0202]

Im having the same issue, were you able to resolve?

[AB2yz]

I had these same issues when trying to install. I'm running on Ubuntu 22.04.2 and got it working by using Node V14 and manually installing sqlite3.
These are the steps I took:

sudo apt update
sudo apt upgrade
sudo apt install nodejs
sudo apt install npm
curl -sL https://raw.githubusercontent.com/nvm-sh/nvm/v0.35.0/install.sh -o install_nvm.sh
bash install_nvm.sh
source ~/.bash_profile
nvm install 14.0.0
npm install sqlite3 --save
git clone https://github.com/timeoff-management/application.git timeoff-management
cd timeoff-management
npm install
npm start

[JohannesFleischer]

@AB2yz This throws me the same errors:

gyp ERR! node -v v14.0.0
gyp ERR! node-gyp -v v5.1.0
gyp ERR! not ok 

and

node-pre-gyp ERR! node -v v14.0.0
node-pre-gyp ERR! node-pre-gyp -v v0.11.0
node-pre-gyp ERR! not ok 

this seems to be a sqlite3 error to me:

npm ERR! Failed at the sqlite3@4.2.0 install script.

Which version of sqlite3 are you using?

Edit1:
sqlite3@5.0.0 seems to work for the Dockerized version
But with vulnerabilities that have to be fixed -> manual review

[adocampo]

Installation also fails on Arch linux:
nodejs version 19.8.1
sqlite version 3.41.2

4218   │ 2967 verbose Linux 6.2.10-arch1-1
4219   │ 2968 verbose node v19.8.1
4220   │ 2969 verbose npm  v8.19.2
4221   │ 2970 error code 1
4222   │ 2971 error path /home/malevolent/development/docker/timeoff-management/node_modules/sqlite3
4223   │ 2972 error command failed
4224   │ 2973 error command sh -c -- node-pre-gyp install --fallback-to-build
4225   │ 2974 error make: se entra en el directorio '/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/build'
4226   │ 2974 error   ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c
4227   │ 2974 error   TOUCH Release/obj.target/deps/action_before_build.stamp
4228   │ 2974 error   CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3310100/sqlite3.o
4229   │ 2974 error rm -f Release/obj.target/deps/sqlite3.a Release/obj.target/deps/sqlite3.a.ar-file-list; mkdir -p `dirname Release/obj.target/deps/sqlite3.a`
4230   │ 2974 error ar crs Release/obj.target/deps/sqlite3.a @Release/obj.target/deps/sqlite3.a.ar-file-list
4231   │ 2974 error   COPY Release/sqlite3.a
4232   │ 2974 error   CXX(target) Release/obj.target/node_sqlite3/src/backup.o
4233   │ 2974 error make: se sale del directorio '/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/build'
4234   │ 2974 error Failed to execute '/usr/bin/node /usr/lib/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/lib/binding/node-v111-linux-x64/node_sqlite3.node --module_name=node_s
       │ qlite3 --module_path=/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/lib/binding/node-v111-linux-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v111' (1)
4235   │ 2975 error node-pre-gyp info it worked if it ends with ok
4236   │ 2975 error node-pre-gyp info using node-pre-gyp@0.11.0
4237   │ 2975 error node-pre-gyp info using node@19.8.1 | linux | x64
4238   │ 2975 error node-pre-gyp WARN Using request for node-pre-gyp https download 
4239   │ 2975 error node-pre-gyp info check checked for "/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/lib/binding/node-v111-linux-x64/node_sqlite3.node" (not found)
4240   │ 2975 error node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v111-linux-x64.tar.gz
4241   │ 2975 error node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v111-linux-x64.tar.gz
4242   │ 2975 error node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v111-linux-x64.tar.gz 
4243   │ 2975 error node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@19.8.1 (node-v111 ABI, glibc) (falling back to source compile with node-gyp) 
4244   │ 2975 error node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v111-linux-x64.tar.gz 
4245   │ 2975 error gyp info it worked if it ends with ok
4246   │ 2975 error gyp info using node-gyp@9.3.1
4247   │ 2975 error gyp info using node@19.8.1 | linux | x64
4248   │ 2975 error gyp info ok 
4249   │ 2975 error gyp info it worked if it ends with ok
4250   │ 2975 error gyp info using node-gyp@9.3.1
4251   │ 2975 error gyp info using node@19.8.1 | linux | x64
4252   │ 2975 error gyp info find Python using Python version 3.10.10 found at "/usr/bin/python3"
4253   │ 2975 error gyp info spawn /usr/bin/python3
4254   │ 2975 error gyp info spawn args [
4255   │ 2975 error gyp info spawn args   '/usr/lib/node_modules/node-gyp/gyp/gyp_main.py',
4256   │ 2975 error gyp info spawn args   'binding.gyp',
4257   │ 2975 error gyp info spawn args   '-f',
4258   │ 2975 error gyp info spawn args   'make',
4259   │ 2975 error gyp info spawn args   '-I',
4260   │ 2975 error gyp info spawn args   '/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/build/config.gypi',
4261   │ 2975 error gyp info spawn args   '-I',
4262   │ 2975 error gyp info spawn args   '/usr/lib/node_modules/node-gyp/addon.gypi',
4263   │ 2975 error gyp info spawn args   '-I',
4264   │ 2975 error gyp info spawn args   '/home/malevolent/.cache/node-gyp/19.8.1/include/node/common.gypi',
4265   │ 2975 error gyp info spawn args   '-Dlibrary=shared_library',
4266   │ 2975 error gyp info spawn args   '-Dvisibility=default',
4267   │ 2975 error gyp info spawn args   '-Dnode_root_dir=/home/malevolent/.cache/node-gyp/19.8.1',
4268   │ 2975 error gyp info spawn args   '-Dnode_gyp_dir=/usr/lib/node_modules/node-gyp',
4269   │ 2975 error gyp info spawn args   '-Dnode_lib_file=/home/malevolent/.cache/node-gyp/19.8.1/<(target_arch)/node.lib',
4270   │ 2975 error gyp info spawn args   '-Dmodule_root_dir=/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3',
4271   │ 2975 error gyp info spawn args   '-Dnode_engine=v8',
4272   │ 2975 error gyp info spawn args   '--depth=.',
4273   │ 2975 error gyp info spawn args   '--no-parallel',
4274   │ 2975 error gyp info spawn args   '--generator-output',
4275   │ 2975 error gyp info spawn args   'build',
4276   │ 2975 error gyp info spawn args   '-Goutput_dir=.'
4277   │ 2975 error gyp info spawn args ]
4278   │ 2975 error gyp info ok 
4279   │ 2975 error gyp info it worked if it ends with ok
4280   │ 2975 error gyp info using node-gyp@9.3.1
4281   │ 2975 error gyp info using node@19.8.1 | linux | x64
4282   │ 2975 error gyp info spawn make
4283   │ 2975 error gyp info spawn args [ 'BUILDTYPE=Release', '-C', 'build' ]
4284   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c: En la función ‘strftimeFunc’:
4285   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c:14483:27: aviso: conversión entre tipos de función incompatibles desde ‘int (*)(void *)’ a ‘void (*)(void *)’ [-Wcast-function-type]
4286   │ 2975 error 14483 | #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3MallocSize)
4287   │ 2975 error       |                           ^
4288   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c:22663:52: nota: en expansión de macro ‘SQLITE_DYNAMIC’
4289   │ 2975 error 22663 |                       z==zBuf ? SQLITE_TRANSIENT : SQLITE_DYNAMIC);
4290   │ 2975 error       |                                                    ^~~~~~~~~~~~~~
4291   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c: En la función ‘sqlite3ErrorWithMsg’:
4292   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c:14483:27: aviso: conversión entre tipos de función incompatibles desde ‘int (*)(void *)’ a ‘void (*)(void *)’ [-Wcast-function-type]
4293   │ 2975 error 14483 | #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3MallocSize)
4294   │ 2975 error       |                           ^
4295   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c:31142:54: nota: en expansión de macro ‘SQLITE_DYNAMIC’
4296   │ 2975 error 31142 |     sqlite3ValueSetStr(db->pErr, -1, z, SQLITE_UTF8, SQLITE_DYNAMIC);
4297   │ 2975 error       |                                                      ^~~~~~~~~~~~~~
4298   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c: En la función ‘sqlite3VdbeMemSetStr’:
4299   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c:14483:27: aviso: conversión entre tipos de función incompatibles desde ‘int (*)(void *)’ a ‘void (*)(void *)’ [-Wcast-function-type]
4300   │ 2975 error 14483 | #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3MallocSize)
4301   │ 2975 error       |                           ^
4302   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c:76549:15: nota: en expansión de macro ‘SQLITE_DYNAMIC’
4303   │ 2975 error 76549 |     if( xDel==SQLITE_DYNAMIC ){
4304   │ 2975 error       |               ^~~~~~~~~~~~~~
4305   │ 2975 error Release/obj/gen/sqlite-autoconf-3310100/sqlite3.c: En la función ‘valueFromExpr’:
...
...
...
4982   │ 2975 error   105 |     TRY_CATCH_CALL((obj),                                                      \
4983   │ 2975 error       |     ^~~~~~~~~~~~~~
4984   │ 2975 error ../src/backup.cc:82:9: nota: en expansión de macro ‘EMIT_EVENT’
4985   │ 2975 error    82 |         EMIT_EVENT(backup->handle(), 2, argv);
4986   │ 2975 error       |         ^~~~~~~~~~
4987   │ 2975 error ../../nan/nan.h:1026:46: nota: se declara aquí
4988   │ 2975 error  1026 |   NAN_DEPRECATED inline v8::Local<v8::Value> MakeCallback(
4989   │ 2975 error       |                                              ^~~~~~~~~~~~
4990   │ 2975 error make: *** [node_sqlite3.target.mk:136: Release/obj.target/node_sqlite3/src/backup.o] Error 1
4991   │ 2975 error gyp ERR! build error 
4992   │ 2975 error gyp ERR! stack Error: `make` failed with exit code: 2
4993   │ 2975 error gyp ERR! stack     at ChildProcess.onExit (/usr/lib/node_modules/node-gyp/lib/build.js:203:23)
4994   │ 2975 error gyp ERR! stack     at ChildProcess.emit (node:events:512:28)
4995   │ 2975 error gyp ERR! stack     at ChildProcess._handle.onexit (node:internal/child_process:293:12)
4996   │ 2975 error gyp ERR! System Linux 6.2.10-arch1-1
4997   │ 2975 error gyp ERR! command "/usr/bin/node" "/usr/lib/node_modules/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/lib/binding/node-v111-linux-x64/node_sqlite3.node" "--module_na
       │ me=node_sqlite3" "--module_path=/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/lib/binding/node-v111-linux-x64" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v111"
4998   │ 2975 error gyp ERR! cwd /home/malevolent/development/docker/timeoff-management/node_modules/sqlite3
4999   │ 2975 error gyp ERR! node -v v19.8.1
5000   │ 2975 error gyp ERR! node-gyp -v v9.3.1
5001   │ 2975 error gyp ERR! not ok 
5002   │ 2975 error node-pre-gyp ERR! build error 
5003   │ 2975 error node-pre-gyp ERR! stack Error: Failed to execute '/usr/bin/node /usr/lib/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/lib/binding/node-v111-linux-x64/node_sq
       │ lite3.node --module_name=node_sqlite3 --module_path=/home/malevolent/development/docker/timeoff-management/node_modules/sqlite3/lib/binding/node-v111-linux-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v111' (1)
5004   │ 2975 error node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/home/malevolent/development/docker/timeoff-management/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
5005   │ 2975 error node-pre-gyp ERR! stack     at ChildProcess.emit (node:events:512:28)
5006   │ 2975 error node-pre-gyp ERR! stack     at maybeClose (node:internal/child_process:1098:16)
5007   │ 2975 error node-pre-gyp ERR! stack     at ChildProcess._handle.onexit (node:internal/child_process:304:5)
5008   │ 2975 error node-pre-gyp ERR! System Linux 6.2.10-arch1-1
5009   │ 2975 error node-pre-gyp ERR! command "/usr/bin/node" "/home/malevolent/development/docker/timeoff-management/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
5010   │ 2975 error node-pre-gyp ERR! cwd /home/malevolent/development/docker/timeoff-management/node_modules/sqlite3
5011   │ 2975 error node-pre-gyp ERR! node -v v19.8.1
5012   │ 2975 error node-pre-gyp ERR! node-pre-gyp -v v0.11.0
5013   │ 2975 error node-pre-gyp ERR! not ok
5014   │ 2976 verbose exit 1
5015   │ 2977 timing npm Completed in 40031ms
5016   │ 2978 verbose unfinished npm timer reify 1681745553871
5017   │ 2979 verbose unfinished npm timer reify:build 1681745558329
5018   │ 2980 verbose unfinished npm timer build 1681745558330
5019   │ 2981 verbose unfinished npm timer build:deps 1681745558330
5020   │ 2982 verbose unfinished npm timer build:run:install 1681745558351
5021   │ 2983 verbose unfinished npm timer build:run:install:node_modules/sqlite3 1681745558387
5022   │ 2984 verbose code 1
5023   │ 2985 error A complete log of this run can be found in:
5024   │ 2985 error     /home/malevolent/.npm/_logs/2023-04-17T15_32_33_815Z-debug-0.log

Docker build also fails

npm ERR! code 1
npm ERR! path /node_modules/sqlite3
npm ERR! command failed
npm ERR! command sh -c node-pre-gyp install --fallback-to-build
npm ERR! Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js configure --fallback-to-build --module=/node_modules/sqlite3/lib/binding/node-v108-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/node_modules/sqlite3/lib/binding/node-v108-linux-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v108 --python=/usr/bin/python3' (1)
npm ERR! node-pre-gyp info it worked if it ends with ok
npm ERR! node-pre-gyp info using node-pre-gyp@0.11.0
npm ERR! node-pre-gyp info using node@18.14.2 | linux | x64
npm ERR! node-pre-gyp WARN Using request for node-pre-gyp https download 
npm ERR! node-pre-gyp info check checked for "/node_modules/sqlite3/lib/binding/node-v108-linux-x64/node_sqlite3.node" (not found)
npm ERR! node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v108-linux-x64.tar.gz
npm ERR! node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v108-linux-x64.tar.gz
npm ERR! node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v108-linux-x64.tar.gz 
npm ERR! node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@18.14.2 (node-v108 ABI, musl) (falling back to source compile with node-gyp) 
npm ERR! node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v108-linux-x64.tar.gz 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.3.0
npm ERR! gyp info using node@18.14.2 | linux | x64
npm ERR! gyp info ok 
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.3.0
npm ERR! gyp info using node@18.14.2 | linux | x64
npm ERR! gyp ERR! find Python 
npm ERR! gyp ERR! find Python checking Python explicitly set from command line or npm configuration
npm ERR! gyp ERR! find Python - "--python=" or "npm config get python" is "/usr/bin/python3"
npm ERR! gyp ERR! find Python - "/usr/bin/python3" is not in PATH or produced an error
npm ERR! gyp ERR! find Python Python is not set from environment variable PYTHON
npm ERR! gyp ERR! find Python checking if "python3" can be used
npm ERR! gyp ERR! find Python - "python3" is not in PATH or produced an error
npm ERR! gyp ERR! find Python checking if "python" can be used
npm ERR! gyp ERR! find Python - "python" is not in PATH or produced an error
npm ERR! gyp ERR! find Python 
npm ERR! gyp ERR! find Python **********************************************************
npm ERR! gyp ERR! find Python You need to install the latest version of Python.
npm ERR! gyp ERR! find Python Node-gyp should be able to find and use Python. If not,
npm ERR! gyp ERR! find Python you can try one of the following options:
npm ERR! gyp ERR! find Python - Use the switch --python="/path/to/pythonexecutable"
npm ERR! gyp ERR! find Python   (accepted by both node-gyp and npm)
npm ERR! gyp ERR! find Python - Set the environment variable PYTHON
npm ERR! gyp ERR! find Python - Set the npm configuration variable python:
npm ERR! gyp ERR! find Python   npm config set python "/path/to/pythonexecutable"
npm ERR! gyp ERR! find Python For more information consult the documentation at:
npm ERR! gyp ERR! find Python https://github.com/nodejs/node-gyp#installation
npm ERR! gyp ERR! find Python **********************************************************
npm ERR! gyp ERR! find Python 
npm ERR! gyp ERR! configure error 
npm ERR! gyp ERR! stack Error: Could not find any Python installation to use
npm ERR! gyp ERR! stack     at PythonFinder.fail (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/find-python.js:330:47)
npm ERR! gyp ERR! stack     at PythonFinder.runChecks (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/find-python.js:159:21)
npm ERR! gyp ERR! stack     at PythonFinder.<anonymous> (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/find-python.js:202:16)
npm ERR! gyp ERR! stack     at PythonFinder.execFileCallback (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/find-python.js:294:16)
npm ERR! gyp ERR! stack     at exithandler (node:child_process:427:5)
npm ERR! gyp ERR! stack     at ChildProcess.errorhandler (node:child_process:439:5)
npm ERR! gyp ERR! stack     at ChildProcess.emit (node:events:513:28)
npm ERR! gyp ERR! stack     at ChildProcess._handle.onexit (node:internal/child_process:289:12)
npm ERR! gyp ERR! stack     at onErrorNT (node:internal/child_process:476:16)
npm ERR! gyp ERR! stack     at process.processTicksAndRejections (node:internal/process/task_queues:82:21)
npm ERR! gyp ERR! System Linux 6.2.10-arch1-1
npm ERR! gyp ERR! command "/usr/bin/node" "/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "configure" "--fallback-to-build" "--module=/node_modules/sqlite3/lib/binding/node-v108-linux-x64/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/node_modules/sqlite3/lib/binding/node-v108-linux-x64" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v108" "--python=/usr/bin/python3"
npm ERR! gyp ERR! cwd /node_modules/sqlite3
npm ERR! gyp ERR! node -v v18.14.2
npm ERR! gyp ERR! node-gyp -v v9.3.0
npm ERR! gyp ERR! not ok 
npm ERR! node-pre-gyp ERR! build error 
npm ERR! node-pre-gyp ERR! stack Error: Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js configure --fallback-to-build --module=/node_modules/sqlite3/lib/binding/node-v108-linux-x64/node_sqlite3.node --module_name=node_sqlite3 --module_path=/node_modules/sqlite3/lib/binding/node-v108-linux-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v108 --python=/usr/bin/python3' (1)
npm ERR! node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (/node_modules/node-pre-gyp/lib/util/compile.js:83:29)
npm ERR! node-pre-gyp ERR! stack     at ChildProcess.emit (node:events:513:28)
npm ERR! node-pre-gyp ERR! stack     at maybeClose (node:internal/child_process:1091:16)
npm ERR! node-pre-gyp ERR! stack     at ChildProcess._handle.onexit (node:internal/child_process:302:5)
npm ERR! node-pre-gyp ERR! System Linux 6.2.10-arch1-1
npm ERR! node-pre-gyp ERR! command "/usr/bin/node" "/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
npm ERR! node-pre-gyp ERR! cwd /node_modules/sqlite3
npm ERR! node-pre-gyp ERR! node -v v18.14.2
npm ERR! node-pre-gyp ERR! node-pre-gyp -v v0.11.0
npm ERR! node-pre-gyp ERR! not ok

npm ERR! A complete log of this run can be found in:
npm ERR!     /root/.npm/_logs/2023-04-17T15_37_37_950Z-debug-0.log

[JohannesFleischer]

@adocampo if you want to start the service with docker you can try this PR.
Worked for me. I guess a fix in main could take a while.

I somehow managed to get the second newest release to work natively, but also only once and on a secomd try it trew errors again..

[adocampo]

@adocampo if you want to start the service with docker you can try this PR. Worked for me. I guess a fix in main could take a while.

I somehow managed to get the second newest release to work natively, but also only once and on a secomd try it trew errors again..

Yes, docker is building with your PR! Thank you very much!

[iNaiks]

I had these same issues when trying to install. I'm running on Ubuntu 22.04.2 and got it working by using Node V14 and manually installing sqlite3. These are the steps I took:

sudo apt update sudo apt upgrade sudo apt install nodejs sudo apt install npm curl -sL https://raw.githubusercontent.com/nvm-sh/nvm/v0.35.0/install.sh -o install_nvm.sh bash install_nvm.sh source ~/.bash_profile nvm install 14.0.0 npm install sqlite3 --save git clone https://github.com/timeoff-management/application.git timeoff-management cd timeoff-management npm install npm start

Frist error on "source ~/.bash_profile", can't find the file ".bash_profile", there is a .bash_history and .profile but not .bash_profile

Then error on installing sqlite3 from rpm.

How can I create a docker instead of installing on the OS?.

[mermetbt]

@iNaiks I've created a docker image available on DockerHub https://hub.docker.com/r/aliengen/timeoff-management-application with changes that are not included in the current version available in this repository (see my PR #570)

[brandonwylescom]

I know this is somewhat an old thread now, but I have got this running with the following prerequisits

Node 14.0.0
SQLite3
Python2.7 (apt-get update; apt-get install python2.7; ln -s /usr/bin/python2.7 /usr/bin/python)

Follow the usual setup process