1 Topic by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Topic: Message to seek support after upgrade.

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.3
- Linux/BSD distribution name and version: Ubuntu
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): NGINX
- Manage mail accounts with iRedAdmin-Pro? NO
- Related log if you're reporting an issue: n/a
====

Hi,

I received the following message after running the bash upgrade_iredapd.sh from iRedAdmin-0.5/tools#.
I cannot seem to login to anything now, I think I broke my iredmail.

Going through the documentation again, fortunately I don't use the email accounts but sucks not to have them working.
I enjoy iRedmail but upgrading still gives me a lot of issues. I will learn it sooner or later, just a lot of trail and error. Lots of errors, so any guidance is appreciated.

I've purchased support requests in the past. As a system administrator I really want to figure this out.

Thanks a loyal promoter of iRedMaill
Stewart Y. techhelpstew@gmail.com

* iRedAdmin was successfully upgraded, restarting web service is required.
* Restart service (uwsgi) to use new iRedAdmin release now? [Y|n] Y
* Restarting app server(s) uwsgi                                                                                                             [ OK ]
* Upgrading completed.
<<< NOTE >>> If iRedAdmin doesn't work as expected, please post your issue in
<<< NOTE >>> our online support forum: http://www.iredmail.org/forum/

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,178

Re: Message to seek support after upgrade.

techhelpstew wrote:

I cannot seem to login to anything now, I think I broke my iredmail.

Any error in /var/log/mail.log, /var/log/dovecot.log, /var/log/iredapd/iredapd.log?

3 Reply by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Re: Message to seek support after upgrade.

[qoute]Any error in /var/log/mail.log, dovecot.log and /log/iredapd/iredapd.log[/qoute]

dovecot.log was empty and iredapd.log was also empty.

Mail log was not.


Apr  7 23:59:33 madev postfix/master[1881]: warning: process /usr/lib/postfix/smtpd pid 10112 exit status 1
Apr  7 23:59:33 madev postfix/master[1881]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
Apr  7 23:59:33 madev postfix/proxymap[10052]: warning: request for unapproved table: "mysql:/etc/postfix/mysql/sender_login_maps.cf"
Apr  7 23:59:33 madev postfix/proxymap[10052]: warning: to approve this table for read-only access, list proxy:mysql:/etc/postfix/mysql/sender_login$
Apr  7 23:59:33 madev postfix/submission/smtpd[10113]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_ma$
Apr  7 23:59:34 madev postfix/master[1881]: warning: process /usr/lib/postfix/smtpd pid 10113 exit status 1
Apr  7 23:59:34 madev postfix/master[1881]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
Apr  7 23:59:38 madev postfix/master[1881]: warning: master_wakeup_timer_event: service pickup(public/pickup): Resource temporarily unavailable
Apr  7 09:14:42 madev postfix/submission/smtpd[10116]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_ma$
Apr  8 00:00:11 madev postfix/postscreen[10169]: CONNECT from [104.47.100.129]:33760 to [199.223.211.214]:25
Apr  8 00:00:17 madev postfix/postscreen[10169]: PASS OLD [104.47.100.129]:33760
Apr  8 00:00:17 madev postfix/postscreen[10169]: warning: cannot connect to service private/smtpd: Resource temporarily unavailable
Apr  8 00:00:18 madev postfix/postscreen[10169]: PASS OLD [104.47.100.129]:33760
Apr  8 00:00:18 madev postfix/postscreen[10169]: DISCONNECT [104.47.100.129]:33760
Apr  7 09:16:44 madev postfix/cleanup[10189]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf"
Apr  8 00:00:32 madev postfix/proxymap[10052]: warning: request for unapproved table: "mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf"
Apr  8 00:00:32 madev postfix/proxymap[10052]: warning: to approve this table for read-only access, list proxy:mysql:/etc/postfix/mysql/sender_bcc_m$
Apr  8 00:00:32 madev postfix/cleanup[10195]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf"
Apr  8 00:00:33 madev postfix/master[1881]: warning: process /usr/lib/postfix/cleanup pid 10195 exit status 1
Apr  8 00:00:33 madev postfix/master[1881]: warning: /usr/lib/postfix/cleanup: bad command startup -- throttling
Apr  8 00:00:33 madev postfix/proxymap[10052]: warning: request for unapproved table: "mysql:/etc/postfix/mysql/sender_login_maps.cf"
Apr  8 00:00:33 madev postfix/proxymap[10052]: warning: to approve this table for read-only access, list proxy:mysql:/etc/postfix/mysql/sender_login$
Apr  8 00:00:33 madev postfix/smtpd[10196]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_maps.cf"
Apr  8 00:00:34 madev postfix/master[1881]: warning: process /usr/lib/postfix/smtpd pid 10196 exit status 1
Apr  8 00:00:34 madev postfix/master[1881]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
Apr  8 00:00:34 madev postfix/proxymap[10052]: warning: request for unapproved table: "mysql:/etc/postfix/mysql/sender_login_maps.cf"
Apr  8 00:00:34 madev postfix/proxymap[10052]: warning: to approve this table for read-only access, list proxy:mysql:/etc/postfix/mysql/sender_login$
Apr  8 00:00:34 madev postfix/submission/smtpd[10198]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_ma$
Apr  8 00:00:35 madev postfix/master[1881]: warning: process /usr/lib/postfix/smtpd pid 10198 exit status 1
Apr  8 00:00:35 madev postfix/master[1881]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,178

