[postfixadmin:patches] #10 simple python vacation script

[Christian B. <chr...@us...>]

- **status**: open --> closed-rejected
- **Group**:  --> SVN (please specify revision!)
- **Comment**:

Given there was no reaction to the SQL injection comment since years, I'll reject this.

I'm not completely opposed to a python-based vacation script (actually I prefer python over perl), but it has to be a full replacement so that we can drop vacation.pl (we are not bored enough to maintain two vacation scripts). If you or someone else has such a python script, feel free to open a pull request on github.



---

** [patches:#10] simple python vacation script**

**Status:** closed-rejected
**Group:** SVN (please specify revision!)
**Created:** Sat Aug 18, 2007 08:53 AM UTC by Thomas Witzenrath
**Last Updated:** Wed Jan 23, 2013 12:48 PM UTC
**Owner:** nobody


Hi,

since the vacation.pl distributed with postfixadmin is broken, i rewrote the whole thing in python.

Features:

\* loop detection
\* Uses Sender:-Header if present
\* rejects multiple Adresses in From:-Header, but replies to Sender: or Reply-To: if present
\* Does not answer to Spam-Messages \(checks for X-Spam-Status\)
\* Does not answer to Precedence: \[bulk|list|junk\]
\* Does not send notifications to people that have been notified in the last week
\* writes messages to logfile
\* logs errors to errorlog, or if all else fails, tries to send a message to an administrator


Limits:

\* So far only support for Postgres, but changing this to MySQL should be as easy as changing two lines of code \(line 20 and 40\).
\*relies on postfix handing in the recipients e-mail address, so you have to change master.cf like this:

vacation                unix    -       n       n       -       -       pipe
flags=DRhu user=vacation argv=/var/spool/vacation/vacation.py $\{user\}


\* based on the gentoo-wiki tablelayout, which I am not sure is the same as is propagated through postfixadmin \(but I think it should\):

Table "public.vacation"
Column  |           Type           |               Modifiers
\----------+--------------------------+----------------------------------------
email    | character varying\(255\)   | not null default ''::character varying
subject  | character varying\(255\)   | not null default ''::character varying
body     | text                     | not null
cache    | text                     |
domain   | character varying\(255\)   | not null default ''::character varying
created  | timestamp with time zone | default now\(\)
modified | timestamp with time zone | default now\(\)
active   | boolean                  | not null default true
Indexes:
"vacation\_key" PRIMARY KEY, btree \(email\)


Table "public.vacation\_notification"
Column    |           Type           |       Modifiers
\-------------+--------------------------+------------------------
on\_vacation | character varying\(255\)   | not null
notified    | character varying\(255\)   | not null
notified\_at | timestamp with time zone | not null default now\(\)
Indexes:
"vacation\_notification\_pkey" PRIMARY KEY, btree \(on\_vacation, notified\)
Foreign-key constraints:
"vacation\_notification\_on\_vacation\_fkey" FOREIGN KEY \(on\_vacation\) REFERENCES vacation\(email\) ON DELETE CASCADE



only limited testing has been done, friendly bug reports are welcome\!





---

Sent from sourceforge.net because pos...@li... is subscribed to https://sourceforge.net/p/postfixadmin/patches/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/postfixadmin/admin/patches/options.  Or, if this is a mailing list, you can unsubscribe from the mailing list.