Portal captive can't access to databases file (sqlite3)

bendida

hello,
every few hours from runing Portal captif , i get this error

Zone: MyZone - Still unable to create tables for MyZone. Error message: disk I/O error. Remove the database file manually and try again.

it can't access the database file, till i restart pfsense Reroot mode, but can't delete the old rules from the firewall.

can you help me to get a solution for this problem without restarting pfsene

thank you,

Nb: the allowed ip address don't work in frensh version. it work only in english language , because the configuration file get the translated word instead of the english one
(les deux) instead of (both)

Gertjan

@bendida said in Portal captive can't access to databases file (sqlite3):

Zone: MyZone - Still unable to create tables for MyZone. Error message: disk I/O error. Remove the database file manually and try again.

'pfSense' tries to read it, and it fails.
'pfSense' tries to to create a new one, and it fails.
Most probable case : disk full.
Next probable case (if it isn't a ZFS ) : How to Run a pfSense Software File System

edit : If needed : it's here /var/db/captiveportalXXXXXX.db
where XXXXX is the zone name.

Next time : don't reroot, reboot, and watch the console during boot closely.

@bendida said in Portal captive can't access to databases file (sqlite3):

Nb: the allowed ip address don't work in frensh version. it work only in english language , because the configuration file get the translated word instead of the english one
(les deux) instead of (both)

I see what you mean. Interesting

I never actually used the "French" translation although it's France all around me.
Short fast solution : stick with the VO for the moment.

bendida

@Gertjan
hello,
thank you for your suggesion
i will try to scan the disk