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

[mrfairsquare]

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

[marcelloc]

Are you using nanobsd?

[mrfairsquare]

Not using nanobsd.

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