Re: Message to seek support after upgrade.

*) Did you see any error in output of command "postconf -n"?
*) Please show us output of "postconf -n" and full content of file /etc/postfix/master.cf.

5 Reply by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Re: Message to seek support after upgrade.

# postconf -n
alias_database = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases
alias_maps = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases
allow_min_user = no
allow_percent_hack = no
biff = no
body_checks = regexp:/etc/postfix/body_checks
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
content_filter = amavis:[127.0.0.1]:10024
daemon_directory = /usr/lib/postfix
data_directory = /var/lib/postfix
debug_peer_level = 2
debugger_command = PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin ddd $daemon_directory/$process_name $process_id & sleep 5
disable_vrfy_command = yes
dovecot_destination_recipient_limit = 1
enable_original_recipient = no
header_checks = regexp:/etc/postfix/header_checks
home_mailbox = Maildir/
inet_interfaces = all
inet_protocols = all
lmtp_tls_mandatory_protocols = !SSLv2 !SSLv3
lmtp_tls_protocols = !SSLv2 !SSLv3
mail_owner = postfix
mailbox_command = /usr/lib/dovecot/deliver
maildrop_destination_concurrency_limit = 1
maildrop_destination_recipient_limit = 1
mailq_path = /usr/bin/mailq
message_size_limit = 15728640
mime_header_checks = regexp:/etc/postfix/mime_header_checks
mydestination = madev.teamait.com, localhost, localhost.localdomain
mydomain = teamait.com
myhostname = madev.teamait.com
mynetworks = 127.0.0.0/8 [::1]/128
myorigin = teamait.com
nested_header_checks = regexp:/etc/postfix/nested_header_checks
newaliases_path = /usr/bin/newaliases
owner_request_special = no
postscreen_access_list = permit_mynetworks, cidr:/etc/postfix/postscreen_access.cidr
postscreen_blacklist_action = enforce
postscreen_dnsbl_action = enforce
postscreen_dnsbl_reply_map = texthash:/etc/postfix/postscreen_dnsbl_reply
postscreen_dnsbl_sites = zen.spamhaus.org*3 b.barracudacentral.org*2 bl.spameatingmonkey.net*2 bl.spamcop.net dnsbl.sorbs.net psbl.surriel.com bl.mailspike.net swl.spamhaus.org*-4 list.dnswl.org=127.[0..255].[0..255].0*-2 list.dnswl.org=127.[0..255].[0..255].1*-3 list.dnswl.org=127.[0..255].[0..255].[2..255]*-4
postscreen_dnsbl_threshold = 2
postscreen_dnsbl_whitelist_threshold = -2
postscreen_greet_action = enforce
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks
queue_directory = /var/spool/postfix
receive_override_options = no_address_mappings
recipient_bcc_maps = proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf
recipient_delimiter = +
relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf
sender_bcc_maps = proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf
sendmail_path = /usr/sbin/sendmail
setgid_group = postdrop
smtp-amavis_destination_recipient_limit = 1
smtp_tls_CAfile = $smtpd_tls_CAfile
smtp_tls_loglevel = 0
smtp_tls_mandatory_protocols = !SSLv2 !SSLv3
smtp_tls_note_starttls_offer = yes
smtp_tls_protocols = !SSLv2,!SSLv3
smtp_tls_security_level = may
smtpd_client_message_rate_limit = 100
smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-virtual_client.cf
smtpd_data_restrictions = reject_unauth_pipelining
smtpd_end_of_data_restrictions = check_policy_service inet:127.0.0.1:7777
smtpd_helo_required = yes
smtpd_helo_restrictions = permit_mynetworks permit_sasl_authenticated reject_non_fqdn_helo_hostname reject_invalid_helo_hostname check_helo_access pcre:/etc/postfix/helo_access.pcre
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf
smtpd_reject_unlisted_recipient = yes
smtpd_reject_unlisted_sender = yes
smtpd_sasl_auth_enable = yes
smtpd_sasl_authenticated_header = yes
smtpd_sasl_local_domain =
smtpd_sasl_path = private/auth
smtpd_sasl_security_options = noanonymous
smtpd_sasl_type = dovecot
smtpd_sender_login_maps = proxy:mysql:/etc/postfix/mysql/sender_login_maps.cf
smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf
smtpd_tls_CAfile = /etc/ssl/certs/iRedMail.crt
smtpd_tls_auth_only = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_dh1024_param_file = /etc/ssl/dhparams.pem
smtpd_tls_exclude_ciphers = aNULL, eNULL, EXPORT, DES, RC4, MD5, PSK, aECDH, EDH-DSS-DES-CBC3-SHA, EDH-RSA-DES-CDC3-SHA, KRB5-DE5, CBC3-SHA
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_tls_loglevel = 0
smtpd_tls_mandatory_protocols = !SSLv2, !SSLv3
smtpd_tls_protocols = !SSLv2,!SSLv3
smtpd_tls_security_level = may
smtpd_use_tls = yes
swap_bangpath = no
tls_random_source = dev:/dev/urandom
transport_maps = hash:/var/lib/mailman/data/transport-mailman, proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
unknown_local_recipient_reject_code = 550
virtual_alias_domains =
virtual_alias_maps = hash:/var/lib/mailman/data/virtual-mailman, proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, proxy:mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_gid_maps = static:5000
virtual_mailbox_base = /var/vmail
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_minimum_uid = 2000
virtual_transport = dovecot
virtual_uid_maps = static:5000

