Captive Portal: Allowed addresses/MACs has no effect + sqlite error

[AFSaltLife]

Greetings and thanks for any help you can provide.

As the title suggests, addresses I apply in the "allowed" field are still not permitted to communicate over the WAN. I have a couple VoIP phones I need to allow through. Disabling the zone confirms the phones can communicate. Addresses that I apply do show up in the "sessions" list.

I've checked the log and I noticed the following error:

Code Select Expand

captiveportal: Traceback (most recent call last): File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py", line 218, in main
bgprocess.db.update_accounting_info(bgprocess.ipfw.list_accounting_info()) File
"/usr/local/opnsense/scripts/OPNsense/CaptivePortal/lib/db.py", line 271, in update_accounting_info for row in
cur.fetchall(): DatabaseError: database disk image is malformed

I'm really hoping I won't have to drop/recreate the database, I've already created/distributed vouchers.

Problem was present in 18.1.12 as well.

Code Select Expand

OPNsense 18.1.13-amd64
FreeBSD 11.1-RELEASE-p11
OpenSSL 1.0.2o 27 Mar 2018

Thanks again.

[AFSaltLife]

Solved by following user "tee4cute"s steps in thread https://github.com/opnsense/core/issues/1700


Database was apparently corrupted somehow. Removing the database and forcing captiveportal to create a new one all was returned to normal.

• cd /var/captiveportal/
  
  
• mv captiveportal.sqlite captiveportal.sqlite.b
  I guess that CP will automatically create sqlite db file if is not found.
  
  
• /usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py
  At this point, I found that the captiveportal.sqlite is automatically created.
  
  
• /usr/local/etc/rc.d/captiveportal stop
  Stop the service to ensure that it is cleanly restarted.
  
  
• /usr/local/etc/rc.d/captiveportal start
  Start service again.