2.2 upgrade - postfix breaks webconfigurator

Sn3ak

the postfix widget is broken on 2.2? or at least on upgrades. it's missing sqlite, and breaks the dashboard.

cmb

Package seems to work, where are you seeing sqlite missing?

The widget does appear broken.
https://redmine.pfsense.org/issues/4270

It doesn't break the dashboard though, just is a blank widget for me. You're seeing it make other parts of the dashboard break?

Sn3ak

These are production boxes, I couldn't leave them broken. sadly I didn't record the error.
I'll attempt to load a vm and replicate the issue and report back in the afternoon.

It may have been unrelated, but the last widget displayed was the postfix widget.

ultimately, i had to hand edit the xml file, and delete all widgets/dashboard content, and restore the config.

Sn3ak

actually, i can replicate it without the widget, in a different way.
go to services/postfix forwarder
click search mail
click a sqlite file (meaning, you need a working? install)
click search


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

btw, this is on i386 full. oh and I did submit one of the widget crashes via the crash dump reporter

Sn3ak

and here's a snap of the widget breakage. as soon as I added it back in, it killed my dashboard.
remove, dashboard is still borked, even after a reboot.

hand edit xml, delete dashboard/widget related items, restore config, all is well again.

my guess is it blank for you, because you haven't previously used the package, thus don't have
any sqlite databases for it to attempt to load.

marcelloc

It needs a fix to update code from sqlite 2 to sqlite 3.

And may not be related only to widget, but all package logging to database.

I'll try to fix it ASAP.

oscarbet5

Hi, everyone.

I am new to pfsense and I am trying to use postfix, but I am getting same issue I think:

Crash report details:

PHP Errors:
[09-Apr-2015 10:36:00 America/Bogota] PHP Fatal error: Call to undefined function sqlite_open() in /usr/local/www/postfix.php on line 457

Anyone has any clue how to solve this?

Thanks a lot.

OSCAR BETANCUR

marcelloc

Disable update logs to database. It's a sqlite2/3 issue I'm working on.

planetinse

@marcelloc:

It needs a fix to update code from sqlite 2 to sqlite 3.

And may not be related only to widget, but all package logging to database.

I'll try to fix it ASAP.

Hi - any news on this topic ? ;) - I have the same issue. (dashboard blank, no sqllite db to select - in search mail)

I have tried the two
fetch -o /usr/local/www/widgets/widgets/postfix.widget.php http://e-sac.siteseguro.ws/px22/postfix.widget.txt
fetch -o /usr/local/www/postfix.php http://e-sac.siteseguro.ws/px22/postfix.txt

it did not fix anything - but gave me this FATAL error instead (1 per minute)
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:
[13-Sep-2016 15:40:00 Europe/Stockholm] PHP Fatal error: require_once(): Failed opening required 'postfix_dkim.inc' (include_path='.:/etc/inc:/usr/local/www:/usr/local/captiveportal:/usr/local/pkg') in /usr/local/www/postfix.php on line 4