Dynamic loading not supported

[setop]

Introduction

upgrading from 0.34.0 to 0.35.1, sqlpage fails to connect to database

To Reproduce

• cd into project directory
• launch sqlpage

Actual behavior

[2025-05-27T21:38:38.949Z INFO  sqlpage] Loaded environment variables from "/home/setop/moviegallery/.env"
[2025-05-27T21:38:38.970Z INFO  sqlpage::app_config] Configuration loaded from /home/setop/moviegallery/sqlpage
[2025-05-27T21:38:38.972Z INFO  sqlpage::webserver::database::connect] Loading SQLite extension: ext/text.so
[2025-05-27T21:38:38.989Z WARN  sqlpage::webserver::database::connect] Failed to connect to the database: error returned from database: (code: 0) Dynamic loading not supported. Retrying in 5 seconds.
[2025-05-27T21:38:43.991Z WARN  sqlpage::webserver::database::connect] Failed to connect to the database: error returned from database: (code: 0) Dynamic loading not supported. Retrying in 5 seconds.
[2025-05-27T21:38:48.994Z WARN  sqlpage::webserver::database::connect] Failed to connect to the database: error returned from database: (code: 0) Dynamic loading not supported. Retrying in 5 seconds.

Expected behavior

[2025-05-27T21:35:51.865Z INFO  sqlpage] Loaded environment variables from "/home/setop/moviegallery/.env"
[2025-05-27T21:35:51.870Z INFO  sqlpage::webserver::database::connect] Loading SQLite extension: ext/text.so
[2025-05-27T21:35:51.880Z INFO  sqlpage::webserver::database::migrations] Not applying database migrations because '/home/setop/moviegallery/sqlpage/migrations' does not exist
✨ SQLPage v0.34.0 started successfully! ✨

Version information

• OS: Debian 12.8
• Database : SQLite
• SQLPage Version : 0.35.1

[lovasoa]

Hi ! I'll investigate this. What is text.so ? Could you provide it ? Is it the sqlite fts5 extension ?

The version of sqlite embedded inside sqlpage already includes fts5, so you should not have to include it manually.

[setop]

It comes from sqlean, text extension.

[lovasoa]

Hi ! I downloaded the extension, but still cannot reproduce your issue

[2025-05-28T13:11:07.613Z INFO  sqlpage] Loaded environment variables from "/home/ophir/dev/sqlpage/.env"
[2025-05-28T13:11:07.614Z INFO  sqlpage::app_config] Configuration loaded from /home/ophir/dev/sqlpage/sqlpage
[2025-05-28T13:11:07.614Z INFO  sqlpage::webserver::database::connect] Loading SQLite extension: /tmp/sqlean/text.so
✨ SQLPage v0.35.2 started successfully! ✨

Could you please provide a minimal reproduction ? Ideally, a zip file with the minimal amount of files and the right structure to reproduce the issue without external dependencies.

[lovasoa]

Ok, I got it ! The issue comes from the fact that we now generate statically-built binaries in our releases. I'll look into it. In the meantime, you can use a glibc-based build.

Here is one

sqlpage.xz.zip

Source issue: rusqlite/rusqlite#990

[setop]

all good with 0.35.2