Re: [AMaViS-user] bypass scanning outgoing mail
Setup port 587 for this (aka submission) in master.cf:
smtpinet n - n - - smtpd
-o content_filter=amavis:[127.0.0.1]:10024
-o receive_override_options=no_address_mappings
-o smtpd_client_restrictions=cidr:/etc/postfix/client.cidr
submission inet n - n - - smtpd
-o content_filter=
-o smtpd_etrn_restrictions=reject
-o
smtpd_client_restrictions=permit_sasl_authenticated,permit_mynetworks,reject
-o smtpd_sasl_auth_enable=yes
This way you have port 25 which does local SMTP delivery with RBL checks and
filtering (incoming) and port 587 which does no filtering but only from
clients connection with SASL or those defined as local network hosts
(outgoing). Consider 587 your relay port. This also conveniently bypasses
SMTP port blocking by residential ISPs or corporate firewalls, allowing
authorized accounts to relay from anywhere. Splitting these two type of
traffic is not a bad idea.
HTH
On 12/11/05 9:49 PM, M. Lewis [EMAIL PROTECTED] wrote:
In the last few days, someone had written in and asked how to do this. I
believe the answer was from Gary. Gary gave two options for doing this.
I chose to do the latter of his two options. But it isn't working for
some reason.
The original thread is here:
http://marc.theaimsgroup.com/?l=amavis-userm=113415019700881w=2
I am getting this in the maillog when I try the second method:
Dec 12 00:40:57 moe postfix/smtpd[23856]: warning: access table
hash:/etc/postfix/amavis_internal: with smtpd_proxy_filter specified,
action FILTER is unavailable
Gary's second suggestion was this:
Another way is more specific:
smtpd_recipient_restrictions =
check_client_access hash:/etc/postfix/amavis_internal
permit_mynetworks
reject_unauth_destination
contents of /etc/postfix/amavis_internal
(ip address of the internal server is listed here):
192.168.1.17 FILTER smtp-amavis:[127.0.0.1]:10026
Then in amavisd.conf:
$inet_socket_port = [10024, 10026];
$interface_policy{'10026'} = 'INTERNAL';
$policy_bank{'INTERNAL'} = { # mail originating from the internal server
bypass_spam_checks_maps = [1], # don't spam-check outgoing mail
bypass_banned_checks_maps = [1], # don't banned-check outgoing mail
final_spam_destiny = D_PASS, # insure spam passes
final_banned_destiny = D_PASS, # insure banned files pass
};
--
Erik Petersen [EMAIL PROTECTED]
(760) 715-8519
S2K International
The International Honda S2000 Owners Community
http://www.s2ki.com
---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
[AMaViS-user] unknown files passes virus check
Hello, i'm new to amavis. There is one thing that i worry about the way amavis do the virus-checking: Why do amavis handle unknown filetypes (e.g. unknown archives, like SITX or so) as OK and letting them through ? I think this behaveiour is very insecure. Can i change this ? Regards, _ Oliver Geisen Systemadministrator Kreisboten Verlag Mühlfellner KG Telefon: 0881/686-63 Telefax: 0881/686-74 --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
[AMaViS-user] amavis-stats-0.1.19 - no data to graph in monthly and yearly
Hello, I've installed the new version 0.1.19 of amavis-stats. In the monthly and yearly tabs I get: NO SPAM/HEADER DATA TO GRAPH NO VIRUS DATA TO GRAPH Is that normal with a fresh installed amavis-stats or went something wrong? I noticed that older versions of amavis-stats (like 0.1.12) did graph monthly and yearly immediately after installation, so I wonder if that changed. Thanks, -- Best regards... Ace --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] amavis-stats-0.1.19 - no data to graph in monthly and yearly
Ace Dahlmann wrote: Hello, I've installed the new version 0.1.19 of amavis-stats. In the monthly and yearly tabs I get: NO SPAM/HEADER DATA TO GRAPH NO VIRUS DATA TO GRAPH Is that normal with a fresh installed amavis-stats or went something wrong? I noticed that older versions of amavis-stats (like 0.1.12) did graph monthly and yearly immediately after installation, so I wonder if that changed. It appears so. The yearly appears only to get graphed at 1am and the monthly probably every other hour or so But i cannot comment on if those graphs should be greated upon the first run... But I'd prefer an empty graph over this message too.. especially now that not so many viruses are getting in an empty graph in the dailies would be appreciated instead of the message Matt --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] amavis-stats-0.1.19 - no data to graph in monthly and yearly
On Dec 12, 2005, at 08:44 , Matthias Keller wrote: Ace Dahlmann wrote: Hello, I've installed the new version 0.1.19 of amavis-stats. In the monthly and yearly tabs I get: NO SPAM/HEADER DATA TO GRAPH NO VIRUS DATA TO GRAPH Is that normal with a fresh installed amavis-stats or went something wrong? I noticed that older versions of amavis-stats (like 0.1.12) did graph monthly and yearly immediately after installation, so I wonder if that changed. It appears so. The yearly appears only to get graphed at 1am and the monthly probably every other hour or so But i cannot comment on if those graphs should be greated upon the first run... If you had a previous install of amavis-stats and graphing data was available then the new install will pick up hwere the old version left off provided that the localstatedir points to the same location. if the old install had the .rrd files in /var/lib/amavis-stats then the new should have been configured with '--localstatedir=/var' otherwise it has no previous data to graph from. But I'd prefer an empty graph over this message too.. especially now that not so many viruses are getting in an empty graph in the dailies would be appreciated instead of the message The problem is that with the newer versions of rrdtool, graphs are not generated if no data is available and would result in an image place-holder in the page with no image and an error in the httpd log that the image doesn't exist resulting in a 404 error. Matt --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/ --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Bayes - Learning Question
Gary V wrote: Gerry wrote: Also, not much spam is getting autolearned: su amavis -c 'sa-learn --dump magic' 0.000 0 3 0 non-token data: bayes db version 0.000 0 29 0 non-token data: nspam 0.000 0 1548 0 non-token data: nham Thanks Gary...I do not see ALL_TRUSTED in the headers. I ran a count on the amount of spam we've received in the last three days where the score is above 6 (default) and there are 850 messages. I have quarantine set to 12. SA msg read: 1 (0%)38, SA parse: 3 (1%)39, SA check: 80 (30%)70, This seems like a very short time for the SA check. I think the mail must score at 12 or above to be learned as spam (it's actually a little more complicated, but generally true). I find it hard to believe that you would have this paltry amount of spam that scores over 12. With the SA check time this low, it would lead me to believe you may not have network tests enabled. In amavisd.conf, make sure you have set: $sa_local_tests_only = 0; If you were to grep (or search) the items in your quarantine, would you find the string SPAMCOP ? If not, then I think network tests are not being performed. If you have not already done so, consider installing DCC, Razor and Pyzor. Gary V I turned on $sa_local_tests_only = 0 and I can now see SPAMCOP and various other tests increasing the scores quite a bit. SA Check times are now much higher and consuming 85-95%. In a day of this Bayes spam is up a bit to 223 nspam. from 35. I installed Pyzor, but a 'spamassassin -D --lint' give the following error, not sure what's going on here: [26906] dbg: pyzor: pyzor is available: /usr/bin/pyzor [26906] dbg: info: entering helper-app run mode [26906] dbg: pyzor: opening pipe: /usr/bin/pyzor check /tmp/.spamassassin26906MvF8NOtmp [26916] dbg: util: setuid: ruid=502 euid=502 [26906] dbg: pyzor: [26916] finished: exit=0x0100 [26906] dbg: pyzor: got response: Traceback (most recent call last):\n File /usr/bin/pyzor, line 4, in ?\npyzor.client.run()\n File /usr/lib/python2.4/site-packages/pyzor/client.py, line 934, in run\nExecCall().run()\n File /usr/lib/python2.4/site-packages/pyzor/client.py, line 169, in run\nos.mkdir(homedir)\nOSError: [Errno 20] Not a directory: '/dev/null/.pyzor' [26906] dbg: info: leaving helper-app run mode [26906] warn: pyzor: check failed: internal error Also, Can I use SA-Learn to feed it messages that are marked as SPAM because they hit sa_tag2_level but didn't hit the kill level, and/or were not autolearned by Bayes? Thanks...Gerry --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Bayes - Learning Question
Gerry wrote: I turned on $sa_local_tests_only = 0 and I can now see SPAMCOP and various other tests increasing the scores quite a bit. SA Check times are now much higher and consuming 85-95%. In a day of this Bayes spam is up a bit to 223 nspam. from 35. I installed Pyzor, but a 'spamassassin -D --lint' give the following error, not sure what's going on here: [26906] dbg: pyzor: got response: Traceback (most recent call last):\n File /usr/bin/pyzor, line 4, in ?\npyzor.client.run()\n File /usr/lib/python2.4/site-packages/pyzor/client.py, line 934, in run\nExecCall().run()\n File /usr/lib/python2.4/site-packages/pyzor/client.py, line 169, in run\nos.mkdir(homedir)\nOSError: [Errno 20] Not a directory: '/dev/null/.pyzor' [26906] dbg: info: leaving helper-app run mode [26906] warn: pyzor: check failed: internal error There are some patches out there. Maybe they will fix this for you. http://antispam.imp.ch/08-opensource.html?lng=0 (or) https://sourceforge.net/mailarchive/forum.php?thread_id=8422423forum_id=8711 Also, Can I use SA-Learn to feed it messages that are marked as SPAM because they hit sa_tag2_level but didn't hit the kill level, and/or were not autolearned by Bayes? Yes, in fact you probably should. Thanks...Gerry Gary V --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] unknown files passes virus check
Oliver, i'm new to amavis. There is one thing that i worry about the way amavis do the virus-checking: Why do amavis handle unknown filetypes (e.g. unknown archives, like SITX or so) as OK and letting them through ? I think this behaveiour is very insecure. It is as insecure as you configure it to be. Can i change this ? You can add a catchall rule to the end of the $banned_filename_re list to block everything else which isn't explicitly allowed by rules earlier in this list. (but you may not like the result) Mark --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] SQL Quarantine and tmp directory.
Rich, Is there a way to have amavisd-new 2.3.3 delete the message amavis-* file in the /tmp directory after it has been released from quarantine using the the AM.PDP interface? You mean deleting the quarantine files in /var/virusmails/... ? (temporary files in $TEMPBASE are being deleted automatically regardless of quarantining) I am trying to create a custom Quarantine management script with SQL. I have the SQL Quarantine setup and working fine and can see the entire message in the DB. I was thinking about just bypassing the AM.PDP interface completly and reinjecting the message stored in the DB directly to Postfix on port 10025. You can do that. It would require duplicating much of the code that is already present in amavisd (handling SQL chunks, SMTP client code, removing auxiliary header fields ...), but is certainly doable. But this would still leave the /tmp directory files. No it won't. See http://www.ijs.si/software/amavisd/#faq-gen perhaps you have a misunderstanding what /var/amavis/tmp is for. Is any body see this as a problem, or am I thinking to much into this and shouldn't worry too much about the /tmp directory and just run a script to kill things that are 30 days? There shouldn't be much in $TEMPBASE. If you see a non-negligible amount of leftover files there, there must be a good reason for this and you should check your logs and fix the problem. Check also if amavisd-nanny reports any processes that 'went away'. I usually run amavisd-nanny once or twice a week just to make sure there were no surprises in previous days. Mark --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Errors in the log
Jim, I use mysql 4.0.24 and phpMyAdmin told me by creating (for example): CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, priority integer NOT NULL DEFAULT '7', policy_id integer unsigned NOT NULL DEFAULT '1', email varchar(255) NOT NULL, fullname varchar(255) DEFAULT NULL, local char(1), KEY email (email) ); CREATE UNIQUE INDEX users_idx_email ON users (email); --snap UNIQUE and INDEX keys should not both be set for column `email` And now I`ve creating the table without the last column (CREATE UNIQUE INDEX users_idx_email ON users (email);). And all work fine. AND - I`ve tuning mysql in my.cnf. ;) That's fine. Use either KEY in the CREATE TABLE, or CREATE ...INDEX, but not both. Mark --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Errors in the log
Heute (13.12.2005/02:09 Uhr) schrieb Mark Martinec ([EMAIL PROTECTED]), Jim, I use mysql 4.0.24 and phpMyAdmin told me by creating (for example): CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, priority integer NOT NULL DEFAULT '7', policy_id integer unsigned NOT NULL DEFAULT '1', email varchar(255) NOT NULL, fullname varchar(255) DEFAULT NULL, local char(1), KEY email (email) ); CREATE UNIQUE INDEX users_idx_email ON users (email); --snap UNIQUE and INDEX keys should not both be set for column `email` And now I`ve creating the table without the last column (CREATE UNIQUE INDEX users_idx_email ON users (email);). And all work fine. AND - I`ve tuning mysql in my.cnf. ;) That's fine. Use either KEY in the CREATE TABLE, or CREATE ...INDEX, but not both. then it`s wrong in the README!? ;) Or how can I understand this? Mark -- Viele Grüße, Kind regards, Jim Knuth [EMAIL PROTECTED] ICQ #277289867 - VoIP: +49 (0) 322 212 044 67 Key ID: 0x1F78066F -- Zufalls-Zitat -- Aus Liebe zu dir hab ich auf MICH verzichtet, es wäre besser gewesen, ich hätte aus Liebe zu mir auf DICH verzichtet. -- Der Text hat nichts mit dem Empfänger der Mail zu tun -- Virus free. Checked by NOD32 Version 1.1320 Build 6438 12.12.2005 --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Errors in the log
Jim, That's fine. Use either KEY in the CREATE TABLE, or CREATE ...INDEX, but not both. then it`s wrong in the README!? ;) Or how can I understand this? Fixed on the version on the web: http://www.ijs.si/software/amavisd/README.sql.txt Mark --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] bypass scanning outgoing mail
Thanks Erik for the suggesion. If I understand correctly, you're
suggesting this as an alternative to what Gary V said.
I'm not using sasl, so I guess that would make it a little bit easier still.
Mike
Erik Petersen wrote:
Setup port 587 for this (aka submission) in master.cf:
smtpinet n - n - - smtpd
-o content_filter=amavis:[127.0.0.1]:10024
-o receive_override_options=no_address_mappings
-o smtpd_client_restrictions=cidr:/etc/postfix/client.cidr
submission inet n - n - - smtpd
-o content_filter=
-o smtpd_etrn_restrictions=reject
-o
smtpd_client_restrictions=permit_sasl_authenticated,permit_mynetworks,reject
-o smtpd_sasl_auth_enable=yes
This way you have port 25 which does local SMTP delivery with RBL checks and
filtering (incoming) and port 587 which does no filtering but only from
clients connection with SASL or those defined as local network hosts
(outgoing). Consider 587 your relay port. This also conveniently bypasses
SMTP port blocking by residential ISPs or corporate firewalls, allowing
authorized accounts to relay from anywhere. Splitting these two type of
traffic is not a bad idea.
HTH
On 12/11/05 9:49 PM, M. Lewis [EMAIL PROTECTED] wrote:
In the last few days, someone had written in and asked how to do this. I
believe the answer was from Gary. Gary gave two options for doing this.
I chose to do the latter of his two options. But it isn't working for
some reason.
The original thread is here:
http://marc.theaimsgroup.com/?l=amavis-userm=113415019700881w=2
I am getting this in the maillog when I try the second method:
Dec 12 00:40:57 moe postfix/smtpd[23856]: warning: access table
hash:/etc/postfix/amavis_internal: with smtpd_proxy_filter specified,
action FILTER is unavailable
Gary's second suggestion was this:
Another way is more specific:
smtpd_recipient_restrictions =
check_client_access hash:/etc/postfix/amavis_internal
permit_mynetworks
reject_unauth_destination
contents of /etc/postfix/amavis_internal
(ip address of the internal server is listed here):
192.168.1.17 FILTER smtp-amavis:[127.0.0.1]:10026
Then in amavisd.conf:
$inet_socket_port = [10024, 10026];
$interface_policy{'10026'} = 'INTERNAL';
$policy_bank{'INTERNAL'} = { # mail originating from the internal server
bypass_spam_checks_maps = [1], # don't spam-check outgoing mail
bypass_banned_checks_maps = [1], # don't banned-check outgoing mail
final_spam_destiny = D_PASS, # insure spam passes
final_banned_destiny = D_PASS, # insure banned files pass
};
--
IBM: Idiots Being Mental
21:05:01 up 4:14, 3 users, load average: 0.09, 0.10, 0.04
Linux Registered User #241685 http://counter.li.org
---
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click
___
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Errors in the log
Heute (13.12.2005/02:56 Uhr) schrieb Mark Martinec ([EMAIL PROTECTED]), Jim, That's fine. Use either KEY in the CREATE TABLE, or CREATE ...INDEX, but not both. then it`s wrong in the README!? ;) Or how can I understand this? Fixed on the version on the web: http://www.ijs.si/software/amavisd/README.sql.txt Mark :) thank you. -- Viele Grüße, Kind regards, Jim Knuth [EMAIL PROTECTED] ICQ #277289867 - VoIP: +49 (0) 322 212 044 67 Key ID: 0x1F78066F -- Zufalls-Zitat -- Alles, was du bist, alles was ich für dich aufbringe, rechtfertigt meine Liebe und nichts, nicht einmal du selbst, könnte mich davon abhalten dich anzubeten. (Marquis de Lafayette) -- Der Text hat nichts mit dem Empfänger der Mail zu tun -- Virus free. Checked by NOD32 Version 1.1320 Build 6438 12.12.2005 --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Errors in the log
Jim wrote: Heute (13.12.2005/02:09 Uhr) schrieb Mark Martinec ([EMAIL PROTECTED]), Jim, I use mysql 4.0.24 and phpMyAdmin told me by creating (for example): CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, priority integer NOT NULL DEFAULT '7', policy_id integer unsigned NOT NULL DEFAULT '1', email varchar(255) NOT NULL, fullname varchar(255) DEFAULT NULL, local char(1), KEY email (email) ); CREATE UNIQUE INDEX users_idx_email ON users (email); --snap UNIQUE and INDEX keys should not both be set for column `email` And now I`ve creating the table without the last column (CREATE UNIQUE INDEX users_idx_email ON users (email);). And all work fine. AND - I`ve tuning mysql in my.cnf. ;) That's fine. Use either KEY in the CREATE TABLE, or CREATE ...INDEX, but not both. then it`s wrong in the README!? ;) Or how can I understand this? Mark Using what you have now on the three I tried: users, mailaddr, policy I get from phpmyadmin: Indexes: Keyname Type Cardinality Field PRIMARY PRIMARY 0id id UNIQUE0id users_idx_email INDEX None email PRIMARY and INDEX keys should not both be set for column `id` Using SERIAL PRIMARY KEY appears to have created a new problem. It looks like it creates two indexes. Reverting back to: INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY solves the newly introduced problem, at least I think it does, as now I get: Indexes: Keyname Type Cardinality Field PRIMARY PRIMARY 0 id users_idx_email INDEXNoneemail I am not an SQL person, but I assume this is more desirable than the former. Gary V --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637alloc_id=16865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
Re: [AMaViS-user] Errors in the log
Heute (13.12.2005/05:49 Uhr) schrieb Gary V ([EMAIL PROTECTED]), Using what you have now on the three I tried: users, mailaddr, policy and maddr, msgrcpt, msgs, wblist Using SERIAL PRIMARY KEY appears to have created a new problem. no no. I`ve no set SERIAL PRIMARY KEY. I`ve set INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY It looks like it creates two indexes. Reverting back to: INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY yes. That`s what I`ve done. Thank you. It`s all alright. I am not an SQL person, I`m too, but now all working fine. SA and amavis-new via MySQL. ;) Gary V -- Viele Grüße, Kind regards, Jim Knuth [EMAIL PROTECTED] ICQ #277289867 - VoIP: +49 (0) 322 212 044 67 Key ID: 0x1F78066F -- Zufalls-Zitat -- Ich denke, daß es einen Weltmarkt für vielleicht fünf Computer gibt. (Thomas Watson, Vorsitzender von IBM, 1943) -- Der Text hat nichts mit dem Empfänger der Mail zu tun -- Virus free. Checked by NOD32 Version 1.1320 Build 6438 12.12.2005 --- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37alloc_id865op=click ___ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
