Snakeoil Forums
[split] Problem starting API server 1.4.1 (Missing qsqlite3 lib) - Printable Version

+- Snakeoil Forums (https://forums.snakeoil-os.net)
+-- Forum: Snakeoil Topics (https://forums.snakeoil-os.net/Forum-Snakeoil-Topics)
+--- Forum: Support & Troubleshooting (https://forums.snakeoil-os.net/Forum-Support-Troubleshooting)
+--- Thread: [split] Problem starting API server 1.4.1 (Missing qsqlite3 lib) (/Thread-split-Problem-starting-API-server-1-4-1-Missing-qsqlite3-lib)

Pages: 1 2

[split] Problem starting API server 1.4.1 (Missing qsqlite3 lib) - clark8888 - 20-Mar-2025

help!  After upgrade 1.4.1, can not enter into web control any more:  
[Image: Image-1.jpg]

RE: Snakeoil 1.4.1 (High End U1) - agent_kith - 20-Mar-2025

(20-Mar-2025, 10:36 AM)clark8888 Wrote: help!  After upgrade 1.4.1, can not enter into web control any more:  

Can you run these? First command to remove snakeoil, second+third command is to reinstall snakeoil. Last command is to tell me which version of snakeoil that's installed.
 
Code:
sudo apt remove snakeoil             # remove snakeoil
sudo apt update                            # update apt database
sudo apt install snakeoil               # re-install snakeoil
snakeoil-rest --long-version          # Show snakeoil version
ldd /usr/local/sbin/snakeoil-rest    # Show libraries

If "--long-version" don't work. Then run the last one ("ldd") as i suspect a library is missing on the system (which I missed in the deb install).. Some folks have that missing library while others don't. So that's why it seems some folks are ok, but others aren't.

RE: Snakeoil 1.4.1 (High End U1) - clark8888 - 20-Mar-2025

(20-Mar-2025, 11:01 AM)agent_kith Wrote:
(20-Mar-2025, 10:36 AM)clark8888 Wrote: help!  After upgrade 1.4.1, can not enter into web control any more:  

Can you run these? First command to remove snakeoil, second+third command is to reinstall snakeoil. Last command is to tell me which version of snakeoil that's installed.
 
Code:
sudo apt remove snakeoil             # remove snakeoil
sudo apt update                            # update apt database
sudo apt install snakeoil               # re-install snakeoil
snakeoil-rest --long-version          # Show snakeoil version
ldd /usr/local/sbin/snakeoil-rest    # Show libraries

If "--long-version" don't work. Then run the last one ("ldd") as i suspect a library is missing on the system (which I missed in the deb install).. Some folks have that missing library while others don't. So that's why it seems some folks are ok, but others aren't.
reinstallation has same result.

 snakeoil-rest --long-version
### Snakeoil Build information ###
  git hash: 3c1cb09
git branch: main
 Timestamp: 20250317T1735
     build: 1.4.1 (High-End U1)

ldd /usr/local/sbin/snakeoil-rest
        linux-vdso.so.1 (0x00007fff38d49000)
        libmcrypt.so.4 => /lib/x86_64-linux-gnu/libmcrypt.so.4 (0x00007f9d069a4000)
        libyaml-cpp.so.0.8 => /lib/x86_64-linux-gnu/libyaml-cpp.so.0.8 (0x00007f9d0695b000)
        libQt6HttpServer.so.6 => /usr/local/lib/libQt6HttpServer.so.6 (0x00007f9d06925000)
        libQt6Network.so.6 => /usr/local/lib/libQt6Network.so.6 (0x00007f9d06714000)
        libQt6Sql.so.6 => /usr/local/lib/libQt6Sql.so.6 (0x00007f9d066bd000)
        libQt6Core.so.6 => /usr/local/lib/libQt6Core.so.6 (0x00007f9d05fe1000)
        libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f9d05d63000)
        libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f9d05d35000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f9d05b23000)
        libQt6WebSockets.so.6 => /usr/local/lib/libQt6WebSockets.so.6 (0x00007f9d05aea000)
        libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f9d059ff000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f9d059fa000)
        libzstd.so.1 => /lib/x86_64-linux-gnu/libzstd.so.1 (0x00007f9d05940000)
        libgssapi_krb5.so.2 => /lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007f9d058ec000)
        libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f9d058d0000)
        libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f9d058bb000)
        libicui18n.so.73 => /usr/local/lib/libicui18n.so.73 (0x00007f9d0556c000)
        libicuuc.so.73 => /usr/local/lib/libicuuc.so.73 (0x00007f9d05354000)
        libicudata.so.73 => /usr/local/lib/libicudata.so.73 (0x00007f9d034c6000)
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f9d034c1000)
        libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f9d03376000)
        libgthread-2.0.so.0 => /lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007f9d03371000)
        librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f9d0336c000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f9d06b2f000)
        libkrb5.so.3 => /lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007f9d032a3000)
        libk5crypto.so.3 => /lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007f9d03277000)
        libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007f9d0326f000)
        libkrb5support.so.0 => /lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007f9d03262000)
        libpcre2-8.so.0 => /lib/x86_64-linux-gnu/libpcre2-8.so.0 (0x00007f9d031c8000)
        libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007f9d031c1000)

RE: Snakeoil 1.4.1 (High End U1) - agent_kith - 20-Mar-2025

(20-Mar-2025, 05:09 PM)clark8888 Wrote: reinstallation has same result.
Everything looks correct as far as I can tell. It's pretty strange.. :/

Can you run these?
Code:
systemctl disable snakeoil-rest

sudo /usr/local/sbin/snakeoil-rest --verbosity 10
And show me the output?

Once you are done, re-run this again:
Code:
systemctl enable snakeoil-rest
Otherwise the API server will not restart on reboot.

