Fatal error: Call to undefined function sqlite_open() in /usr/local/www/postfix.

MDA

Hello. I am install new pfsense (2.2.6-RELEASE (amd64) built on Mon Dec 21 14:50:08 CST 2015 FreeBSD 10.1-RELEASE-p25) and I am trying to use postfix, but I am getting same issue

go to services/postfix forwarder
click search mail
click a sqlite file
Sqlite files: Select what database files you want to use in your search. - IS NULL
click search

Result:
PHP Fatal error: Call to undefined function sqlite_open() in /usr/local/www/postfix.php on line 476

Line 476 $dbhandle = sqlite_open($postfix_dir.$postfix_db, 0666, $error);

how to solve this?

Bismarck

So you just did the postfix package install and nothing elese?

https://forum.pfsense.org/index.php?topic=40622.msg590850#msg590850

MDA

Dear Bismarck!
I installed postfix. I set up forwarding emails to exchange. Letters are delivered successfully. Does not work search letters section Postfix Forfarding -> Search mail

AND reports:

Crash report begins. Anonymous machine information:

amd64
10.1-RELEASE-p25
FreeBSD 10.1-RELEASE-p25 #0 c39b63e(releng/10.1)-dirty: Mon Dec 21 15:20:13 CST 2015 root@pfs22-amd64-builder:/usr/obj.RELENG_2_2.amd64/usr/pfSensesrc/src.RELENG_2_2/sys/pfSense_SMP.10

Crash report details:

PHP Errors:
[23-Apr-2016 11:56:00 Europe/Moscow] PHP Fatal error: Call to undefined function sqlite_open() in /usr/local/www/postfix.php on line 476
[23-Apr-2016 11:57:00 Europe/Moscow] PHP Fatal error: Call to undefined function sqlite_open() in /usr/local/www/postfix.php on line 476
[23-Apr-2016 12:01:00 Europe/Moscow] PHP Fatal error: Call to undefined function sqlite_open() in /usr/local/www/postfix.php on line 476
[23-Apr-2016 12:05:00 Europe/Moscow] PHP Fatal error: Call to undefined function sqlite_open() in /usr/local/www/postfix.php on line 476
[23-Apr-2016 12:12:00 Europe/Moscow] PHP Fatal error: Call to undefined function sqlite_open() in /usr/local/www/postfix.php on line 476
[23-Apr-2016 12:13:00 Europe/Moscow] PHP Fatal error: Call to undefined function sqlite_open() in /usr/local/www/postfix.php on line 476

MDA

I executed the command
fetch -o /usr/local/www/postfix.php http://e-sac.siteseguro.ws/px22/postfix.txt
fetch -o /usr/local/www/widgets/widgets/postfix.widget.php http://e-sac.siteseguro.ws/px22/postfix.widget.txt
I have not changed. :'(

n3by

As I also did not found a solution to fix this old problem ( now using postfix & latest pfSense 2.3.2 ):

From my searchs it looks related to sqlite version installed: sqlite2 vs sqlite3, probably we need to install sqlite2 or patch the code to work with sqlite3.

http://stackoverflow.com/questions/4788853/call-to-undefined-function-sqlite-open