6 Reply by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Re: Message to seek support after upgrade.

# on-line: http://www.postfix.org/master.5.html).
#
# Do not forget to execute "postfix reload" after editing this file.
#
# ==========================================================================
# service type  private unpriv  chroot  wakeup  maxproc command + args
#               (yes)   (yes)   (yes)   (never) (100)
# ==========================================================================
#smtp      inet  n       -       -       -       -       smtpd
smtp      inet  n       -       -       -       1       postscreen
smtpd     pass  -       -       -       -       -       smtpd
dnsblog   unix  -       -       -       -       0       dnsblog
tlsproxy  unix  -       -       -       -       0       tlsproxy
#submission inet n       -       -       -       -       smtpd
#  -o syslog_name=postfix/submission
#  -o smtpd_tls_security_level=encrypt
#  -o smtpd_sasl_auth_enable=yes
#  -o smtpd_reject_unlisted_recipient=no
#  -o smtpd_client_restrictions=$mua_client_restrictions
#  -o smtpd_helo_restrictions=$mua_helo_restrictions
#  -o smtpd_sender_restrictions=$mua_sender_restrictions
#  -o smtpd_recipient_restrictions=
#  -o smtpd_relay_restrictions=permit_sasl_authenticated,reject
#  -o milter_macro_daemon_name=ORIGINATING
#smtps     inet  n       -       -       -       -       smtpd
#  -o syslog_name=postfix/smtps
#  -o smtpd_tls_wrappermode=yes
#  -o smtpd_sasl_auth_enable=yes
#  -o smtpd_reject_unlisted_recipient=no
#  -o smtpd_client_restrictions=$mua_client_restrictions
#  -o smtpd_helo_restrictions=$mua_helo_restrictions
#  -o smtpd_sender_restrictions=$mua_sender_restrictions
#  -o smtpd_recipient_restrictions=
#  -o smtpd_relay_restrictions=permit_sasl_authenticated,reject
#  -o milter_macro_daemon_name=ORIGINATING
#628       inet  n       -       -       -       -       qmqpd
pickup    unix  n       -       -       60      1       pickup
cleanup   unix  n       -       -       -       0       cleanup
qmgr      unix  n       -       n       300     1       qmgr
#qmgr     unix  n       -       n       300     1       oqmgr
tlsmgr    unix  -       -       -       1000?   1       tlsmgr
rewrite   unix  -       -       -       -       -       trivial-rewrite
bounce    unix  -       -       -       -       0       bounce
defer     unix  -       -       -       -       0       bounce
trace     unix  -       -       -       -       0       bounce
verify    unix  -       -       -       -       1       verify
flush     unix  n       -       -       1000?   0       flush
proxymap  unix  -       -       n       -       -       proxymap
proxywrite unix -       -       n       -       1       proxymap
smtp      unix  -       -       -       -       -       smtp
relay     unix  -       -       -       -       -       smtp
#       -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
showq     unix  n       -       -       -       -       showq
error     unix  -       -       -       -       -       error
retry     unix  -       -       -       -       -       error
discard   unix  -       -       -       -       -       discard
local     unix  -       n       n       -       -       local
virtual   unix  -       n       n       -       -       virtual
lmtp      unix  -       -       -       -       -       lmtp
anvil     unix  -       -       -       -       1       anvil
scache    unix  -       -       -       -       1       scache
#
# ====================================================================
# Interfaces to non-Postfix software. Be sure to examine the manual
# pages of the non-Postfix software to find out what options it wants.
#
# Many of the following services use the Postfix pipe(8) delivery
# agent.  See the pipe(8) man page for information about ${recipient}
# and other message envelope options.
# ====================================================================
#
# maildrop. See the Postfix MAILDROP_README file for details.
# Also specify in main.cf: maildrop_destination_recipient_limit=1
#
maildrop  unix  -       n       n       -       -       pipe
  flags=DRhu user=vmail argv=/usr/bin/maildrop -d vmail ${extension} ${recipient} ${user} ${nexthop} ${sender}
