1

Добрый день отстраиваю связку
1.
сервера;
MySQL, именно в базе данных мы будем хранить почтовые аккаунты; 2.
Dovecot, предоставляет сервисы POP3/IMAP для пользователей сервера; 3.
Clamd (ClamAV Daemon), отвечает за проверку почту на наличие  4.
вирусов;
ClamSMTP, связывает работу Posti  x и ClamAV между собой; 5.
Spamassassin, отвечает за проверку почты на наличие SPAM-сообщений; 6.
Posti  xadmin – веб-интерфейс для управления Posti  x; 7.
Squirrelmail – веб-интерфейс для пользователей почтового сервера

по инструкции из книги Видеокурс
«17 Технологий ИТ»

Все работает кроме Dovecot
Squirrelmail выдает ошибку
Error connecting to IMAP server: localhost.
111 : Connection refused

nmap  после сканирования пишет  Not shown: 995 closed ports
PORT    STATE SERVICE
22/tcp  open  ssh
53/tcp  open  domain
80/tcp  open  http
111/tcp open  rpcbind
443/tcp open  https

Что делать ума не приложу? помогите плиз

2

Будьте добры, измените название темы на нормальное

3

dovecot вообще запущен?

4

dovecot неживой, но подсистема заблокирована

5

потому белка приконнектиться и не может... выкладывайте конфиги и логи довкота

6

base_dir = /var/run/dovecot/
protocols = imap pop3
   protocol imap {
     listen = *:143
   }
   protocol pop3 {
     listen = *:110
   }
log_timestamp = «%Y-%m-%d %H:%M:%S»
syslog_facility = mail
mail_location = maildir:/var/vmail/%d/%u
mail_debug = yes
fi  rst_valid_uid = 1000
last_valid_uid = 1000
maildir_copy_with_hardlinks = yes
protocol imap {
  login_executable = /usr/libexec/dovecot/imap-login
  mail_executable = /usr/libexec/dovecot/imap
  imap_max_line_length = 65536
}
protocol pop3 {
  login_executable = /usr/libexec/dovecot/pop3-login
  mail_executable = /usr/libexec/dovecot/pop3
  pop3_uidl_format = %08Xu%08Xv
}
protocol lda {
  postmaster_address = postmaster@company.ru
  sendmail_path = /usr/lib/sendmail
  auth_socket_path = /var/run/dovecot/auth-master
}
auth_verbose = yes
auth_debug = yes
auth_debug_passwords = yes
auth default {

mechanisms = plain
  passdb pam {
  }

passdb sql {
    args = /etc/dovecot-sql.conf
  }
  userdb passwd {
  }
  userdb sql {
    args = /etc/dovecot-sql.conf
  }
  user = nobody
  socket listen {
    master {
      path = /var/run/dovecot/auth-master
      mode = 0660
      user = vmail
      group = mail
    }
    client {
      path = /var/spool/postfi  x/private/auth
      mode = 0660
      user = postfi  x
      group = postfi  x
    }
  }
}
dict {
}
plugin {
}

7

dovecot: Jun 16 13:41:34 Error: Auth process died too early - shutting down
dovecot: Jun 16 13:41:34 Error: auth(default): Error in configuration file /etc/dovecot-sql.conf line 5: Expecting '='
dovecot: Jun 16 13:41:34 Error: child 3543 (auth) returned error 89
dovecot: Jun 16 13:41:40 Error: Auth process died too early - shutting down
dovecot: Jun 16 13:41:40 Error: auth(default): Error in configuration file /etc/dovecot-sql.conf line 5: Expecting '='
dovecot: Jun 16 13:41:40 Error: child 3563 (auth) returned error 89
dovecot: Jun 16 13:44:27 Error: Auth process died too early - shutting down
dovecot: Jun 16 13:44:27 Error: auth(default): Error in configuration file /etc/dovecot-sql.conf line 5: Expecting '='
dovecot: Jun 16 13:44:27 Error: child 3627 (auth) returned error 89

8

проверяйте 5 строку в /etc/dovecot-sql.conf

9

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=password
default_pass_scheme = MD5
user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail,
1000 AS uid, 12 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox
WHERE username = '%u' AND active = '1'
password_query = SELECT username as user, password, '/var/vmail/%d/%n' asuserdb_
home, 'maildir:/var/vmail/%d/%n' as userdb_mail, 1000 as userdb_uid, 12 asuserdb_gid
FROM mailbox WHERE username = '%u' AND active = '1'

