Postfix issue

Discussion in 'Installation/Configuration' started by trcinc1, Mar 29, 2022.

  1. trcinc1

    trcinc1 New Member HowtoForge Supporter

    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)
     
  2. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Run 'ispconfig_update.sh --force' on that mail server and answer yes to reconfiguring services.
     
  3. trcinc1

    trcinc1 New Member HowtoForge Supporter

    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?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

  5. trcinc1

    trcinc1 New Member HowtoForge Supporter

    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.
     
  6. trcinc1

    trcinc1 New Member HowtoForge Supporter

    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?
     
  7. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    I would guess you have custom postfix config that needs updated, check under /usr/local/ispconfig/server/conf-custom/install/
     
  8. trcinc1

    trcinc1 New Member HowtoForge Supporter

    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?
     
  9. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    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.
     
    30uke likes this.
  10. trcinc1

    trcinc1 New Member HowtoForge Supporter

    Thanks Jesse. I'll have to try that this weekend. Thanks to all for the help.
     

Share This Page