Re: [AMaViS-user] amavisd 2.6.0 mysql table msgs problems

2008-07-03 Thread Nate
At 03:47 PM 7/2/2008, Steve wrote: > > I've noticed that MailZu now takes very very long to execute it's > > queries. I believe this to be because the maddr table no longer has > > an index on the email column. Would adding that index in there as a > > non-unique really fubar anything? > > >I don

Re: [AMaViS-user] amavisd 2.6.0 mysql table msgs problems

2008-07-02 Thread Nate
n maddr. I've added "where partition_tag = 0" and that speeds it up to where it used to be; however, as soon as i tell amavisd-new to write a partition_tag other than 0, things are no doubt going to blow up. - Nate -

Re: [AMaViS-user] Spam Kill Level Not Working

2007-09-19 Thread Nate
g and why it's not getting killed. - Nate At 07:29 PM 9/17/2007, Erik Kristensen wrote: >Greetings, > >I am running amavisd-new-2.4.4 (20061120). If I need to upgrade I >will. > >I am using a mysql database with my users to do per-user/per-domain >configurations. My MTA is

Re: [AMaViS-user] Loading recomendations

2007-09-11 Thread Nate
mtp connections and also added smtpd_timeout = 30s in main.cf. - Nate - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. h

[AMaViS-user] Add penpals score to Status line?

2007-09-08 Thread Nate
rnatively it could go in the X-Amavis-Penpals line. - Nate - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT

Re: [AMaViS-user] penpals triggered on outbound, not inbound.

2007-09-07 Thread Nate
entries in the users table with local as Y. All other users should fall into the wildcard @. category and not be scanned for spam or penpals. I think this accomplishes it all and doesn't leave any holes of coverage. - Nate --

Re: [AMaViS-user] penpals triggered on outbound, not inbound.

2007-09-07 Thread Nate
Y This is a result of having a wildcard (@.) entry in my mysql users table which specifies @. as local. By changing this to N in the database, it seems to have solved the majority of my issue. - Nate At 03:44 PM 9/7/2007, Nate wrote: >I know this must be something I've overlooked

[AMaViS-user] penpals triggered on outbound, not inbound.

2007-09-07 Thread Nate
ight point out where i goofed? Thanks, - Nate - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120

Re: [AMaViS-user] Wildcard White/Black Lists?

2007-08-22 Thread Nate
At 09:30 AM 8/22/2007, Nate wrote: > > > >As Gary noted, this is not currently available. > >You will need to modify subroutine make_query_keys > >to generate additional search key(s). > >Mark, > >Actually from what I read Gary seemed to think it was possib

Re: [AMaViS-user] Wildcard White/Black Lists?

2007-08-22 Thread Nate
tch an exact domain match such as "[EMAIL PROTECTED]" if there is no subdomain? Thanks, - Nate - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search lo

[AMaViS-user] Wildcard White/Black Lists?

2007-08-21 Thread Nate
OTECTED]" as well to catch all sub-domains of a domain as well. Any suggestions? - Nate - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and conf

Re: [AMaViS-user] Foreign Keys Necessary?

2007-08-17 Thread Nate
SELECT 1 FROM msgs WHERE sid=id) AND NOT EXISTS (SELECT 1 FROM msgrcpt WHERE rid=id) # clean msgrcpt table from orphaned records DELETE LOW_PRIORITY FROM msgrcpt WHERE NOT EXISTS (SELECT 1 FROM msgs WHERE mail_id=msgrcpt.mail_id) # clean quarantine table from orphaned records DELETE LOW_PRIORIT

[AMaViS-user] InnoDB vs myISAM performance

2007-08-15 Thread Nate
d given that myISAM is considerably faster, what are the benefits to continuing to use innodb? - Nate - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log ev

[AMaViS-user] Foreign Keys Necessary?

2007-08-15 Thread Nate
foreign keys to keep the database clean? Can I do away with them and clean it up manually without causing any problems? I'm also curious, what type of stats do the pgsql people see with foreign keys on? Thanks, - Nate ---

[AMaViS-user] Attachment Ripper

2006-10-16 Thread Nate
making inboxes smaller. Thanks, - Nate - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application