Thread

  1. RBLs ... I'm tired of spam ...

    Marc G. Fournier <scrappy@hub.org> — 2003-05-27T20:41:37Z

    *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?
    
    
  2. Re: RBLs ... I'm tired of spam ...

    Larry Rosenman <ler@lerctr.org> — 2003-05-27T21:38:43Z

    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@hub.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@postgresql.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@lerctr.org
    US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
    
    
    
    
    
  3. Re: RBLs ... I'm tired of spam ...

    Vince Vielhaber <vev@michvhf.com> — 2003-05-27T22:08:13Z

    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.
    
    
    
  4. Re: RBLs ... I'm tired of spam ...

    Ricardo Ryoiti S. Junior <suga@netbsd.com.br> — 2003-05-27T22:16:39Z

    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.
    
    
    
    
    
  5. Re: RBLs ... I'm tired of spam ...

    Michael A Nachbaur <mike@nachbaur.com> — 2003-05-27T22:32:14Z

    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@postgresql.org so that your
    > message can get through to the mailing list cleanly
    
    -- 
    Michael A Nachbaur <mike@nachbaur.com>
    
    
    
  6. Re: RBLs ... I'm tired of spam ...

    scott.marlowe <scott.marlowe@ihs.com> — 2003-05-27T22:47:58Z

    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@postgresql.org so that your
    > > message can get through to the mailing list cleanly
    > 
    > 
    
    
    
  7. Re: RBLs ... I'm tired of spam ...

    Marc G. Fournier <scrappy@postgresql.org> — 2003-05-28T00:30:33Z

    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 ...
    
    
    
  8. Re: RBLs ... I'm tired of spam ...

    Marc G. Fournier <scrappy@postgresql.org> — 2003-05-28T00:31:45Z

    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 ...
    
    
    
  9. Re: RBLs ... I'm tired of spam ...

    Larry Rosenman <ler@lerctr.org> — 2003-05-28T02:37:01Z

    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@postgresql.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@postgresql.org
    >
    
    
    
    -- 
    Larry Rosenman                     http://www.lerctr.org/~ler
    Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
    US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
    
    
    
    
    
  10. Re: RBLs ... I'm tired of spam ...

    Allan Wind <allanwind@lifeintegrity.com> — 2003-05-28T04:11:03Z

    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
    
  11. Re: RBLs ... I'm tired of spam ...

    Oleg Bartunov <oleg@sai.msu.su> — 2003-05-28T07:30:22Z

    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@postgresql.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@sai.msu.su, http://www.sai.msu.su/~megera/
    phone: +007(095)939-16-83, +007(095)939-23-83
    
    
  12. Stored Procs / Transaction IDs

    Brian <brian@mail.pantalaimon.net> — 2003-05-28T17:42:20Z

    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@mail.pantalaimon.net