Lists: | pgsql-hackers |
---|
From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | RBLs ... I'm tired of spam ... |
Date: | 2003-05-27 20:41:37 |
Message-ID: | 20030527173937.H9254@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
*Way* off topic ... but I'm tired of processing through >300 messages
nightly of which 10 are stuff that need to be approved for the lists, and
290 are trash ...
What are ppl using / trusting out there as far as Free RBLs are concerned?
From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-27 21:38:43 |
Message-ID: | 422190000.1054071523@lerlaptop.iadfw.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
FEATURE(dnsbl,`korea.services.net',``Mail from $&{client_addr} rejected by
korea.services.net'')dnl
FEATURE(dnsbl,`brazil.blackholes.us',``Mail from $&{client_addr} rejected
by brazil.blackholes.us'')dnl
FEATURE(dnsbl,`opm.blitzed.org',``Mail from $&{client_addr} rejected by
opm.blitzed.org'')dnl
plus I have a contract for rbl-plus.mail-abuse.org
opm.blitzed.org is open proxies, and the others are obvious.
LER
--On Tuesday, May 27, 2003 17:41:37 -0300 "Marc G. Fournier"
<scrappy(at)hub(dot)org> wrote:
>
> *Way* off topic ... but I'm tired of processing through >300 messages
> nightly of which 10 are stuff that need to be approved for the lists, and
> 290 are trash ...
>
> What are ppl using / trusting out there as far as Free RBLs are concerned?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-27 22:08:13 |
Message-ID: | Pine.BSF.4.44.0305271806460.46730-100000@paprika.michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Tue, 27 May 2003, Marc G. Fournier wrote:
>
> *Way* off topic ... but I'm tired of processing through >300 messages
> nightly of which 10 are stuff that need to be approved for the lists, and
> 290 are trash ...
>
> What are ppl using / trusting out there as far as Free RBLs are concerned?
Avoid SPEWS.
Vince.
--
Fast, inexpensive internet service 56k and beyond! http://www.pop4.net/
http://www.meanstreamradio.com http://www.unknown-artists.com
Internet radio: It's not file sharing, it's just radio.
From: | "Ricardo Ryoiti S(dot) Junior" <suga(at)netbsd(dot)com(dot)br> |
---|---|
To: | Larry Rosenman <ler(at)lerctr(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-27 22:16:39 |
Message-ID: | 3ED3E3C7.6090608@netbsd.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Larry Rosenman wrote:
> FEATURE(dnsbl,`korea.services.net',``Mail from $&{client_addr}
> rejected by korea.services.net'')dnl
> FEATURE(dnsbl,`brazil.blackholes.us',``Mail from $&{client_addr}
> rejected by brazil.blackholes.us'')dnl
Yes, SPAM is really a problem here. Unfortunatelly, telco companies
won't do anything to keep spammers out of service. It's very radical to
simply drop all the brazilian IPs, and I just cannot do this otherwise
I'd be unable to talk to anyone. I've added about 20 B classes to the
mta's access list and 99% of the spam went away. This is because ALL the
spam that comes from Brazil are originated from ADSLs/Cablemodens.
Yet, I used to receive many spams from US/China until I started
using spews.
I think that people with .org/.net/.com domains are really in a bad
situation. People say that when they receive 300 mails a day, 250 or so
are spam. This sounds really bad. In the worst times, I used to receive
at most 5-10 spams a day, from 400 other e-mails.
> FEATURE(dnsbl,`opm.blitzed.org',``Mail from $&{client_addr} rejected
> by opm.blitzed.org'')dnl
>
>
> plus I have a contract for rbl-plus.mail-abuse.org
> opm.blitzed.org is open proxies, and the others are obvious.
I found mail-abuse.org to be very burocratic to add a single IP to
it's database. I think this makes them much less effective.
[]s
Ricardo.
From: | Michael A Nachbaur <mike(at)nachbaur(dot)com> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-27 22:32:14 |
Message-ID: | 200305271532.14075.mike@nachbaur.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Install SpamAssassin, and let it figure it out for you. It uses a whole list
of RBLs and uses them to score a message as spam, instead of just
blanket-denying messages from those SMTP servers. It works quite well.
On Tuesday 27 May 2003 01:41 pm, Marc G. Fournier wrote:
> *Way* off topic ... but I'm tired of processing through >300 messages
> nightly of which 10 are stuff that need to be approved for the lists, and
> 290 are trash ...
>
> What are ppl using / trusting out there as far as Free RBLs are concerned?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Michael A Nachbaur <mike(at)nachbaur(dot)com>
From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Michael A Nachbaur <mike(at)nachbaur(dot)com> |
Cc: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-27 22:47:58 |
Message-ID: | Pine.LNX.4.33.0305271646500.25862-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Another vote for SpamAssassin. We use it at work here and it's quite
nice. It puts all the "borderline" spam in a holding area and sends you a
daily email with all the topics / names listed and you can request those
out of the spam bucket. It's configurable to the extreme.
On Tue, 27 May 2003, Michael A Nachbaur wrote:
> Install SpamAssassin, and let it figure it out for you. It uses a whole list
> of RBLs and uses them to score a message as spam, instead of just
> blanket-denying messages from those SMTP servers. It works quite well.
>
> On Tuesday 27 May 2003 01:41 pm, Marc G. Fournier wrote:
> > *Way* off topic ... but I'm tired of processing through >300 messages
> > nightly of which 10 are stuff that need to be approved for the lists, and
> > 290 are trash ...
> >
> > What are ppl using / trusting out there as far as Free RBLs are concerned?
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
>
>
From: | The Hermit Hacker <scrappy(at)postgresql(dot)org> |
---|---|
To: | Vince Vielhaber <vev(at)michvhf(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-28 00:30:33 |
Message-ID: | 20030527212923.S598@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Tue, 27 May 2003, Vince Vielhaber wrote:
> On Tue, 27 May 2003, Marc G. Fournier wrote:
>
> >
> > *Way* off topic ... but I'm tired of processing through >300 messages
> > nightly of which 10 are stuff that need to be approved for the lists, and
> > 290 are trash ...
> >
> > What are ppl using / trusting out there as far as Free RBLs are concerned?
>
> Avoid SPEWS.
Ya, Spews is one of the 'evil ones' ... one of the blocks we were on in
panama was in spews, and they don't seem to provide any way (that we could
find) of removing the IPs when the offending server(s) were taken off the
network ...
From: | The Hermit Hacker <scrappy(at)postgresql(dot)org> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | Michael A Nachbaur <mike(at)nachbaur(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-28 00:31:45 |
Message-ID: | 20030527213106.L598@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Tue, 27 May 2003, scott.marlowe wrote:
> Another vote for SpamAssassin. We use it at work here and it's quite
> nice. It puts all the "borderline" spam in a holding area and sends you a
> daily email with all the topics / names listed and you can request those
> out of the spam bucket. It's configurable to the extreme.
'K, I haven't found *that* feature yet ... can you do this on a per-user
basis as well, or is this a 'blanket, site wide' configuration ...
From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | The Hermit Hacker <scrappy(at)postgresql(dot)org>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | Michael A Nachbaur <mike(at)nachbaur(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-28 02:37:01 |
Message-ID: | 15840000.1054089421@lerlaptop.lerctr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Per user or site....
I use Spamassassin AFTER the 4 RBL's and a personal fecal Roster.
--On Tuesday, May 27, 2003 21:31:45 -0300 The Hermit Hacker
<scrappy(at)postgresql(dot)org> wrote:
> On Tue, 27 May 2003, scott.marlowe wrote:
>
>> Another vote for SpamAssassin. We use it at work here and it's quite
>> nice. It puts all the "borderline" spam in a holding area and sends you
>> a daily email with all the topics / names listed and you can request
>> those out of the spam bucket. It's configurable to the extreme.
>
> 'K, I haven't found *that* feature yet ... can you do this on a per-user
> basis as well, or is this a 'blanket, site wide' configuration ...
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From: | allanwind(at)lifeintegrity(dot)com (Allan Wind) |
---|---|
To: | The Hermit Hacker <scrappy(at)postgresql(dot)org> |
Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, Michael A Nachbaur <mike(at)nachbaur(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-28 04:11:03 |
Message-ID: | 20030528041103.GA23907@lifeintegrity.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 2003-05-27 21:31:45, The Hermit Hacker wrote:
> 'K, I haven't found *that* feature yet ... can you do this on a per-user
> basis as well, or is this a 'blanket, site wide' configuration ...
# When using the 'local:' quarantine method (default), the following
# applies:
#
# A finer control of quarantining is available through variable
# $virus_quarantine_to/$spam_quarantine_to. It may be a simple scalar
# string,
# or a ref to a hash lookup table, or a regexp lookup table object,
# which makes possible to set up per-recipient quarantine addresses.
I am very impressed with the amavisd-new, spamassassin, razor
combination that I installed on my home machine a few days. Not had to
manually process any spam since, and mailq provides a nice reference on
what could be outright blocked.
http://lawmonkey.org/anti-spam.html is a well written guide to get
started, although most of the details were taken care of by the debian
package used.
/Allan
--
Allan Wind
P.O. Box 2022
Woburn, MA 01888-0022
USA
From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RBLs ... I'm tired of spam ... |
Date: | 2003-05-28 07:30:22 |
Message-ID: | Pine.GSO.4.55.0305281128100.23898@ra.sai.msu.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
I'm using bogofilter. It works well after learning what is spam/non spam.
I save all spam into seprarate box and check it once a week.
It takes mostly pressing "d" in pine and could be done very quickly.
Oleg
On Tue, 27 May 2003, Marc G. Fournier wrote:
>
> *Way* off topic ... but I'm tired of processing through >300 messages
> nightly of which 10 are stuff that need to be approved for the lists, and
> 290 are trash ...
>
> What are ppl using / trusting out there as far as Free RBLs are concerned?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
From: | Brian <brian(at)mail(dot)pantalaimon(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Stored Procs / Transaction IDs |
Date: | 2003-05-28 17:42:20 |
Message-ID: | Pine.LNX.4.50.0305281341070.3473-100000@lyra |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Is it possible to get the transaction ID of the transaction a trigger
fired on from plpgsql?
I see in postgresql/contrib/dbmirror/pending.c a C based stored procedure
that is accessing this information. I can't find anything in the online
docs for accessing the xid from plpgsql.
Brian Knox
brian(at)mail(dot)pantalaimon(dot)net