Roundcube не берет пароли.

[klaster]

Связка exim-4.72+dovecot-1.2.14_1+postfixadmin-2.3.2+clamav-0.96.5 +roundcube-0.4.2,1
Создаю почтовые ящики в postfixadmin задаю пароль, пробую зайти в roundcube пишет login failad. Где копать, если какой конфиг надо выложу.

mailog если останавливаешь и включаешь dovecot :

Код: Выделить всё

Jan  5 12:48:13 gipernet dovecot: dovecot: Killed with signal 15 (by pid=1635 uid=0 code=kill)
Jan  5 12:48:17 gipernet dovecot: Dovecot v1.2.14 starting up
Jan  5 12:48:17 gipernet dovecot: auth-worker(default): mysql: Connected to localhost (exim)
Jan  5 12:48:18 gipernet dovecot: auth(default): new auth connection: pid=1663
Jan  5 12:48:18 gipernet dovecot: auth(default): new auth connection: pid=1665
Jan  5 12:48:18 gipernet dovecot: auth(default): new auth connection: pid=1662
Jan  5 12:48:18 gipernet dovecot: auth(default): new auth connection: pid=1664
Jan  5 12:48:18 gipernet dovecot: auth(default): new auth connection: pid=1666
Jan  5 12:48:18 gipernet dovecot: auth(default): new auth connection: pid=1667

а это если водишь в roundcube логин и пароль :

Код: Выделить всё

Jan  5 12:51:39 gipernet dovecot: auth(default): client in: AUTH        1      PLAIN    service=imap    secured lip=127.0.0.1   rip=127.0.0.1   lport=143      rport=15694      resp=<hidden>
Jan  5 12:51:39 gipernet dovecot: auth-worker(default): sql(info@gipernet.eu,127.0.0.1): query: SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'info@gipernet.eu' AND `active`='1'
Jan  5 12:51:39 gipernet dovecot: auth-worker(default): sql(info@gipernet.eu,127.0.0.1): Password mismatch
Jan  5 12:51:40 gipernet dovecot: auth(default): new auth connection: pid=1670
Jan  5 12:51:41 gipernet dovecot: auth(default): client out: FAIL       1      user=info@gipernet.eu
Jan  5 12:51:46 gipernet dovecot: imap-login: Disconnected (auth failed, 1 attempts): user=<info@gipernet.eu>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured

[Хостинг HostFood.ru]

Тарифы на хостинг в России, от 12 рублей: https://www.host-food.ru/tariffs/hosting/
Тарифы на виртуальные сервера (VPS/VDS/KVM) в РФ, от 189 руб.: https://www.host-food.ru/tariffs/virtualny-server-vps/
Выделенные сервера, Россия, Москва, от 2000 рублей (HP Proliant G5, Intel Xeon E5430 (2.66GHz, Quad-Core, 12Mb), 8Gb RAM, 2x300Gb SAS HDD, P400i, 512Mb, BBU):
https://www.host-food.ru/tariffs/vydelennyi-server-ds/
Недорогие домены в популярных зонах: https://www.host-food.ru/domains/

[xM]

Так это... Написано же...

Jan 5 12:51:39 gipernet dovecot: auth-worker(default): sql(info@gipernet.eu,127.0.0.1): Password mismatch

Проверьте идентичность схем шифрования пароля.

[xM]

Т.е. переменная default_pass_scheme в dovecot-sql.conf (у меня - CRAM-MD5) должна соответствовать указанной в переменной $CONF['encrypt'] в config.inc.php Postfixadmin'а (у меня - 'dovecot:CRAM-MD5').

[klaster]

Exim работает в порядке там мои заморочки именно с настройками были, но все равно когда проверяю через локалхост отправку выдает ошибку :

Код: Выделить всё

gipernet# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 mail.gipernte.eu, ESMTP EXIM 4.72
Helo gipernet.eu
250 mail.gipernte.eu Hello gipernet.eu [127.0.0.1]
Mail from: test@gipernet.eu
250 OK
Rcpt to: inf@gipernet.eu
250 Accepted
DATA
354 Enter message, ending with "." on a line by itself
To: test@gipernet.eu
From: info@gipernet.eu
Subject: Test
Hi!
This is a test.
.
451 Temporary local problem - please try later
Quit
221 mail.gipernte.eu closing connection
Connection closed by foreign host.

