Thelounge - sqlite3 unable to load #719

Closed
opened 2026-02-04 21:05:52 +03:00 by OVERLORD · 6 comments
Owner

Originally created by @whinette on GitHub (Mar 31, 2025).

Originally assigned to: @tremor021 on GitHub.

Have you read and understood the above guidelines?

yes

📜 What is the name of the script you are using?

The Lounge LXC

📂 What was the exact command used to execute the script?

bash -c "$(wget -qLO - https://github.com/community-scripts/ProxmoxVE/raw/main/ct/the-lounge.sh)"

📝 Provide a clear and concise description of the issue.

I'm migrating from a vps to a lxc.
While migrating the data, I found out no logs were imported and the /search function wasn't enabled.

After discussing with a maintainer of the lounge on irc, it happens when sqlite3 isn't present/supported by the install.

Doing some diging in the service logs and it seems the sqlite3 bundle with the install doesn't install/load correctly.

I tried to install sqlite3 with apt, npm, yarn and also recompile the package (from local source, from online sources), alas to no avail.

⚙️ What settings are you using?

  • Default Settings
  • Advanced Settings

🖥️ Which Linux distribution are you using?

Debian 12

🔄 Steps to reproduce the issue.

Step1. Install the lxc with the given command on https://community-scripts.github.io/ProxmoxVE/scripts?id=the-lounge
Step2. Go into lxc shell
Step3. Type service thelounge status
Step4. Observe that the service is unable to load sqlite3 module

Paste the full error output (if available).

Mar 27 20:07:30 the-lounge systemd[1]: Started thelounge.service - The Lounge (IRC client).
Mar 27 20:07:32 the-lounge thelounge[158]: 2025-03-27 19:07:32 [ERROR] Unable to load sqlite3 module. See https://github.com/mapbox/node-sq>
Mar 27 20:07:34 the-lounge thelounge[158]: 2025-03-27 19:07:34 [INFO] The Lounge v4.4.3 (Node.js 22.14.0 on linux x64)
Mar 27 20:07:34 the-lounge thelounge[158]: 2025-03-27 19:07:34 [INFO] Configuration file: /etc/thelounge/config.js
Mar 27 20:07:34 the-lounge thelounge[158]: 2025-03-27 19:07:34 [INFO] Available at http://[::]:9000/ in private mode

🖼️ Additional context (optional).

Don't need to tweak the config of thelounge to use sqlite3 to observe the issue, a fresh install shows it in the service logs.

Originally created by @whinette on GitHub (Mar 31, 2025). Originally assigned to: @tremor021 on GitHub. ### ✅ Have you read and understood the above guidelines? yes ### 📜 What is the name of the script you are using? The Lounge LXC ### 📂 What was the exact command used to execute the script? bash -c "$(wget -qLO - https://github.com/community-scripts/ProxmoxVE/raw/main/ct/the-lounge.sh)" ### 📝 Provide a clear and concise description of the issue. I'm migrating from a vps to a lxc. While migrating the data, I found out no logs were imported and the `/search` function wasn't enabled. After discussing with a maintainer of the lounge on irc, it happens when sqlite3 isn't present/supported by the install. Doing some diging in the service logs and it seems the sqlite3 bundle with the install doesn't install/load correctly. I tried to install sqlite3 with apt, npm, yarn and also recompile the package (from local source, from online sources), alas to no avail. ### ⚙️ What settings are you using? - [x] Default Settings - [ ] Advanced Settings ### 🖥️ Which Linux distribution are you using? Debian 12 ### 🔄 Steps to reproduce the issue. Step1. Install the lxc with the given command on https://community-scripts.github.io/ProxmoxVE/scripts?id=the-lounge Step2. Go into lxc shell Step3. Type `service thelounge status` Step4. Observe that the service is unable to load sqlite3 module ### ❌ Paste the full error output (if available). ``` Mar 27 20:07:30 the-lounge systemd[1]: Started thelounge.service - The Lounge (IRC client). Mar 27 20:07:32 the-lounge thelounge[158]: 2025-03-27 19:07:32 [ERROR] Unable to load sqlite3 module. See https://github.com/mapbox/node-sq> Mar 27 20:07:34 the-lounge thelounge[158]: 2025-03-27 19:07:34 [INFO] The Lounge v4.4.3 (Node.js 22.14.0 on linux x64) Mar 27 20:07:34 the-lounge thelounge[158]: 2025-03-27 19:07:34 [INFO] Configuration file: /etc/thelounge/config.js Mar 27 20:07:34 the-lounge thelounge[158]: 2025-03-27 19:07:34 [INFO] Available at http://[::]:9000/ in private mode ``` ### 🖼️ Additional context (optional). Don't need to tweak the config of thelounge to use sqlite3 to observe the issue, a fresh install shows it in the service logs.
OVERLORD added the bug label 2026-02-04 21:05:52 +03:00
Author
Owner

@tremor021 commented on GitHub (Mar 31, 2025):

why aren't you just typing apt-get install -y sqlite3 ?

@tremor021 commented on GitHub (Mar 31, 2025): why aren't you just typing `apt-get install -y sqlite3` ?
Author
Owner

@whinette commented on GitHub (Mar 31, 2025):

It was the first thing I did, did not help. Forgot about it I will add it in the issue.

@whinette commented on GitHub (Mar 31, 2025): It was the first thing I did, did not help. Forgot about it I will add it in the issue.
Author
Owner

@tremor021 commented on GitHub (Mar 31, 2025):

oh its Node's module thats missing... I think i know whats the issue. Hold on

@tremor021 commented on GitHub (Mar 31, 2025): oh its Node's module thats missing... I think i know whats the issue. Hold on
Author
Owner

@tremor021 commented on GitHub (Mar 31, 2025):

Image
looks better now :)

@tremor021 commented on GitHub (Mar 31, 2025): ![Image](https://github.com/user-attachments/assets/a1010ff9-250c-4d37-8f93-a50527a5d84c) looks better now :)
Author
Owner

@tremor021 commented on GitHub (Mar 31, 2025):

Ok, so, during .deb install time Node fails to build sqlite3 because some dependencies are missing for it.

After #3542 merges, you should be able to make a new LXC that builds just fine, no errors.

@tremor021 commented on GitHub (Mar 31, 2025): Ok, so, during .deb install time Node fails to build sqlite3 because some dependencies are missing for it. After #3542 merges, you should be able to make a new LXC that builds just fine, no errors.
Author
Owner

@whinette commented on GitHub (Mar 31, 2025):

Thanks. :) I'll confirm tomorrow / once it's merged and close the issue.

@whinette commented on GitHub (Mar 31, 2025): Thanks. :) I'll confirm tomorrow / once it's merged and close the issue.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/ProxmoxVE#719