First time install: CentOS7, Postfix, MariaDB

Worked through some errors.

Still confused concerning virtual email users. Expect to make user unix directories under virtual domains directories. Have not seen a Yes or No answer.

One error is creating virtual aliases in MariaDB.

https://www.linode.com/docs/email/postf … ysql#mysql">https://www.linode.com/docs/email/postfix/email-with-postfix-dovecot-and-mysql#mysql

Create a table for the email aliases:

CREATE TABLE virtual_aliases (

id int(11) NOT NULL auto_increment,

domain_id int(11) NOT NULL,

source varchar(100) NOT NULL,

destination varchar(100) NOT NULL,

PRIMARY KEY (id),

FOREIGN KEY (domainid) REFERENCES virtualdomains(id) ON DELETE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

If I enter all lines at once with a space here: CASADE ) ENGINE, SHOW ENGINE INNODB STATUS gives LATEST FOREIGN KEY ERROR dictionary error.

If I enter all the lines at once with no space, CASADE) ENGINE, SHOW ENGINE INNODB STATUS gives LATEST FOREIGN KEY ERROR Parse error in 'FOREIGN KEY (domain_id).

If I enter the lines one at a time. SHOW ENGINE INNODB STATUS gives LATEST FOREIGN KEY ERROR Parse error in 'FOREIGN KEY (domain_id)

Edited /etc/postfix/main.cf.

Commented out $mydestination.

No change.

warning: /etc/postfix/main.cf: unused parameter: dovecotdestinationrecipient_limit=1

warning: /etc/postfix/main.cf: undefined parameter: virtualmailboxlimit_maps

warning: /etc/postfix/main.cf: unused parameter: virtualcreatemaildirsize=yes

warning: /etc/postfix/main.cf: unused parameter: virtualmaildirextended=yes

warning: /etc/postfix/main.cf: unused parameter: dovecotdestinationrecipient_limit=1

postfix/master[4847]: daemon started – version 2.10.1, configuration /etc/postfix

systemd[1]: Started Postfix Mail Transport Agent.

postfix/master[4847]: warning: masterwakeuptimer_event: service pickup(public/pickup): Connection refused

postfix/master[4847]: warning: masterwakeuptimer_event: service pickup(public/pickup): Connection refused

postfix/master[4847]: warning: masterwakeuptimer_event: service pickup(public/pickup): Connection refused

proxyreadmaps =

$localrecipientmaps

$mydestination

$virtualaliasmaps

$virtualaliasdomains

$virtualmailboxmaps

$virtualmailboxdomains

$relayrecipientmaps

$relay_domains

$canonical_maps

$sendercanonicalmaps

$recipientcanonicalmaps

$relocatedmaps $transportmaps

$mynetworks

$virtualmailboxlimit_maps – highlighted red.

Corrected dovecot: auth: Fatal: sql /etc/dovecot/dovecot-sql.conf.ext: Error in configuration file /etc/dovecot/dovecot-sql.conf.ext line 1: Unknown setting: ver

Changed first line from ver = mysql to driver = mysql.

sudo ls -alsh /home/vmail/vhosts/TESTDOMAIN/davida/Maildir

total 60K, has directories now.

Working on:

postfix User unknown in virtual alias table

postfix/trivial-rewrite: warning: do not list domain TESTDOMAIN in BOTH virtualaliasdomains and virtualmailboxdomains

Cannot get around this:

postfix/qmgr[6547]: warning: connect to transport private/spamassassin: No such file or directory

/etc/postfix/master.cf

smtp inet n - n - - smtpd -o content_filter=spamassassin

Tried smtp-amavis and amavis.

/etc/postfix/main.cf

content_filter = smtp-amavis:[127.0.0.1]:10024

Could not solve email server setup problem. Removed email software. Repurposed as webserver.