[AMaViS-user] Whitelisting and SQL

2010-05-07 Thread Jason Gauthier
All, This is seemingly, an elementary question, but I am missing something. First, I have used this configuration for whitelisting/blacklisting for years: read_hash(\%whitelist_sender, '/var/amavis/lists/whitelist'); read_hash(\%blacklist_sender, '/var/amavis/lists/blacklist'); I

[AMaViS-user] Mailzu-NG

2010-05-03 Thread Jason Gauthier
All, Probably not the most appropriate place for this thread, but it seems somewhat relative. The warranty on my edge mail server is up, and I am moving it to a VM. In doing so, I am evaluating the applications that I run on it. Mailzu is one of them. I noticed, and read, that Mailzu-NG is as

[AMaViS-user] Help: Production system affected

2009-09-28 Thread Jason Gauthier
All, I moved from 2.5 to 2.6 and encountered some errors. Regretfully, I wiped my database and started fresh. This morning, I found mail queued up for several hours. It was due to this error: Sep 28 00:00:01 mail amavis[30234]: (30234-03) (!!)TROUBLE in check_mail: sql-enter FAILED:

Re: [AMaViS-user] Error release objects

2009-09-28 Thread Jason Gauthier
Mark, So it is not in the SQL quarantine, and amavisd-release can't release it for this reason. Well, I see why this happened now. It never saved the data. I'm assuming this is an amavis failure and not a local configuration failure. But suggestions welcome! Sep 21 16:39:56 mail

Re: [AMaViS-user] Help: Production system affected

2009-09-28 Thread Jason Gauthier
I see this email last summer: Looks like the AUTO_INCREMENT counter value was reset after the change of the table msgs, and started counting from zero again. Not good. As the post you found suggests, it looks like the auto-increment counter is b0rked. It's a simple fix, though you'll have

Re: [AMaViS-user] Error release objects

2009-09-24 Thread Jason Gauthier
Jason Gauthier wrote: All, I moved to 2.6 from a 2.5 based application. I made all the schema changes I could reverse engineer from the RELEASE NOTES and README.sql.mysql files. (or whatever it was called). I did not change my configuration in any way aside from that. When I attempt

Re: [AMaViS-user] Error release objects

2009-09-24 Thread Jason Gauthier
Jason Gauthier wrote: All, I moved to 2.6 from a 2.5 based application. I made all the schema changes I could reverse engineer from the RELEASE NOTES and README.sql.mysql files. (or whatever it was called). I did not change my configuration in any way aside from that. When I attempt

[AMaViS-user] Error release objects

2009-09-23 Thread Jason Gauthier
All, I moved to 2.6 from a 2.5 based application. I made all the schema changes I could reverse engineer from the RELEASE NOTES and README.sql.mysql files. (or whatever it was called). I did not change my configuration in any way aside from that. When I attempt to release some mail

Re: [AMaViS-user] Error release objects

2009-09-23 Thread Jason Gauthier
Jason Gauthier wrote: All, I moved to 2.6 from a 2.5 based application. I made all the schema changes I could reverse engineer from the RELEASE NOTES and README.sql.mysql files. (or whatever it was called). I did not change my configuration in any way aside from that. When I attempt

[AMaViS-user] Moving from 2.5 to 2.6

2009-09-15 Thread Jason Gauthier
All, I am moving from 2.5 to 2.6. I know there are schema changes, and maybe other requirements needed before I can start running 2.6. Would someone suggest a process, or document, I can follow? I want to get it right one the first try! Thanks! Jason

Re: [AMaViS-user] Moving from 2.5 to 2.6

2009-09-15 Thread Jason Gauthier
I am moving from 2.5 to 2.6. I know there are schema changes, and maybe other requirements needed before I can start running 2.6. Would someone suggest a process, or document, I can follow? I want to get it right one the first try! See: http://www.ijs.si/software/amavisd/release-notes.txt

[AMaViS-user] max_servers

2009-01-16 Thread Jason Gauthier
All, Recently had many thousands of messages hold up my mail server, and I adjusted max_servers to 15, and also changed master.cf to reflex that on the 'post processing' side. My question is, how much is too much? Server limitations aside, and speaking strictly software/OS. At what

[AMaViS-user] amavisd-nanny for vt100 family

2007-09-13 Thread Jason Gauthier
All, This is not very pretty at all, but if you are on a vt100 compatible terminal, you might like this. I wanted to sticky my amavisd-nanny in a small window and leave it on my desktop. But, it continually scrolls. Some might like seeing that historical data, but I wanted real time redraws.

[AMaViS-user] PID disappearance

2007-07-30 Thread Jason Gauthier
All, Running Debian 4.x.My /var/amavis/amavisd.pid file keeps disappearing. I'm sure something in cron is doing it, but I have not located it yet. Does anyone know? Thanks, Jason - This SF.net email is sponsored

