Which SQLite package does opensnitch require on Fedora 41?

[dca00]

$ opensnitch-ui 
Themes not available. Install qt-material if you want to change GUI's appearance: pip3 install qt-material.
Loaded network aliases from /usr/lib/python3/dist-packages/opensnitch/utils/network_aliases/network_aliases.json
	 ~ OpenSnitch GUI - 1.7.2 ~
	protobuf: 3.19.6 - grpc: 1.48.4
-------------------------------------------------- 
QT_AUTO_SCREEN_SCALE_FACTOR: True
gRPC Max Message Length: 4MiB
                  Bytes: 4194304
** Error opening DB: SQLite driver not loaded. DB name: /home/use0/.opensnitch/db
    Available drivers:  ['QSQLITE']
$ sudo dnf install sqlite
Updating and loading repositories:
Repositories loaded.
Package "sqlite-3.46.1-5.fc41.x86_64" is already installed.

Nothing to do.

Debian 13 does not have this problem and starts the UI up right after it is installed. It looks like this is the dependency, but Fedora does not seem to have it:

What should I install?

[dca00]

Can you indicate whether you are unable or unwilling to answer this question?

[gustavo-iniguez-goya]

hi @dca00 ,

Sorry, I have hundreds of unread notifications in the queue , it's not on purpose O:)

In principle, the dependency libqt5sql5-sqlite should provide the sqlite driver. But it seems that PyQt5 and Qt5 have been removed from the repositories.
The sqlite driver is installed under /usr/lib64/qt6/plugins/sqldrivers/.

Given that Qt5 has been removed from the repos, I'd suggest to install latest v1.8.0 which uses PyQt6. If it still doesn't work, launch the GUI as follow and post the output:

$ QT_DEBUG_PLUGINS=1 opensnitch-ui --debug

[dca00]

Dependencies resolved.
=================================================================================================================================================
 Package                                    Architecture              Version                              Repository                       Size
=================================================================================================================================================
Installing:
 opensnitch                                 x86_64                    1.8.0-1                              @commandline                    6.3 M
 opensnitch-ui                              noarch                    1.8.0-1                              @commandline                    1.5 M
Installing dependencies:
 abseil-cpp                                 x86_64                    20240116.3-1.fc40                    updates                         689 k
 grpc-data                                  noarch                    1.48.4-34.fc40                       fedora                           23 k
 info                                       x86_64                    7.1-2.fc40                           fedora                          182 k
 libnetfilter_queue                         x86_64                    1.0.5-8.fc40                         fedora                           28 k
 python-pyqt6-rpm-macros                    noarch                    6.8.1-0.1.fc40                       updates                          10 k
 python3-pyqt6                              x86_64                    6.8.1-0.1.fc40                       updates                         1.1 M
 python3-pyqt6-base                         x86_64                    6.8.1-0.1.fc40                       updates                         3.1 M
 python3-pyqt6-sip                          x86_64                    13.9.1-1.fc40                        updates                          66 k
 python3-text-unidecode                     noarch                    1.3-15.fc40                          fedora                           68 k
 qt6-qtconnectivity                         x86_64                    6.8.2-1.fc40                         updates                         509 k
 qt6-qtremoteobjects                        x86_64                    6.8.2-1.fc40                         updates                         487 k
 qt6-qtsensors                              x86_64                    6.8.2-1.fc40                         updates                         225 k
 qt6-qttools-libs-help                      x86_64                    6.8.2-1.fc40                         updates                         207 k
 qt6-qtwebsockets                           x86_64                    6.8.2-1.fc40                         updates                         108 k
Installing weak dependencies:
 python3-grpcio                             x86_64                    1.48.4-34.fc40                       fedora                          2.3 M
 python3-notify2                            noarch                    0.3.1-20.fc40                        fedora                           19 k
 python3-protobuf                           x86_64                    3.19.6-8.fc40                        fedora                          411 k
 python3-slugify                            noarch                    6.1.2-6.fc40                         fedora                           31 k

Transaction Summary
=================================================================================================================================================
Install  20 Packages

Total size: 17 M
Total download size: 9.4 M
Installed size: 62 M
Is this ok [y/N]: 