RE: Snakeoil 1.4.1 (High End U1) - clark8888 - 21-Mar-2025

(20-Mar-2025, 05:53 PM)agent_kith Wrote:
(20-Mar-2025, 05:09 PM)clark8888 Wrote: reinstallation has same result.
Everything looks correct as far as I can tell. It's pretty strange.. :/

Can you run these?
 
Code:
systemctl disable snakeoil-rest

sudo /usr/local/sbin/snakeoil-rest --verbosity 10
And show me the output?

sudo /usr/local/sbin/snakeoil-rest --verbosity 10
 
  • Snakeoil OS API Server 1.4.1 (High-End U1) [RELEASE] [service/singleton.cpp:125|singleton_c::init()]
    [4] QSqlDatabase: QSQLITE driver not loaded
    [4] QSqlDatabase: available drivers:
    [5] Cannot open snakeoil configuration, access problem? [service/database.cpp:41|database_c::database_c()]
    Segmentation fault



    Once you are done, re-run this again:
     
    Code:
    systemctl enable snakeoil-rest
    Otherwise the API server will not restart on reboot.
  •  systemctl status  snakeoil-rest
    ● snakeoil-rest.service - Snakeoil RestAPI server
         Loaded: loaded (/etc/systemd/system/snakeoil-rest.service; enabled; preset: enabled)
         Active: activating (auto-restart) (Result: exit-code) since Fri 2025-03-21 02:00:26 UTC; 2s ago
        Process: 2756 ExecStart=/usr/local/bin/snakeoil-server.sh (code=exited, status=1/FAILURE)
       Main PID: 2756 (code=exited, status=1/FAILURE)
            CPU: 32ms



RE: [split] Problem starting API server 1.4.1 (Missing qsqlite3 lib) - agent_kith - 21-Mar-2025

@clark8888 

What version of Ubuntu Noble are you using? Is it Raspberry Pi or amd64?
Can you run this command and show me the output?
Code:
find /usr/local/lib/plugins -type f

Also, run this and tell me what's in this file
Code:
cat /etc/systemd/system/snakeoil-rest.service

your problem is somehow in your environment your OS cannot find the plugins folder for that sqlite3 driver.

RE: [split] Problem starting API server 1.4.1 (Missing qsqlite3 lib) - clark8888 - 21-Mar-2025

(21-Mar-2025, 11:31 AM)agent_kith Wrote: @clark8888 

What version of Ubuntu Noble are you using? Is it Raspberry Pi or amd64?
Can you run this command and show me the output?

Intel n4100 x64  linux 6.8.1-1015-realtime #16-Ubuntu server 24.04 SMP PREEMPT_RT
Code:
find /usr/local/lib/plugins -type f
find /usr/local/lib/plugins -type f
/usr/local/lib/plugins/sqldrivers/libqsqlite.so
/usr/local/lib/plugins/networkinformation/libqglib.so
/usr/local/lib/plugins/networkinformation/libqnetworkmanager.so
/usr/local/lib/plugins/tls/libqcertonlybackend.so
/usr/local/lib/plugins/tls/libqopensslbackend.so

Also, run this and tell me what's in this file
 
Code:
cat /etc/systemd/system/snakeoil-rest.service
cat /etc/systemd/system/snakeoil-rest.service
[Unit]
Description=Snakeoil RestAPI server
Wants=network-online.target network.target
After=network.target network-online.target nmbd.service

[Service]
User=root
WorkingDirectory=/var/www/
Environment=QT_PLUGIN_PATH=/usr/local/lib/plugins/
ExecStart=/usr/local/bin/snakeoil-server.sh
# optional items below
Restart=always
RestartSec=3

[Install]
WantedBy=multi-user.target

your problem is somehow in your environment your OS cannot find the plugins folder for that sqlite3 driver.
But I only updated from SO 1.4.0. and did nothing else.    Now only GUI is missing, I can still use LMS/Album Player/Diretta host

RE: [split] Problem starting API server 1.4.1 (Missing qsqlite3 lib) - agent_kith - 22-Mar-2025

(21-Mar-2025, 02:46 PM)clark8888 Wrote: But I only updated from SO 1.4.0. and did nothing else.    Now only GUI is missing, I can still use LMS/Album Player/Diretta host
This is weird, so pressing SHIFT + the reload button (or SHIFT+F5) don't get the WebApp back?

Can you try this again?
 
Code:
systemctl disable snakeoil-rest
systemctl stop snakeoil-rest
sudo QT_PLUGIN_PATH=/usr/local/lib/plugins/ /usr/local/sbin/snakeoil-rest --verbosity 10

And show me the logs of the API service.

After which you can run:
Code:
systemctl enable snakeoil-rest

Reboot the computer, then run this and show me the output
Code:
journalctl -u snakeoil-rest --since="24 hours ago"


RE: [split] Problem starting API server 1.4.1 (Missing qsqlite3 lib) - agent_kith - 22-Mar-2025

I suspect it's some entry in the database. Folks with this problem, can you SSH to your machine, and run this command:
Code:
snakeoil-rest --diag

You will get a file called: "/media/music/diagnostics.tar.bz2". Please send this file to support"AT"snakeoil-os.net (Replace "AT" with @) so I can have a look at what is causing the problem.

RE: [split] Problem starting API server 1.4.1 (Missing qsqlite3 lib) - clark8888 - 22-Mar-2025

(22-Mar-2025, 09:41 AM)agent_kith Wrote: I suspect it's some entry in the database. Folks with this problem, can you SSH to your machine, and run this command:
 
Code:
snakeoil-rest --diag

You will get a file called: "/media/music/diagnostics.tar.bz2". Please send this file to support"AT"snakeoil-os.net (Replace "AT" with @) so I can have a look at what is causing the problem.
file sent by email