Hey there
I have been thinking bout this very same thing for a little while, I
want my users to be able to create/modify/delete etc their own filters,
and have been wishing for MySql support. However, I have thought of a
way that may work, haven't tried it yet, but am about to:).
What I have is php compiled as a CGI as well as the apache module. I am
going to write up a php cgi script that will be doing all the mailfilter
mods, and set it to execute as vpopmail:vchkpw, this will allow the
mailfilter modifying php cgi to access and make changes to the
mailfilters in the users Maildir's. From what I have been reading, this
should be an acceptable alternative, specially if the stand alone php is
out of the web tree, as it appears to protect itself from non-genuine
execution attempts on the php script that will be doin the work pretty
well. It will be probably interesting cause I have never compiled/used
php as anything other than a Apache module before, so I will probably
make any number of mistakes before it gets tested properly, but I'm
hopeful.
Going to give it a try anyway, will let you know how it goes if you
want?
Regards
(would still kill for user mailfilter storage in MySql tho.. lol)
----- Original Message -----
From: "Sunil William Savkar" <sav...@inthespace.com>
To: <br...@cfu.net>
Cc: <cour...@lists.sourceforge.net>
Sent: Tuesday, September 24, 2002 11:53 PM
Subject: Re: [maildropl] Maildrop .mailfilter file permissions? Using
web interface for filter creation?
Joseph W. Breu wrote:
I changed the uid/gid of apache to vmail.vmail. I could then modify
the
mailfilters.
Hm, I guess that works, but of course then you have to worry about all
the
other files that were previously accessed and used by apache. You
would
need to make sure they were also vmail.vmail as uid.gid, right?
It seems a bit kludgey to me though I guess it works.
Does maildrop have mysql support similar to spamassassin for purposes
of
storing .mailfilters in sql dbs? This may make things easier when
dealing
with virtual users and circumvent the whole permission issue...