Hi, I started getting this error in my mail.log and now I cannot get receive any emails: (I think this happened when I was removing an email account) Mar 29 07:30:05 imap postfix/proxymap[14347]: warning: mysql:/etc/postfix/mysql-virtual_alias_domains.cf is unavailable. open /etc/postfix/mysql-virtual_alias_domains.cf: No such file or directory Mar 29 07:30:05 imap postfix/trivial-rewrite[14615]: warning: virtual_alias_domains: proxy:mysql:/etc/postfix/mysql-virtual_alias_domains.cf: table lookup problem Mar 29 07:30:05 imap postfix/trivial-rewrite[14615]: warning: virtual_alias_domains lookup failure Any ideas? Thanks, Dave (Debian 10 - ISPConfig 3.2.8.p1)
Hi Jesse, Thanks for the tip. I did that earlier without success as I think I messed this up. I just found a main.cf from a backup a few days ago and replaced the current one with the backup and we started getting emails again. I had similar problems like this on this same server and it seems to happen when I change anything under "custom rules" or change something under "email alias". I wanted to forward an email address of someone who no longer works for us to some other emails. Under the old persons email account in "custom rules": redirect "[email protected]"; redirect "[email protected]"; stop; Seems that when I "save" my changes, something breaks and I have to check the logs and go from there. I'm thinking it might be a postifx issue or an issue with updating files (permissions) after editing? Maybe I should create a new thread for this?
You can use the debug mode to find out what's happening in detail: https://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/
Hi Till, Once I made the change to "debug", emails stopped again and I see this in the mail logs. Mar 29 09:48:54 imap postfix/submission/smtpd[24756]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql-virtual_sender.cf" Mar 29 09:49:55 imap postfix/submission/smtpd[24815]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql-virtual_sender.cf" I do not see anything (that I can tell) from the system-log that raises any concern. I'll go back and replace my main.cf to see if emails start again.
Email is back up when I replace main.cf with the previous one before any changes to the server-config. Everything under /etc/postfix has owner and group of root except the mysql-virtual_xxxx.cf files are all owner root and group postfix. Seems like any updates or saves breaks the main.cf as if something is not getting updated?
I would guess you have custom postfix config that needs updated, check under /usr/local/ispconfig/server/conf-custom/install/
That location only has the empty.dir file. Over the years I most likely messed with the main.cf. Would it be as simple as replacing and testing an original copy of the postfix main.cf? Or are there other files involved?
The main files are main.cf and master.cf; and there are a lot of files created for database lookups which you wouldn't usually customize. You could try backing up your main.cf and master.cf, replace with default ones, and run the ispconfig installer to update the config, that should work. Or you could just run the installer to update config, see where things are at (eg. if there are problems, what error(s) is(are) logged?) and fix whatever might need it.
