1 Temat przez dzeus

  • dzeus
  • Użytkownik
  • Nieaktywny
  • Zarejestrowany: 2012-04-02
  • Posty: 69

Temat: SQLite header and source version mismatch - co zrobić jak żyć?:)

Hej,

po aktualizacji do:

 ----------------------------------------------------------------------------
 |         _____                             _          _____  _            |
 |        |  __ \                           | |        |  __ \| |           |
 |        | |  \/ __ _ _ __ __ _  ___  _   _| | ___    | |__) | |           |
 |        | | __ / _` | '__/ _` |/ _ \| | | | |/ _ \   |  ___/| |           |
 |        | |_\ \ (_| | | | (_| | (_) | |_| | |  __/   | |    | |__         |
 |         \____/\__,_|_|  \__, |\___/ \__, |_|\___|   |_|    |____|        |
 |                          __/ |       __/ |                               |
 |                         |___/       |___/                                |
 |                                                                          |
 |--------------------------------------------------------------------------|
 | Gargoyle PL version 1.15.0.1        | OpenWrt 23.05 branch               |
 | Gargoyle revision 491a1b2d          | OpenWrt commit 1292a49             |
 | Built February 06, 2025             | Target  ath79/default              |
 ----------------------------------------------------------------------------

Zainstalowałem pakiet pod sqlite3

opkg info sqlite3-cli
Package: sqlite3-cli
Version: 3410200-1
User-Installed: true
Install-Destination: root
SHA256sum: 86c1c1a17cad37b56da05f112f66421cf2e264e96702dc6539668bcba90718ec
Source: feeds/packages/libs/sqlite3
Size: 102116
SourceDateEpoch: 1758107533
Installed-Size: 101706
License: PUBLICDOMAIN
Installed-Time: 0
Description: SQLite is a small C library that implements a self-contained, embeddable,
             zero-configuration SQL database engine.
             This package contains a terminal-based front-end to the SQLite (v3.x) library
             that can evaluate queries interactively and display the results in multiple
             formats.
Architecture: mips_24kc
Source-ID: openwrt_23.05-SNAPSHOT_packages
CPE-ID: cpe:/a:sqlite:sqlite
SourceName: sqlite3-cli
Section: utils
Filename: sqlite3-cli_3410200-1_mips_24kc.ipk
Status: install user installed
Depends: libc, libsqlite3-0, libedit

Niestety przy próbuje odpalenia dostaję błąd

sqlite3
SQLite header and source version mismatch
2023-03-10 12:13:52 20399f3eda5ec249d147ba9e48da6e87f969d7966a9a896764ca437ff7e737ff
2023-03-22 11:56:21 0d1fc92f94cb6b76bffe3ec34d69cffde2924203304e8ffc4155597af0c191da

Czy mam ręcznie podgrać inne DLLki?

2 Odpowiedź przez Cezary

  • Skąd: Warszawa
  • Zarejestrowany: 2006-02-25
  • Posty: 116,352

Odp: SQLite header and source version mismatch - co zrobić jak żyć?:)

Z tego samego źródła zainstaluj i sqlite3 i libsqlite, czyli bezpośrednio z repo openwrt, nie ode mnie jedno.

Masz niepotrzebny router, uszkodzony czy nie - chętnie przygarnę go.

Cezary's Strona

3 Odpowiedź przez dzeus (edytowany przez dzeus 2025-10-01 12:31:59)

  • dzeus
  • Użytkownik
  • Nieaktywny
  • Zarejestrowany: 2012-04-02
  • Posty: 69

Odp: SQLite header and source version mismatch - co zrobić jak żyć?:)

Qde, jakoś pod górę to wszystko.

Znalazłem dwa pakiety

https://mirror-03.infra.openwrt.org/releases/23.05-SNAPSHOT/packages/mips_24kc/packages/sqlite3-cli_3410200-1_mips_24kc.ipk
https://mirror-03.infra.openwrt.org/releases/23.05-SNAPSHOT/packages/mips_24kc/packages/libsqlite3-0_3410200-1_mips_24kc.ipk

Pobrałem do /tmp i odpaliłem:opkg install z nawami pakietów.

Po bojach się zaisntalowało, ale teraz dostaję

sqlite3
Bus error

ta instalacja też chyba ine poszła jak powinna bo;

opkg info sqlite3-cli
Package: sqlite3-cli
Version: 3410200-1
User-Installed: true
Install-Destination: root
SHA256sum: 86c1c1a17cad37b56da05f112f66421cf2e264e96702dc6539668bcba90718ec
Source: feeds/packages/libs/sqlite3
Size: 102116
SourceDateEpoch: 1758107533
Installed-Size: 101706
License: PUBLICDOMAIN
Installed-Time: 0
Description: SQLite is a small C library that implements a self-contained, embeddable,
             zero-configuration SQL database engine.
             This package contains a terminal-based front-end to the SQLite (v3.x) library
             that can evaluate queries interactively and display the results in multiple
             formats.
