# Sqlite3 not installed or broken

**URL:** <https://discourse.nodered.org/t/sqlite3-not-installed-or-broken/77010>\
**Category:** General\
**Created:** [28 March 2023 09:00 UTC](https://discourse.nodered.org/t/sqlite3-not-installed-or-broken/77010 "2023-03-28T09:00:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nerevar](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@nerevar](https://discourse.nodered.org/u/nerevar)\
**Post date:** [28 March 2023 09:00 UTC](https://discourse.nodered.org/t/sqlite3-not-installed-or-broken/77010/1 "2023-03-28T09:00:18Z")

</div>

Hello,

I've been trying to do reindex on my db but nothing happens when I run it through the node-red.  
So I tried to do it through shell, but seems there is no sqlite3 installed.

Which is weid because node-red-node-sqlite works OK:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/6/7680c04760c8542549b71b11ebb009b13aaa6895.png)

Also, there is this issue in `/node_modules`:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/e/ee7be2b2cbc2b37d534755b3ec2451bdc091b47d.png)

Here are some querry listings:

```auto
pi@odin:~ $ sqlite3
-bash: sqlite3: command not found

pi@odin:~ $ npm list node-red-node-sqlite
/home/pi
└── node-red-node-sqlite@1.0.1
pi@odin:~ $ npm list sqlite3

/home/pi
└─┬ node-red-node-sqlite@1.0.1
  └── UNMET DEPENDENCY sqlite3@5.0.2

npm ERR! missing: sqlite3@5.0.2, required by node-red-node-sqlite@1.0.1

pi@odin:~ $ dpkg -l | grep sqlite3
iU libaprutil1-dbd-sqlite3:armhf 1.6.1-4+deb10u1 armhf Apache Portable Runtime Utility Library - SQLite3 Driver
ii libsqlite3-0:armhf   

pi@odin:~ $ apt show sqlite3
Package: sqlite3
Version: 3.27.2-3+deb10u2
Priority: optional
Section: database
Maintainer: Laszlo Boszormenyi (GCS) <gcs@debian.org>
Installed-Size: 2,278 kB
Depends: libc6 (>= 2.28), libreadline7 (>= 6.0), zlib1g (>= 1:1.2.0), libsqlite3-0 (= 3.27.2-3+deb10u2)
Suggests: sqlite3-doc
Homepage: https://www.sqlite.org/
Download-Size: 839 kB
APT-Sources: http://raspbian.raspberrypi.org/raspbian buster/main armhf Packages
Description: Command line interface for SQLite 3
 SQLite is a C library that implements an SQL database engine.
 Programs that link with the SQLite library can have SQL database
 access without running a separate RDBMS process.

```

Anyone know how to fix it?

Debian 10 buster  
Node-red 2.14  
Node 14

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [28 March 2023 09:27 UTC](https://discourse.nodered.org/t/sqlite3-not-installed-or-broken/77010/2 "2023-03-28T09:27:00Z")

</div>

> [@nerevar](#):
>
> `pi@odin:~ $ npm list node-red-node-sqlite`

Assuming that you have a conventional install of node-red then you must do that from within your .node-red folder. For some reason it seems you have been installing nodes into your home folder. Possibly by running npm install from there.

> [@nerevar](#):
>
> So I tried to do it through shell, but seems there is no sqlite3 installed.  
> Which is weid because node-red-node-sqlite works OK:

It is not weird, node-red-node-sqlite includes its own driver, the command line utility does not have to be installed. If you want to use it then install it using apt.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [27 May 2023 09:27 UTC](https://discourse.nodered.org/t/sqlite3-not-installed-or-broken/77010/3 "2023-05-27T09:27:26Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.