Can't install node-red-node-sqlite from manage palette

[AlbertoGiani]

As i wrote in the title i'm getting an error when trying to install sqlite from manage palette, i managed to install several others components but this isn't working. this is the log ( i also tried to install directly the tgz file but it is still not working). Thanks you

[CodeShepherd]

Did you already check e.g. this post that shows steps to go to install a palette?

[Sgilk]

Hello @AlbertoGiani ,

Are you doing this on a physical or virtual CORE? What versions of ctrlX OS apps and Node-RED are installed?

I just installed this pallet on a physical CORE with 1.20 apps and did not experience this issue.

[AlbertoGiani]

Hello, i'm doing this on a virtual core, i have ctrlx version 1.20.9 and node red: 1.20.0 + 3.0.2-ctrlx

[Sgilk · Accepted solution]

@AlbertoGiani ,

Please do not make duplicate posts (see Nodered 1.20.0 + 3.0.2-ctrlx, can't install sqlite). I was able to reproduce this with your versions. This is a problem specific to the virtual CORE architecture. In the pallet documentation, native code is compiled on the device during installation and this is where the failure occurs. The npm package sqlite3 is used which looks to only be supported on arm architecture.

Unfortunately, prebuild cannot differentiate between armv6 and armv7, and instead uses arm as the {arch}. Until that is fixed, you will still need to install sqlite3 from source.

As this is a 3rd party node, this is about as much support as I can provide here. It should work fine on an arm device.

[AlbertoGiani]

Hello and thanks you for your reply, unfortunatly i need to install sqlite on my virtual core because i have really limited access to the physical core and I will be able to use it ony for a couple hours when i have finished to prepare the whole project in virtual. Do you have any idea of any solution? how can i install sqlite from source as you suggested? thanks you

[Sgilk · Accepted solution]

@AlbertoGiani ,

Give this a shot. Article will be released soon.

[AlbertoGiani]

It worked! you saved me ahhaa thanks you very much for all the help

[Sgilk]

@AlbertoGiani ,

Sorry, but I don't think this works actually. I could install, but the nodes do not function. I believe it is because the package calls for a native compilation...