#
# ====================================================================
#
# Recent Cyrus versions can use the existing "lmtp" master.cf entry.
#
# Specify in cyrus.conf:
#   lmtp    cmd="lmtpd -a" listen="localhost:lmtp" proto=tcp4
#
# Specify in main.cf one or more of the following:
#  mailbox_transport = lmtp:inet:localhost
#  virtual_transport = lmtp:inet:localhost
#
# ====================================================================
#
# Cyrus 2.1.5 (Amos Gouaux)
# Also specify in main.cf: cyrus_destination_recipient_limit=1
#
#cyrus     unix  -       n       n       -       -       pipe
#  user=cyrus argv=/cyrus/bin/deliver -e -r ${sender} -m ${extension} ${user}
#
# ====================================================================
# Old example of delivery via Cyrus.
#
#old-cyrus unix  -       n       n       -       -       pipe
#  flags=R user=cyrus argv=/cyrus/bin/deliver -e -m ${extension} ${user}
#
# ====================================================================
#
# See the Postfix UUCP_README file for configuration details.
#
uucp      unix  -       n       n       -       -       pipe
  flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
#
# Other external delivery methods.
#
ifmail    unix  -       n       n       -       -       pipe
  flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp     unix  -       n       n       -       -       pipe
  flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
scalemail-backend unix  -       n       n       -       2       pipe
  flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
