Re: [AMaViS-user] amavisd-new 2.6.1

2009-03-30 Thread John
troxlinux xserverli...@gmail.com schreef in bericht news:a2c6daca0903271121m6c44ca12g8e2fefb37630f...@mail.gmail.com... 2009/3/25 John jknappers-argen...@hotmail.com: Hi, Troxlinux, The problem is that you mix packages from different repositories or origin. You use clamav-0.94.2-1.el5.rf

Re: [AMaViS-user] amavisd-new 2.6.1

2009-03-27 Thread troxlinux
2009/3/25 John jknappers-argen...@hotmail.com: Hi, Troxlinux, The problem is that you mix packages from different repositories or origin. You use clamav-0.94.2-1.el5.rf from Rpmforge (did you also install clamd-0.94.2-1.el5.rf? ), but rebuild amavisd-new from FC9. Amavisd-new from FC9

Re: [AMaViS-user] amavisd-new 2.6.1

2009-03-25 Thread John
troxlinux xserverli...@gmail.com schreef in bericht news:a2c6daca0903181149p76484adbgfdcf4c9eeaa1f...@mail.gmail.com... Hi list , I am trying to install amavisd-new 2.6.1 in a centos 5.2, but it shows me this error: error: Failed dependencies: /etc/clamd.d is needed by

Re: [AMaViS-user] amavisd-new 2.6.1

2009-03-23 Thread Nuno Fernandes
On Wednesday 18 March 2009 18:49:37 troxlinux wrote: Hi list , I am trying to install amavisd-new 2.6.1 in a centos 5.2, but it shows me this error: error: Failed dependencies: /etc/clamd.d is needed by amavisd-new-2.6.1-1.noarch I have installed clamav-0.94.2-1.el5.rf some

Re: [AMaViS-user] amavisd-new 2.6.1

2009-03-23 Thread troxlinux
2009/3/23 Nuno Fernandes npf-mli...@eurotux.com: Do you have clamd-0.94.2-1.el5.rf installed? yes have it installed Nevertheless, clamd doesn't have /etc/clam.d. For what it's seems your amavisd-new rpm has wrong dependencies. ok Where did you find it?

[AMaViS-user] amavisd-new 2.6.1

2009-03-18 Thread troxlinux
Hi list , I am trying to install amavisd-new 2.6.1 in a centos 5.2, but it shows me this error: error: Failed dependencies: /etc/clamd.d is needed by amavisd-new-2.6.1-1.noarch I have installed clamav-0.94.2-1.el5.rf some idea? -- rickygm http://gnuforever.homelinux.com

[AMaViS-user] amavisd-new 2.6.1 - stale PID file older than system uptime

2008-09-25 Thread Eddy Beliveau
Hi! I'm using amavisd-new 2.6.1 and it's working pretty well. On RedHat, when doing # service amavisd stop, the following error message appears in my logs and amavisd-new refuse to stop amavis[11902]: Ignoring stale PID file /var/amavis/amavisd.pid, older than system uptime 2 19:27:00

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-27 Thread Mark Martinec
Thomas, I'm running 2.6.0 with most of the mentioned patches in production since a while, no issues right now. The small cluster is currently hit by peaks of nearly 6 million delivery attempts a day. Most of them fortunately do NOT hit Amavis, but there are still a few million mails in

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CA NDIDATE is available

