search

ioBroker / ioBroker.sql

Store history data in SQL Database: MySQL, PostgreSQL or SQLite
MIT License
45 stars 24 forks source link

sqlite3 not working due to missing sql package #306

Closed daniel-2k closed 1 year ago

daniel-2k commented 1 year ago

I updated the iobroker.sql adapter (to latest 2.2.0) and after that, the adapter does not start. I get an error in the log

SQL package "SQLite3Client" is not installed.

I checked the installation of node.js "sql-client". The "sqlite3" package is installed and up to date.

What is missing here to start the adapter?

My environment is a raspberry pi. Node v16

Apollon77 commented 1 year ago

If this comes then most likely the native build of sqlite3 failed somehow. An install log would help.

YOu can try to do "npm rebuild" or "nom install" in the sqlite3 directory

daniel-2k commented 1 year ago

npm rebuild in sqlite3 directory worked, but first after upgrading my python3 to >= 3.6 (3.8). Otherwise rebuild failed.