Re: [AMaViS-user] PID disappearance

2007-07-30 Thread Jason Gauthier
Running Debian 4.x.My /var/amavis/amavisd.pid file keeps disappearing. I'm sure something in cron is doing it, but I have not located it yet. Does anyone know? Do you mean /var/run/amavis/amavisd.pid? I do, but mine is located in /var/amavis grep ! /var/log/mail.log Nope.

[AMaViS-user] OS Fingerprinting

2007-07-03 Thread Jason Gauthier
Hey all, With the help of this list, I was able to get p0f working successfully. One issue, perhaps: All my fingerprints result in UNKNOWN. As an example: Jul 3 09:49:32 mail amavis[4056]: (04056-15) OS_fingerprint: 66.63.160.251 14.216 UNKNOWN

Re: [AMaViS-user] OS Fingerprinting

2007-07-03 Thread Jason Gauthier
On Tue, 2007-07-03 at 09:51 -0400, Jason Gauthier wrote: Hey all, With the help of this list, I was able to get p0f working successfully. One issue, perhaps: All my fingerprints result in UNKNOWN. is your mail server behind a nat firewall? That tends to kill most

Re: [AMaViS-user] p0f, not being queried

2007-06-28 Thread Jason Gauthier
Mark, Is amavisd getting information about client IP from MTA through XFORWARD? A client IP address should show (through macro %a) in the log, and at log level 1 also in the log entry such as: amavis[16469]: (16469-18) Checking: rhOluIzi8z9w [121.133.47.8] xxx - xxx My Checking line

[AMaViS-user] p0f, not being queried

2007-06-27 Thread Jason Gauthier
All, I've been reading some documentation, and trying to implement p0f fingerprint checking. I went ahead and turned it on in my config: $os_fingerprint_method = 'p0f:127.0.0.1:2345'; # to query p0f-analyzer.pl And the resulting amavisd log shows that the fingerprint code is loaded. I am

[AMaViS-user] SQL quarantine

2007-05-15 Thread Jason Gauthier
I started seeing this in my mailq. So I deleted my quarantine database, which is only virus. It now has zero rows, but still occurs. I'm not an SQL idiot, but I'm uncertain what the problem is here. Thanks, Jason -=-=-=-= 05E0CEFC9C44713 Tue May 15 01:42:25 MAILER-DAEMON (host

Re: [AMaViS-user] How to print running configuration?

2007-04-26 Thread Jason Gauthier
is there a way to print amavisd-new current configuration? I mean the values of all configuration variables (like $mydomain and so on). I imagine this is a FAQ... but I couldn't find an answer yet :( cat /usr/sbin/amavisd /etc/amavisd.conf | egrep '\$' | lpr Well, that gets you

Re: [AMaViS-user] Policy Banks

2007-04-24 Thread Jason Gauthier
Mark, Policy Banks, being new to amavisd are definitely new to me. The originating style policy bank is very appealing to me, and I would like to implement this. I realize there are a few methods to accommodate this. I think I would prefer to do it with XFORWARD from postfix. The

[AMaViS-user] Pen pal setup verification

2007-04-24 Thread Jason Gauthier
]' 132888 Query UPDATE msgs SET content='C', quar_type=' ', quar_loc='', dsn_sent='N', spam_l evel='0', message_id='[EMAIL PROTECTED]' , from_addr='\Jason Gauthier\ [EMAIL PROTECTED]', subject='sdlfkj' WHERE mail_id='M+tLtOzPmNIh' 132953 Query SELECT

[AMaViS-user] Policy Banks

2007-04-23 Thread Jason Gauthier
All, Policy Banks, being new to amavisd are definitely new to me. The originating style policy bank is very appealing to me, and I would like to implement this. I realize there are a few methods to accommodate this. I think I would prefer to do it with XFORWARD from postfix. The

[AMaViS-user] Mail quarantine user interface

2007-04-19 Thread Jason Gauthier
Hey all, I've been happily running postfix (relay only), amavisd, and spamassassin for well over two years now. (end point is Exchange 2003) (09:33:40 up 810 days, 10:12, 2 users, load average: 0.87, 1.19, 1.18) All of my quarantined emails go to an Exchange mailbox that I review. Any

[AMaViS-user] Whitelist/Blacklist not working

2007-03-05 Thread Jason Gauthier
Greetings all, I recently wrote some scripts to populate my whitelist and blacklist automatically. I began to review log files for blocks and saw a few from 03/04: Mar 4 00:02:53 mail amavis[16806]: (16806-03) SPAM-KILL, [EMAIL PROTECTED] - [EMAIL PROTECTED], score=x, kill=2.3,