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

    Postfix log db file is empty, and postfix does not/can not write to the log db.

    Scheduled Pinned Locked Moved pfSense Packages
    3 Posts 2 Posters 2.7k 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
      mrfairsquare
      last edited by

      Hello to all who read this. After many days investigating and chewing on this particular issue, i have reached the conclusion, i need help… HELP!


      ISSUE:
      –-----
      The postfix log db file is empty, and postfix does not or can not write to the db file.

      Location i'm looking at:   /var/db/postfix


      TRIED SO FAR:
      –-------------
      1. Initially i found an error on line 54 when running this: /usr/local/bin/php -q /usr/local/www/postfix.php 01min - I fixed that, by changing the sync setting to "disabled", as was set to something else. So now it outputs just fine.

      2. I made sure that sqlite was installed, by using the touch command as in an earlier post. -
      "touch /etc/php_dynamodules/pdo
      touch /etc/php_dynamodules/pdo_sqlite"

      3. Discovered differences in permission in the /var/db/postfix folder, and attempted setting any any rules on file and folder permissions to no success or noticable effect, since reverted back to previous permissions.

      4. Increased debugging level to 6, in an attempt to get more information.

      5. Can find no errors or notable problems when using: # tail -f /var/log/mailog

      6. Deleting the db files, restarting postfix and recieving a test e-mail to trigger a new db file.

      7. Ensured set as follows: "Choose how often pfSense will transfer log files to Sqlite database.
      To use Diagnostics -> Search mail you need to:
      Select Loggin Destination to /var/log/maillog
      Select update Sqlite frequency
      Inlcude /^Subject:/ WARN line in Acl Headers after all your Subject rules. "

      –-------------------
      PROCESS INVOLVED:
      –-------------------
      This is the flow of what happens:

      1. New e-mail comes in and shows in tail -f /var/log/maillog
      2. If not already created, a db file is created for the current day in the /var/db/postfix folder
      3. DB is created at 38,912 bytes.
      4. 5 more e-mails come in, DB is still 38,912 bytes.


      THEORY:
      –-------
      Postfix is not writing data to the log file, therefore either sqlite issue or permissions.

      If anyone can help you'll be making me a very happy man, possibly enough to add a little spring in my step.  ;D


      VERSION:
      –--------
      2.0.1-RELEASE (i386)
      FreeBSD pfsense-vm.***.com 8.1-RELEASE-p6 FreeBSD 8.1-RELEASE-p6

      Peace. x

      1 Reply Last reply Reply Quote 0
      • marcellocM
        marcelloc
        last edited by

        Are you using nanobsd?

        Treinamentos de Elite: http://sys-squad.com

        Help a community developer! ;D

        1 Reply Last reply Reply Quote 0
        • M
          mrfairsquare
          last edited by

          Not using nanobsd.

          –-------
          Version:
          –-------
          2.0.1-RELEASE (i386)
          FreeBSD pfsense-vm.***.com 8.1-RELEASE-p6 FreeBSD 8.1-RELEASE-p6

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.