Topics

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 all,
On a simple setup  with dual WAN & failover configuration it seems as we are missing a point.
Failover is working as expected for the LAN devices.
Opnsense  is resolving correctly through any of the DNS servers assigned to each gateway.
However, default gateway is not changing as first WAN goes down resulting in it not being able to reach a remote VPN Server.
Any tip would be appreciated.
Thanks

Hi,

Our system has been running smoothly for months.
After upgrade to version  21.7.3_3 ,  GUI of the captive portal does not show active sessions although it is running.

Any tip would be appreciated.

Regards

Hi thare, we are facing problems runnnig the captive Portal afer update to this version.

Redirection seems to work fine, but it looks as if lighttpd is not serving the landing page on port 8000.

Any ideas, help would be appreciated ?

Hi,
when I mess a configuration  too much I tend to do a restore to default config my PC sets LAN on em0 and WAN on em1 (I find this setting more convenient the other way around em0=WAN, em1=LAN).

Does anyone know if the Default configuration can be modified?

Thanks & Regards

Hi there,

after doing it at least 10 times trying anyting I could think of, I have not manage to set up MULTIWAN as failover.

The configuration simply does not take the gateway group into account.

Attached my very basic configuration following https://wiki.opnsense.org/manual/how-tos/multiwan.html

Any suggestion would be appreciated.

Hi there,
I've been struggling to make a "basic" setup with two bridges on the LAN side of the router:

Bridge1: em1 + em2
Bridge0: VLAN500 on em1 + em3

As I create Bridge1, bridge0 stops forwarding traffic.

Any suggestion will be appreciated.

***************************************
Configuration:

bridge0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> metric 0 mtu 1500
        ether 02:0f:9d:95:72:00
        inet 192.168.32.1 netmask 0xffffff00 broadcast 192.168.32.255
        nd6 options=1<PERFORMNUD>
        groups: bridge
        id 00:00:00:00:00:00 priority 32768 hellotime 2 fwddelay 15
        maxage 20 holdcnt 6 proto rstp maxaddr 2000 timeout 1200
        root id 00:00:00:00:00:00 priority 32768 ifcost 0 port 0
        member: em3 flags=143<LEARNING,DISCOVER,AUTOEDGE,AUTOPTP>
                ifmaxaddr 0 port 4 priority 128 path cost 55
        member: em1_vlan500 flags=143<LEARNING,DISCOVER,AUTOEDGE,AUTOPTP>
                ifmaxaddr 0 port 9 priority 128 path cost 20000

bridge1: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> metric 0 mtu 1500
        ether 02:0f:9d:95:72:01
        inet 172.16.0.1 netmask 0xffffff00 broadcast 172.16.0.255
        nd6 options=1<PERFORMNUD>
        groups: bridge
        id 00:00:00:00:00:00 priority 32768 hellotime 2 fwddelay 15
        maxage 20 holdcnt 6 proto rstp maxaddr 2000 timeout 1200
        root id 00:00:00:00:00:00 priority 32768 ifcost 0 port 0
        member: em1 flags=143<LEARNING,DISCOVER,AUTOEDGE,AUTOPTP>
                ifmaxaddr 0 port 2 priority 128 path cost 55
        member: em2 flags=143<LEARNING,DISCOVER,AUTOEDGE,AUTOPTP>
                ifmaxaddr 0 port 3 priority 128 path cost 55

Bidge Options:

net.link.bridge.ipfw: 0
net.link.bridge.allow_llz_overlap: 0
net.link.bridge.inherit_mac: 0
net.link.bridge.log_stp: 0
net.link.bridge.pfil_local_phys: 0
net.link.bridge.pfil_member: 0
net.link.bridge.ipfw_arp: 0
net.link.bridge.pfil_bridge: 1
net.link.bridge.pfil_onlyip: 0

My PPPoE Server is replying such an error and not allowing clients connection.
Pretty basic set-up:

startup:

