spdMerlin spdMerlin v4.4.12 [2025-Jun-22] - Internet Speedtest and Monitoring Tool for AsusWRT Merlin

[Strych99]

The above error message indicates that you have a corrupted SQLite3 installation. Follow the instructions below to clean up and restart with a "fresh" installation:

1) Uninstall spdMerlin:

/jffs/scripts/spdmerlin uninstall

2) Copy & paste the following set of commands (*including* the enclosing curly braces):

{
   rm -f /opt/share/tmp/spdMerlin_*.LOG
   rm -f /opt/share/spdmerlin.d/spdstats.db
   rm -f /jffs/addons/spdmerlin.d/spdstats.db
   opkg remove sqlite3-cli libsqlite3 --force-removal-of-dependent-packages
   opkg update
   opkg install sqlite3-cli
   echo "----------------------------------------"
   opkg list-installed | grep sqlite3
   /opt/bin/sqlite3 -version
   echo "----------------------------------------"
}

3) Download and reinstall the latest spdMerlin 'develop' branch version:

curl -LSs --retry 3 --retry-delay 5 --retry-connrefused \
https://raw.githubusercontent.com/AMTM-OSR/spdMerlin/refs/heads/develop/spdmerlin.sh \
-o /jffs/scripts/spdmerlin && chmod 755 /jffs/scripts/spdmerlin
/jffs/scripts/spdmerlin install

4) When the spdMerlin installation is completed, post the results and debug logfile (if any).

Removing package sqlite3-cli from root...
Removing package python3-pip from root...
Removing package python3 from root...
Removing package python3-sqlite3 from root...
Removing package libsqlite3 from root...
Downloading https://bin.entware.net/aarch64-k3.10/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/entware
Installing sqlite3-cli (3.49.1-2) to root...
Downloading https://bin.entware.net/aarch64-k3.10/sqlite3-cli_3.49.1-2_aarch64-3.10.ipk
Installing libsqlite3 (3460100-1) to root...
Collected errors:
* opkg_download_pkg: Package libsqlite3 is not available from any configured src.
* opkg_install_pkg: Failed to download libsqlite3. Perhaps you need to run 'opkg update'?
* opkg_install_cmd: Cannot install package sqlite3-cli.
----------------------------------------
-sh: /opt/bin/sqlite3: not found
----------------------------------------

 

[Strych99]

Removing package sqlite3-cli from root...
Removing package python3-pip from root...
Removing package python3 from root...
Removing package python3-sqlite3 from root...
Removing package libsqlite3 from root...
Downloading https://bin.entware.net/aarch64-k3.10/Packages.gz
Updated list of available packages in /opt/var/opkg-lists/entware
Installing sqlite3-cli (3.49.1-2) to root...
Downloading https://bin.entware.net/aarch64-k3.10/sqlite3-cli_3.49.1-2_aarch64-3.10.ipk
Installing libsqlite3 (3460100-1) to root...
Collected errors:
* opkg_download_pkg: Package libsqlite3 is not available from any configured src.
* opkg_install_pkg: Failed to download libsqlite3. Perhaps you need to run 'opkg update'?
* opkg_install_cmd: Cannot install package sqlite3-cli.
----------------------------------------
-sh: /opt/bin/sqlite3: not found
----------------------------------------

[SOLVED]:
My entware packages were FUBAR. So I uninstalled / re-installed the entware packages, ran the spdmerlin install (4.4.11), and spdmerlin is working perfectly now!

Thanks so much for your help and I apologize for the errant rabbit hole side venture!

 

[Martinski]

[SOLVED]:
My entware packages were FUBAR. So I uninstalled / re-installed the entware packages, ran the spdmerlin install (4.4.11), and spdmerlin is working perfectly now!

Thanks so much for your help and I apologize for the errant rabbit hole side venture!

Ah, no worries. It was all in a day’s work! Our little side venture actually made the code a little better because now there’s error handling for cases where some output files are not created during a database operation. So it was not all for naught.

Thank you for taking the time to provide feedback and useful data.

 

[Martinski]

Release Notes for spdMerlin v4.4.12 production version now available
[2025-Jun-22]

1) IMPROVED: Added error-handling code when an SQLite3 database operation fails to create a file.

2) IMPROVED: When an SQLite3 operation returns error messages indicating a corrupted binary, the error-handling code will now log a separate message to the system logger and to its own debug logfile to let users know of the corrupted SQLite3 and the need to remove and reinstall its Entware package.

3) Miscellaneous code improvements.


The fork from @Jack Yaz's spdMerlin add-on is now hosted on the AMTM-OSR GitHub repo:

GitHub - AMTM-OSR/spdMerlin: spdMerlin is an internet speedtest and monitoring tool for AsusWRT Merlin with charts for daily, weekly and monthly summaries. It tracks download/upload bandwidth as well as latency, jitter and packet loss.

spdMerlin is an internet speedtest and monitoring tool for AsusWRT Merlin with charts for daily, weekly and monthly summaries. It tracks download/upload bandwidth as well as latency, jitter and pac...

github.com