Installer 1.0.1 on CentOS7

[Me.B]

Nadal will win

[saharmohamedali]

Dear Me.B,

I manage to find the problem (you probably too).
sentora_postfix.sql
this database structure script is executed till 115 line which is "CREATE TABLE 'quota' (" anything after that table including that table aint created so probably postfix is broken.

Probably because usernamer is VarChar255 and Path is 100; the primary key is on both so:
255 * 3 + 100 * 3 = 1065 which is more than 1000;

[turino]

Hi,

You can try with this method until updated...

1. Download sentora auto install and preconfig file

Code:

wget https://raw.githubusercontent.com/sentora/sentora-installers/master/sentora_install.sh wget -nv -O sentora_preconfig.zip https://github.com/sentora/sentora-installers/archive/1.0.0.zip

2. Extract sentora_preconfig.zip
3. Edit sentora-installers-1.0.0/preconf/sentora-install/sql/sentora_postfix.sql change this code

Code:

CREATE TABLE `quota` (  `username` varchar(255) NOT NULL,  `path` varchar(100) NOT NULL,  `current` bigint(20) DEFAULT NULL,  PRIMARY KEY (`username`,`path`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

With the new code

Code:

CREATE TABLE `quota` (  `username` varchar(255) NOT NULL,  `path` varchar(100) NOT NULL,  `current` bigint(20) DEFAULT NULL,  PRIMARY KEY (`username`,`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Also this sql code

Code:

CREATE TABLE `vacation_notification` (  `on_vacation` varchar(255) CHARACTER SET latin1 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';

With this

Code:

CREATE TABLE `vacation_notification` (  `on_vacation` varchar(255) CHARACTER SET latin1 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=MyISAM DEFAULT CHARSET=utf8 COMMENT='Postfix Admin - Virtual Vacation Notifications';

4. Edit sentora_install.sh 

Code:

wget -nv -O sentora_preconfig.zip https://github.com/sentora/sentora-installers/archive/$SENTORA_PRECONF_VERSION.zip

make like this

Code:

#wget -nv -O sentora_preconfig.zip https://github.com/sentora/sentora-installers/archive/$SENTORA_PRECONF_VERSION.zip

5. remove sentora_preconfig.zip and zip again sentora-installers-1.0.0, dont forget to do rename with sentora_preconfig.zip

6. chmod +r sentora_install.sh;./sentora_install.sh





Finish... I hope you understand that i mean... hahaha...
I have success with that method... Good Luck...

[sapsa]

Hi,

You can try with this method until updated...
[...]
Finish... I hope you understand that i mean... hahaha...
I have success with that method... Good Luck...

Hello,

I pushed same thing to github repo of sentora. Sadly I gave up on this project.
I went back to ISPConfig which is imo more security wise.

[Me.B]

The issue is mainly with quota table that postfix don't need.

So we will remove this table and issue a patch for those who want to add the missing vacation tables that fail right post quota error.

https://github.com/sentora/sentora-installers/pull/72

M B

[Jango]

where is the patch boss?

[Me.B]

This one:

https://github.com/sentora/sentora-insta...r_1.0.3.sh

This had been already posted in announcement:

http://forums.sentora.org/showthread.php?tid=1853

[Jango]

still getting error on roundcube: "Connection to storage server failed."

[Jango]

after several hours of testing & trying postpix & domain all working now