>
> > wouldn't postfix be able to allow relay access by a mysql:
> > map to this table?
>
> Good question. I don't know what postfix's mysql map support look
> like, nor whether it's flexible enough to allow making a
> check_client_access map reference with an SQL query that would
> properly check against a timestamp. I expect you'd also want to rig
> a sweeper daemon to periodically clean old entries out, to prevent
> the table from growing without bound, or perhaps qpopper can do
> that.
>

well, you wouldn't need to check the value of the timestamp for postfix,
just the ip.
you would use the timestamp for your sweeper program to clean out old
entries. i.e. ip_timestamp <= time(0) - HOURS_TO_ALLOW_RELAY*3600

i already patched qpopper with this mysql patch after posting about this
(though i watered down the auth patch a bit, i didn't want to auth virtual
domains)
and i know the patch works, and writes the ip/timestamp out good, and i
wrote a sweeper program in C to clean out old entries, now i just gotta
try a mysql: map for postfix.
i'll let you know

-Tony
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.
Anthony J. Biacco Network Administrator/Engineer
thelittleprinceasteroid-b612.org Intergrafix Internet Services

    "Dream as if you'll live forever, live as if you'll die today"
http://www.asteroid-b612.org http://www.intergrafix.net
.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-._.-.

> > I ask, not only because it's kind of related to the
topic, but > > because i want to do it. :-)
>
> If that can be made to work, it sounds like it'd be a cleaner
> solution than pop-before-smtp for qpopper users, or at least for
> qpopper+mysql-mail patch users. Whether it's a more pleasing
> alternative than pop-before-smtp for others would of course be a
> design question. I've not observed sufficient performance problems
> from pop-before-smtp for this alternative to necessarily seem
> compelling for people who aren't using qpopper+mysql already.
>
> -Bennett
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]