1 (edited by murat 2017-07-03 17:17:20)

Topic: I get an error in setup

Hello i am getting these errors in setup. Please help me.

SOGo database schemas are _not_ automatically upgraded by
the packaging system.

Please check the list of database schema upgrade scripts
inside /usr/share/doc/sogo/ and apply them if needed.

dpkg: error processing package sogo:amd64 (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up postfix-mysql (2.11.3-1+deb8u2) ...
Adding mysql map entry to /etc/postfix/dynamicmaps.cf
Setting up postfix-pcre (2.11.3-1+deb8u2) ...
Adding pcre map entry to /etc/postfix/dynamicmaps.cf
dpkg: dependency problems prevent configuration of sogo-activesync:
sogo-activesync depends on sogo (= 3.2.9.20170703-1); however:
  Package sogo:amd64 is not configured yet.

dpkg: error processing package sogo-activesync (--configure):
dependency problems - leaving unconfigured
Processing triggers for libc-bin (2.19-18+deb8u10) ...
Errors were encountered while processing:
sogo:amd64
sogo-activesync
E: Sub-process /usr/bin/dpkg returned an error code (1)
<< ERROR >> Installation failed, please check the terminal output.
<< ERROR >> If you're not sure what the problem is, try to get help in iRedMail
<< ERROR >> forum: http://www.iredmail.org/forum/

Post's attachments

Ekran Alıntısı.PNG
Ekran Alıntısı.PNG 31.78 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

----

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

2

Re: I get an error in setup

Looks like a SOGo deb package issue ... but i never had this issue during my testing. No clue yet. Maybe report this (SOGo) installation issue in SOGo bug tracker:
https://sogo.nu/bugs/

3

Re: I get an error in setup

ZhangHuangbin wrote:

Looks like a SOGo deb package issue ... but i never had this issue during my testing. No clue yet. Maybe report this (SOGo) installation issue in SOGo bug tracker:
https://sogo.nu/bugs/

Hi, I've proceeded without choosing SOGO. I've signed up for domain and email from iredadmin, they are done too. Postfix settings are done too but this error shows up ( Shown in the screenshot) If i can start to sending emails I'll upgrade to iredadmin pro. Could you please help me?

IMAP Error in /opt/www/roundcubemail-1.3.0/program/lib/Roundcube/rcube_imap.php (196): Login failed for noreply@exmplae.com from 0.0.0.39. LOGIN: Temporary authentication failure. [mail.exmplae.com:2017-07-04 16:03:15]

Post's attachments

Ekran Alıntısı.PNG 12.04 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

4

Re: I get an error in setup

Any related error in Postfix log file (/var/log/mail.log) and Dovecot log file (/var/log/dovecot/*)? Seems smtp auth doesn't work.

5 (edited by murat 2017-07-06 01:16:38)

Re: I get an error in setup

Hello, logs (in the files)  in dovecot folder is empty but mail.log is full so I'm sending this in down below.

Jul  5 18:50:39 mail sm-mta[6961]: rejecting connections on daemon MTA-v4: load average: 150
Jul  5 18:50:39 mail sm-mta[6961]: rejecting connections on daemon MSP-v4: load average: 150
Jul  5 18:50:54 mail sm-mta[6961]: accepting connections again for daemon MTA-v4
Jul  5 18:50:54 mail sm-mta[6961]: accepting connections again for daemon MSP-v4

Jul  5 20:14:41 mail postfix/proxymap[12950]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf is unavailable. unsupported dictionary type: mysql
Jul  5 20:14:41 mail postfix/cleanup[12951]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "root@postmaster@exmp.com"
Jul  5 20:14:41 mail postfix/cleanup[12951]: warning: 7E876D2380B: sender_bcc_maps map lookup problem -- message not accepted, try again later
Jul  5 20:14:41 mail postfix/pickup[12937]: warning: maildrop/26B6FD61886: error writing 7E876D2380B: queue file write error
Jul  5 20:14:42 mail postfix/pickup[12937]: warning: 7F7E8D2380B: message has been queued for 10 days
Jul  5 20:14:42 mail postfix/pickup[12937]: 7F7E8D2380B: uid=999 from=<sogo>
Jul  5 20:14:42 mail postfix/proxymap[12950]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf is unavailable. unsupported dictionary type: mysql
Jul  5 20:14:42 mail postfix/cleanup[12951]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "sogo@postmaster@exmp.com"
Jul  5 20:14:42 mail postfix/cleanup[12951]: warning: 7F7E8D2380B: sender_bcc_maps map lookup problem -- message not accepted, try again later
Jul  5 20:14:42 mail postfix/pickup[12937]: warning: maildrop/64AE8D62CB8: error writing 7F7E8D2380B: queue file write error


/opt/www/roundcubemail-1.3.0/program/lib/Roundcube/rcube_imap.php:161:
array (size=15)
  'auth_type' => string 'LOGIN' (length=5)
  'auth_cid' => null
  'auth_pw' => null
  'debug' => boolean false
  'force_caps' => boolean false
  'disabled_caps' =>
    array (size=0)
      empty
  'socket_options' =>
    array (size=1)
      'ssl' =>
        array (size=2)
          'verify_peer' => boolean false
          'verify_peer_name' => boolean false
  'timeout' => int 0
  'skip_deleted' => boolean false
  'driver' => string 'imap' (length=4)
  'abort' => boolean false
  'port' => int 143
  'host' => string '127.0.0.1' (length=9)
  'user' => string 'noreply@exmp.com' (length=22)
  'attempt' => int 1


/opt/www/roundcubemail-1.3.0/program/lib/Roundcube/rcube_imap.php:171:
array (size=5)
  'host' => string '127.0.0.1' (length=9)
  'user' => string 'noreply@exm.com' (length=22)
  'password' => string 'teeest' (length=10)
  'port' => int 143
  'ssl' => null
IMAP Error in /opt/www/roundcubemail-1.3.0/program/lib/Roundcube/rcube_imap.php (200):

6

Re: I get an error in setup

murat wrote:

Jul  5 20:14:41 mail postfix/proxymap[12950]: warning: mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf is unavailable. unsupported dictionary type: mysql

Make sure you have package 'postfix-mysql' installed.

7 (edited by murat 2017-07-07 16:44:37)

Re: I get an error in setup

hi,

I regenerate my mysql port settings again and the login was successful. I am having trouble sending mail to the following error logs are as follows.

An error occurred!
SMTP Error (451): Failed to add recipient "sdf@gmail.com" (4.3.0 <noreply@exmp.com>: Temporary lookup failure).

SMTP Error in /opt/www/roundcubemail-1.3.0/program/lib/Roundcube/rcube.php (1665):</b>&nbsp;Failed to add recipient 'murat@exmp.com'. 4.3.0 <noreply@exmp.com>: Temporary lookup failure (Code: 451)

dovecot-core is already the newest version.
dovecot-imapd is already the newest version.
dovecot-lmtpd is already the newest version.
dovecot-mysql is already the newest version.
dovecot-pop3d is already the newest version.
postfix-mysql is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 5 not upgraded.


tail /var/log/dovecot.log

No error

iredapd log

2017-07-03 20:43:23 INFO Starting iRedAPD (version: 2.1, backend: mysql), listening on 127.0.0.1:7777.
2017-07-03 20:43:23 INFO Log rotate type: time, interval: W6, backup copies: 12.
2017-07-03 20:43:23 INFO Loading plugin (priority: 100): reject_null_sender
2017-07-03 20:43:23 INFO Loading plugin (priority: 99): wblist_rdns
2017-07-03 20:43:23 INFO Loading plugin (priority: 90): reject_sender_login_mismatch
2017-07-03 20:43:23 INFO Loading plugin (priority: 80): greylisting
2017-07-03 20:43:23 INFO Loading plugin (priority: 60): throttle
2017-07-03 20:43:23 INFO Loading plugin (priority: 50): sql_alias_access_policy
2017-07-03 20:43:23 INFO Loading plugin (priority: 40): amavisd_wblist

tail /var/log/mail.log

Jul  6 19:29:08 mail postfix/pickup[11030]: warning: 7F10FD2380E: message has been queued for 3 days
Jul  6 19:29:08 mail postfix/pickup[11030]: 7F10FD2380E: uid=999 from=<sogo>
Jul  6 19:29:08 mail postfix/cleanup[11569]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "sogo@exmp.com"
Jul  6 19:29:08 mail postfix/cleanup[11569]: warning: 7F10FD2380E: sender_bcc_maps map lookup problem -- message not accepted, try again later
Jul  6 19:29:08 mail postfix/pickup[11030]: warning: maildrop/A0F09D65A4B: error writing 7F10FD2380E: queue file write error
Jul  6 19:29:09 mail postfix/pickup[11030]: warning: 7F797D2380E: message has been queued for 10 days
Jul  6 19:29:09 mail postfix/pickup[11030]: 7F797D2380E: uid=999 from=<sogo>
Jul  6 19:29:09 mail postfix/cleanup[11569]: warning: proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf lookup error for "sogo@exmp.com"
Jul  6 19:29:09 mail postfix/cleanup[11569]: warning: 7F797D2380E: sender_bcc_maps map lookup problem -- message not accepted, try again later
Jul  6 19:29:09 mail postfix/pickup[11030]: warning: maildrop/C1EBBD635E2: error writing 7F797D2380E: queue file write error


tail /var/log/dovecot-imap.log

Jul  6 17:58:06 mail dovecot: imap(noreply@exmp.com): Disconnected: Logged out in=421 out=1559


main.cf

# --------------------
# INSTALL-TIME CONFIGURATION INFORMATION
#
# location of the Postfix queue. Default is /var/spool/postfix.
queue_directory = /var/spool/postfix

# location of all postXXX commands. Default is /usr/sbin.
command_directory = /usr/sbin

# location of all Postfix daemon programs (i.e. programs listed in the
# master.cf file). This directory must be owned by root.
# Default is /usr/libexec/postfix
daemon_directory = /usr/lib/postfix

# location of Postfix-writable data files (caches, random numbers).
# This directory must be owned by the mail_owner account (see below).
# Default is /var/lib/postfix.
data_directory = /var/lib/postfix

# owner of the Postfix queue and of most Postfix daemon processes.
# Specify the name of a user account THAT DOES NOT SHARE ITS USER OR GROUP ID
# WITH OTHER ACCOUNTS AND THAT OWNS NO OTHER FILES OR PROCESSES ON THE SYSTEM.
# In particular, don't specify nobody or daemon. PLEASE USE A DEDICATED USER.
# Default is postfix.
mail_owner = postfix

# The following parameters are used when installing a new Postfix version.
#
# sendmail_path: The full pathname of the Postfix sendmail command.
# This is the Sendmail-compatible mail posting interface.
#
sendmail_path = /usr/sbin/sendmail

# newaliases_path: The full pathname of the Postfix newaliases command.
# This is the Sendmail-compatible command to build alias databases.
#
newaliases_path = /usr/bin/newaliases

# full pathname of the Postfix mailq command.  This is the Sendmail-compatible
# mail queue listing command.
mailq_path = /usr/bin/mailq

# group for mail submission and queue management commands.
# This must be a group name with a numerical group ID that is not shared with
# other accounts, not even with the Postfix account.
setgid_group = postdrop

# external command that is executed when a Postfix daemon program is run with
# the -D option.
#
# Use "command .. & sleep 5" so that the debugger can attach before
# the process marches on. If you use an X-based debugger, be sure to
# set up your XAUTHORITY environment variable before starting Postfix.
#
debugger_command =
    PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
    ddd $daemon_directory/$process_name $process_id & sleep 5

debug_peer_level = 2

# --------------------
# CUSTOM SETTINGS
#

# SMTP server response code when recipient or domain not found.
unknown_local_recipient_reject_code = 550

# Do not notify local user.
biff = no

# Disable the rewriting of "site!user" into "user@site".
swap_bangpath = no

# Disable the rewriting of the form "user%domain" to "user@domain".
allow_percent_hack = no

# Allow recipient address start with '-'.
allow_min_user = no

# Disable the SMTP VRFY command. This stops some techniques used to
# harvest email addresses.
disable_vrfy_command = yes

# Enable both IPv4 and/or IPv6: ipv4, ipv6, all.
inet_protocols = all

# Enable all network interfaces.
inet_interfaces = all

#
# TLS settings.
#
# SSL key, certificate, CA
#
smtpd_tls_key_file = /etc/ssl/private/iRedMail.key
smtpd_tls_cert_file = /etc/ssl/certs/iRedMail.crt
smtpd_tls_CAfile = /etc/ssl/certs/iRedMail.crt

#
# Disable SSLv2, SSLv3
#
smtpd_tls_protocols = !SSLv2 !SSLv3
smtpd_tls_mandatory_protocols = !SSLv2 !SSLv3
smtp_tls_protocols = !SSLv2 !SSLv3
smtp_tls_mandatory_protocols = !SSLv2 !SSLv3
lmtp_tls_protocols = !SSLv2 !SSLv3
lmtp_tls_mandatory_protocols = !SSLv2 !SSLv3

#
# Fix 'The Logjam Attack'.
#
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_dh512_param_file = /etc/ssl/dh512_param.pem
smtpd_tls_dh1024_param_file = /etc/ssl/dh2048_param.pem

tls_random_source = dev:/dev/urandom

# Log only a summary message on TLS handshake completion — no logging of client
# certificate trust-chain verification errors if client certificate
# verification is not required. With Postfix 2.8 and earlier, log the summary
# message, peer certificate summary information and unconditionally log
# trust-chain verification errors.
smtp_tls_loglevel = 1
smtpd_tls_loglevel = 1

# Opportunistic TLS: announce STARTTLS support to remote SMTP clients, but do
# not require that clients use TLS encryption.
smtpd_tls_security_level = may

# Produce `Received:` message headers that include information about the
# protocol and cipher used, as well as the remote SMTP client CommonName and
# client certificate issuer CommonName.
# This is disabled by default, as the information may be modified in transit
# through other mail servers. Only information that was recorded by the final
# destination can be trusted.
#smtpd_tls_received_header = yes

# Opportunistic TLS, used when Postfix sends email to remote SMTP server.
# Use TLS if this is supported by the remote SMTP server, otherwise use
# plaintext.
# References:
#   - http://www.postfix.org/TLS_README.html#client_tls_may
#   - http://www.postfix.org/postconf.5.html# … rity_level
smtp_tls_security_level = may

# Use the same CA file as smtpd.
smtp_tls_CAfile = $smtpd_tls_CAfile
smtp_tls_note_starttls_offer = yes

# Enable long, non-repeating, queue IDs (queue file names).
# The benefit of non-repeating names is simpler logfile analysis and easier
# queue migration (there is no need to run "postsuper" to change queue file
# names that don't match their message file inode number).
#enable_long_queue_ids = yes

# Reject unlisted sender and recipient
smtpd_reject_unlisted_recipient = yes
smtpd_reject_unlisted_sender = yes

# Header and body checks with PCRE table
header_checks = pcre:/etc/postfix/header_checks
body_checks = pcre:/etc/postfix/body_checks.pcre

# A mechanism to transform commands from remote SMTP clients.
# This is a last-resort tool to work around client commands that break
# interoperability with the Postfix SMTP server. Other uses involve fault
# injection to test Postfix's handling of invalid commands.
# Requires Postfix-2.7+.
#smtpd_command_filter = pcre:/etc/postfix/command_filter.pcre

# HELO restriction
smtpd_helo_required = yes
smtpd_helo_restrictions =
    permit_mynetworks
    permit_sasl_authenticated
    check_helo_access pcre:/etc/postfix/helo_access.pcre
    reject_non_fqdn_helo_hostname
    reject_unknown_helo_hostname

# Sender restrictions
smtpd_sender_restrictions =
    reject_unknown_sender_domain
    reject_non_fqdn_sender
    reject_unlisted_sender
    permit_mynetworks
    permit_sasl_authenticated
    check_sender_access pcre:/etc/postfix/sender_access.pcre

# Recipient restrictions
smtpd_recipient_restrictions =
    reject_unknown_recipient_domain
    reject_non_fqdn_recipient
    reject_unlisted_recipient
    check_policy_service inet:127.0.0.1:7777
    permit_mynetworks
    permit_sasl_authenticated
    reject_unauth_destination

# END-OF-MESSAGE restrictions
smtpd_end_of_data_restrictions =
    check_policy_service inet:127.0.0.1:7777

# Data restrictions
smtpd_data_restrictions = reject_unauth_pipelining

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

# Avoid duplicate recipient messages. Default is 'yes'.
enable_original_recipient = no

# Virtual support.
virtual_minimum_uid = 2000
virtual_uid_maps = static:2000
virtual_gid_maps = static:2000
virtual_mailbox_base = /var/vmail

# Do not set virtual_alias_domains.
virtual_alias_domains =

#
# Enable SASL authentication on port 25 and force TLS-encrypted SASL authentication.
# WARNING: NOT RECOMMENDED to enable smtp auth on port 25, all end users should
#          be forced to submit email through port 587 instead.
#
#smtpd_sasl_auth_enable = yes
#smtpd_sasl_security_options = noanonymous
#smtpd_tls_auth_only = yes

# hostname
myhostname = mail.exmp.com
myorigin = /etc/mailname
mydomain = exmp.com

# trusted SMTP clients which are allowed to relay mail through Postfix.
#
# Note: additional IP addresses/networks listed in mynetworks should be listed
#       in iRedAPD setting 'MYNETWORKS' (in `/opt/iredapd/settings.py`) too.
#       for example:
#
#       MYNETWORKS = ['xx.xx.xx.xx', 'xx.xx.xx.0/24', ...]
#
mynetworks = 127.0.0.1 [::1]

# Accepted local emails
mydestination = $myhostname, localhost, localhost.localdomain

alias_maps = hash:/etc/postfix/aliases
alias_database = hash:/etc/postfix/aliases

# Default message_size_limit.
message_size_limit = 900000000

# The set of characters that can separate a user name from its extension
# (example: user+foo), or a .forward file name from its extension (example:
# .forward+foo).
# Postfix 2.11 and later supports multiple characters.
recipient_delimiter = +

# The time after which the sender receives a copy of the message headers of
# mail that is still queued. Default setting is disabled (0h) by Postfix.
#delay_warning_time = 1h
#
# Lookup virtual mail accounts
#
transport_maps =
    proxy:mysql:/etc/postfix/mysql/transport_maps_user.cf
    proxy:mysql:/etc/postfix/mysql/transport_maps_domain.cf

sender_dependent_relayhost_maps =
    proxy:mysql:/etc/postfix/mysql/sender_dependent_relayhost_maps.cf

# Lookup table with the SASL login names that own the sender (MAIL FROM) addresses.
smtpd_sender_login_maps =
    proxy:mysql:/etc/postfix/mysql/sender_login_maps.cf

virtual_mailbox_domains =
    proxy:mysql:/etc/postfix/mysql/virtual_mailbox_domains.cf

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

virtual_mailbox_maps =
    proxy:mysql:/etc/postfix/mysql/virtual_mailbox_maps.cf

virtual_alias_maps =
    proxy:mysql:/etc/postfix/mysql/virtual_alias_maps.cf
    proxy:mysql:/etc/postfix/mysql/domain_alias_maps.cf
    proxy:mysql:/etc/postfix/mysql/catchall_maps.cf
    proxy:mysql:/etc/postfix/mysql/domain_alias_catchall_maps.cf

sender_bcc_maps =
    proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_user.cf
    proxy:mysql:/etc/postfix/mysql/sender_bcc_maps_domain.cf

recipient_bcc_maps =
    proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_user.cf
    proxy:mysql:/etc/postfix/mysql/recipient_bcc_maps_domain.cf

#
# Postscreen
#
postscreen_greet_action = enforce
postscreen_blacklist_action = enforce
postscreen_dnsbl_action = enforce
postscreen_dnsbl_threshold = 2
postscreen_dnsbl_sites =
    zen.spamhaus.org=127.0.0.[2..11]*3
    b.barracudacentral.org=127.0.0.[2..11]*2

postscreen_dnsbl_reply_map = texthash:/etc/postfix/postscreen_dnsbl_reply
postscreen_access_list = permit_mynetworks cidr:/etc/postfix/postscreen_access.cidr

# Require Postfix-2.11+
postscreen_dnsbl_whitelist_threshold = -2
#
# Dovecot SASL support.
#
smtpd_sasl_type = dovecot
smtpd_sasl_path = private/dovecot-auth
virtual_transport = dovecot
dovecot_destination_recipient_limit = 1

#
# Amavisd + SpamAssassin + ClamAV
#
content_filter = smtp-amavis:[127.0.0.1]:10024

# Concurrency per recipient limit.
smtp-amavis_destination_recipient_limit = 1
relayhost =
mailbox_size_limit = 0
mailbox_command = procmail -a "$EXTENSION"

Post's attachments

Ekran Alıntısı.PNG
Ekran Alıntısı.PNG 36.36 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.