LinuxForum.Fans
Тема

Dovecot и все-все-все

Автор: AlexLinux 40 сообщений 12098 просмотров
16.06.2010 10:42 #51800

Добрый день отстраиваю связку
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

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

16.06.2010 11:01 #51811

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

16.06.2010 11:04 #51814

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

16.06.2010 11:06 #51815

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

16.06.2010 11:12 #51819

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

16.06.2010 11:16 #51820
text
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 {
}
16.06.2010 11:47 #51826

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

16.06.2010 11:50 #51827

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

16.06.2010 11:54 #51830

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'

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

16.06.2010 11:57 #51832

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

16.06.2010 12:00 #51833

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

16.06.2010 12:00 #51834
text
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'
16.06.2010 12:06 · отредактировано #51838

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

text
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'

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

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

16.06.2010 12:24 #51843
text
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'

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

16.06.2010 12:25 #51845

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

16.06.2010 14:40 #51881
text
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
16.06.2010 14:41 #51882

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

16.06.2010 14:43 #51883

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

16.06.2010 14:46 #51887
text
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
Войдите или зарегистрируйтесь, чтобы ответить.