немогу понять что не то

10

Вы конфиги заключайте с тэги <code>, иначе не понятно, где какие строки

11

насколько я понимаю, вокруг знака "=" должны быть пробелы... проверьте у себя

12

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=password
default_pass_scheme = MD5
user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail,
1000 AS uid, 12 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox
WHERE username = '%u' AND active = '1'
password_query = SELECT username as user, password, '/var/vmail/%d/%n' asuserdb_
home, 'maildir:/var/vmail/%d/%n' as userdb_mail, 1000 as userdb_uid, 12 asuserdb_gid
FROM mailbox WHERE username = '%u' AND active = '1'

13 (16.06.2010 12:12:18 отредактировано Hrafn)

еще вопрос: у Вас вот эта часть:

user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail,
1000 AS uid, 12 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox
WHERE username = '%u' AND active = '1'

в одну строку?

если нет, перенесите в одну строку
и запрос пароля из базы также в одну строку

14

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=password
default_pass_scheme = MD5
user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail, 1000 AS uid, 12 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1'
password_query = SELECT username as user, password, '/var/vmail/%d/%n'asuserdb_home, 'maildir:/var/vmail/%d/%n' as userdb_mail, 1000 as userdb_uid, 12 asuserdb_gid FROM mailbox WHERE username = '%u' AND active = '1'

РЕСПЕК И УВАЖУХА УВАЖАЕМЫЙ ВСЕ РАБОТАЕТ ))))))

15

Рад был помочь. На будущее - запросы к базе пишите в одну строку, проще будет ab

16

