Messages

Many thanks for the tip.

Unfortunately after running opnsense-bootstrap and reloading the backup configuration we are not able to update the version, sqlite error persists as well as missing  /usr/local/etc/pkg/repos/OPNsense.conf.

Trying to run a second time  opnsense-bootstrap shows "package database non-existent"

Does it look like a hardware/SDD issue?


**********************

Enter an option: 12

Fetching change log information, please wait... Missing /usr/local/etc/pkg/repos/OPNsense.conf
Missing /usr/local/etc/pkg/repos/OPNsense.conf
fetch: /sets/changelog.txz: No such file or directory

This will automatically fetch all available updates and apply them.

Missing /usr/local/etc/pkg/repos/OPNsense.conf
Missing /usr/local/etc/pkg/repos/OPNsense.conf
Proceed with this action? [y/N]: y

Missing /usr/local/etc/pkg/repos/OPNsense.conf
Missing /usr/local/etc/pkg/repos/OPNsense.conf
Starting web GUI...done.
pkg: sqlite error while executing ALTER TABLE packages ADD licenselogic INTEGER NOT NULL DEFAULT(1); in file pkgdb.c:2333: no such table: packages
pkg: sqlite error while executing ALTER TABLE packages ADD licenselogic INTEGER NOT NULL DEFAULT(1); in file pkgdb.c:2333: no such table: packages
Usage: pkg version [-IPR] [-hoqvU] [-l limchar] [-L limchar] [-Cegix pattern]
                    [-r reponame] [-O origin|-n pkgname] [index]
        pkg version -t <version1> <version2>
        pkg version -T <pkgname> <pattern>

For more information see 'pkg help version'.
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
Updating FreeBSD-kmods repository catalogue...
FreeBSD-kmods repository is up to date.
All repositories are up to date.
pkg: sqlite error while executing ALTER TABLE packages ADD licenselogic INTEGER NOT NULL DEFAULT(1); in file pkgdb.c:2333: no such table: packages
pkg: sqlite error while executing ALTER TABLE packages ADD licenselogic INTEGER NOT NULL DEFAULT(1); in file pkgdb.c:2333: no such table: packages
Updating FreeBSD repository catalogue...
FreeBSD repository is up to date.
Updating FreeBSD-kmods repository catalogue...
FreeBSD-kmods repository is up to date.
All repositories are up to date.
pkg: sqlite error while executing ALTER TABLE packages ADD licenselogic INTEGER NOT NULL DEFAULT(1); in file pkgdb.c:2333: no such table: packages
pkg: sqlite error while executing ALTER TABLE packages ADD licenselogic INTEGER NOT NULL DEFAULT(1); in file pkgdb.c:2333: no such table: packages
Missing /usr/local/etc/pkg/repos/OPNsense.conf


********************************

root@OPNsense:~ # opnsense-bootstrap
This utility will attempt to turn this installation into the latest
OPNsense 25.7 release.  All packages will be deleted, the base
system and kernel will be replaced, and if all went well the system
will automatically reboot.

Proceed with this action? [y/N]: y
fetch: https://github.com/opnsense/core/archive/stable/25.7.tar.gz: size of remote file is not known
/tmp/opnsense-bootstrap/core.tar.gz                     11 MB 8262 kBps    02s
pkg: package database non-existent
pkg: No packages installed
pkg: No packages installed
mkdir: /usr/local/etc/pkg: No such file or directory
*** Error code 1

Stop.
make[1]: stopped in /tmp/opnsense-bootstrap/core-stable-25.7/src
*** Error code 1

Stop.
make: stopped in /tmp/opnsense-bootstrap/core-stable-25.7
root@OPNsense:~ #


***********************************************

Regards

Hi,

After the update to 25.7 we face sqlite error on the package database "database disk image is malformed".

Attached please find logs from the update and pkg bootsrap commands.

After backup of  /var/db/pkg/local.sqlite its recovery has not succeeded.

Any suggestion would be appreciated.

