How to access MySql/Sqlite database from pfsense shell?

[Mahendra]

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 !

[marcelloc]

Ckeck if it's a text or an sqlite2 file.

[Mahendra]

No.. it's a ".db" file.

[jimp]

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.