1
18.1 Legacy Series / Captive Portal: Allowed addresses/MACs has no effect + sqlite error
« 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:
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.
Thanks again.
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.