OPNsense Forum

Archive => 18.1 Legacy Series => Topic started by: AFSaltLife on July 26, 2018, 05:11:23 am

Title: Captive Portal: Allowed addresses/MACs has no effect + sqlite error
Post by: AFSaltLife on July 26, 2018, 05:11:23 am
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]
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]
OPNsense 18.1.13-amd64
FreeBSD 11.1-RELEASE-p11
OpenSSL 1.0.2o 27 Mar 2018
Thanks again.
Title: Re: Captive Portal: Allowed addresses/MACs has no effect + sqlite error
Post by: AFSaltLife on July 31, 2018, 05:09:53 am
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.