Not able to run the portable version on NixOS

[felipelalli]

Details

When I try to execute the portable version under the NixOS it says the file doesn't exist.

Steps to reproduce

Download the portable Linux version and try to execute:

Using zsh:

➜  SQLiteStudio ls
assets      iconengines  imageformats  platforminputcontexts  platformthemes  printsupport  sqlitestudiocli
extensions  ico.png      lib           platforms              plugins         sqlitestudio  styles
➜  SQLiteStudio chmod +x sqlitestudio
➜  SQLiteStudio ./sqlitestudio
zsh: no such file or directory: ./sqlitestudio

If I use bash:

[xpto@nixos-locomania:~/app/SQLiteStudio]$ ./sqlitestudio
bash: ./sqlitestudio: cannot execute: required file not found

Operating system

➜  SQLiteStudio nixos-version
23.05.2162.6da4bc6cb07 (Stoat)

SQLiteStudio version

3.4.4

More context

➜  SQLiteStudio ldd sqlitestudio
        linux-vdso.so.1 (0x00007ffd3bf21000)
        libcoreSQLiteStudio.so.1 => /home/xpto/app/SQLiteStudio/./lib/libcoreSQLiteStudio.so.1 (0x00007f9ad3a00000)
        libguiSQLiteStudio.so.1 => /home/xpto/app/SQLiteStudio/./lib/libguiSQLiteStudio.so.1 (0x00007f9ad3200000)
        libQt5Widgets.so.5 => /home/xpto/app/SQLiteStudio/./lib/libQt5Widgets.so.5 (0x00007f9ad2800000)
        libQt5Network.so.5 => /home/xpto/app/SQLiteStudio/./lib/libQt5Network.so.5 (0x00007f9ad2400000)
        libQt5Core.so.5 => /home/xpto/app/SQLiteStudio/./lib/libQt5Core.so.5 (0x00007f9ad1c00000)
        libstdc++.so.6 => /nix/store/843dqq10jdkalr2yazaz6drx334visrb-gcc-12.2.0-lib/lib/libstdc++.so.6 (0x00007f9ad1800000)
        libgcc_s.so.1 => /nix/store/843dqq10jdkalr2yazaz6drx334visrb-gcc-12.2.0-lib/lib/libgcc_s.so.1 (0x00007f9ad3f8a000)
        libc.so.6 => /nix/store/46m4xx889wlhsdj72j38fnlyyvvvvbyb-glibc-2.37-8/lib/libc.so.6 (0x00007f9ad161a000)
        libsqlite3.so => /home/xpto/app/SQLiteStudio/./lib/libsqlite3.so (0x00007f9ad3e91000)
        libQt5Qml.so.5 => /home/xpto/app/SQLiteStudio/./lib/libQt5Qml.so.5 (0x00007f9ad0e00000)
        libpthread.so.0 => /nix/store/46m4xx889wlhsdj72j38fnlyyvvvvbyb-glibc-2.37-8/lib/libpthread.so.0 (0x00007f9ad3e8a000)
        libQt5Gui.so.5 => /home/xpto/app/SQLiteStudio/./lib/libQt5Gui.so.5 (0x00007f9ad0400000)
        libGL.so.1 => not found
        libm.so.6 => /nix/store/46m4xx889wlhsdj72j38fnlyyvvvvbyb-glibc-2.37-8/lib/libm.so.6 (0x00007f9ad3920000)
        libz.so.1 => not found
        libdl.so.2 => /nix/store/46m4xx889wlhsdj72j38fnlyyvvvvbyb-glibc-2.37-8/lib/libdl.so.2 (0x00007f9ad3e85000)
        libgssapi_krb5.so.2 => not found
        libz.so.1 => not found
        libicui18n.so.56 => /home/xpto/app/SQLiteStudio/./lib/libicui18n.so.56 (0x00007f9acfe00000)
        libicuuc.so.56 => /home/xpto/app/SQLiteStudio/./lib/libicuuc.so.56 (0x00007f9acfa00000)
        libicudata.so.56 => /home/xpto/app/SQLiteStudio/./lib/libicudata.so.56 (0x00007f9ace000000)
        /lib64/ld-linux-x86-64.so.2 => /nix/store/46m4xx889wlhsdj72j38fnlyyvvvvbyb-glibc-2.37-8/lib64/ld-linux-x86-64.so.2 (0x00007f9ad3fda000)
        libgthread-2.0.so.0 => not found
        libglib-2.0.so.0 => not found
        librt.so.1 => /nix/store/46m4xx889wlhsdj72j38fnlyyvvvvbyb-glibc-2.37-8/lib/librt.so.1 (0x00007f9ad3e7c000)
        libGL.so.1 => not found
        libz.so.1 => not found