*************************************************
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
Updating OPNsense repository catalogue...
OPNsense repository is up to date.
All repositories are up to date.
pkg-static: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
Checking for upgrades (0 candidates): . done
Processing candidates (0 candidates): . done
pkg-static: sqlite error while executing END TRANSACTION; in file pkgdb.c:2333: database disk image is malformed
Checking integrity... done (0 conflicting)
Your packages are up to date.
pkg-static: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg-static: sqlite error while executing END TRANSACTION; in file pkgdb.c:2333: database disk image is malformed
Checking integrity... done (0 conflicting)
Nothing to do.
pkg-static: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages:
pkg-static: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages... done
pkg-static: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
Nothing to do.
Nothing to do.
Starting web GUI...done.
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
Installation out of date. The update to opnsense-25.7.1_1 is required.



*******************************************

root@OPNsense:~ # pkg bootstrap -f
The package management tool is not yet installed on your system.
Do you want to fetch and install it now? [y/N]: y
Bootstrapping pkg from https://pkg.opnsense.org/FreeBSD:14:amd64/25.7/latest, please wait...
Verifying signature with trusted certificate pkg.opnsense.org.20250710... done
Installing pkg-1.19.2_5...
package pkg is already installed, forced install
pkg-static: sqlite error while executing INSERT OR REPLACE INTO packages( origin, name, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, automatic, licenselogic, time, manifestdigest, dep_formula, vital)VALUES( 'ports-mgmt/pkg', 'pkg', '1.19.2_5', 'Package manager', 'Package management tool', NULL, 'FreeBSD:14:amd64', 'pkg@FreeBSD.org', 'https://github.com/freebsd/pkg';, '/usr/local', 16880765, 0, 1, NOW(), NULL, NULL, 0 ) in file pkgdb.c:1633: database disk image is malformed

Failed to install the following 1 package(s): /tmp//pkg.pkg.8kdK0k

Hi there,

Please give it try to this configuration:

1.- On the advanced options on the firewall rule on the LAN interface, activate "allow options"
2.- Install os-igmp-proxy plugin
3.- Configure IGMP Proxy selecting your WAN interface as Upstream, Networks 224.0.0.0/4 + "Multicast sources IP"   
4.- Configure IGMP Proxy selecting your LAN interface as Downstream.Networks LAN Network

Hope this helps
   

Hi,

May I ask if you provide DNS servers to the VPN & Wireguard clients?

Regards

Hallo,

Wäre es möglich dieser Skripte zu verteilen?

MfG

Could it be related to the we browser's cache?

25.1.5_4

same login error

then the submit/connect button was lost/missing even if not yet authenticated.
even reverting to default template same error but submit button shows
returns login failed

I am using no auththentication just conenct button to authenticate

On the firewall rules there should be a Wireguard entry, have you set any traffic rule there?
/32 refers to allowing traffic only from this IP of the Wireguard range.

Hope this helps

Hi,

Don't you map ip address to each specific MAC on the DHCP server  and then allow these Ips through the captive portal?

Hope this helps
 

Have you tried the os-igmp-proxy plugin?

It does send an IGMP V2 General query packet on the selected Downstream interface.

Regards 

Hi,

We have deployed OVPN in Tap mode for very specific scenarios (L2 discovery required).

We just added the OVPN Server's interface to the LAN bridge.

Hope this helps

Wireguard running as expected on our 25.1 deployment (just private Wireguard servers).

May I suggest to check firewall configuration on the Wireguard interface?

Hope this helps

Have you checked  the General logs?

I would suggest to check firewall configuration on WAN interafce as well as port forwarding rule.

I would use tcpdump on interfaces WAN/LAN  interfaces to try to sort out the issue.

Hope this helps

Regards

Looks good.

Would you share final interfaces configuration on Opnsense (ifconfig) as well as Driver used on the NIcs?

Thanks & regards

I would suggest to review the NAT configuration.

What does  tracert www.opnsense.com shows on the local_PC?

Rgds