How can I add SQLite support?

[bonnecomm]

I'd like to add SQLite support instead of the MySQL someone had suggested earlier. How can I do this?

[jimp]

The sqlite libraries are built in, just not active. It's already on the box, you just have to enable it. Actually now that I look mysql is there also.

To enable, just do:

touch /etc/php_dynamodules/pdo
touch /etc/php_dynamodules/pdo_sqlite

or

touch /etc/php_dynamodules/mysql

And then restart the webgui from the console/ssh menu (or reboot)

[pola090]

where is the php setup gui in the webconfigurator.

[Gertjan]

Hi !

Start reading https://github.com/bsdperimeter/pfsense/blob/master/etc/rc.php_ini_setup