How to access MySql/Sqlite database from pfsense shell?
-
Hi,
I tried to open captiveportal_radius.db file with Sqlite Browser but its showing file is corrupted or encrypted, so kindly help me out in how to connect mysql/sqlite database from PFSense shell or the correct method access tables structure.
Thanks in Advance !
-
Ckeck if it's a text or an sqlite2 file.
-
No.. it's a ".db" file.
-
On 2.0.x and before, and on 2.1 up until late December, that's just a normal text file not a special database file.
On recent 2.1 snapshots it is actually an sqlite database.