Architecture: mips_24kc
Source-ID: openwrt_23.05-SNAPSHOT_packages
CPE-ID: cpe:/a:sqlite:sqlite
SourceName: sqlite3-cli
Section: utils
Filename: sqlite3-cli_3410200-1_mips_24kc.ipk
Status: install user installed
Depends: libc, libsqlite3-0, libedit

root@Gargoyle:/tmp$ opkg remove sqlite3-cli
ERROR: Package sqlite3-cli is installed to destination 'root' which is not writable, cannot uninstall

+

ackage: libsqlite3-0
Version: 3410200-1
User-Installed: true
Install-Destination: root
SHA256sum: d8e63e620c0870466c92e0ec8a45555f70f38b82b24e48c70f5e3db1f4954227
Source: feeds/packages/libs/sqlite3
Size: 507615
SourceDateEpoch: 1758107533
Installed-Size: 507543
License: PUBLICDOMAIN
Installed-Time: 0
Provides: libsqlite3
Description: SQLite is a small C library that implements a self-contained, embeddable,
             zero-configuration SQL database engine.
             This package contains the SQLite (v3.x) shared library, used by other
             programs.
Architecture: mips_24kc
Source-ID: openwrt_23.05-SNAPSHOT_packages
CPE-ID: cpe:/a:sqlite:sqlite
SourceName: libsqlite3
Section: libs
Filename: libsqlite3-0_3410200-1_mips_24kc.ipk
Status: install user half-installed
Depends: libc, libpthread, zlib
ABIVersion: -0

4 Odpowiedź przez Cezary

  • Skąd: Warszawa
  • Zarejestrowany: 2006-02-25
  • Posty: 116,352

Odp: SQLite header and source version mismatch - co zrobić jak żyć?:)

Albo właśnie zawaliłeś flash i nic dalej nie da się zrobić. Zobacz ile masz wolnego we flash.

Masz niepotrzebny router, uszkodzony czy nie - chętnie przygarnę go.

Cezary's Strona

5 Odpowiedź przez dzeus (edytowany przez dzeus 2025-10-01 13:08:43)

  • dzeus
  • Użytkownik
  • Nieaktywny
  • Zarejestrowany: 2012-04-02
  • Posty: 69

Odp: SQLite header and source version mismatch - co zrobić jak żyć?:)

Dobra, przywróciłem do fabrycznych, tak było najprościej. Pytanie jak teraz to ogarnąć, aby było po bożemu smile

na świeżo tak wyglądają pakiety:

opkg info sqlite3-cli
Package: sqlite3-cli
Version: 3410200-1
Install-Destination: Not Installed
SHA256sum: 86c1c1a17cad37b56da05f112f66421cf2e264e96702dc6539668bcba90718ec
Size: 102116
Installed-Size: 101706
License: PUBLICDOMAIN
Description: SQLite is a small C library that implements a self-contained, embeddable,
             zero-configuration SQL database engine.
             This package contains a terminal-based front-end to the SQLite (v3.x) library
             that can evaluate queries interactively and display the results in multiple
             formats.
Architecture: mips_24kc
Source-ID: openwrt_23.05-SNAPSHOT_packages
CPE-ID: cpe:/a:sqlite:sqlite
Section: utils
Filename: sqlite3-cli_3410200-1_mips_24kc.ipk
Status: unknown ok not-installed
Depends: libc, libsqlite3-0, libedit

+

opkg info libsqlite3-0
Package: libsqlite3-0
Version: 3410100-1
User-Installed: false
Install-Destination: root
SHA256sum: b8bd167965e0d4df84f676a338d3d993bb1fe6b1752c218105e3b2d5808ed3cb
Auto-Installed: yes
Size: 507514
Installed-Size: 507429
License: PUBLICDOMAIN
Installed-Time: 1738049803
Provides: libsqlite3
Description: SQLite is a small C library that implements a self-contained, embeddable,
             zero-configuration SQL database engine.
             This package contains the SQLite (v3.x) shared library, used by other
             programs.
Architecture: mips_24kc
Source-ID: gargoylepl_base
CPE-ID: cpe:/a:sqlite:sqlite
Section: libs
Filename: libsqlite3-0_3410100-1_mips_24kc.ipk
Status: install ok installed
Depends: libc, libpthread, zlib
ABIVersion: -0

