Files
Pranav GargandClaude Opus 5.5 a2ee929eda fetchmail.pl: add SQLite support
Accept $db_type = 'SQLite' with $db_name as the path to the database
file. SQLite has no now() or unix_timestamp(), so use strftime('%s', ...)
for the poll interval check and datetime('now') when storing the poll
time. Booleans are 1/0 on SQLite, the same as MySQL.

Requested in https://github.com/postfixadmin/postfixadmin/discussions/1197

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-11-12 19:23:47 +00:00
..
2010-09-26 23:14:42 +00:00
2009-05-03 16:14:14 +00:00
2026-11-12 19:23:47 +00:00
2007-03-24 07:27:00 +00:00

BEFORE YOU START

**** ALL THESE SCRIPTS ARE CREATED BY THIRD PARTIES **** **** THEY ARE AS IS, USE AT YOUR OWN RISK! ****

ADDITIONS

In this directory you will find additional scripts that are build by others.

change_password.tgz

by George Vieira SquirrelMail plugin to change your passwor

cleanupdirs.pl

by jared bell Displays a list of mailboxes that need to be deleted

mailbox_remover.pl

by Petr Znojemsky Deletes all unused mailboxes

mkeveryone.pl

by Joshua Preston Generate an 'everybody' alias for a domain.

pfa_maildir_cleanup.pl

by Stephen Fulton Deletes all unused mailboxes

postfixadmin-0.3-1.4.tar.gz

by Florian Kimmerl

The Postfixadmin SquirrelMail plugin let users change their virtual alias, vacation status/message and password.

See also : https://github.com/postfixadmin/postfixadmin/tree/master/ADDITIONS/squirrelmail-plugin

virtualmaildel.php

by George Vieira Deletes all unused mailboxes

Example mailbox / domain scripts for PostfixAdmin

  • postfixadmin-mailbox-postcreation.sh
  • postfixadmin-mailbox-postdeletion.sh
  • postfixadmin-domain-postdeletion.sh

by Troels Arvin troels@arvin.dk

Examples relevant to the optional mailbox_postcreation_script, mailbox_postdeletion_script and domain_postdeletion_script configuration options.

Review and adjust basedir and trashbase before installing the scripts. Run them as the account that owns the Maildirs, not as root. If sudo is required, grant the web server permission to run only the exact script as that account; never grant access to a generic mv command. Install privileged hooks in a root-owned directory that is not writable by the web server or mail users.

Sudoers applies to every enabled hook

Sudoers is not specific to the optional Rspamd integration. Every hook enabled in config.local.php that is invoked through sudo needs its own rule with the exact target account and installed script path. For example, after replacing the account names and paths to match the local system:

apache ALL=(courier) NOPASSWD: /usr/local/libexec/postfixadmin/postfixadmin-mailbox-postcreation.sh
apache ALL=(courier) NOPASSWD: /usr/local/libexec/postfixadmin/postfixadmin-mailbox-postdeletion.sh
apache ALL=(courier) NOPASSWD: /usr/local/libexec/postfixadmin/postfixadmin-domain-postdeletion.sh
apache ALL=(dovecot) NOPASSWD: /usr/local/libexec/postfixadmin/postfixadmin-mailbox-postpassword.sh

Only add rules for hooks that are actually configured. If the optional Rspamd hooks are installed, their rules extend this base policy. The composite Rspamd domain-deletion hook replaces the direct domain-deletion rule; unrelated mailbox and Dovecot rules remain in effect. See DOCUMENTS/RSPAMD-DKIM-HOOKS.md for the complete mapping.

The scripts validate the argument contracts documented in config.inc.php. Deletion is idempotent: an already absent Maildir is reported as a successful no-op so an interrupted hook can be retried safely.

postfixadmin-mailbox-postpassword.sh is an example for Dovecot mail-crypt. It requires Dovecot 2.3.19 or newer. Its default private-password setting name is for Dovecot 2.3; follow the comment in the script when using Dovecot 2.4.

Optional Rspamd DKIM hooks

  • postfixadmin-rspamd-dkim-postcreation.sh
  • postfixadmin-rspamd-dkim-postdeletion.sh
  • postfixadmin-domain-postdeletion-with-rspamd.sh

These examples keep Rspamd DKIM key management separate from the generic Maildir hooks and run each operation as its owning service account. See DOCUMENTS/RSPAMD-DKIM-HOOKS.md for installation, config.local.php, sudoers and recovery guidance.

Removed quota_usage.pl example

The legacy quota_usage.pl example has been removed. It scanned a fixed /home/vmail/domain/user layout with du; its database mode still required an obsolete mailbox.quota_usage column and wrote a value displayed as MB into quota2.bytes. Its SQL upsert was MySQL-specific despite advertising PostgreSQL support.

If a local cron job or script invokes this example, review that integration before upgrading. Removal does not delete locally added database columns or change the application's quota display. For Dovecot-backed quota reporting, see the Dovecot configuration guide and the Dovecot 2.4 example.

A future replacement should use the mail server's configured quota backend as its source of usage, preserve byte and message units, and support the installation's mailbox paths and configured table names. Any optional SQL writer should use parameterized, engine-appropriate queries and define safe failure and concurrency behavior alongside the mail server's quota updates. It should be tested against the supported backends before being distributed; no replacement utility is included with this removal.

Cyrus Quota Usage

See https://github.com/o-m-d/cyrus-quotausage-to-pfa

Optional strict MX policy service

postfix-strict-mx-policy is a standalone Postfix policy service that rejects recipient domains without an explicit MX record. This is intentionally stricter than standard SMTP implicit-MX delivery; see the project documentation before enabling it.