2008-06-27 Thread Mark Martinec
Zhang Huangbin, I tryed to import SQL from README.sql-mysql(amavisd-new-2.6.1-rc1), but failed too. Seperate SQL from README.sql-mysql, and 'SOURCE' it from mysql command line: ERROR 1005 (HY000): Can't create table './amavisd/msgs.frm' (errno: 150) ERROR 1146 (42S02): Table

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-27 Thread Zhang Huangbin
Mark Martinec wrote: As reported by Leonardo Rodrigues, there is a mismatch on data types on foreign keys, which is why a table msgs (and subsequent ones) can not be built, because msgs.sid is referencing maddr.id of a different type. Please try the schema in:

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-26 Thread Michael Scheidell
5 rows in set (0.00 sec) mysql CREATE TABLE quarantine ( - mail_idvarchar(12) NOT NULL,-- long-term unique mail id - chunk_ind integer unsigned NOT NULL, -- chunk number, starting with 1 - mail_text blob NOT NULL, -- store mail as chunks of

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-26 Thread Benny Pedersen
On Thu, June 26, 2008 14:20, Michael Scheidell wrote: ERROR 1005 (HY000): Can't create table './amavisd/quarantine.frm' (errno: 150) It looks like you did not build innodb support into mysql, and/or did not read and edit the my.cnf to enable the innodb values. i have seen this error # with

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Max Matslofva
Hi Zhang Huangbin skrev: Leonardo Rodrigues Magalhães wrote: Mark Martinec escreveu: A release candidate of amavisd-new-2.6.1 is available at: http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz Release notes: http://www.ijs.si/software/amavisd/release-notes.txt The

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Zhang Huangbin
Max Matslofva wrote: Hi Zhang Huangbin skrev: Leonardo Rodrigues Magalhães wrote: Mark Martinec escreveu: A release candidate of amavisd-new-2.6.1 is available at: http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz Release notes:

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Max Matslofva
Zhang Huangbin skrev: Max Matslofva wrote: Hi Zhang Huangbin skrev: Leonardo Rodrigues Magalhães wrote: Mark Martinec escreveu: A release candidate of amavisd-new-2.6.1 is available at: http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz Release notes:

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Zhang Huangbin
Max Matslofva wrote: Zhang Huangbin skrev: Max Matslofva wrote: Hi Zhang Huangbin skrev: Leonardo Rodrigues Magalhães wrote: Mark Martinec escreveu: A release candidate of amavisd-new-2.6.1 is available at:

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Max Matslofva
Zhang Huangbin skrev: Hi, Max. I deleted all 'ENGINE=InnoDB' in README.sql-mysql and use 'SOURCE' to import it, it works. What's wrong with it? Am i missing something? Test if you can create anything using InnoDB mysql CREATE TABLE noInnoDB ( test varchar(10)) ENGINE=MyISAM; Query OK,

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Thomas Gelf
Max Matslofva schrieb: mysql CREATE TABLE quarantine ( - ... - FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE - ) ENGINE=InnoDB; ERROR 1005 (HY000): Can't create table './maxtest/quarantine.frm' (errno: 150) mysql CREATE TABLE msgs ( - ...

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Max Matslofva
Thomas Gelf skrev: Max Matslofva schrieb: mysql CREATE TABLE quarantine ( - ... - FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE - ) ENGINE=InnoDB; ERROR 1005 (HY000): Can't create table './maxtest/quarantine.frm' (errno: 150) mysql CREATE TABLE msgs

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Zhang Huangbin
Max Matslofva wrote: Zhang Huangbin skrev: Hi, Max. I deleted all 'ENGINE=InnoDB' in README.sql-mysql and use 'SOURCE' to import it, it works. What's wrong with it? Am i missing something? Test if you can create anything using InnoDB mysql CREATE TABLE noInnoDB ( test

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Max Matslofva
Zhang Huangbin skrev: Hi, Max. They all worked :( mysql CREATE TABLE noInnoDB ( test varchar(10)) ENGINE=MyISAM; Query OK, 0 rows affected (0.08 sec) mysql drop table noInnoDB; Query OK, 0 rows affected (0.00 sec) mysql CREATE TABLE testInnoDB ( test varchar(10)) ENGINE=InnoDB;

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-25 Thread Zhang Huangbin
Max Matslofva wrote: Hi Zhang Can you send the output from mysql show tables; and mysql CREATE TABLE quarantine ( mail_idvarchar(12) NOT NULL,-- long-term unique mail id chunk_ind integer unsigned NOT NULL, -- chunk number, starting with 1 mail_text blob NOT NULL,

[AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-24 Thread Mark Martinec
A release candidate of amavisd-new-2.6.1 is available at: http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz Release notes: http://www.ijs.si/software/amavisd/release-notes.txt The 2.6.1 is a maintenance release, fixing known problems over 2.6.0 and meeting needs for MySQL

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-24 Thread Leonardo Rodrigues Magalhães
Mark Martinec escreveu: A release candidate of amavisd-new-2.6.1 is available at: http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz Release notes: http://www.ijs.si/software/amavisd/release-notes.txt The 2.6.1 is a maintenance release, fixing known problems over 2.6.0

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-24 Thread Thomas Gelf
Leonardo, I must confess that I didn't read your message really careful. And as I'm using a partitioned db scheme since a little while your statement doesn't directly meet my scenario. Foreign keys are no longer required in a partitioned setup - you are even unable to use them (this is true at

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-24 Thread Thomas Gelf
As we are talking about better default db schemas here some other suggestions: In current MySQL releases the following statements are true when using CHAR datatypes: v = V BINARY(v) != BINARY(V) As functions usually make all SQL searches on indexed fields slower I decided to use

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-24 Thread Thomas Gelf
Mark Martinec schrieb: A release candidate of amavisd-new-2.6.1 is available at: ... The 2.6.1 is a maintenance release, fixing known problems over 2.6.0 and meeting needs for MySQL table partitioning. Please try it out, the final release is due by the end of the week. I'm running 2.6.0

Re: [AMaViS-user] amavisd-new-2.6.1-rc1 RELEASE CANDIDATE is available

2008-06-24 Thread Zhang Huangbin
Leonardo Rodrigues Magalhães wrote: Mark Martinec escreveu: A release candidate of amavisd-new-2.6.1 is available at: http://www.ijs.si/software/amavisd/amavisd-new-2.6.1-rc1.tar.gz Release notes: http://www.ijs.si/software/amavisd/release-notes.txt The 2.6.1 is a maintenance