[nix-shell:~/app/SQLiteStudio]$ strace -f -e openat ./sqlitestudio
openat(AT_FDCWD, "/nix/store/46m4xx889wlhsdj72j38fnlyyvvvvbyb-glibc-2.37-8/share/locale/locale.alias", O_RDONLY|O_CLOEXEC) = 3
strace: exec: No such file or directory
+++ exited with 1 +++

[pawelsalawa]

        libGL.so.1 => not found
        libz.so.1 => not found
        libgssapi_krb5.so.2 => not found
        libz.so.1 => not found
        libgthread-2.0.so.0 => not found
        libglib-2.0.so.0 => not found
        libGL.so.1 => not found
        libz.so.1 => not found

This is the problem. You need these files and either they are in packages, that you don't have installed yet, or they are in directories, that aren't in LD_LIBRARY_PATH, or they are named differently under NixOS - in which case you can simply create symlinks to them to match expected names.

[felipelalli]

If the version is "portable", I would expect these dependencies to be included in the final package. However, if that's not feasible, please follow the shell.nix that I've constructed after much trial and error, along with an extended conversation with ChatGPT (however I'm not sure if this is the best optimized option):

{ pkgs ? import <nixpkgs> { } }:

let
  qt = pkgs.qt515;
  sqliteStudioPath = ".";  
in
pkgs.mkShell {
  # Just for some extra debug-useful visibility
  QT_DEBUG_PLUGINS = 1;

  LD_LIBRARY_PATH = with pkgs; pkgs.lib.makeLibraryPath [
    qt5.full
    zlib
    krb5
    glib
    patchelf
    readline
    stdenv.cc.cc
    libGL
    zlib
    glib # libgthread-2.0.so
    xorg.libX11 # libX11-xcb.so
    xorg.libxcb # libxcb-shm.so
    xorg.xcbutilwm # libxcb-icccm.so
    xorg.xcbutil # libxcb-util.so
    xorg.xcbutilimage # libxcb-image.so
    xorg.xcbutilkeysyms # libxcb-keysyms.so
    xorg.xcbutilrenderutil # libxcb-renderutil.so
    xorg.xcbutilrenderutil # libxcb-renderutil.so
    dbus # libdbus-1.so
    libxkbcommon # libxkbcommon-x11.so
    fontconfig
    freetype
  ];

  shellHook = ''
    export LD_LIBRARY_PATH=${sqliteStudioPath}/lib:${pkgs.libGL.out}/lib:${pkgs.zlib.out}/lib:${pkgs.glib.out}/lib:${pkgs.qt5.full.out}/lib:${pkgs.xorg.libX11.out}/lib:${pkgs.xorg.libxcb.out}/lib:${pkgs.xorg.xcbutilwm.out}/lib:${pkgs.xorg.xcbutil.out}/lib:${pkgs.xorg.xcbutilimage.out}/lib:${pkgs.xorg.xcbutilkeysyms.out}/lib:${pkgs.xorg.xcbutilrenderutil.out}/lib:${pkgs.dbus.out}/lib:${pkgs.libxkbcommon.out}/lib:${pkgs.fontconfig.out}/lib:${pkgs.freetype.out}/lib:$LD_LIBRARY_PATH
    patchelf --set-interpreter "$(cat $NIX_CC/nix-support/dynamic-linker)" ./sqlitestudio
    patchelf --set-rpath "${pkgs.libGL.out}/lib:${pkgs.zlib.out}/lib:${pkgs.glib.out}/lib:${pkgs.qt5.full.out}/lib:${pkgs.xorg.libX11.out}/lib:${pkgs.xorg.libxcb.out}/lib:${pkgs.xorg.xcbutilwm.out}/lib:${pkgs.xorg.xcbutil.out}/lib:${pkgs.xorg.xcbutilimage.out}/lib:${pkgs.xorg.xcbutilkeysyms.out}/lib:${pkgs.xorg.xcbutilrenderutil.out}/lib:${pkgs.dbus.out}/lib:${pkgs.libxkbcommon.out}/lib:${pkgs.fontconfig.out}/lib:${pkgs.freetype.out}/lib" ./sqlitestudio
    export QT_PLUGIN_PATH="${pkgs.qt5.qtbase.bin}/lib/qt-${pkgs.qt5.qtbase.version}/plugins/platforms"
  '';
}

Note that this .nix maybe doesn't work for any users, because my system (configuration.nix) already has much pre-installed packages.

For the NixOS users, just put this file on the root of SQLiteStudio and run nix-shell. Maybe it will be necessary to edit ~/.config/nixpkgs/config.nix and add as well:

{
  permittedInsecurePackages = [
   "qtwebkit-5.212.0-alpha4"
  ];
}

---

Maybe it would be a good idea to make an official package for NixOS:

• NixOS Packaging/Tutorial

Or, at least, it would be nice to include this shell.nix at root level of the final package. The NixOS users would know what to do. Remember: it have to be tested/fixed in a fresh installation of NixOS.

[felipelalli]

Related: NixOS/nixpkgs#126536