mailman   unix  -       n       n       -       -       pipe
  flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
  ${nexthop} ${user}

# Submission, port 587, force TLS connection.
submission inet n       -       n       -       -       smtpd
  -o syslog_name=postfix/submission
  -o smtpd_tls_security_level=encrypt
  -o smtpd_sasl_auth_enable=yes
  -o smtpd_client_restrictions=permit_mynetworks,permit_sasl_authenticated,reject
  -o content_filter=smtp-amavis:[127.0.0.1]:10026

# Use dovecot's `deliver` program as LDA.
dovecot unix    -       n       n       -       -      pipe
    flags=DRh user=vmail:vmail argv=/usr/lib/dovecot/deliver -f ${sender} -d ${user}@${domain} -m ${extension}

# Amavisd integration.
smtp-amavis unix -  -   -   -   2  smtp
    -o smtp_data_done_timeout=1200
    -o smtp_send_xforward_command=yes
    -o disable_dns_lookups=yes
    -o max_use=20
127.0.0.1:10025 inet n  -   -   -   -  smtpd
    -o content_filter=
    -o mynetworks_style=host
    -o mynetworks=127.0.0.0/8
    -o local_recipient_maps=
    -o relay_recipient_maps=
    -o strict_rfc821_envelopes=yes
    -o smtp_tls_security_level=none
    -o smtpd_tls_security_level=none
    -o smtpd_restriction_classes=
    -o smtpd_delay_reject=no
    -o smtpd_client_restrictions=permit_mynetworks,reject
    -o smtpd_helo_restrictions=
    -o smtpd_sender_restrictions=
    -o smtpd_recipient_restrictions=permit_mynetworks,reject
-o smtpd_end_of_data_restrictions=
    -o smtpd_error_sleep_time=0
    -o smtpd_soft_error_limit=1001
    -o smtpd_hard_error_limit=1000
    -o smtpd_client_connection_count_limit=0
    -o smtpd_client_connection_rate_limit=0
    -o receive_override_options=no_header_body_checks,no_unknown_recipient_checks,no_address_mappings

7 Reply by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Re: Message to seek support after upgrade.

mail.err

Apr 10 04:05:08 madev postfix/smtpd[23436]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_maps.cf"
Apr 10 04:06:09 madev postfix/cleanup[23466]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf"
Apr 10 04:06:09 madev postfix/submission/smtpd[23468]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_ma$
Apr 10 04:06:09 madev postfix/smtpd[23467]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_maps.cf"
Apr 10 04:07:10 madev postfix/cleanup[23493]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf"
Apr 10 04:07:10 madev postfix/submission/smtpd[23494]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_ma$
Apr 10 04:07:10 madev postfix/smtpd[23495]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_maps.cf"
Apr 10 04:08:11 madev postfix/cleanup[23521]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf"
Apr 10 04:08:11 madev postfix/submission/smtpd[23522]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_ma$
Apr 10 04:08:11 madev postfix/smtpd[23523]: fatal: proxymap service is not configured for table "mysql:/etc/postfix/mysql/sender_login_maps.cf"

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,178

Re: Message to seek support after upgrade.

In main.cf, replace 'proxy_read_maps' by below one, then restart Postfix service:

proxy_read_maps = $canonical_maps $lmtp_generic_maps $local_recipient_maps $mydestination $mynetworks $recipient_bcc_maps $recipient_canonical_maps $relay_domains $relay_recipient_maps $relocated_maps $sender_bcc_maps $sender_canonical_maps $smtp_generic_maps $smtpd_sender_login_maps $transport_maps $virtual_alias_domains $virtual_alias_maps $virtual_mailbox_domains $virtual_mailbox_maps $smtpd_sender_restrictions $sender_dependent_relayhost_maps

9 Reply by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Re: Message to seek support after upgrade.

done. restart postfix and server.

Still unable to login.