Downloading Packages:
(1/18): libnetfilter_queue-1.0.5-8.fc40.x86_64.rpm                                                               169 kB/s |  28 kB     00:00    
(2/18): grpc-data-1.48.4-34.fc40.noarch.rpm                                                                      137 kB/s |  23 kB     00:00    
(3/18): python3-notify2-0.3.1-20.fc40.noarch.rpm                                                                 315 kB/s |  19 kB     00:00    
(4/18): info-7.1-2.fc40.x86_64.rpm                                                                               527 kB/s | 182 kB     00:00    
(5/18): python3-slugify-6.1.2-6.fc40.noarch.rpm                                                                  385 kB/s |  31 kB     00:00    
(6/18): python3-text-unidecode-1.3-15.fc40.noarch.rpm                                                            1.0 MB/s |  68 kB     00:00    
(7/18): python3-protobuf-3.19.6-8.fc40.x86_64.rpm                                                                1.1 MB/s | 411 kB     00:00    
(8/18): python-pyqt6-rpm-macros-6.8.1-0.1.fc40.noarch.rpm                                                        182 kB/s |  10 kB     00:00    
(9/18): abseil-cpp-20240116.3-1.fc40.x86_64.rpm                                                                  2.4 MB/s | 689 kB     00:00    
(10/18): python3-grpcio-1.48.4-34.fc40.x86_64.rpm                                                                2.6 MB/s | 2.3 MB     00:00    
(11/18): python3-pyqt6-sip-13.9.1-1.fc40.x86_64.rpm                                                              947 kB/s |  66 kB     00:00    
(12/18): python3-pyqt6-6.8.1-0.1.fc40.x86_64.rpm                                                                 1.9 MB/s | 1.1 MB     00:00    
(13/18): qt6-qtconnectivity-6.8.2-1.fc40.x86_64.rpm                                                              2.9 MB/s | 509 kB     00:00    
(14/18): qt6-qtsensors-6.8.2-1.fc40.x86_64.rpm                                                                   1.9 MB/s | 225 kB     00:00    
(15/18): qt6-qtremoteobjects-6.8.2-1.fc40.x86_64.rpm                                                             2.0 MB/s | 487 kB     00:00    
(16/18): qt6-qttools-libs-help-6.8.2-1.fc40.x86_64.rpm                                                           3.3 MB/s | 207 kB     00:00    
(17/18): qt6-qtwebsockets-6.8.2-1.fc40.x86_64.rpm                                                                2.0 MB/s | 108 kB     00:00    
(18/18): python3-pyqt6-base-6.8.1-0.1.fc40.x86_64.rpm                                                            3.2 MB/s | 3.1 MB     00:00    
-------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                            4.1 MB/s | 9.4 MB     00:02     
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                         1/1 
  Installing       : qt6-qtwebsockets-6.8.2-1.fc40.x86_64                                                                                   1/20 
  Installing       : qt6-qttools-libs-help-6.8.2-1.fc40.x86_64                                                                              2/20 
  Installing       : qt6-qtsensors-6.8.2-1.fc40.x86_64                                                                                      3/20 
  Installing       : qt6-qtremoteobjects-6.8.2-1.fc40.x86_64                                                                                4/20 
  Installing       : qt6-qtconnectivity-6.8.2-1.fc40.x86_64                                                                                 5/20 
  Installing       : python3-pyqt6-sip-13.9.1-1.fc40.x86_64                                                                                 6/20 
  Installing       : python-pyqt6-rpm-macros-6.8.1-0.1.fc40.noarch                                                                          7/20 
  Installing       : python3-pyqt6-base-6.8.1-0.1.fc40.x86_64                                                                               8/20 
  Installing       : python3-pyqt6-6.8.1-0.1.fc40.x86_64                                                                                    9/20 
  Installing       : abseil-cpp-20240116.3-1.fc40.x86_64                                                                                   10/20 
  Installing       : python3-text-unidecode-1.3-15.fc40.noarch                                                                             11/20 
  Installing       : python3-slugify-6.1.2-6.fc40.noarch                                                                                   12/20 
  Installing       : python3-protobuf-3.19.6-8.fc40.x86_64                                                                                 13/20 
  Installing       : python3-notify2-0.3.1-20.fc40.noarch                                                                                  14/20 
  Installing       : libnetfilter_queue-1.0.5-8.fc40.x86_64                                                                                15/20 
  Installing       : info-7.1-2.fc40.x86_64                                                                                                16/20 
  Installing       : grpc-data-1.48.4-34.fc40.noarch                                                                                       17/20 
  Installing       : python3-grpcio-1.48.4-34.fc40.x86_64                                                                                  18/20 
  Installing       : opensnitch-ui-1.8.0-1.noarch                                                                                          19/20 
  Running scriptlet: opensnitch-ui-1.8.0-1.noarch                                                                                          19/20 
