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:
>>>>> 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 table partitioning.
>>>>>
>>>>> Please try it out, the final release is due by the end of the week.
>>>>>
>>>>>
>>>>>
>>>> Hi Mark,
>>>>
>>>> Please check this message i sent last week, regarding an error with
>>>> readme.sql-mysql file.
>>>>
>>>> http://marc.info/?l=amavis-user&m=121382542701631&w=2
>>>>
>>>> It's still unfixed on 2.6.1rc1.
>>>>
>>>>
>>>>
>>> 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 'amavisd.msgs' doesn't exist
>>> ERROR 1146 (42S02): Table 'amavisd.msgs' doesn't exist
>>> ERROR 1146 (42S02): Table 'amavisd.msgs' doesn't exist
>>> ERROR 1005 (HY000): Can't create table './amavisd/msgrcpt.frm' (errno: 150)
>>> ERROR 1146 (42S02): Table 'amavisd.msgrcpt' doesn't exist
>>> ERROR 1146 (42S02): Table 'amavisd.msgrcpt' doesn't exist
>>> ERROR 1005 (HY000): Can't create table './amavisd/quarantine.frm'
>>> (errno: 150)
>>>
>>> I use RHEL 5.2, x86_64.
>>>
>>> mysql-server-5.0.45-7.el5
>>> mysql-5.0.45-7.el5
>>>
>>>
>>>
>> Check if InnoDB is enabled.
>> mysql> SHOW ENGINES;
>> +------------+---------+----------------------------------------------------------------+
>> | Engine | Support | Comment
>> |
>> +------------+---------+----------------------------------------------------------------+
>> | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
>> performance |
>> | MEMORY | YES | Hash based, stored in memory, useful for temporary
>> tables |
>> | InnoDB | YES | Supports transactions, row-level locking, and
>> foreign keys |
>>
>> Check the status of InnoDB
>> mysql>SHOW ENGINE INNODB STATUS;
>>
>>
>>
>> /Max
>
> Hi, Max.
>
> Thanks for your quick reply.
>
> It seems InnoDB is enabled:
>
> mysql> SHOW ENGINES;
>
> | InnoDB | YES | Supports transactions, row-level locking, and
> foreign keys |
>
> mysql> SHOW ENGINE INNODB STATUS;
> many info here.
>
Create table msgs before quarantine..
If I try to create quarantine before msgs I get ERROR 1005 (HY000)....
mysql> CREATE TABLE quarantine (
-> mail_id varchar(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
octets
-> PRIMARY KEY (mail_id,chunk_ind),
-> 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 (
^^^^
-> mail_id varchar(12) NOT NULL PRIMARY KEY, -- long-term unique
mail id
-> secret_id varchar(12) DEFAULT '', -- authorizes release of mail_id
-> am_id varchar(20) NOT NULL, -- id used in the log
-> time_num integer unsigned NOT NULL, -- rx_time: seconds since Unix
epoch
-> time_iso char(16) NOT NULL, -- rx_time: ISO8601 UTC ascii
time
-> sid integer unsigned NOT NULL, -- sender: maddr.id
-> policy varchar(255) DEFAULT '', -- policy bank path (like macro
%p)
-> client_addr varchar(255) DEFAULT '', -- SMTP client IP address (IPv4
or v6)
-> size integer unsigned NOT NULL, -- message size in bytes
-> content char(1), -- content type:
V/B/S/s/M/H/O/C:
-> --
virus/banned/spam(kill)/spammy(tag2)
-> -- /bad mime/bad
header/oversized/clean
-> -- is NULL on partially
processed mail
-> quar_type char(1), -- quarantined as: '
'/F/Z/B/Q/M/L
-> -- none/file/zipfile/bsmtp/sql/
-> -- /mailbox(smtp)/mailbox(lmtp)
-> quar_loc varchar(255) DEFAULT '', -- quarantine location (e.g.
file)
-> dsn_sent char(1), -- was DSN sent? Y/N/q
(q=quenched)
-> spam_level float, -- SA spam level (no boosts)
-> message_id varchar(255) DEFAULT '', -- mail Message-ID header field
-> from_addr varchar(255) DEFAULT '', -- mail From header field,
UTF8
-> subject varchar(255) DEFAULT '', -- mail Subject header field,
UTF8
-> host varchar(255) NOT NULL, -- hostname where amavisd is
running
-> FOREIGN KEY (sid) REFERENCES maddr(id) ON DELETE RESTRICT
-> ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.03 sec)
mysql> CREATE TABLE quarantine (
-> mail_id varchar(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
octets
-> PRIMARY KEY (mail_id,chunk_ind),
-> FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE
-> ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.03 sec)
/Max
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