10 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,178

Re: Message to seek support after upgrade.

What's the error message/log after updated proxy_read_maps?

11 Reply by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Re: Message to seek support after upgrade.

mail.log

Apr 10 22:01:01 madev postfix/qmgr[2139]: 1BAE5C398: from=<sogo@teamait.com>, size=792, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 10644588D: from=<sogo@teamait.com>, size=794, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 137B1BDF9: from=<sogo@teamait.com>, size=794, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 1FBE0C878: from=<sogo@teamait.com>, size=794, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 1A280F322: from=<sogo@teamait.com>, size=794, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 1DA47A193: from=<sogo@teamait.com>, size=792, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 1F7B97968: from=<sogo@teamait.com>, size=792, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 12DEECBD6: from=<sogo@teamait.com>, size=792, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 14891A741: from=<sogo@teamait.com>, size=792, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 164BFC0A8: from=<sogo@teamait.com>, size=792, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 1E8111767: from=<sogo@teamait.com>, size=794, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 1697B11B9: from=<sogo@teamait.com>, size=794, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 1BD468C00: from=<sogo@teamait.com>, size=794, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/qmgr[2139]: 187A2B006: from=<sogo@teamait.com>, size=794, nrcpt=1 (queue active)
Apr 10 22:01:01 madev postfix/error[4255]: CCF20F931: to=<sogo@teamait.com>, relay=none, delay=4035780, delays=4035747/32/0/0.48, dsn=4.3.0, status=$
Apr 10 22:01:01 madev postfix/error[4255]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:01 madev postfix/error[4255]: warning: CCF20F931: flush service failure
Apr 10 22:01:01 madev postfix/error[4282]: C5407DEEE: to=<sogo@teamait.com>, relay=none, delay=1900920, delays=1900887/32/0/0.49, dsn=4.3.0, status=$
Apr 10 22:01:01 madev postfix/error[4282]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:01 madev postfix/error[4282]: warning: C5407DEEE: flush service failure
Apr 10 22:01:01 madev postfix/error[4254]: C07362E17: to=<sogo@teamait.com>, relay=none, delay=3389279, delays=3389246/32/0/0.49, dsn=4.3.0, status=$
Apr 10 22:01:01 madev postfix/error[4254]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:01 madev postfix/error[4254]: warning: C07362E17: flush service failure
Apr 10 22:01:01 madev postfix/error[4307]: C95CFF3CC: to=<sogo@teamait.com>, relay=none, delay=2281440, delays=2281407/32/0/0.49, dsn=4.3.0, status=$
Apr 10 22:01:01 madev postfix/error[4307]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:01 madev postfix/error[4247]: C489A10057: to=<sogo@teamait.com>, relay=none, delay=1654319, delays=1654286/32/0/0.49, dsn=4.3.0, status$
Apr 10 22:01:01 madev postfix/error[4247]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:01 madev postfix/error[4247]: warning: C489A10057: flush service failure
Apr 10 22:01:01 madev postfix/error[4246]: C971BA970: to=<sogo@teamait.com>, relay=none, delay=101820, delays=101787/32/0/0.49, dsn=4.3.0, status=de$
Apr 10 22:01:01 madev postfix/error[4246]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:42 madev postfix/error[4356]: 74D404CA1: to=<sogo@teamait.com>, relay=none, delay=149020, delays=148956/64/0/0.01, dsn=4.3.0, status=de$
Apr 10 22:01:42 madev postfix/error[4356]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:42 madev postfix/error[4356]: warning: 74D404CA1: flush service failure
Apr 10 22:01:42 madev postfix/pickup[2138]: warning: 20FDE86D9: message has been queued for 13 days
Apr 10 22:01:42 madev postfix/pickup[2138]: 20FDE86D9: uid=999 from=<sogo>
Apr 10 22:01:42 madev postfix/cleanup[4402]: 20FDE86D9: message-id=<20160411050142.20FDE86D9@madev.teamait.com>
Apr 10 22:01:42 madev postfix/qmgr[2139]: 1ECCF137E7: from=<sogo@teamait.com>, size=796, nrcpt=1 (queue active)
Apr 10 22:01:42 madev postfix/error[4384]: 7C98EAD12: to=<sogo@teamait.com>, relay=none, delay=4042001, delays=4041937/64/0/0, dsn=4.3.0, status=def$
Apr 10 22:01:42 madev postfix/error[4384]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:42 madev postfix/error[4384]: warning: 7C98EAD12: flush service failure
Apr 10 22:01:42 madev postfix/error[4399]: 7102910614: to=<sogo@teamait.com>, relay=none, delay=1681001, delays=1680937/64/0/0, dsn=4.3.0, status=de$
Apr 10 22:01:42 madev postfix/error[4399]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:42 madev postfix/error[4399]: warning: 7102910614: flush service failure
Apr 10 22:01:42 madev postfix/error[4363]: 74B66CA9F: to=<sogo@teamait.com>, relay=none, delay=4059460, delays=4059396/64/0/0.01, dsn=4.3.0, status=$
Apr 10 22:01:42 madev postfix/error[4363]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:42 madev postfix/error[4363]: warning: 74B66CA9F: flush service failure
Apr 10 22:01:42 madev postfix/error[4361]: 70A2FAB16: to=<amavis@teamait.com>, relay=none, delay=2817817, delays=2817753/64/0/0.01, dsn=4.3.0, statu$
Apr 10 22:01:42 madev postfix/error[4387]: 7456176BF: to=<sogo@teamait.com>, relay=none, delay=92321, delays=92257/64/0/0.01, dsn=4.3.0, status=defe$
Apr 10 22:01:42 madev postfix/error[4372]: 7041610E27: to=<sogo@teamait.com>, relay=none, delay=86501, delays=86437/64/0/0.01, dsn=4.3.0, status=def$
Apr 10 22:01:42 madev postfix/error[4372]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:42 madev postfix/error[4372]: warning: 7041610E27: flush service failure
Apr 10 22:01:42 madev postfix/error[4387]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:42 madev postfix/error[4387]: warning: 7456176BF: flush service failure
Apr 10 22:01:42 madev postfix/error[4361]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf: table lookup problem
Apr 10 22:01:42 madev postfix/error[4361]: warning: 70A2FAB16: flush service failure