Jan  6 19:25:56 gipernet exim[2067]: exim 4.72 daemon started: pid=2067, -q30m, listening for SMTP on port 25 (IPv4) and for SMTPS on port 465 (IPv4)
Jan  6 19:28:00 gipernet exim[2070]: SMTP syntax error in "\377\364\377\375\006" H=(gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25 unrecognized command
Jan  6 19:29:12 gipernet exim[2070]: unexpected disconnection while reading SMTP command from (gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25
Jan  6 19:35:48 gipernet exim[2072]: 1PatjA-0000XQ-3D malware acl condition: unable to connect to sophie UNIX socket (/var/run/sophie). errno=2
Jan  6 19:35:48 gipernet exim[2072]: 1PatjA-0000XQ-3D malware acl condition: unable to connect to sophie UNIX socket (/var/run/sophie). errno=2
Jan  6 19:35:48 gipernet exim[2072]: 1PatjA-0000XQ-3D H=(gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25 F=<test@gipernet.eu> temporarily rejected after DATA
Jan  6 19:35:48 gipernet exim[2072]: [1\11] 1PatjA-0000XQ-3D H=(gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25 F=<test@gipernet.eu> temporarily rejected after DATA
Jan  6 19:35:48 gipernet exim[2072]: [2\11] Envelope-from: <test@gipernet.eu>
Jan  6 19:35:48 gipernet exim[2072]: [3\11] Envelope-to: <inf@gipernet.eu>
Jan  6 19:35:48 gipernet exim[2072]: [4\11] P Received: from [127.0.0.1] (helo=gipernet.eu)
Jan  6 19:35:48 gipernet exim[2072]: [5\11]    by mail.gipernte.eu with smtp (Exim 4.72 (FreeBSD))
Jan  6 19:35:48 gipernet exim[2072]: [6\11]    (envelope-from <test@gipernet.eu>)
Jan  6 19:35:48 gipernet exim[2072]: [7\11]    id 1PatjA-0000XQ-3D
Jan  6 19:35:48 gipernet exim[2072]: [8\11]    for inf@gipernet.eu; Thu, 06 Jan 2011 19:35:48 +0200
Jan  6 19:35:48 gipernet exim[2072]: [9\11] T To: test@gipernet.eu
Jan  6 19:35:48 gipernet exim[2072]: [10\11] F From: info@gipernet.eu
Jan  6 19:35:48 gipernet exim[2072]: [11/11]   Subject: Test

Я понемаю что не работает SMTP но где копать.

[GrayLAN]

не знаю что такое "sophie", но у тебя его либо нет, либо он не запущен, либо настроен не так как ожидает exim...
для начала вытри из конфига обращение к нему.

[ADRE]

отключите в acl правила проверки писем антивирусом софи - антивирус.

[Alex Keda]

отключите в acl правила проверки писем антивирусом софи - антивирус.

уточню
он дефолтовый антивирус. и если сказано юзать антивирус, и не сказано какой юзать - пытается прислюнявиться именно к нему

[klaster]

Подправил конфиг Exima, на него вроде не ругаеться но зато начал ругаться на dovecot :

Права на папку : /var/mail/exim
drwxrwxr-x 3 mailnull mail 512 Jan 6 14:55 exim

Код: Выделить всё

Jan  7 15:58:06 gipernet dovecot: dovecot: Killed with signal 15 (by pid=1949 uid=0 code=kill)
Jan  7 15:58:06 gipernet dovecot: Dovecot v1.2.14 starting up
Jan  7 15:58:06 gipernet dovecot: auth-worker(default): mysql: Connected to localhost (exim)
Jan  7 16:00:04 gipernet exim[1972]: 1PbCqX-0000Vo-TQ <= test@gipernet.eu H=(mail.gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25 P=smtp S=319 from <test@gipernet.eu> for info@gipernet.eu
Jan  7 16:00:04 gipernet dovecot: deliver(info@gipernet.eu): auth input: home=/var/mail/exim/gipernet.eu/info/
Jan  7 16:00:04 gipernet dovecot: deliver(info@gipernet.eu): auth input: uid=26
Jan  7 16:00:04 gipernet dovecot: deliver(info@gipernet.eu): auth input: gid=26
Jan  7 16:00:04 gipernet dovecot: deliver(info@gipernet.eu): maildir: data=/var/mail/exim/gipernet.eu/info
Jan  7 16:00:04 gipernet dovecot: deliver(info@gipernet.eu): maildir++: root=/var/mail/exim/gipernet.eu/info, index=, control=, inbox=/var/mail/exim/gipernet.eu/info
Jan  7 16:00:04 gipernet dovecot: deliver(info@gipernet.eu): Namespace : Using permissions from /var/mail/exim/gipernet.eu/info: mode=0775 gid=6
Jan  7 16:00:04 gipernet dovecot: deliver(info@gipernet.eu): msgid=: saved mail to INBOX
Jan  7 16:00:04 gipernet exim[1989]: 1PbCqX-0000Vo-TQ => info <info@gipernet.eu> R=dovecot_user T=dovecot_delivery
Jan  7 16:00:04 gipernet exim[1989]: 1PbCqX-0000Vo-TQ Completed

В чем может быть проблема ?

Да вот еще посмотрите через telnet что происходит :

Код: Выделить всё

gipernet# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 mail.gipernte.eu, ESMTP EXIM 4.72
Helo mail.gipernet.eu
250 mail.gipernte.eu Hello mail.gipernet.eu [127.0.0.1]
MAIL FROM: test@gipernet.eu
250 OK
RCPT TO: info@gipernet.eu
250 Accepted
DATA
354 Enter message, ending with "." on a line by itself
To: test@gipernet.eu
From: info@gipernet.eu
Subject: Test
Subject: Test
Hi!
This is a test message.
.
250 OK id=1PbCqX-0000Vo-TQ
Quit
221 mail.gipernte.eu closing connection
Connection closed by foreign host.

Че за проблема не могу понять ?

[Alex Keda]

что именно не так?
сообщения принимаются, доставляются

[klaster]

Когда вводишь Это :
gipernet# telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 mail.gipernte.eu, ESMTP EXIM 4.72
MAIL FROM: test@gipernet.eu
250 OK
RCPT TO: info@gipernet.eu
250 Accepted
DATA
354 Enter message, ending with "." on a line by itself
To: test@gipernet.eu
From: info@gipernet.eu
Subject: Test
Hi!
Test.
.
250 OK id=1PbJ51-0000S7-QN
Quit
221 mail.gipernte.eu closing connection
Connection closed by foreign host.

Вываливаеться аот это :
Jan 7 22:41:50 gipernet dovecot: deliver(test@gipernet.eu): userdb lookup: connect(/var/run/dovecot/auth-master) failed: Permission denied (euid=26(mailnull) egid=26(mailnull) missing +r perm: /var/run/dovecot/auth-master)
Jan 7 22:41:50 gipernet exim[1758]: 1PbIfG-0000R4-2G == test@gipernet.eu R=dovecot_user T=dovecot_delivery defer (0): Child process of dovecot_delivery transport returned 75 (could mean temporary error) from command: /usr/local/libexec/dovecot/deliver
Jan 7 22:41:50 gipernet exim[1762]: 1PbIff-0000R9-GN == info@gipernet.eu R=dovecot_user T=dovecot_delivery defer (-52): Retry time not yet reached
Jan 7 22:41:50 gipernet exim[1763]: 1PbJ51-0000S7-QN == info@gipernet.eu R=dovecot_user T=dovecot_delivery defer (-52): Retry time not yet reached
Jan 7 22:41:50 gipernet exim[1764]: 1PbJ1K-0000Ry-K5 == info@gipernet.eu R=dovecot_user T=dovecot_delivery defer (-52): Retry time not yet reached
Jan 7 22:41:50 gipernet exim[1765]: 1PbIf9-0000R2-Ms Message is frozen
Jan 7 22:41:50 gipernet exim[1766]: 1PbIf9-0000Qz-KO Message is frozen

А если создаю в postfixadmin ящик вываливаеться вот это :

Jan 7 22:51:39 gipernet exim[1784]: 1PbJHe-0000Sm-W7 <= ad@gipernet.eu H=(www.gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25 P=esmtp S=506 from <ad@gipernet.eu> for sys@gipernet.eu
Jan 7 22:51:39 gipernet dovecot: deliver(sys@gipernet.eu): userdb lookup: connect(/var/run/dovecot/auth-master) failed: Permission denied (euid=26(mailnull) egid=26(mailnull) missing +r perm: /var/run/dovecot/auth-master)
Jan 7 22:51:39 gipernet exim[1785]: 1PbJHe-0000Sm-W7 == sys@gipernet.eu R=dovecot_user T=dovecot_delivery defer (0): Child process of dovecot_delivery transport returned 75 (could mean temporary error) from command: /usr/local/libexec/dovecot/deliver

Подскажите че делать 3 дня уже бьюсь ?

[ufoola]

Jan 7 22:51:39 gipernet exim[1784]: 1PbJHe-0000Sm-W7 <= ad@gipernet.eu H=(http://www.gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25 P=esmtp S=506 from <ad@gipernet.eu> for sys@gipernet.eu
Jan 7 22:51:39 gipernet dovecot: deliver(sys@gipernet.eu): userdb lookup: connect(/var/run/dovecot/auth-master) failed: Permission denied (euid=26(mailnull) egid=26(mailnull) missing +r perm: /var/run/dovecot/auth-master)
Jan 7 22:51:39 gipernet exim[1785]: 1PbJHe-0000Sm-W7 == sys@gipernet.eu R=dovecot_user T=dovecot_delivery defer (0): Child process of dovecot_delivery transport returned 75 (could mean temporary error) from command: /usr/local/libexec/dovecot/deliver

Подскажите че делать 3 дня уже бьюсь ?

В свое время с@баку на этом съел..

Jan 7 22:51:39 gipernet dovecot: deliver(sys@gipernet.eu): userdb lookup: connect(/var/run/dovecot/auth-master) failed: Permission denied (euid=26(mailnull) egid=26(mailnull) missing +r perm: /var/run/dovecot/auth-master)

Проверь права пользователя mailnull и/или группы для доступа к сокету...

С какими правами создается сокет и от чьего имени указанно в конфиге довекота:

Код: Выделить всё

  socket listen {
    master {
      path = /var/run/dovecot/auth-master
      mode = 0660
      user = mailnull
      group = mailnull 
    }
  }

[klaster]

Дошел до такого лога, когда создаешь почтовый ящик в postfixadmin, вываливаеться такая проблема.
Что только не делал и в postfixadmin create-mailbox.php добовлял полный путь /var/mai/exim но ничего не решилось начало показывать в логах не
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): Home dir not found: gipernet.eu/sus/

а

Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): Home dir not found: /var/mail/exim/gipernet.eu/sus/

Что касаеться прав то права поставил на все папки 700 вот пример

drwx------ 3 mailnull mail 512 Jan 9 00:50 exim

Вот сам лог :
________________________________________________________
Jan 10 13:39:07 gipernet exim[1578]: 1PcG5b-0000PS-7P <= ad@gipernet.eu H=(www.gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25 P=esmtp S=506 from <ad@gipernet.eu> for sus@gipernet.eu
Jan 10 13:39:07 gipernet dovecot: auth(default): master in: USER 1 sus@gipernet.eu service=deliver
Jan 10 13:39:07 gipernet dovecot: auth-worker(default): sql(sus@gipernet.eu): SELECT `maildir` AS `home`, 26 AS `uid`, 26 AS `gid` FROM `mailbox` WHERE `username` = 'sus@gipernet.eu' AND `active`='1'
Jan 10 13:39:07 gipernet dovecot: auth(default): master out: USER 1 sus@gipernet.eu home=gipernet.eu/sus/ uid=26gid=26
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): auth input: home=gipernet.eu/sus/
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): auth input: uid=26
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): auth input: gid=26
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): Home dir not found: gipernet.eu/sus/
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): maildir: data=/var/mail/exim/gipernet.eu/sus
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): maildir++: root=/var/mail/exim/gipernet.eu/sus, index=, control=, inbox=/var/mail/exim/gipernet.eu/sus
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): Namespace : Permission lookup failed from /var/mail/exim/gipernet.eu/sus
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): Namespace : Using permissions from /var/mail/exim/gipernet.eu/sus: mode=0700 gid=-1
Jan 10 13:39:07 gipernet dovecot: deliver(sus@gipernet.eu): msgid=: saved mail to INBOX
Jan 10 13:39:07 gipernet exim[1579]: 1PcG5b-0000PS-7P => sus <sus@gipernet.eu> R=dovecot_user T=dovecot_delivery
Jan 10 13:39:07 gipernet exim[1579]: 1PcG5b-0000PS-7P Completed