gtk-update-icon-cache: Cache file created successfully.

  Installing       : opensnitch-1.8.0-1.x86_64                                                                                             20/20 
  Running scriptlet: opensnitch-1.8.0-1.x86_64                                                                                             20/20 
Created symlink /etc/systemd/system/multi-user.target.wants/opensnitch.service → /usr/lib/systemd/system/opensnitch.service.


Installed:
  abseil-cpp-20240116.3-1.fc40.x86_64                grpc-data-1.48.4-34.fc40.noarch              info-7.1-2.fc40.x86_64                        
  libnetfilter_queue-1.0.5-8.fc40.x86_64             opensnitch-1.8.0-1.x86_64                    opensnitch-ui-1.8.0-1.noarch                  
  python-pyqt6-rpm-macros-6.8.1-0.1.fc40.noarch      python3-grpcio-1.48.4-34.fc40.x86_64         python3-notify2-0.3.1-20.fc40.noarch          
  python3-protobuf-3.19.6-8.fc40.x86_64              python3-pyqt6-6.8.1-0.1.fc40.x86_64          python3-pyqt6-base-6.8.1-0.1.fc40.x86_64      
  python3-pyqt6-sip-13.9.1-1.fc40.x86_64             python3-slugify-6.1.2-6.fc40.noarch          python3-text-unidecode-1.3-15.fc40.noarch     
  qt6-qtconnectivity-6.8.2-1.fc40.x86_64             qt6-qtremoteobjects-6.8.2-1.fc40.x86_64      qt6-qtsensors-6.8.2-1.fc40.x86_64             
  qt6-qttools-libs-help-6.8.2-1.fc40.x86_64          qt6-qtwebsockets-6.8.2-1.fc40.x86_64        

Complete!

$ opensnitch-ui
Themes not available. Install qt-material if you want to change GUI's appearance: pip3 install qt-material.
Loaded network aliases from /usr/lib/python3/dist-packages/opensnitch/utils/network_aliases/network_aliases.json
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
	 ~ OpenSnitch GUI - 1.8.0 ~
	protobuf: 3.19.6 - grpc: 1.48.4
-------------------------------------------------- 

QT_AUTO_SCREEN_SCALE_FACTOR: True
gRPC Max Message Length: 4MiB
                  Bytes: 4194304
[server] addr: unix:///tmp/osui.sock
db.initialize() error: Database is corrupted (1)

[gustavo-iniguez-goya]

ok, that's a good sign, it didn't complain about the sqlite driver.

Remove the db from disk and reopen the GUI. When it's corrupted we try to recover it, but sometimes is not possible.

[dca00]

$opensnitch-ui 
Themes not available. Install qt-material if you want to change GUI's appearance: pip3 install qt-material.
Loaded network aliases from /usr/lib/python3/dist-packages/opensnitch/utils/network_aliases/network_aliases.json
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
	 ~ OpenSnitch GUI - 1.8.0 ~
	protobuf: 3.19.6 - grpc: 1.48.4
-------------------------------------------------- 

QT_AUTO_SCREEN_SCALE_FACTOR: True
gRPC Max Message Length: 4MiB
                  Bytes: 4194304
[server] addr: unix:///tmp/osui.sock

 ** Error opening DB: SQLite driver not loaded. DB name: /home/use0/.opensnitch/db


    Available drivers:  ['QMARIADB', 'QMYSQL', 'QSQLITE']

[gustavo-iniguez-goya]

See if you have the file libqsqlite.so under /usr/lib64/qt6/plugins/sqldrivers/.
If it's there, execute and post the output of: ldd /usr/lib64/qt6/plugins/sqldrivers/libqsqlite.so

