Posts: 45
Threads: 5
Joined: Dec 2014
Reputation:
0
Sex: Male
Thanks: 0
Given 3 thank(s) in 3 post(s)
1.0.2 1.0.3 postfix fix not work
06-12-2021, 05:37 AM
(This post was last modified: 06-12-2021, 05:40 AM by 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
Posts: 109
Threads: 14
Joined: Aug 2015
Reputation:
8
Sex: Male
Thanks: 3
Given 15 thank(s) in 12 post(s)
RE: 1.0.2 1.0.3 postfix fix not work
06-12-2021, 06:35 AM
(This post was last modified: 06-12-2021, 08:10 AM by ccr1969.)
(06-12-2021, 05:37 AM)andykimpe Wrote: 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
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
Posts: 45
Threads: 5
Joined: Dec 2014
Reputation:
0
Sex: Male
Thanks: 0
Given 3 thank(s) in 3 post(s)
RE: 1.0.2 1.0.3 postfix fix not work
06-12-2021, 06:41 AM
(This post was last modified: 06-12-2021, 06:50 AM by 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
Posts: 109
Threads: 14
Joined: Aug 2015
Reputation:
8
Sex: Male
Thanks: 3
Given 15 thank(s) in 12 post(s)
RE: 1.0.2 1.0.3 postfix fix not work
06-12-2021, 06:47 AM
(This post was last modified: 06-12-2021, 08:12 AM by 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';
Posts: 45
Threads: 5
Joined: Dec 2014
Reputation:
0
Sex: Male
Thanks: 0
Given 3 thank(s) in 3 post(s)
RE: 1.0.2 1.0.3 postfix fix not work
06-12-2021, 06:59 AM
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"
Posts: 109
Threads: 14
Joined: Aug 2015
Reputation:
8
Sex: Male
Thanks: 3
Given 15 thank(s) in 12 post(s)
RE: 1.0.2 1.0.3 postfix fix not work
06-12-2021, 07:01 AM
(This post was last modified: 06-12-2021, 07:03 AM by ccr1969.)
(06-12-2021, 06:59 AM)andykimpe Wrote: 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
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';
Posts: 45
Threads: 5
Joined: Dec 2014
Reputation:
0
Sex: Male
Thanks: 0
Given 3 thank(s) in 3 post(s)
RE: 1.0.2 1.0.3 postfix fix not work
06-12-2021, 07:06 AM
ok solve
just
Code: sql-mode="NO_ENGINE_SUBSTITUTION"
work
Posts: 109
Threads: 14
Joined: Aug 2015
Reputation:
8
Sex: Male
Thanks: 3
Given 15 thank(s) in 12 post(s)
RE: 1.0.2 1.0.3 postfix fix not work
06-12-2021, 07:07 AM
(06-12-2021, 07:06 AM)andykimpe Wrote: ok solve
just
Code: sql-mode="NO_ENGINE_SUBSTITUTION"
work
glad to hear
Posts: 45
Threads: 5
Joined: Dec 2014
Reputation:
0
Sex: Male
Thanks: 0
Given 3 thank(s) in 3 post(s)
RE: 1.0.2 1.0.3 postfix fix not work
06-12-2021, 07:08 AM
(This post was last modified: 06-12-2021, 07:09 AM by andykimpe.)
but postfix and always off
the service is active but the port is not responding
Posts: 109
Threads: 14
Joined: Aug 2015
Reputation:
8
Sex: Male
Thanks: 3
Given 15 thank(s) in 12 post(s)
RE: 1.0.2 1.0.3 postfix fix not work
06-12-2021, 07:12 AM
(06-12-2021, 07:08 AM)andykimpe Wrote: but postfix and always off
the service is active but the port is not responding is the port open ?
|