12 Reply by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Re: Message to seek support after upgrade.

mail.err seems to have stopped logging error after the postfix changes to main.cf.
I am looking around at other logs.

Please feel free to point out specific log commands.

Thanks for you help.

Stewart

13 Reply by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Re: Message to seek support after upgrade.

I had to stop postfix, fail2ban, and Sogo services. The logs failure was pushing my CPU to 90%, so I stopped them for now.
Mail services should be stopped completely unless I missed a service?.

14 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,178

Re: Message to seek support after upgrade.

techhelpstew wrote:

relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf
relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf

Do you have these 2 files?

Default settings in iRedMail is:

relay_domains = $mydestination, proxy:mysql:/etc/postfix/mysql/relay_domains.cf
relay_recipient_maps =

BTW, you should read the log file first if it doesn't work, try to understand what the log saying.

15 Reply by techhelpstew

  • techhelpstew
  • Member
  • Offline
  • Registered: 2015-08-16
  • Posts: 12

Re: Message to seek support after upgrade.

Yes I see the to files in that location.

From what I can tell from the log, it's seems to be looking for those files in the postfix folder instead of postfix/mysql.

postfix/error[3608]: warning: mysql:/etc/postfix/mysql-virtual_relaydomains.cf i

I think a lot of different parts are configured incorrectly in my various attempts.
For now I will just have to live without email, good thing I use gmail.

Once I have the funds, I'll shoot a support request your way.
I would re-install everything from scratch but I don't really feel like doing that.
Worst case scenario I host my email elsewhere and point MX records.

Not attempting anymore upgrades, I have another server running iRedMail 0.9.2 will no problem.

Thanks for taking the time to help me. It's appreciated.
Stewart Y.
techhelpstew@gmail.com
Support Engineer