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 ------------------------------------------------------------------------- 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/