poes:
  set ippool add pool1 10.10.100.190 10.10.101.187
  create bundle template B
  set iface up-script /var/etc/pppoe1-vpn/linkup
  set iface down-script /var/etc/pppoe1-vpn/linkdown
  set iface idle 0
  set iface disable on-demand
  set iface disable proxy-arp
  set iface enable tcpmssfix
  set iface mtu 1500
  set ipcp no vjcomp
  set ipcp ranges 10.9.9.1/32 ippool pool1
  set ipcp dns 10.9.9.1 8.8.4.4

  set bundle enable compression
  set ccp yes mppc
  set mppc yes e40
  set mppc yes e128
  set mppc yes stateless

  create link template L pppoe
  set link action bundle B
  set link no multilink
  set link disable pap
  set link disable eap
  set link enable chap
  set link keep-alive 10 60
  set link max-redial -1
  set link mtu 1492
  set link mru 1492
  set link latency 1
  set pppoe service pppoe1
  set pppoe iface em1
  set link enable incoming
  set auth max-logins 1

********************************************************
Error Log

***********************************************************+

Nov 13 06:12:50 OPNsense poes: PPPoE: message 7 from unexisting link "1"
Nov 13 06:12:55 OPNsense poes: Incoming PPPoE connection request via em1: for service "pppoe1" from b4:99:ba:e2:2e:a8
Nov 13 06:12:55 OPNsense poes: [L-1] Accepting PPPoE connection
Nov 13 06:12:55 OPNsense poes: [L-1] PPPoE: Cannot send original request: No buffer space available
Nov 13 06:12:55 OPNsense poes: [L-1] PPPoE connection not accepted due to error
Nov 13 06:12:55 OPNsense poes: [L-1] Link: Shutdown
Nov 13 06:12:55 OPNsense poes: PPPoE: message 7 from unexisting link "1"
Nov 13 06:13:00 OPNsense poes: Incoming PPPoE connection request via em1: for service "pppoe1" from b4:99:ba:e2:2e:a8
Nov 13 06:13:00 OPNsense poes: [L-1] Accepting PPPoE connection
Nov 13 06:13:00 OPNsense poes: [L-1] PPPoE: Cannot send original request: No buffer space available
Nov 13 06:13:00 OPNsense poes: [L-1] PPPoE connection not accepted due to error
Nov 13 06:13:00 OPNsense poes: [L-1] Link: Shutdown
Nov 13 06:13:00 OPNsense poes: PPPoE: message 7 from unexisting link "1"
Nov 13 06:14:20 OPNsense poes: Multi-link PPP daemon for FreeBSD


Any Ideas?

Hi there,
I come across an issue implementing static roting on  OPNsense 18.1.12-amd64.

Very basic set-up: Network 192.168.21.0/24 on 10.10.100.53

Opensense WAN: 10.10.100.52/24
Default Gateway: 10.10.100.1

Option " Bypass firewall rules for traffic on the same interface " is activated.

Routing table:
root@OPNsense:~ # netstat -4rn
Routing tables

Internet:
Destination        Gateway            Flags     Netif Expire
default            10.10.100.1        UGS         em0
10.10.100.0/24     link#1             U           em0
10.10.100.52       link#1             UHS         lo0
127.0.0.1          link#7             UH          lo0
192.168.1.0/24     link#2             U           em1
192.168.1.1        link#2             UHS         lo0
192.168.21.0/24    10.10.100.53       UGS         em0

root@OPNsense:~ # traceroute 192.168.21.1
traceroute to 192.168.21.1 (192.168.21.1), 64 hops max, 40 byte packets
1  10.10.100.1 (10.10.100.1)  0.317 ms  0.154 ms  0.150 ms
2  1.0.0.138 (1.0.0.138)  0.542 ms  0.537 ms  0.595 ms
3  1.0.0.82 (1.0.0.82)  0.659 ms  0.733 ms  0.645 ms
4  1.1.1.12 (1.1.1.12)  0.896 ms  0.830 ms  0.712 ms


Any suggestion will be appreciated.

Rgds