I am trying to configure mail for domain example.com thru Virtualmin Pro.
I have working (running) Postfix mail server already manually configured to accept and send mail for other domains I host on my server;
Postfix Mail server in Webmin for ‘Domain mapping lookup tables’ is set to:
with content: hosts = 127.0.0.1 user = usernamexxx password = passwordxxx dbname = postfixadmin query = SELECT goto FROM alias WHERE address='%s' AND active = 1 table = alias select_field = domain where_field = active
but when I try to enable Mail for domain example.com I got error:
Adding to email domains list …
… Mail for domain failed! : SQL insert failed : Incorrect integer value: ‘example.com’ for column ‘active’ at row 1
I don’t know how to resolve this problem and I would much appreciate some help and suggestions.