• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Search
  • Register
  • Login
Netgate Discussion Forum
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Search
  • Register
  • Login

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

Scheduled Pinned Locked Moved pfSense Packages
5 Posts 3 Posters 2.3k Views
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M
    MDA
    last edited by Apr 23, 2016, 9:15 AM

    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?

    1 Reply Last reply Reply Quote 0
    • B
      Bismarck
      last edited by Apr 23, 2016, 12:07 PM

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

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

      1 Reply Last reply Reply Quote 0
      • M
        MDA
        last edited by Apr 25, 2016, 7:10 AM

        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

        1 Reply Last reply Reply Quote 0
        • M
          MDA
          last edited by Apr 25, 2016, 9:24 AM

          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. :'(

          1 Reply Last reply Reply Quote 0
          • N
            n3by
            last edited by Jan 2, 2017, 9:30 AM

            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

            1 Reply Last reply Reply Quote 0
            • First post
              Last post
            Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.
              This community forum collects and processes your personal information.
              consent.not_received