Package: libsqlite3-0
Version: 3410200-1
Install-Destination: Not Installed
SHA256sum: d8e63e620c0870466c92e0ec8a45555f70f38b82b24e48c70f5e3db1f4954227
Size: 507615
Installed-Size: 507543
License: PUBLICDOMAIN
Provides: libsqlite3
Description: SQLite is a small C library that implements a self-contained, embeddable,
             zero-configuration SQL database engine.
             This package contains the SQLite (v3.x) shared library, used by other
             programs.
Architecture: mips_24kc
Source-ID: openwrt_23.05-SNAPSHOT_packages
CPE-ID: cpe:/a:sqlite:sqlite
Section: libs
Filename: libsqlite3-0_3410200-1_mips_24kc.ipk
Status: unknown ok not-installed
Depends: libc, libpthread, zlib
ABIVersion: -0

6 Odpowiedź przez Cezary

  • Skąd: Warszawa
  • Zarejestrowany: 2006-02-25
  • Posty: 116,352

Odp: SQLite header and source version mismatch - co zrobić jak żyć?:)

libsqlite3-0 zaktualizuj do wersji 3410200-1

opkg update
opkg install libsqlite3-0

Jeżeli taka wersja jest w repo.

Masz niepotrzebny router, uszkodzony czy nie - chętnie przygarnę go.

Cezary's Strona

7 Odpowiedź przez dzeus

  • dzeus
  • Użytkownik
  • Nieaktywny
  • Zarejestrowany: 2012-04-02
  • Posty: 69

Odp: SQLite header and source version mismatch - co zrobić jak żyć?:)

hmm

root@Gargoyle:~# opkg install libsqlite3-0
WARNING: Package libsqlite3-0 is already installed, ignoring
         Use --force-reinstall to force reinstallation

No packages to install.

root@Gargoyle:~# opkg install --force-reinstall libsqlite3-0
WARNING: Package libsqlite3-0 is already installed, forcing removal and reinstallation

Removing package libsqlite3-0...
Finished removing libsqlite3-0.

Preparing to install the following packages, which will require 507543 bytes:
        libsqlite3-0

Preparing to install package libsqlite3-0...
        Downloading...
        Downloaded libsqlite3-0 successfully.
        Installing libsqlite3-0...
ERROR: file '/usr/lib/libsqlite3.so.0'
       from package libsqlite3-0 already exists.

An error occurred during Installation, removing partially installed packages.
Removing package libsqlite3-0...
Finished removing libsqlite3-0.

Finished removing partially installed packages.

root@Gargoyle:~# opkg info libsqlite3-0
Package: libsqlite3-0
Version: 3410100-1
Install-Destination: Not Installed
SHA256sum: b8bd167965e0d4df84f676a338d3d993bb1fe6b1752c218105e3b2d5808ed3cb
Size: 507514
Installed-Size: 507429
License: PUBLICDOMAIN
Provides: libsqlite3
Description: SQLite is a small C library that implements a self-contained, embeddable,
             zero-configuration SQL database engine.
             This package contains the SQLite (v3.x) shared library, used by other
             programs.
Architecture: mips_24kc
Source-ID: gargoylepl_base
CPE-ID: cpe:/a:sqlite:sqlite
Section: libs
Filename: libsqlite3-0_3410100-1_mips_24kc.ipk
Status: unknown ok not-installed
Depends: libc, libpthread, zlib
ABIVersion: -0

Package: libsqlite3-0
Version: 3410200-1
Install-Destination: Not Installed
SHA256sum: d8e63e620c0870466c92e0ec8a45555f70f38b82b24e48c70f5e3db1f4954227
Size: 507615
Installed-Size: 507543
License: PUBLICDOMAIN
Provides: libsqlite3
Description: SQLite is a small C library that implements a self-contained, embeddable,
             zero-configuration SQL database engine.
             This package contains the SQLite (v3.x) shared library, used by other
             programs.
Architecture: mips_24kc
Source-ID: openwrt_23.05-SNAPSHOT_packages
CPE-ID: cpe:/a:sqlite:sqlite
Section: libs
Filename: libsqlite3-0_3410200-1_mips_24kc.ipk
Status: unknown ok not-installed
Depends: libc, libpthread, zlib
ABIVersion: -0

8 Odpowiedź przez Cezary

  • Skąd: Warszawa
  • Zarejestrowany: 2006-02-25
  • Posty: 116,352

Odp: SQLite header and source version mismatch - co zrobić jak żyć?:)

No, i teraz zainstaluj jeszcze raz smile

Masz niepotrzebny router, uszkodzony czy nie - chętnie przygarnę go.

Cezary's Strona