Verify that the sqlite3 libs are installed: ~ $ yum repoquery --installed | grep sqlite

It'll also be usefull the output of: ~ $ QT_DEBUG_PLUGINS=1 opensnitch-ui

Some piece is missing here, a package, a lib...

[gustavo-iniguez-goya]

By the way, the file /usr/lib64/qt6/plugins/sqldrivers/libqsqlite.so is provided by the package qt6-qtbase. It's probably already installed, since it's a basic component, but just to be sure verify that it's installed.

[dca00]

$ ls -l /usr/lib64/qt6/plugins/sqldrivers/libqsqlite.so
-rwxr-xr-x. 1 root root 105136 Feb 12  2025 /usr/lib64/qt6/plugins/sqldrivers/libqsqlite.so
$ yum repoquery --installed | grep sqlite
libdbi-dbd-sqlite-0:0.9.0-28.fc40.x86_64
sqlite-0:3.45.1-3.fc40.x86_64
sqlite-libs-0:3.45.1-3.fc40.i686
sqlite-libs-0:3.45.1-3.fc40.x86_64
$ QT_DEBUG_PLUGINS=1 opensnitch-ui
Themes not available. Install qt-material if you want to change GUI's appearance: pip3 install qt-material.
Loaded network aliases from /usr/lib/python3/dist-packages/opensnitch/utils/network_aliases/network_aliases.json
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
	 ~ OpenSnitch GUI - 1.8.0 ~
	protobuf: 3.19.6 - grpc: 1.48.4
-------------------------------------------------- 

QT_AUTO_SCREEN_SCALE_FACTOR: True
gRPC Max Message Length: 4MiB
                  Bytes: 4194304
[server] addr: unix:///tmp/osui.sock

 ** Error opening DB: SQLite driver not loaded. DB name: /home/use0/.opensnitch/db


    Available drivers:  ['QMARIADB', 'QMYSQL', 'QSQLITE']
$ dnf list qt6-qtbase
Installed Packages
qt6-qtbase.x86_64    6.8.2-3.fc40        @updates
Available Packages
qt6-qtbase.i686      6.8.2-3.fc40        updates 

[gustavo-iniguez-goya]

everything seems to be in place. I'm running out of ideas :(

I've realized that on Fedora QT_DEBUG_PLUGINS=1 doesn't prints to stdout the log traces.

Please, execute the following command and post the log file /tmp/1463.txt: ~ $ QT_DEBUG_PLUGINS=1 strace -f -o /tmp/1463.txt opensnitch-ui --debug

In my environment:

4630  readlink("/usr/lib64/qt6/plugins", 0x7ffd2f289a90, 1023) = -1 EINVAL (Invalid argument)
4630  readlink("/usr/lib64/qt6/plugins/sqldrivers", 0x7ffd2f289a90, 1023) = -1 EINVAL (Invalid argument)
4630  readlink("/usr/lib64/qt6/plugins/sqldrivers/libqsqlite.so", 0x7ffd2f289a90, 1023) = -1 EINVAL (Invalid argument)
4630  openat(AT_FDCWD, "/usr/lib64/qt6/plugins/sqldrivers/libqsqlite.so", O_RDONLY|O_CLOEXEC) = 27

Hopefully we'll see there what's failing.

[dca00]

$ QT_DEBUG_PLUGINS=1 strace -f -o /tmp/1463.txt opensnitch-ui --debug
Themes not available. Install qt-material if you want to change GUI's appearance: pip3 install qt-material.
Loaded network aliases from /usr/lib/python3/dist-packages/opensnitch/utils/network_aliases/network_aliases.json
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
	 ~ OpenSnitch GUI - 1.8.0 ~
	protobuf: 3.19.6 - grpc: 1.48.4
-------------------------------------------------- 

QT_AUTO_SCREEN_SCALE_FACTOR: True
gRPC Max Message Length: 4MiB
                  Bytes: 4194304
[server] addr: unix:///tmp/osui.sock

 ** Error opening DB: SQLite driver not loaded. DB name: /home/use0/.opensnitch/db


    Available drivers:  ['QMARIADB', 'QMYSQL', 'QSQLITE']

1463.txt

[gustavo-iniguez-goya]

thanks!

