Re: [AMaViS-user] Amavis-new and dual master replication with MySQL

2009-07-07 Thread Thomas Gelf
Steve wrote: If you created these with REAL partitions, then you could alter table drop partition (which is even faster) What do you mean with REAL partitions? Partitions in MySQL? Yes, using MySQL 5.1 - it helped me to decrease time needed for garbage collection from 4 days to 4 seconds.

Re: [AMaViS-user] How to log the 'helo' domain passed from upstream.

2009-07-07 Thread Thomas Gelf
Xueron Nee wrote: Is there any macros can be used in log_templ point to the Helo/Ehlo domain passed from upstream? Not sure how your setup looks like - but usually this is a task that should be accomplished by your front MX server (Postfix of whatever). Regards, Thomas Gelf

Re: [AMaViS-user] swap_pager_getswapspace failed.

2009-07-07 Thread Glenn Sieb
Michael Scheidell said the following on 7/2/09 9:56 AM: Something borked in your installation. If these pid's are amavisd pid's, something wrong. You running the official spam assassin ports of everything? Sa, dependencies? amavisd? Dependencies? Or did you do a CPAN thing? Looks like

Re: [AMaViS-user] Amavis-new and dual master replication with MySQL

2009-07-07 Thread Steve
Hallo Thomas, Yes, using MySQL 5.1 - it helped me to decrease time needed for garbage collection from 4 days to 4 seconds. Can you point me to some good documentation how to implement that? I am running 5.1.36 over here. Regards, Thomas Gelf // Steve -- Neu: GMX Doppel-FLAT mit

[AMaViS-user] Adding an image in an html Altermime disclaimer

2009-07-07 Thread Alan Munday
I have both text and html disclaimers working and have been asked to include a company logo to the html disclaimer. html is not an area of expertise, but I've been trying to use the following to include the image: img src=/etc/amavisd/logo.png width=160 height=139 alt=Company Logo This arrives

Re: [AMaViS-user] mysql partitioning setup cheat sheet?

2009-07-07 Thread Thomas Gelf
Michael Scheidell wrote: I guess you don't need the 'bigint(20) on id if the id is unique only on each partition, and you need to add partition_tag to primary key (since a list partition has to use primary keys) Yes and no: primary key is defined as PRIMARY KEY (id, partition_tag), however

Re: [AMaViS-user] Amavis-new and dual master replication with MySQL

2009-07-07 Thread Michael Scheidell
Hallo Michael, If you created these with REAL partitions, then you could alter table drop partition (which is even faster) What do you mean with REAL partitions? Partitions in MySQL? Yes, see recent post by Thomas Gelf. -- Michael Scheidell, CTO |SECNAP Network Security Finalist 2009

[AMaViS-user] PostgreSQL 8.3 requires changes to queries

2009-07-07 Thread Tim Howe
I haven't seen this mentioned yet, so if this is already being discussed I apologize. As of Pg version 8.3, Non-character data types are no longer automatically cast to TEXT. See http://www.postgresql.org/docs/8.3/static/release-8-3.html under section E.8.2.1. General This requires changes to

[AMaViS-user] Recent spam increase // Any clue??

2009-07-07 Thread bsd
Hello folks, I am using a combination of amavisd-new 2.6.4 - spamassassin - p0f - dcc - razor2 - SPF - DKIM on FBSD box, with quite good results since many years now. I would like to know if anyone has already found a solution to fight these scams as I am a little bit clueless to fight

Re: [AMaViS-user] PostgreSQL 8.3 requires changes to queries

2009-07-07 Thread Tim Howe
On Tue, 7 Jul 2009 08:08:43 -0700 Tim Howe th...@bendtel.net wrote: I haven't seen this mentioned yet, so if this is already being discussed I apologize. As of Pg version 8.3, Non-character data types are no longer automatically cast to TEXT. See

Re: [AMaViS-user] Recent spam increase // Any clue??

2009-07-07 Thread Bill Landry
Hello folks, I am using a combination of amavisd-new 2.6.4 - spamassassin - p0f - dcc - razor2 - SPF - DKIM on FBSD box, with quite good results since many years now. I would like to know if anyone has already found a solution to fight these scams as I am a little bit clueless to fight

Re: [AMaViS-user] Guide / Howto for Lenny

2009-07-07 Thread Carlos Williams
On Fri, Jun 26, 2009 at 2:58 PM, Daniel Luttermann dan...@dlutt.de wrote: personally I can recommend these two howtos: http://workaround.org/articles/ispmail-etch/index.html.en The link above seems to be working fine however I start at step 10. I don't have or am using a MySQL database for