Подскажите где копать ?

[blade_007]

Как то сбивчиво.. опишите подробней в чем вопрос?
вот эта строчка "=> sus <sus@gipernet.eu> R=dovecot_user T=dovecot_delivery" как бы говорит что доставка работает.

"Home dir not found: /var/mail/exim/gipernet.eu/sus/" эта строчка говорит сама за себя. переменная home возвращается при userbd lookup.

[klaster]

Вообщем проблема такая не могу зайти на roundcube, когда набераю пользователя пароль и сервер происходит

Вот такой лог :

Jan 10 20:21:14 gipernet dovecot: auth(default): client in: AUTH 1 PLAIN service=imap secured lip=192.168.1.4 rip=192.168.1.4 lport=143 rport=57158 resp=AHRlc3RAZ2lwZXJuZXQuZXUATWFsaXNoa2E=
Jan 10 20:21:14 gipernet dovecot: auth-worker(default): sql(test@gipernet.eu,192.168.1.4): query: SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'test@gipernet.eu' AND `active`='1'
Jan 10 20:21:14 gipernet dovecot: auth-worker(default): sql(test@gipernet.eu,192.168.1.4): unknown user
Jan 10 20:21:14 gipernet dovecot: auth(default): new auth connection: pid=3198
Jan 10 20:21:16 gipernet dovecot: auth(default): client out: FAIL 1 user=test@gipernet.eu
Jan 10 20:21:21 gipernet dovecot: imap-login: Disconnected (auth failed, 1 attempts): user=<test@gipernet.eu>, method=PLAIN, rip=192.168.1.4, lip=192.168.1.4, secured

Вот я и капаю postfixadmin где происходит вот это :

