Yarn Start throw a sqlite3 issue

[nephaste]

Description

Trying to compile in a /opt/JellySeerr Prefix with NodeJS 16.18.1

but on stat it throw an error with sqlite3

/opt/JellySeer/jellyseerr/node_modules/typeorm/driver/sqlite/SqliteDriver.js:130 throw new DriverPackageNotInstalledError_1.DriverPackageNotInstalledError("SQLite", "sqlite3"); ^

DriverPackageNotInstalledError: SQLite package has not been found installed. Try to install it: npm install sqlite3 --save

sqlite3 is well installed ...

Version

git master

Steps to Reproduce

follwoing step in install tutorial

installed yarn 1.2.19 as well into my prefix

Yarn install

yarn run build

starting on my dev environment (and on target as wel) jump into this error

Screenshots

No response

Logs

dont know how to find it

Platform

desktop

Device

none

Operating System

Linux Ubuntu

Browser

none

Additional Context

No response

Code of Conduct

• [X] I agree to follow Overseerr's Code of Conduct

[nephaste]

already tried to install " npm install sqlite3 --save" but has no impact error remain the same

[Fallenbagel]

Try on nodejs version LTS. Also if you have discord, please join so can give real-time support as we mostly do support on discord

[nephaste]

Hi Thanks... got same problem with Overseerr .. problem is libc on target system is 2.21 and latest bianry prodived by NodeJS are not compatble with this old libc... I will give a try with version 17 (latest working) or build a static version for nodeJS 18

[nephaste]

seems i am unlucky NodeJs17 and NodeJS18 LTS throw the same error

[nephaste]

and got an error installing sqlite3 now

[Fallenbagel]

and got an error installing sqlite3 now

Could you try yarn install sqlite3 --save

[nephaste]

seems command is yarn add sqlite3 --save (also tried without --save) same issue

[Fallenbagel]

Try adding the it to global w the -g arg

[nephaste]

will try tomorrow... also found this

https://github.com/TryGhost/node-sqlite3/wiki/Binaries

will give a try if -g do not work

[nephaste]

but

it is getting me mad , it is well present

and some check

[Fallenbagel]

https://stackoverflow.com/questions/40461439/error-installing-sqlite3-in-node-js

^ Try one of these. There seems to be an issue with your node_modules folder. Have you tried deleting and re-running a yarn install?

Also for a hassle-free usage I recommend docker (and in the near future we will hopefully release snaps, just need it snaps to be configured)

[nephaste]

did everything, built several times... also used the nodejs 16.7.1 (used in docker)

there is no way to make it run when built from source... goal is not use docker and bring it as native application on Qnap NAS

i think more and more than issue is related to typeorm and not sqlite3

latest push version is 0.3.11 ... but may be i am wrong

[nephaste]

installing typeorm 0.2.5 ..error changed

export NODE_ENV=production do not fix

[Fallenbagel]

did everything, built several times... also used the nodejs 16.7.1 (used in docker)

@nephaste Which branch is this. Could you git checkout to the develop branch

But before that remove the node_modules folder. A CLEAN installation might help

Also, which ubuntu os version is this? I have tried on debian, ubuntu (a lot of people in discord use natively built from source in ubuntu, including one of the dev), arch(use for test builds), nixos (running as my production) and alpine (the one used in docker)

EDIT: debian

[nephaste]

I must run on trusty ubuntu 1404 ... due to libc restriction

i am trying to move on dev branch to see (was on main)

still got this typeorm warning

[Fallenbagel]

Those warnings are not significant. You can safely ignore them.

Also I just tested on Ubuntu 22.04.1 LTS

[nephaste]

still no luck .. typeorm makin mess even on dev branch

[Fallenbagel]

still no luck .. typeorm makin mess even on dev branch

Would snap builds work for you? We gonna release snap builds soon

[nephaste]

tried ubuntu 2204 same script... seems to work (thats crazy) ... will see if cross toolchain worked exporting on NAS target

[nephaste]

On target, it goes back with same previous error ... somethin i am missing, not logical

[Fallenbagel]

On target, it goes back with same previous error ... somethin i am missing, not logical

Seems to be related to ubuntu 14.04. The only way I could think of is dockerised or snap builds

[nephaste]

this is my host target (Qnap NAS) not ubuntu 1404, exported compilation in the package

i exported the CC , CXX, etc... for a cross compilation with my toolchain in my script build , but it doesnt take effect ...

export CXX=${HOST}-g++
export LD=${HOST}-ld
export AS=${HOST}-as
export AR=${HOST}-ar
export CC=${HOST}-gcc

do you know if i can crossompile with Yarn (npm) i dont find infromation on this ?

[Fallenbagel]

do you know if i can crossompile with Yarn (npm) i dont find infromation on this ?

I found this but its to cross-compile to arm. Might be able to adapt? https://chrislea.com/2018/08/20/cross-compiling-node-js-for-arm-on-ubuntu/

[nephaste]

thanks, but seems to cross compile nodejs it self and a nodejs application with his modules... will check if i can use my MUSL framwork to build it under an Alpine OS

[nephaste]

Finally able to start with Alpine ELF but crash ... I am definitively unlucky

[Fallenbagel]

Finally able to start with Alpine ELF but crash ... I am definitively unlucky

Which node version is this?

[nephaste]

Hi Finally, fixed this issue by cross compiling correctly sqlite3

basically here are instruction done, where ${HOST} is my toolchain

export npm_config_build_from_source=true

export CC=${HOST}-cc export CXX=${HOST}-g++

CYPRESS_INSTALL_BINARY=0 CC=${HOST}-cc CXX=${HOST}-g++ npm_config_build_from_source=true npm_config_build_from_source=sqlite3 ../bin/yarn install --frozen-lockfile --network-timeout 1000000 ; CC=${HOST}-cc CXX=${HOST}-g++ npm_config_build_from_source=true npm_config_build_from_source=sqlite3 ../bin/yarn run build ;