Installing PostFix error ERROR 1005

[vikhyat]

I am trying to install Sentora on centos-7-x86_64-minimal but I am getting this error due to which mail server doesn't work ERROR 1005 (HY000) at line 98: Can't create table 'sentora_postfix.vacation_notification' (errno: 150)

[vikhyat]

Update: mail server is working after restarting but still I want to know how to fix this error

[TGates]

In phpmyadmin make sure sentora_postfix.vacation_notification table exists, if not add it:

Code:

CREATE TABLE `vacation_notification` (
`on_vacation` varchar(255) NOT NULL,
`notified` varchar(255) CHARACTER SET latin1 NOT NULL,
`notified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`on_vacation`,`notified`),
CONSTRAINT `vacation_notification_pkey` FOREIGN KEY (`on_vacation`) REFERENCES `vacation` (`email`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix Admin - Virtual Vacation Notifications';