Jan 10 20:26:15 gipernet exim[3219]: 1PcMRb-0000pv-Hf <= admin@gipernet.eu H=(www.gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25 P=esmtp S=512 from <admin@gipernet.eu> for sos@gipernet.eu
Jan 10 20:26:15 gipernet dovecot: auth(default): master in: USER 1 sos@gipernet.eu service=deliver
Jan 10 20:26:15 gipernet dovecot: auth-worker(default): sql(sos@gipernet.eu): SELECT `maildir` AS `home`, 26 AS `uid`, 26 AS `gid` FROM `mailbox` WHERE `username` = 'sos@gipernet.eu' AND `active`='1'
Jan 10 20:26:15 gipernet dovecot: auth(default): master out: USER 1 sos@gipernet.eu home=gipernet.eu/sos/ uid=26gid=26
Jan 10 20:26:15 gipernet dovecot: deliver(sos@gipernet.eu): auth input: home=gipernet.eu/sos/
Jan 10 20:26:15 gipernet dovecot: deliver(sos@gipernet.eu): auth input: uid=26
Jan 10 20:26:15 gipernet dovecot: deliver(sos@gipernet.eu): auth input: gid=26
Jan 10 20:26:15 gipernet dovecot: deliver(sos@gipernet.eu): Home dir not found: gipernet.eu/sos/
Jan 10 20:26:15 gipernet dovecot: deliver(sos@gipernet.eu): maildir: data=/var/mail/exim/gipernet.eu/sos
Jan 10 20:26:15 gipernet dovecot: deliver(sos@gipernet.eu): maildir++: root=/var/mail/exim/gipernet.eu/sos, index=, control=, inbox=/var/mail/exim/gipernet.eu/sos
Jan 10 20:26:15 gipernet dovecot: deliver(sos@gipernet.eu): Namespace : Permission lookup failed from /var/mail/exim/gipernet.eu/sos
Jan 10 20:26:15 gipernet dovecot: deliver(sos@gipernet.eu): Namespace : Using permissions from /var/mail/exim/gipernet.eu/sos: mode=0700 gid=-1
Jan 10 20:26:15 gipernet dovecot: deliver(sos@gipernet.eu): msgid=: saved mail to INBOX
Jan 10 20:26:15 gipernet exim[3220]: 1PcMRb-0000pv-Hf => sos <sos@gipernet.eu> R=dovecot_user T=dovecot_delivery
Jan 10 20:26:15 gipernet exim[3220]: 1PcMRb-0000pv-Hf Completed

Задаю права на папку chmod -R 755 /var/mail/exim .., но когда создаю пользователя всеравно пишет Namespace : Permission lookup failed from /var/mail/exim/gipernet.eu/sos ; уже устал играться с правами и с dovecot-sql.conf

Помогите плиз ?

[blade_007]

1. test@gipernet.eu, unknown user это как бы говорит, что нет такого пользователя в БД.
2. => sos <sos@gipernet.eu> R=dovecot_user T=dovecot_delivery ПИСЬМО ДОХОДИТ!.
3. Здесь написано про namespaces http://wiki1.dovecot.org/Namespaces
Permissions задаются (скорей всего у вас виртуальные пользователи) НЕ на уровне фс, а на уровне ACL (http://wiki1.dovecot.org/ACL) так что не пугайтесь данной записи.

[blade_007]

Ну и догонку http://wiki1.dovecot.org/MailLocation.

[klaster]

А в чем может быть причина того что я не могу зайти в roundcube. Что я сделал :
//> mysql -u root -p
password:******
> CREATE DATABASE roundcubemail DEFAULT CHARACTER SET utf8 \
-> COLLATE utf8_general_ci;
> GRANT ALL PRIVILEGES ON roundcubemail.* TO urcube@localhost \
-> IDENTIFIED BY 'PWD';
> use roundcubemail;
> GRANT ALL PRIVILEGES ON *.* TO urcube@localhost \
-> IDENTIFIED BY 'PWD' WITH GRANT OPTION;
>\q

Потом : mysql -u root -p roundcubemail < mysql.initial.sql

После чего добавил :

ee /usr/local/www/roundcube/config/db.inc.php
$rcmail_config['db_dsnw'] = 'mysql://urcube:PWD@localhost/roundcubemail';

Ну и ввожу roundcube :
Базовый пользователь в мускуле
Username urcube
Pass PWD
Server gipernet.eu

Ну также пытался зайти создонными пользователями в postfixadmin, ну я имею ввиду почтовые ящики, такая же самая проблема.

В базе же существует пользователь почему он пишет :
Jan 10 22:29:13 gipernet dovecot: auth(default): client in: AUTH 1 PLAIN service=imap secured lip=192.168.1.4 rip=192.168.1.4 lport=143 rport=33586 resp=AHJvdW5kY3ViZUBnaXBlcm5ldC5ldQByb3VuZEBsb2NhbGhvc3Q=
Jan 10 22:29:13 gipernet dovecot: auth-worker(default): sql(roundcube@gipernet.eu,192.168.1.4): query: SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'roundcube@gipernet.eu' AND `active`='1'
Jan 10 22:29:13 gipernet dovecot: auth-worker(default): sql(roundcube@gipernet.eu,192.168.1.4): unknown user
Jan 10 22:29:13 gipernet dovecot: auth(default): new auth connection: pid=3666
Jan 10 22:29:15 gipernet dovecot: auth(default): client out: FAIL 1 user=roundcube@gipernet.eu
Jan 10 22:29:20 gipernet dovecot: imap-login: Disconnected (auth failed, 1 attempts): user=<roundcube@gipernet.eu>, method=PLAIN, rip=192
Не могу догнать ?

[blade_007]

1. после создания пользователя в mysql сделайте
mysql> flush privileges;
либо перезапустите mysql

2. сделайте запрос в mysql
mysql> SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'roundcube@gipernet.eu' AND `active`='1' ;

и посмотрите вывод - может все-таки нет такого пользователя или запрос неправильный (не те данные подставляются)?

[klaster]

Может не правильно ввожу но получаю вот такую кашу : Что скажете про это :

mysql> SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'test@gipernet.eu' AND `active`='1' ;
ERROR 1046 (3D000): No database selected
mysql> SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'test@gipernet.eu' AND `active`='1' ; ERROR 1046 (3D000): No database selected
mysql> SELECT `kika` as `kika`, `kika` FROM `mailbox` WHERE `username` = 'kika@gipernet.eu' AND `active`='1' ;
ERROR 1046 (3D000): No database selected

log при вводе в roundcube :

Jan 10 23:37:45 gipernet dovecot: auth(default): client in: AUTH 1 PLAIN service=imap secured lip=192.168.1.4 rip=192.168.1.4 lport=143 rport=54608 resp=AGtpa2FAZ2lwZXJuZXQuZXUAa2lrYQ==
Jan 10 23:37:45 gipernet dovecot: auth-worker(default): sql(kika@gipernet.eu,192.168.1.4): query: SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'kika@gipernet.eu' AND `active`='1'
Jan 10 23:37:45 gipernet dovecot: auth-worker(default): sql(kika@gipernet.eu,192.168.1.4): Password mismatch
Jan 10 23:37:45 gipernet dovecot: auth-worker(default): sql(kika@gipernet.eu,192.168.1.4): PLAIN(kika) != '$1$99f13d49$RHLGVOVV.pme./98K2F4V/', try CRYPT scheme instead
Jan 10 23:37:45 gipernet dovecot: auth(default): new auth connection: pid=3958
Jan 10 23:37:47 gipernet dovecot: auth(default): client out: FAIL 1 user=kika@gipernet.eu
Jan 10 23:37:52 gipernet dovecot: imap-login: Disconnected (auth failed, 1 attempts): user=<kika@gipernet.eu>, method=PLAIN, rip=192.168.1.4, lip=192.168.1.4, secured

[ADRE]

Настройки Dovecot надо проверить вам, в логах достаточно информации.
А также какой вид аудентификации используется у куба? с открытым паролем или нет? поддерживает данную аудентификацию Dovecot

[blade_007]

Это к "ERROR 1046 (3D000): No database selected"
mysql> use roundcubemail;
mysql> ваш_запрос;

В dovecot-sql.conf (или как он у вас называется) попробуйте добавить/изменить default_pass_scheme=CRYPT, либо в конфигах roundcube смотрите опцию imap_auth_type. Т.е. и там и там должно совпадать.

[klaster]

Привожу конфиг
dovecot-sql.conf

Код: Выделить всё

driver = mysql
connect = host=localhost dbname=exim user=exim password=exim
default_pass_scheme = PLAIN
password_query = SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = '%n@%d' AND `active`='1'
user_query = SELECT `maildir` AS `home`, 26 AS `uid`, 26 AS `gid` FROM `mailbox` WHERE `username` = '%n@%d' AND `active`='1'

dovecot.conf :

Код: Выделить всё

base_dir = /var/run/dovecot/
protocols = imap pop3 imaps pop3s
listen = *
###disable_plaintext_auth = no
###shutdown_clients = yes
#log_path =
#info_log_path =
log_timestamp = "%b %d %H:%M:%S "
syslog_facility = mail
#ssl_listen =
###ssl = yes
ssl_cert_file = /etc/dovecot/ssl/dovecot.crt
ssl_key_file = /etc/dovecot/ssl/dovecot.key
#ssl_key_password =
#ssl_ca_file =
#ssl_verify_client_cert = no
#ssl_cert_username_field = commonName
#ssl_parameters_regenerate = 168
#ssl_cipher_list = ALL:!LOW:!SSLv2
#verbose_ssl = no
login_dir = /var/run/dovecot/login
login_chroot = yes
login_user = dovecot
login_process_size = 64
login_process_per_connection = yes
login_processes_count = 3
login_max_processes_count = 128
login_max_connections = 256
login_greeting = Dovecot ready.
#login_trusted_networks =
login_log_format_elements = user=<%u> method=%m rip=%r lip=%l %c
login_log_format = %$: %s
mail_location = maildir:/var/mail/exim/%d/%n
mail_debug = yes
#mail_log_prefix = "%Us(%u): "
#mail_log_max_lines_per_sec = 10
#mmap_disable = no
#dotlock_use_excl = yes
#fsync_disable = no
#mail_nfs_index = no
#lock_method = fcntl
#mail_drop_priv_before_exec = no
verbose_proctitle = yes
first_valid_uid = 26
#last_valid_uid = 0
first_valid_gid = 6
#last_valid_gid = 0
#max_mail_processes = 512
#mail_process_size = 256
#mail_max_keyword_length = 50
#valid_chroot_dirs =
#mail_chroot =
#mail_cache_min_mail_count = 0
#mailbox_idle_check_interval = 30
#mail_save_crlf = no
#maildir_stat_dirs = no
maildir_copy_with_hardlinks = yes
#maildir_copy_preserve_filename = no
#maildir_very_dirty_syncs = no
#mbox_read_locks = fcntl
#mbox_write_locks = dotlock fcntl
#mbox_lock_timeout = 300
#mbox_dotlock_change_timeout = 120
#mbox_dirty_syncs = yes
#mbox_very_dirty_syncs = no
#mbox_lazy_writes = yes
#mbox_min_index_size = 0
#dbox_rotate_size = 2048
#dbox_rotate_min_size = 16
#dbox_rotate_days = 0
protocol imap {
  imap_client_workarounds = delay-newmail netscape-eoh tb-extra-mailbox-sep
}
protocol pop3 {
  #pop3_enable_last = no
  #pop3_reuse_xuidl = no
  #pop3_lock_session = no
  pop3_uidl_format = %08Xu%08Xv
  #pop3_save_uidl = no
  #pop3_logout_format = top=%t/%p, retr=%r/%b, del=%d/%m, size=%s
  #mail_max_userip_connections = 3
  #mail_plugins =
  #mail_plugin_dir = /usr/local/lib/dovecot/pop3
  pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
}
protocol lda {
  postmaster_address = postmaster@gipernet.eu
  #hostname =
  #mail_plugins =
  #mail_plugin_dir = /usr/local/lib/dovecot/lda
  #quota_full_tempfail = no
  #deliver_log_format = msgid=%m: %$
  sendmail_path = /usr/sbin/sendmail
  #rejection_subject = Rejected: %s
  auth_socket_path = /var/run/dovecot/auth-master
}
#auth_executable = /usr/local/libexec/dovecot/dovecot-auth
#auth_process_size = 256
#auth_cache_size = 0
#auth_cache_ttl = 3600
#auth_cache_negative_ttl = 3600
#auth_realms =
#auth_default_realm =
#auth_username_chars = abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.-_@
#auth_username_translation =
#auth_username_format = %Lu
#auth_master_user_separator =
#auth_anonymous_username = anonymous
auth_verbose = yes
auth_debug = yes
auth_debug_passwords = yes
#auth_worker_max_count = 30
#auth_gssapi_hostname =
#auth_krb5_keytab =
#auth_use_winbind = no
#auth_winbind_helper_path = /usr/local/bin/ntlm_auth
#auth_failure_delay = 2
auth default {
  mechanisms = plain login
   socket listen {
     master {
       path = /var/run/dovecot/auth-master
       mode = 0600
       user = mailnull
       #group = mail
     }
   }
  passdb sql {
    args = /usr/local/etc/dovecot-sql.conf
  }
  userdb sql {
    args = /usr/local/etc/dovecot-sql.conf
  }
  user = root
  #chroot =
  #count = 1
  #ssl_require_client_cert = no
  #ssl_username_from_cert = no
}

Вот что в мускуле получаю ;

Код: Выделить всё

mysql> use roundcube;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'test@gipernet.eu' AND `active`='1' ;
ERROR 1146 (42S02): Table 'roundcube.mailbox' doesn't exist

Не понемаю почему он ругаеться ?
Делал так :

Код: Выделить всё

mysql> create database roundcube;
mysql> grant all on roundcube.* to 'roundcube'@'localhost' identified by 'roundcube';
mysql> flush privileges;
mysql> quit

После чего

Код: Выделить всё

/usr/local/www/roundcube/SQL
mysql -u roudcube -p roundcube  < mysql.initial.sql

ee /usr/local/www/roundcube/config/db.inc.php

Код: Выделить всё

$rcmail_config['db_dsnw'] = 'mysql://roundcube:roundcube@localhost/roundcube';

После занелся конфигом
ee /usr/local/www/roundcube/config/main.inc.php

Код: Выделить всё

$rcmail_config = array();
$rcmail_config['debug_level'] = 1;
$rcmail_config['log_driver'] = 'file';
$rcmail_config['log_date_format'] = 'd-M-Y H:i:s O';
$rcmail_config['syslog_id'] = 'roundcube';
$rcmail_config['syslog_facility'] = LOG_USER;
$rcmail_config['smtp_log'] = true;
$rcmail_config['log_logins'] = false;
$rcmail_config['sql_debug'] = false;
$rcmail_config['imap_debug'] = false;
$rcmail_config['ldap_debug'] = false;
$rcmail_config['smtp_debug'] = false;
$rcmail_config['default_host'] = '';
$rcmail_config['default_port'] = 143;
$rcmail_config['imap_auth_type'] = 'PLAIN';
$rcmail_config['imap_root'] = null;
$rcmail_config['imap_delimiter'] = null;
$rcmail_config['imap_force_caps'] = false;
$rcmail_config['imap_timeout'] = 0;
$rcmail_config['smtp_server'] = 'localhost';
$rcmail_config['smtp_port'] = 25;
$rcmail_config['smtp_user'] = '%u';
$rcmail_config['smtp_pass'] = '%p';
$rcmail_config['smtp_auth_type'] = 'PLAIN';
$rcmail_config['smtp_helo_host'] = 'mail.gipernet.eu';
$rcmail_config['smtp_timeout'] = 0;
$rcmail_config['enable_installer'] = false;
$rcmail_config['log_dir'] = 'logs/';
$rcmail_config['temp_dir'] = 'temp/';
$rcmail_config['enable_caching'] = false;
$rcmail_config['message_cache_lifetime'] = '10d';
$rcmail_config['force_https'] = false;
$rcmail_config['auto_create_user'] = true;
$rcmail_config['skin_include_php'] = false;
$rcmail_config['session_lifetime'] = 10;
$rcmail_config['ip_check'] = false;
$rcmail_config['double_auth'] = false;
###$rcmail_config['des_key'] = 'rcmail-!24ByteDESkey*Str';
$rcmail_config['username_domain'] = '%d';
$rcmail_config['mail_domain'] = '%d';
$rcmail_config['password_charset'] = 'ISO-8859-1';
$rcmail_config['sendmail_delay'] = 0;
$rcmail_config['max_recipients'] = 0;
$rcmail_config['max_group_members'] = 0;
$rcmail_config['useragent'] = 'Roundcube Webmail/'.RCMAIL_VERSION;
$rcmail_config['product_name'] = 'Roundcube Webmail';
$rcmail_config['include_host_config'] = false;
$rcmail_config['generic_message_footer'] = '';
$rcmail_config['generic_message_footer_html'] = '';
$rcmail_config['http_received_header'] = false;
$rcmail_config['http_received_header_encrypt'] = false;
$rcmail_config['mail_header_delimiter'] = NULL;
$rcmail_config['line_length'] = 72;
$rcmail_config['send_format_flowed'] = true;
$rcmail_config['session_domain'] = '';
$rcmail_config['dont_override'] = array();
$rcmail_config['identities_level'] = 0;
$rcmail_config['mime_magic'] = '/usr/share/misc/magic';
$rcmail_config['email_dns_check'] = false;
$rcmail_config['plugins'] = array();
$rcmail_config['message_sort_col'] = '';
$rcmail_config['message_sort_order'] = 'DESC';
$rcmail_config['list_cols'] = array('subject', 'from', 'date', 'size', 'flag', 'attachment');
$rcmail_config['language'] = null;
$rcmail_config['date_short'] = 'D H:i';
$rcmail_config['date_long'] = 'd.m.Y H:i';
$rcmail_config['date_today'] = 'H:i';
$rcmail_config['drafts_mbox'] = 'Drafts';
$rcmail_config['junk_mbox'] = 'Junk';
$rcmail_config['sent_mbox'] = 'Sent';
$rcmail_config['trash_mbox'] = 'Trash';
$rcmail_config['default_imap_folders'] = array('INBOX', 'Drafts', 'Sent', 'Junk', 'Trash');
$rcmail_config['create_default_folders'] = false;
$rcmail_config['protect_default_folders'] = true;
$rcmail_config['quota_zero_as_unlimited'] = false;
$rcmail_config['mdn_requests'] = 0;
$rcmail_config['enable_spellcheck'] = true;
$rcmail_config['spellcheck_engine'] = 'googie';
$rcmail_config['spellcheck_uri'] = '';
$rcmail_config['spellcheck_languages'] = NULL;
$rcmail_config['max_pagesize'] = 200;
$rcmail_config['min_keep_alive'] = 60;
$rcmail_config['address_book_type'] = 'sql';
$rcmail_config['ldap_public'] = array();
$rcmail_config['autocomplete_addressbooks'] = array('sql');
$rcmail_config['default_charset'] = 'ISO-8859-1';
$rcmail_config['skin'] = 'default';
$rcmail_config['pagesize'] = 40;
$rcmail_config['timezone'] = 'auto';
$rcmail_config['dst_active'] = (bool)date('I');
$rcmail_config['prefer_html'] = true;
$rcmail_config['show_images'] = 0;
$rcmail_config['htmleditor'] = false;
$rcmail_config['prettydate'] = true;
$rcmail_config['draft_autosave'] = 300;
$rcmail_config['preview_pane'] = false;
$rcmail_config['preview_pane_mark_read'] = 0;
$rcmail_config['focus_on_new_message'] = true;
$rcmail_config['logout_purge'] = false;
$rcmail_config['logout_expunge'] = false;
$rcmail_config['inline_images'] = true;
$rcmail_config['mime_param_folding'] = 1;
$rcmail_config['skip_deleted'] = false;
$rcmail_config['read_when_deleted'] = true;
$rcmail_config['flag_for_deletion'] = false;
$rcmail_config['keep_alive'] = 60;
$rcmail_config['check_all_folders'] = false;
$rcmail_config['display_next'] = false;
$rcmail_config['autoexpand_threads'] = 0;
$rcmail_config['top_posting'] = false;
$rcmail_config['strip_existing_sig'] = true;
$rcmail_config['show_sig'] = 1;
$rcmail_config['sig_above'] = false;
$rcmail_config['force_7bit'] = false;
$rcmail_config['search_mods'] = null;
$rcmail_config['delete_always'] = false;

А вот лог который выдает после ввода в roundcube :

Код: Выделить всё

Jan 11 18:01:37 gipernet dovecot: auth(default): client in: AUTH	1	PLAIN	service=imap	secured	lip=192.168.1.4	rip=192.168.1.4	lport=143	rport=55044	resp=AGluZm9AZ2lwZXJuZXQuZXUATWFsaXNoa2E=
Jan 11 18:01:37 gipernet dovecot: auth-worker(default): sql(info@gipernet.eu,192.168.1.4): query: SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'info@gipernet.eu' AND `active`='1'
Jan 11 18:01:37 gipernet dovecot: auth(default): client out: OK	1	user=info@gipernet.eu
Jan 11 18:01:37 gipernet dovecot: auth(default): master in: REQUEST	6	1808	1
Jan 11 18:01:37 gipernet dovecot: auth-worker(default): sql(info@gipernet.eu,192.168.1.4): SELECT `maildir` AS `home`, 26 AS `uid`, 26 AS `gid` FROM `mailbox` WHERE `username` = 'info@gipernet.eu' AND `active`='1'
Jan 11 18:01:37 gipernet dovecot: auth(default): master out: USER	6	info@gipernet.eu	home=/var/mail/exim/gipernet.eu/info/	uid=26	gid=26
Jan 11 18:01:37 gipernet dovecot: IMAP(info@gipernet.eu): Effective uid=26, gid=26, home=/var/mail/exim/gipernet.eu/info/
Jan 11 18:01:37 gipernet dovecot: IMAP(info@gipernet.eu): maildir: data=/var/mail/exim/gipernet.eu/info
Jan 11 18:01:37 gipernet dovecot: IMAP(info@gipernet.eu): maildir++: root=/var/mail/exim/gipernet.eu/info, index=, control=, inbox=/var/mail/exim/gipernet.eu/info
Jan 11 18:01:37 gipernet dovecot: imap-login: Login: user=<info@gipernet.eu>, method=PLAIN, rip=192.168.1.4, lip=192.168.1.4, secured
Jan 11 18:01:37 gipernet dovecot: IMAP(info@gipernet.eu): Disconnected: Logged out bytes=56/744
Jan 11 18:01:38 gipernet dovecot: auth(default): new auth connection: pid=1845

И пишет на странице :
Service currently not available !
Error No. [500]

Раз я уже начал вот код exima 4.72
configure :

Код: Выделить всё

primary_hostname = gipernte.eu
 hide mysql_servers = localhost/exim/exim/exim
 domainlist local_domains = ${lookup mysql{SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'}}
domainlist relay_to_domains = ${lookup mysql{SELECT `domain` FROM `domain` WHERE `domain`='${domain}' AND `active`='1'}}
hostlist   relay_from_hosts = localhost : 127.0.0.0/8
#acl_smtp_auth = acl_check_auth
#acl_smtp_connect = acl_check_connect
acl_smtp_rcpt = acl_check_rcpt
acl_smtp_data = acl_check_data
# av_scanner = clamd:/var/run/clamav/clamd.sock
 spamd_address = 127.0.0.1 783
 tls_advertise_hosts = *
 tls_certificate = /etc/exim/ssl/exim.crt
 tls_privatekey = /etc/exim/ssl/exim.pem
 daemon_smtp_ports = 25 : 465
 tls_on_connect_ports = 465
qualify_domain = gipernet.eu
qualify_recipient = gipernet.eu
# allow_domain_literals
exim_user = mailnull
exim_group = mail
never_users = root
#host_lookup = *
#rfc1413_hosts = *
rfc1413_query_timeout = 0s
 sender_unqualified_hosts = +relay_from_hosts
 recipient_unqualified_hosts = +relay_from_hosts
ignore_bounce_errors_after = 45m
 timeout_frozen_after = 5d
 helo_accept_junk_hosts = 127.0.0.1
 auto_thaw = 1h
 smtp_banner = "$primary_hostname, ESMTP EXIM $version_number"
 smtp_accept_max = 50
 smtp_accept_max_per_connection = 25
 smtp_connect_backlog = 30
 smtp_accept_max_per_host = 20
 remote_max_parallel = 15
 message_size_limit = 10M
 helo_allow_chars = _
 smtp_enforce_sync = true
 log_selector = +all_parents +connection_reject +incoming_interface +lost_incoming_connection +received_sender +received_recip
 syslog_timestamp = no
 split_spool_directory = true
begin acl
acl_check_rcpt:
  accept  hosts = :
 # control = dkim_disable_verify
  deny    message       = Restricted characters in address
          domains       = +local_domains
          local_parts   = ^[.] : ^.*[@%!/|]

 deny    message       = Restricted characters in address
          domains       = !+local_domains
          local_parts   = ^[./|] : ^.*[@%!] : ^.*/\\.\\./
# accept  local_parts   = postmaster
#          domains       = +local_domains
# require verify        = sender
  accept  hosts = +relay_from_hosts
   #       control       = submission # Режим подчинения
   #        control       = dkim_disable_verify # Отключить проверку DKIM
  accept  authenticated = *
    #     control       = submission
#          control       = dkim_disable_verify

 deny    message         = "HELO/EHLO require by SMTP RFC"
                condition       = ${if eq{$sender_helo_name}{}{yes}{no}}

  deny    message       = "Your IP in HELO - access denied!"
          hosts         =  * : !+relay_from_hosts : !81-196.domain-ak.ru
          condition     = ${if eq{$sender_helo_name}\
    {$sender_host_address}{true}{false}}

  deny    condition     = ${if eq{$sender_helo_name}\
    {$interface_address}{yes}{no}}
 hosts         = !127.0.0.1 : !localhost : *
          message       = "main IP in your HELO! Access denied!"

  deny    condition     = ${if match{$sender_helo_name}\
    {\N^\d+$\N}{yes}{no}}
          hosts         = !127.0.0.1 : !localhost : *
          message       = "can not be only number in HELO!"
#  deny    condition     = ${if match{$sender_address}{\N^\s+$\N}{yes}{no}}
#          hosts         = !127.0.0.1 : !localhost : *
#          message       = "Sender address contains spaces?! not for RFC..."

  deny    condition     = ${if eq{$sender_address}{}{yes}{no}}
          hosts         = !127.0.0.1 : !localhost : *
          message       = "Sender address is empty?! not for RFC..."

  deny   condition = ${lookup mysql{SELECT `goto` FROM \
        `alias` WHERE \
        `address`='${quote_mysql:$local_part@domain-ak.ru}'}{no}{yes}}
        hosts         = !127.0.0.1 : !localhost : !192.168.1.0/24 : *
        message       = "No such user!"

  deny   condition     = ${if match{$sender_helo_name}{masterhost.ru}{no}{yes}}
         hosts         = !127.0.0.1 : !localhost : *
         message       = "Access deny!"
#  deny    message       = "your hostname is bad (adsl, poll, ppp & etc)."
#          condition     = ${if match{$sender_host_name} \
#                               {adsl|dialup|pool|peer|dhcp} \
#                               {yes}{no}}
  warn
        set acl_m0 = 30s
  warn
        hosts = +relay_from_hosts : 127.0.0.1/8 : 192.168.1.0/24

         set acl_m0 = 0s
  warn
        logwrite = Delay $acl_m0 for $sender_host_name [$sender_host_address] with HELO=$sender_helo_name. Mail from $sender_a
      delay = $acl_m0
  accept  domains       = +local_domains
          endpass
          message       = "In my mailserver not stored this user"
          verify        = recipient
  accept  domains       = +relay_to_domains
          endpass
          message       = "main server not know how relay to this address"
          verify        = recipient
 deny  message  = "you in blacklist - $dnslist_domain \n $dnslist_text"
       dnslists = opm.blitzed.org : cbl.abuseat.org : bl.csma.biz : dynablock.njabl.org
  accept  hosts         = +relay_from_hosts
  deny    message       = "Homo hominus lupus est"
acl_check_data:
#  deny malware = *
#  message = "In e-mail found VIRUS - $malware_name"
  accept
begin routers
# aliases_mysql_nnov:
#  driver = redirect
#  condition = ${if eq{zern.domain-ak.ru}{$domain}{yes}{no}}
#  allow_fail
#  allow_defer
#  data = ${quote:$local_part}@domain-ak.ru
#copy_message:
#   driver = redirect
#   unseen
#   domains = *
#   data = audit@domain-ak.ru
system_aliases:
    driver = redirect
    allow_fail
    allow_defer
    data = ${lookup mysql{SELECT `goto` FROM `alias` WHERE `address`='${quote_mysql:$local_part@$domain}' OR `address`='${quot
dovecot_user:
  driver = accept
condition = ${lookup mysql{SELECT `goto` FROM `alias` WHERE `address`='${quote_mysql:$local_part@$domain}' OR `address`='${q
  transport = dovecot_delivery
dnslookup:
  driver = dnslookup
  domains = ! +local_domains
  transport = remote_smtp
  ignore_target_hosts = 0.0.0.0 : 127.0.0.0/8
  no_more
begin transports
remote_smtp:
driver = smtp
dovecot_delivery:
  driver = pipe
  command = /usr/local/libexec/dovecot/deliver -d $local_part@$domain
  message_prefix =
  message_suffix =
  delivery_date_add
  envelope_to_add
  return_path_add
  log_output
  user = mailnull
address_pipe:
  driver = pipe
  return_output
address_reply:
  driver = autoreply
begin retry
begin rewrite
begin authenticators
auth_plain:
  driver = plaintext
  public_name = PLAIN
  server_condition = ${lookup mysql{SELECT `username` FROM `mailbox` WHERE `username` = '${quote_mysql:$auth2}' AND `password`
  server_prompts = :
  server_set_id = $auth2
auth_login:
  driver = plaintext
public_name = LOGIN
  server_condition = ${lookup mysql{SELECT `username` FROM `mailbox` WHERE `username` = '${quote_mysql:$auth1}' AND `password`
  server_prompts = Username:: : Password::
  server_set_id = $auth1
auth_cram_md5:
  driver = cram_md5
  public_name = CRAM-MD5
  server_secret = ${lookup mysql{SELECT `password` FROM `mailbox` WHERE `username` = '${quote_mysql:$auth1}'}{$value}fail}
  server_set_id = $auth2

И за одно тогда уже postfixadmin :

Код: Выделить всё

if (ereg ("config.inc.php", $_SERVER['PHP_SELF']))
 {
   header ("Location: login.php");
   exit;
 }
$CONF['configured'] = true;
$CONF['setup_password'] = 'b3f739ea0c28d8625a11bdfdca51f77c:c4cdcfaabbb9bfdc2cfc1691b29307131046d574';
$CONF['postfix_admin_url'] = 'http://gipernet.eu/postfixadmin/';
$CONF['postfix_admin_path'] = '/usr/local/www/postfixadmin/';
$CONF['default_language'] = 'ru';
$CONF['database_type'] = 'mysql';
$CONF['database_host'] = 'localhost';
$CONF['database_user'] = 'exim';
$CONF['database_password'] = 'exim';
$CONF['database_name'] = 'exim';
$CONF['database_prefix'] = '';
$CONF['database_prefix'] = '';
$CONF['database_tables'] = array (
    'admin' => 'admin',
    'alias' => 'alias',
    'alias_domain' => 'alias_domain',
    'config' => 'config',
    'domain' => 'domain',
    'domain_admins' => 'domain_admins',
    'fetchmail' => 'fetchmail',
    'log' => 'log',
    'mailbox' => 'mailbox',
    'vacation' => 'vacation',
    'vacation_notification' => 'vacation_notification',
    'quota' => 'quota',
    'quota2' => 'quota2',
);
$CONF['admin_email'] = 'postmaster@gipernet.eu';
$CONF['smtp_server'] = 'localhost';
$CONF['smtp_port'] = '25';
$CONF['encrypt'] = 'cleartext';
$CONF['authlib_default_flavor'] = 'md5raw';
$CONF['dovecotpw'] = "/usr/sbin/dovecotpw";
$CONF['min_password_length'] = 5;
$CONF['generate_password'] = 'NO';
$CONF['show_password'] = 'NO';
$CONF['page_size'] = '25';
$CONF['default_aliases'] = array (
    'abuse' => 'abuse@gipernet.eu',
    'hostmaster' => 'hostmaster@gipernet.eu',
    'postmaster' => 'postmaster@gipernet.eu',
    'webmaster' => 'webmaster@gipernet.eu'
);
$CONF['domain_path'] = 'YES';
$CONF['domain_in_mailbox'] = 'NO';
$CONF['maildir_name_hook'] = 'NO';
$CONF['aliases'] = '0';
$CONF['mailboxes'] = '0';
$CONF['maxquota'] = '0';
$CONF['quota'] = 'YES';
$CONF['quota_multiplier'] = '1024000';
$CONF['transport'] = 'NO';
$CONF['transport_options'] = array (
    'virtual',  // for virtual accounts
    'local',    // for system accounts
    'relay'     // for backup mx
);
$CONF['transport_default'] = 'virtual';
$CONF['vacation'] = 'NO';
$CONF['vacation_domain'] = 'autoreply.gipernet.eu';
$CONF['vacation_control'] ='YES';
$CONF['vacation_control_admin'] = 'YES';
$CONF['alias_control'] = 'YES';
$CONF['alias_control_admin'] = 'YES';
$CONF['special_alias_control'] = 'YES';
$CONF['alias_goto_limit'] = '0';
$CONF['alias_domain'] = 'YES';
$CONF['backup'] = 'YES';
$CONF['sendmail'] = 'YES';
$CONF['logging'] = 'YES';
$CONF['fetchmail'] = 'YES';
$CONF['fetchmail_extra_options'] = 'NO';
$CONF['show_header_text'] = 'NO';
$CONF['header_text'] = ':: Postfix Admin ::';
$CONF['user_footer_link'] = "http://gipernet.eu/postfixadmin";
$CONF['show_footer_text'] = 'YES';
$CONF['footer_text'] = 'Return to change-this-to-your.domain.tld';
$CONF['footer_link'] = 'http://gipernet.eu/postfixadmin';
$CONF['welcome_text'] = <<<EOM
Hi,
$CONF['emailcheck_resolve_domain']='NO';
$CONF['show_status']='NO';
$CONF['show_status_key']='NO';
$CONF['show_status_text']='&nbsp;&nbsp;';
$CONF['show_undeliverable']='NO';
$CONF['show_undeliverable_color']='tomato';
$CONF['show_undeliverable_exceptions']=array("unixmail.domain.ext","exchangeserver.domain.ext","gmail.com");
$CONF['show_popimap']='NO';
$CONF['show_popimap_color']='darkgrey';
$CONF['show_custom_domains']=array("subdomain.domain.ext","domain2.ext");
$CONF['show_custom_colors']=array("lightgreen","lightblue");
$CONF['recipient_delimiter'] = "";
// $CONF['mailbox_postcreation_script']='sudo -u courier /usr/local/bin/postfixadmin-mailbox-postcreation.sh';
// $CONF['mailbox_postedit_script']='sudo -u courier /usr/local/bin/postfixadmin-mailbox-postedit.sh';
// $CONF['mailbox_postdeletion_script']='sudo -u courier /usr/local/bin/postfixadmin-mailbox-postdeletion.sh';
//$CONF['domain_postcreation_script']='sudo -u courier /usr/local/bin/postfixadmin-domain-postcreation.sh';
// $CONF['domain_postdeletion_script']='sudo -u courier /usr/local/bin/postfixadmin-domain-postdeletion.sh';
// $CONF['create_mailbox_subdirs']=array('Spam');
// $CONF['create_mailbox_subdirs_host']='localhost';
$CONF['create_mailbox_subdirs_prefix']='INBOX.';
$CONF['used_quotas'] = 'NO';
$CONF['new_quota_table'] = 'NO';
// $CONF['create_mailbox_subdirs_hostport']=143;
// $CONF['create_mailbox_subdirs_hostoptions']=array('notls');
// $CONF['create_mailbox_subdirs_hostoptions']=array('novalidate-cert','norsh');
$CONF['theme_logo'] = 'images/logo-default.png';
$CONF['theme_css'] = 'css/default.css';
$CONF['xmlrpc_enabled'] = false;
if (file_exists(dirname(__FILE__) . '/config.local.php')) {
    include(dirname(__FILE__) . '/config.local.php');
}

Когда создаю почтовый ящик в Posrfixadmin вылезают такие логи :

Код: Выделить всё

Jan 11 19:01:22 gipernet exim[1955]: 1Pchb0-0000VX-NS <= admin@gipernet.eu H=(www.gipernet.eu) [127.0.0.1] I=[127.0.0.1]:25 P=esmtp S=507 from <admin@gipernet.eu> for sos@gipernet.eu
Jan 11 19:01:22 gipernet dovecot: auth(default): master in: USER        1       sos@gipernet.eu service=deliver
Jan 11 19:01:22 gipernet dovecot: auth-worker(default): sql(sos@gipernet.eu): SELECT `maildir` AS `home`, 26 AS `uid`, 26 AS `gid` FROM `mailbox` WHERE `username` = 'sos@gipernet.eu' AND `active`='1'
Jan 11 19:01:22 gipernet dovecot: auth(default): master out: USER       1       sos@gipernet.eu home=/var/mail/exim/gipernet.eu/sos/  uid=26  gid=26
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): auth input: home=/var/mail/exim/gipernet.eu/sos/
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): auth input: uid=26
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): auth input: gid=26
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): Home dir not found: /var/mail/exim/gipernet.eu/sos/
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): maildir: data=/var/mail/exim/gipernet.eu/sos
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): maildir++: root=/var/mail/exim/gipernet.eu/sos, index=, control=, inbox=/var/mail/exim/gipernet.eu/sos
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): Namespace : Permission lookup failed from /var/mail/exim/gipernet.eu/sos
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): Namespace : Using permissions from /var/mail/exim/gipernet.eu/sos: mode=0700 gid=-1
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): msgid=: saved mail to INBOX
Jan 11 19:01:22 gipernet exim[1956]: 1Pchb0-0000VX-NS => sos <sos@gipernet.eu> R=dovecot_user T=dovecot_delivery
Jan 11 19:01:22 gipernet exim[1956]: 1Pchb0-0000VX-NS Completed

Подскажите что не так ???

[blade_007]

итак, сначала.
1. БД для аккаунтов exim - одна (exim судя по вашим конфигам вот здесь - hide mysql_servers = localhost/exim/exim/exim),
БД для rouncube - другая, в вашем случае roundcube (см. здесь $rcmail_config['db_dsnw'] = 'mysql://roundcube:roundcube@localhost/roundcube';) Roundcude здесь хранит пользовательские настройки, адресную книгу и т.п.
ЭТО РАЗНЫЕ БД!!!! Если хотите сделать запрос (проверка пользователя), то см. ниже:

Код: Выделить всё

mysql>use exim;
mysql> SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` = 'test@gipernet.eu' AND `active`='1' ;

2. "Когда создаю почтовый ящик в Posrfixadmin вылезают такие логи :"
вы уверены, что приведенные вами строки лога соот. моменту создания почтового ящика? По-моему это лог доставки сообщения юзеру sos <sos@gipernet.eu>

3. Эти строки измените и смотрите файлы в каталоге /usr/local/www/roundcube/logs (на него кстати должны быть права для записи пользователям)
$rcmail_config['log_logins'] = true;
$rcmail_config['sql_debug'] = true;
$rcmail_config['imap_debug'] = true;

[blade_007]

$rcmail_config['default_host'] = '';
ГДЕ IMAP-SERVER????

[klaster]

База данных exim, как видите находить пользователя.

Код: Выделить всё

mysql> use exim;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT `username` as `user`, `password` FROM `mailbox` WHERE `username` =                                               'test@gipernet.eu' AND `active`='1' ;
+------------------+----------+
| user             | password |
+------------------+----------+
| test@gipernet.eu | ***** |
+------------------+----------+
1 row in set (0.00 sec)

Ну когда создаю в postfixadmin ящик, он ругаеться на :

Код: Выделить всё

Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): Home dir not found: /var/mail/exim/gipernet.eu/sos/
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): Namespace : Permission lookup failed from /var/mail/exim/gipernet.eu/sos
Jan 11 19:01:22 gipernet dovecot: deliver(sos@gipernet.eu): Namespace : Using permissions from /var/mail/exim/gipernet.eu/sos: mode=0700 gid=-1

Я понемаю что это проблема с правами , но как их сделать чтоб при создание нового пользователя это отлетало и деректорию находил ?

Что касаеться этого $rcmail_config['default_host']= 'gipernet.eu' сейчас добавлю отпишю.