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: >>>>>> >>>>>> 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 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? -- Best Regards. Zhang Huangbin - Mail Server Solution for Red Hat(R) Enterprise Linux & CentOS 5.x: http://rhms.googlecode.com/ ------------------------------------------------------------------------- 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/
