Project

General

Profile

Actions
Copy link

Bug #4904

closed

Captive Portal databases are not upgraded from sqlite 2.x to sqlite 3.x, must be removed post-upgrade

Added by Jim Pingle over 9 years ago. Updated about 9 years ago.

Status:
Resolved
Priority:
Low
Assignee:
Jim Pingle
Category:
Captive Portal
Target version:
2.2.5
Start date:
07/29/2015
Due date:
% Done:

100%

Estimated time:
Plus Target Version:
Release Notes:
Affected Version:
2.2.x
Affected Architecture:
All

Description

Upgrading from pfSense 2.1.x to 2.2, the captive portal databases are in the older sqlite 2.x format and cannot be read:

Jul 28 10:12:59 pfsense logportalauth[11289]: Zone: zonename - Error during table zonename creation. Error message: file is encrypted or is not a database

Removing the database files with rm /var/db/*.db and then re-saving all CP zones and voucher tabs will recreate the files in the proper format.

We should either convert the files up or remove/reinitialize the files if they are detected in the wrong format.

Actions
Copy link

Also available in: Atom PDF