Jun 16 16:35:33 surgut-mosap sendmail[5157]: o5GAZXdO005157: from=root, size=55, class=0, nrcpts=1, msgid=<201006161035.o5GAZXdO005157@surgut-mosap.ru>, relay=root@localhost
Jun 16 16:35:33 surgut-mosap postfix/smtpd[5158]: connect from localhost[127.0.0.1]
Jun 16 16:35:33 surgut-mosap postfix/smtpd[5158]: E6E1C3267B1: client=localhost[127.0.0.1]
Jun 16 16:35:33 surgut-mosap postfix/cleanup[5163]: E6E1C3267B1: message-id=<201006161035.o5GAZXdO005157@surgut-mosap.ru>
Jun 16 16:35:33 surgut-mosap postfix/qmgr[5154]: E6E1C3267B1: from=<root@surgut-mosap.ru>, size=545, nrcpt=1 (queue active)
Jun 16 16:35:33 surgut-mosap postfix/qmgr[5154]: warning: connect to transport scan: Connection refused
Jun 16 16:35:33 surgut-mosap sendmail[5157]: o5GAZXdO005157: to=adminmosap@surut-mosap.ru, ctladdr=root (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=30055, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (Ok: queued as E6E1C3267B1)
Jun 16 16:35:34 surgut-mosap postfix/smtpd[5158]: disconnect from localhost[127.0.0.1]
Jun 16 16:36:25 surgut-mosap postfix/qmgr[5154]: warning: connect to transport spamfilter: Connection refused
Jun 16 16:36:33 surgut-mosap postfix/qmgr[5154]: warning: connect to transport scan: Connection refused
Jun 16 16:37:25 surgut-mosap postfix/qmgr[5154]: warning: connect to transport spamfilter: Connection refused
Jun 16 16:37:33 surgut-mosap postfix/qmgr[5154]: warning: connect to transport scan: Connection refused
Jun 16 16:38:25 surgut-mosap postfix/qmgr[5154]: warning: connect to transport spamfilter: Connection refused
Jun 16 16:38:33 surgut-mosap postfix/qmgr[5154]: warning: connect to transport scan: Connection refused
Jun 16 16:39:25 surgut-mosap postfix/qmgr[5154]: warning: connect to transport spamfilter: Connection refused
Jun 16 16:39:33 surgut-mosap postfix/qmgr[5154]: warning: connect to transport scan: Connection refused

17

Снова ошибки почта не понятно куда уходит

18

конфиги всего в студию ab

19

alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
content_filter = scan:127.0.0.1:10025
daemon_directory = /usr/libexec/postfix
debug_peer_level = 2
default_privs = nobody
html_directory = no
inet_interfaces = all
local_recipient_maps = $virtual_mailbox_maps, $virtual_alias_maps
mail_owner = postfix
mail_spool_directory = /var/spool/mail
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
mydestination = $myhostname#, localhost.$mydomain, localhost
mydomain = surgut-mosap.ru
myhostname = mail.surgut-mosap.ru
mynetworks = 127.0.0.0/8,192.168.1.0/24
myorigin = $mydomain
newaliases_path = /usr/bin/newaliases.postfix
queue_directory = /var/spool/postfix
readme_directory = /usr/share/doc/postfix-2.3.3/README_FILES
receive_override_options = no_address_mappings
sample_directory = /usr/share/doc/postfix-2.3.3/samples
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
smtpd_banner = $myhostname ESMTP
smtpd_recipient_restrictions = permit_mynetworks,            permit_sasl_authenticated,            reject_unauth_destination,            reject_non_fqdn_recipient,            reject_unverified_recipient,            reject_rbl_client cbl.abuseat.org,            reject_rbl_client dialups.mail-abuse.org,
smtpd_sasl_auth_enable = yes
smtpd_sasl_exceptions_networks = $mynetworks
smtpd_sasl_path = private/auth
smtpd_sasl_security_options = noanonymous
smtpd_sasl_type = dovecot
soft_bounce = no
unknown_local_recipient_reject_code = 550
virtual_alias_maps = mysql:$config_directory/sql/valias.cf
virtual_gid_maps = static:12
virtual_mailbox_base = /var/vmail
virtual_mailbox_domains = mysql:$config_directory/sql/vdomains.cf
virtual_mailbox_maps = mysql:$config_directory/sql/vmailbox.cf
virtual_minimum_uid = 1000
virtual_transport = dovecot
virtual_uid_maps = static:1000

20

и master.cf

21

#
# Postfix master process configuration file.  For details on the format
# of the file, see the master(5) manual page (command: "man 5 master").
#
# ==========================================================================
# service type  private unpriv  chroot  wakeup  maxproc command + args
#               (yes)   (yes)   (yes)   (never) (100)
# ==========================================================================
smtp      inet  n       -       n       -       -       smtpd
  #   -o content_filter=spamfilter:dummy
#submission inet n       -       n       -       -       smtpd
#  -o smtpd_enforce_tls=yes
#  -o smtpd_sasl_auth_enable=yes
#  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#smtps     inet  n       -       n       -       -       smtpd
#  -o smtpd_tls_wrappermode=yes
#  -o smtpd_sasl_auth_enable=yes
#  -o smtpd_client_restrictions=permit_sasl_authenticated,reject
#628      inet  n       -       n       -       -       qmqpd
pickup    fifo  n       -       n       60      1       pickup
cleanup   unix  n       -       n       -       0       cleanup
qmgr      fifo  n       -       n       300     1       qmgr
#qmgr     fifo  n       -       n       300     1       oqmgr
tlsmgr    unix  -       -       n       1000?   1       tlsmgr
rewrite   unix  -       -       n       -       -       trivial-rewrite
bounce    unix  -       -       n       -       0       bounce
defer     unix  -       -       n       -       0       bounce
trace     unix  -       -       n       -       0       bounce
verify    unix  -       -       n       -       1       verify
flush     unix  n       -       n       1000?   0       flush
proxymap  unix  -       -       n       -       -       proxymap
smtp      unix  -       -       n       -       -       smtp
# When relaying mail as backup MX, disable fallback_relay to avoid MX loops
relay     unix  -       -       n       -       -       smtp
        -o fallback_relay=
#       -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
showq     unix  n       -       n       -       -       showq
error     unix  -       -       n       -       -       error
discard   unix  -       -       n       -       -       discard
local     unix  -       n       n       -       -       local
virtual   unix  -       n       n       -       -       virtual
lmtp      unix  -       -       n       -       -       lmtp
anvil     unix  -       -       n       -       1       anvil
scache    unix  -       -       n       -       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/local/bin/maildrop -d ${recipient}
#
# The Cyrus deliver program has changed incompatibly, multiple times.
#
old-cyrus unix  -       n       n       -       -       pipe
  flags=R user=cyrus argv=/usr/lib/cyrus-imapd/deliver -e -m ${extension} ${user}
# Cyrus 2.1.5 (Amos Gouaux)
# Also specify in main.cf: cyrus_destination_recipient_limit=1
cyrus     unix  -       n       n       -       -       pipe
  user=cyrus argv=/usr/lib/cyrus-imapd/deliver -e -r ${sender} -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=foo argv=/usr/local/sbin/bsmtp -f $sender $nexthop $recipient

dovecot unix    -       n       n       -       -       pipe
  fiags=DRhu user=vmail:mail argv=/usr/libexec/dovecot/deliver -d $(recipient)


#scan unix - - n - 16 smtp -o smtp_send_xforward_command=yes
#127.0.0.1:10026 inet n - n - 16 smtpd
#         -o content_filter=
        # -o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
       #  -o smtpd_helo_restrictions=
      #   -o smtpd_client_restrictions=
     #    -o smtpd_sender_restrictions=
    #     -o smtpd_recipient_restrictions=permit_mynetworks,reject
  ##       -o mynetworks_style=host
 #        -o smtpd_authorized_xforward_hosts=127.0.0.0/8
#-o content_filter=filter

22 (16.06.2010 15:05:20 отредактировано Hrafn)

AlexLinux пишет:

#scan unix - - n - 16 smtp -o smtp_send_xforward_command=yes
#127.0.0.1:10026 inet n - n - 16 smtpd
#         -o content_filter=
        # -o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
       #  -o smtpd_helo_restrictions=
      #   -o smtpd_client_restrictions=
     #    -o smtpd_sender_restrictions=
    #     -o smtpd_recipient_restrictions=permit_mynetworks,reject
  ##       -o mynetworks_style=host
#        -o smtpd_authorized_xforward_hosts=127.0.0.0/8
#-o content_filter=filter

почему закомментировано?

почитайте тут:
http://ubuntologia.ru/forum/viewtopic.p … amp;t=2299
пункт №10

23

не как?

24

ругался на транспорт

25

я решил выключить антиспам

26 (16.06.2010 15:06:47 отредактировано Hrafn)

Hrafn пишет:

почитайте тут:
http://ubuntologia.ru/forum/viewtopic.p … amp;t=2299
пункт №10

27

Jun 16 16:34:09 surgut-mosap sendmail[5077]: o5GAY94d005077: from=root, size=56, class=0, nrcpts=1, msgid=<201006161034.o5GAY94d005077@surgut-mosap.ru>, relay=root@localhost
Jun 16 16:34:09 surgut-mosap postfix/smtpd[5078]: connect from localhost[127.0.0.1]
Jun 16 16:34:09 surgut-mosap postfix/smtpd[5078]: 8B5F23267B0: client=localhost[127.0.0.1]
Jun 16 16:34:09 surgut-mosap postfix/cleanup[5083]: 8B5F23267B0: message-id=<201006161034.o5GAY94d005077@surgut-mosap.ru>
Jun 16 16:34:09 surgut-mosap sendmail[5077]: o5GAY94d005077: to=adminmosap@surut-mosap.ru, ctladdr=root (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=30056, relay=[127.0.0.1] [127.0.0.1], dsn=2.0.0, stat=Sent (Ok: queued as 8B5F23267B0)
Jun 16 16:34:09 surgut-mosap postfix/qmgr[5073]: 8B5F23267B0: from=<root@surgut-mosap.ru>, size=546, nrcpt=1 (queue active)
Jun 16 16:34:09 surgut-mosap postfix/qmgr[5073]: 8B5F23267B0: to=<adminmosap@surut-mosap.ru>, relay=none, delay=0.09, delays=0.08/0.01/0/0, dsn=4.3.0, status=deferred (mail transport unavailable)
Jun 16 16:34:09 surgut-mosap postfix/smtpd[5078]: disconnect from localhost[127.0.0.1]
Jun 16 16:34:59 surgut-mosap postfix/qmgr[5073]: warning: connect to transport spamfilter: Connection refused

28

Просто лучше уж делать последовательно. Если намеряны использовать антиспам, то смысл его отключать?

29

почитайте тут:
http://ubuntologia.ru/forum/viewtopic.p … amp;t=2299
пункт №10

не работает

30

Я согласен но он ругался на транспорт