1.0.2 1.0.3 postfix fix not work

[andykimpe]

1.0.2 1.0.3 postfix fix not work

Code:

USE `sentora_postfix`; CREATE TABLE IF NOT EXISTS `vacation` (  `email` varchar(255) NOT NULL,  `subject` varchar(255) CHARACTER SET utf8 NOT NULL,  `body` text CHARACTER SET utf8 NOT NULL,  `cache` text NOT NULL,  `domain` varchar(255) NOT NULL,  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',  `active` tinyint(1) NOT NULL DEFAULT '1',  PRIMARY KEY (`email`),  KEY `email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix - Virtual Vacation/ autoresponder'; CREATE TABLE IF NOT EXISTS `vacation_notification` (  `on_vacation` varchar(255) CHARACTER SET utf8 NOT NULL,  `notified` varchar(255) CHARACTER SET utf8 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 - Virtual Vacation Notifications LOG'; /* Update Sentora Version */ USE `sentora_core`; /* Update the sentora database version number */ UPDATE `x_settings` SET `so_value_tx` = '1.0.3' WHERE `so_name_vc` = 'dbversion';

sql error return
for vacation table

Code:

# 1067 - Invalid default value for 'created'

for vacation_notification table

Code:

# 1215 - Cannot add foreign key constraint

mysql server version 5.7.34

would someone have a solution because without it is postfix table does not work

[ccr1969]

1.0.2 1.0.3 postfix fix not work

Code:

USE `sentora_postfix`; CREATE TABLE IF NOT EXISTS `vacation` (  `email` varchar(255) NOT NULL,  `subject` varchar(255) CHARACTER SET utf8 NOT NULL,  `body` text CHARACTER SET utf8 NOT NULL,  `cache` text NOT NULL,  `domain` varchar(255) NOT NULL,  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',  `active` tinyint(1) NOT NULL DEFAULT '1',  PRIMARY KEY (`email`),  KEY `email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix - Virtual Vacation/ autoresponder'; CREATE TABLE IF NOT EXISTS `vacation_notification` (  `on_vacation` varchar(255) CHARACTER SET utf8 NOT NULL,  `notified` varchar(255) CHARACTER SET utf8 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 - Virtual Vacation Notifications LOG'; /* Update Sentora Version */ USE `sentora_core`; /* Update the sentora database version number */ UPDATE `x_settings` SET `so_value_tx` = '1.0.3' WHERE `so_name_vc` = 'dbversion';

sql error return
for vacation table

Code:

# 1067 - Invalid default value for 'created'

for vacation_notification table

Code:

# 1215 - Cannot add foreign key constraint

mysql server version 5.7.34

would someone have a solution because without it is postfix table does not work

try change this
/etc/mysql/my.cnf
#set the complete "forgiving" mode
sql-mode = ""
# alternatively you can set sql mode to the following
#sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"

restart mysql

[andykimpe]

this line does not exist I added them but it doesn't change anything

the worst is who will only have 2 sites, 2 domains and 2 mailboxes on this server

[ccr1969]

run this cmd line i just changed a cmd line should solve problem

Code:

USE `sentora_postfix`; CREATE TABLE IF NOT EXISTS `vacation` ( `email` varchar(255) NOT NULL, `subject` varchar(255) CHARACTER SET utf8 NOT NULL, `body` text CHARACTER SET utf8 NOT NULL, `cache` text NOT NULL, `domain` varchar(255) NOT NULL, `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `active` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`email`), KEY `email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix - Virtual Vacation/ autoresponder'; CREATE TABLE IF NOT EXISTS `vacation_notification` ( `on_vacation` varchar(255) CHARACTER SET utf8 NOT NULL, `notified` varchar(255) CHARACTER SET utf8 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 - Virtual Vacation Notifications LOG'; /* Update Sentora Version */ USE `sentora_core`; /* Update the sentora database version number */ UPDATE `x_settings` SET `so_value_tx` = '1.0.3' WHERE `so_name_vc` = 'dbversion';

[andykimpe]

my.ini it's under windows only

for linux my.cnf

/etc/mysql/my.cnf

Code:

!includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/

/etc/mysql/conf.d/mysql.cnf

Code:

[mysql] sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"

/etc/mysql/mysql.conf.d/mysqld.cnf

Code:

[mysqld] pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock datadir = /var/lib/mysql log-error = /var/log/mysql/error.log # By default we only accept connections from localhost bind-address = 127.0.0.1 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"

[ccr1969]

my.ini it's under windows only

for linux my.cnf

/etc/mysql/my.cnf

Code:

!includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/

/etc/mysql/conf.d/mysql.cnf

Code:

[mysql] sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"

/etc/mysql/mysql.conf.d/mysqld.cnf

Code:

[mysqld] pid-file        = /var/run/mysqld/mysqld.pid socket          = /var/run/mysqld/mysqld.sock datadir         = /var/lib/mysql log-error       = /var/log/mysql/error.log # By default we only accept connections from localhost bind-address    = 127.0.0.1 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"

Code:

sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"

that to this

Code:

sql-mode = ""

---

or try run updated cmd

USE `sentora_postfix`;

CREATE TABLE IF NOT EXISTS `vacation` (
`email` varchar(255) NOT NULL,
`subject` varchar(255) CHARACTER SET utf8 NOT NULL,
`body` text CHARACTER SET utf8 NOT NULL,
`cache` text NOT NULL,
`domain` varchar(255) NOT NULL,
`created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`active` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`email`),
KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix - Virtual Vacation/ autoresponder';

CREATE TABLE IF NOT EXISTS `vacation_notification` (
`on_vacation` varchar(255) CHARACTER SET utf8 NOT NULL,
`notified` varchar(255) CHARACTER SET utf8 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 - Virtual Vacation Notifications LOG';

/* Update Sentora Version */
USE `sentora_core`;

/* Update the sentora database version number */
UPDATE `x_settings` SET `so_value_tx` = '1.0.3' WHERE `so_name_vc` = 'dbversion';

[andykimpe]

ok solve

just

Code:

sql-mode="NO_ENGINE_SUBSTITUTION"

work

[ccr1969]

ok solve

just

Code:

sql-mode="NO_ENGINE_SUBSTITUTION"

work

glad to hear

[andykimpe]

but postfix and always off

the service is active but the port is not responding

[ccr1969]

but postfix and always off

the service is active but the port is not responding

is the port open ?