• Bug#1107146: sqlite3 does not look in XDG_CONFIG_HOME for config file a

    From Bastian Venthur@21:1/5 to All on Mon Jun 2 10:40:01 2025
    Package: sqlite3
    Version: 3.46.1-6
    Severity: normal
    X-Debbugs-Cc: venthur@debian.org

    Dear Maintainer,

    the man page of sqlite3 says

    If the file ${XDG_CONFIG_HOME}/sqlite3/sqliterc or ~/.sqliterc exists, the first of those to be found is processed during startup.

    however, it does not look in XDG_CONFIG_HOME at all. You can verify with

    ```
    strace -f -t -e trace=file sqlite3
    ```

    Cheers,

    Bastian


    -- System Information:
    Debian Release: 13.0
    APT prefers unstable
    APT policy: (500, 'unstable')
    Architecture: amd64 (x86_64)
    Foreign Architectures: i386

    Kernel: Linux 6.12.29-amd64 (SMP w/16 CPU threads; PREEMPT)
    Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
    Shell: /bin/sh linked to /usr/bin/dash
    Init: systemd (via /run/systemd/system)
    LSM: AppArmor: enabled

    Versions of packages sqlite3 depends on:
    ii libc6 2.41-8
    ii libreadline8t64 8.2-6
    ii libsqlite3-0 3.46.1-6
    ii zlib1g 1:1.3.dfsg+really1.3.1-1+b1

    sqlite3 recommends no packages.

    Versions of packages sqlite3 suggests:
    pn sqlite3-doc <none>

    -- no debconf information

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Petter Reinholdtsen@21:1/5 to All on Mon Jun 2 11:30:01 2025
    [Bastian Venthur]
    however, it does not look in XDG_CONFIG_HOME at all. You can verify with

    ```
    strace -f -t -e trace=file sqlite3
    ```

    Sure enough.

    % echo | XDG_CONFIG_HOME=/tmp strace -f -t -e trace=file sqlite3 2>&1 |grep /tmp
    %

    --
    Happy hacking
    Petter Reinholdtsen

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bastian Venthur@21:1/5 to All on Mon Jun 2 11:50:01 2025
    Package: sqlite3
    Version: 3.46.1-6
    Followup-For: Bug #1107146
    X-Debbugs-Cc: venthur@debian.org

    FYI: Seems like upstream has a fix applied for this issue:

    https://www.sqlite.org/src/info/33841c9c3cb57bee

    which seems not available in Debian's sources.


    -- System Information:
    Debian Release: 13.0
    APT prefers unstable
    APT policy: (500, 'unstable')
    Architecture: amd64 (x86_64)
    Foreign Architectures: i386

    Kernel: Linux 6.12.29-amd64 (SMP w/16 CPU threads; PREEMPT)
    Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
    Shell: /bin/sh linked to /usr/bin/dash
    Init: systemd (via /run/systemd/system)
    LSM: AppArmor: enabled

    Versions of packages sqlite3 depends on:
    ii libc6 2.41-8
    ii libreadline8t64 8.2-6
    ii libsqlite3-0 3.46.1-6
    ii zlib1g 1:1.3.dfsg+really1.3.1-1+b1

    sqlite3 recommends no packages.

    Versions of packages sqlite3 suggests:
    pn sqlite3-doc <none>

    -- no debconf information

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)