70440 openat(AT_FDCWD, "/usr/lib64/qt6/plugins/sqldrivers/libqsqlite.so", O_RDONLY|O_CLOEXEC) = 18
70440 read(18, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 832) = 832
70440 fstat(18, {st_mode=S_IFREG|0755, st_size=105136, ...}) = 0

good, the plugin is loaded.

but it seems that for some reason it's not finding the db file:

70440 openat(AT_FDCWD, "/home/user_xxx/.opensnitch/db", O_RDONLY|O_NOFOLLOW|O_CLOEXEC) = -1 ENOENT (No such file or directory)

I'd try to change the db path to for example /tmp/op.db and see if it works.

[dca00]

Argh! My apologies: I've blown away too much, and the subfolder as well. Once I mkdir ~/.opensnitch the UI started right up.
Thanks a lot for your help!

[gustavo-iniguez-goya]

🎉 I'll modify the error message when the db fails to load because it's confusing.

[dca00]

Tried to install 1.8.0-1 on another Fedora 41 box and got the same error, having deleted the DB and kept the .opensnitch folder:

$ opensnitch-ui 
Themes not available. Install qt-material if you want to change GUI's appearance: pip3 install qt-material.
Loaded network aliases from /usr/lib/python3/dist-packages/opensnitch/utils/network_aliases/network_aliases.json
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
	 ~ OpenSnitch GUI - 1.8.0 ~
	protobuf: 3.19.6 - grpc: 1.48.4
-------------------------------------------------- 

QT_AUTO_SCREEN_SCALE_FACTOR: True
gRPC Max Message Length: 4MiB
                  Bytes: 4194304
[server] addr: unix:///tmp/osui.sock

 ** Error opening DB: SQLite driver not loaded. DB name: /home/user_r03/.opensnitch/db


    Available drivers:  ['QSQLITE', 'QMARIADB', 'QMYSQL']
$ yum repoquery --installed | grep sqlite
libdbi-dbd-sqlite-0:0.9.0-29.fc41.x86_64
sqlite-0:3.46.1-5.fc41.x86_64
sqlite-libs-0:3.46.1-5.fc41.i686
sqlite-libs-0:3.46.1-5.fc41.x86_64
$ ls -l /usr/lib64/qt6/plugins/sqldrivers/libqsqlite.so
-rwxr-xr-x 1 root root 109224 Jun 22  2025 /usr/lib64/qt6/plugins/sqldrivers/libqsqlite.so

1463.txt

Should the UI be able to auto-create the folder and the DB?

[gustavo-iniguez-goya]

Oh my! I think I've reproduced this issue.

Let me guess, you are typing the directory + the db file in the file dialog.

[dca00]

Ah, no, not typing it, but simply trying to reproduce the steps above, on the new box:
Install the latest version of opensnitch and opensnitch-ui,
Blow away the DB
Enable/start the service
Start the UI
The above ended up working on the first machine, but is not working on the second one, for some reason.

[gustavo-iniguez-goya]

In this case the db path must exist: ./home/user_r03/.opensnitch/. The GUI right now only creates the db file, not the whole path to the db.

[dca00]

It does exist:

$ ls -l ~/.opensnitch/
total 0
$ opensnitch-ui 
Themes not available. Install qt-material if you want to change GUI's appearance: pip3 install qt-material.
Loaded network aliases from /usr/lib/python3/dist-packages/opensnitch/utils/network_aliases/network_aliases.json
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
qt.sql.qsqldatabase: QSqlDatabase requires a QCoreApplication
	 ~ OpenSnitch GUI - 1.8.0 ~
	protobuf: 3.19.6 - grpc: 1.48.4
-------------------------------------------------- 

QT_AUTO_SCREEN_SCALE_FACTOR: True
gRPC Max Message Length: 4MiB
                  Bytes: 4194304
[server] addr: unix:///tmp/osui.sock

 ** Error opening DB: SQLite driver not loaded. DB name: /home/user_r03/.opensnitch/db


    Available drivers:  ['QSQLITE', 'QMARIADB', 'QMYSQL']

[gustavo-iniguez-goya]

Post please the output of strace -f -e trace=%file -o /tmp/1463.txt opensnitch-ui --debug.
to see what it's trying to open.

Also try other paths, like /tmp/db, /home/user_r03/db, etc.