This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

1.0.2 1.0.3 postfix fix not work
#1
1.0.2 1.0.3 postfix fix not work
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
Reply
Thanks given by:
#2
RE: 1.0.2 1.0.3 postfix fix not work
(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
#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
Reply
Thanks given by:
#3
RE: 1.0.2 1.0.3 postfix fix not work
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
Reply
Thanks given by:
#4
RE: 1.0.2 1.0.3 postfix fix not work
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';
Reply
Thanks given by:
#5
RE: 1.0.2 1.0.3 postfix fix not work
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"
Reply
Thanks given by:
#6
RE: 1.0.2 1.0.3 postfix fix not work
(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
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';
Reply
Thanks given by:
#7
RE: 1.0.2 1.0.3 postfix fix not work
ok solve

just

Code:
sql-mode="NO_ENGINE_SUBSTITUTION"

work
Reply
Thanks given by:
#8
RE: 1.0.2 1.0.3 postfix fix not work
(06-12-2021, 07:06 AM)andykimpe Wrote: ok solve

just

Code:
sql-mode="NO_ENGINE_SUBSTITUTION"

work

glad to hear
Reply
Thanks given by:
#9
RE: 1.0.2 1.0.3 postfix fix not work
but postfix and always off

the service is active but the port is not responding
Reply
Thanks given by:
#10
RE: 1.0.2 1.0.3 postfix fix not work
(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 ?
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
Postfix relay specific domains to mailjet johnnyp 0 2 ,003 01-29-2021, 04:44 AM
Last Post: johnnyp
Webalizer Stats not work - how to fix it ? domyhost 2 5 ,637 04-28-2020, 05:14 PM
Last Post: domyhost
I changed date and time from server and sentora does not work gabriel15959 1 4 ,553 03-20-2019, 11:52 PM
Last Post: fearworks

Forum Jump:


Users browsing this thread: 1 Guest(s)