LINUX.ORG.RU

Сообщения trevymi

 

Не входит на почту под свежесозданным пользователям (Postfix)

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

Создал пользователя через MySQL ,но не могу войти

cat /var/log/mail.log | grep gavryshin

Apr 30 09:40:45 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 09:41:15 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 09:51:23 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 09:51:38 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 09:56:37 mail postfix/virtual[5026]: CE2CD53AA83: to=<aleksandr.gavryshin@mydomain.net>, relay=virtual, delay=0.11, delays=0.09/0.01/0/0.01, dsn=2.0.0, status=sent (delivered to mailbox)
Apr 30 09:57:48 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 09:58:10 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 10:05:13 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 10:05:59 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 10:32:49 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 10:35:47 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]
Apr 30 10:43:21 mail imapd: LOGIN FAILED, user=aleksandr.gavryshin@mydomain.net, ip=[::ffff:127.0.0.1]

Добавлял пользователя так:

INSERT INTO users VALUES ("aleksandr.gavryshin@mydomain.net",PASSWORD("password"),"mydomain.net/aleksandr.gavryshin","0","0","0","0","NULL");
INSERT INTO aliases VALUES ("aleksandr.gavryshin@mydomain.net","aleksandr.gavryshin@mydomain.net","NULL");

А вот и сами таблицы:

+----------------+
| Tables_in_mail |
+----------------+
| aliases        |
| forward        |
| transport      |
| users          |
+----------------+
4 rows in set (0.28 sec)

+-----------------------+
| Tables_in_postfix     |
+-----------------------+
| admin                 |
| alias                 |
| config                |
| domain                |
| domain_admins         |
| fetchmail             |
| log                   |
| mailbox               |
| vacation              |
| vacation_notification |
+-----------------------+
10 rows in set (0.00 sec)


mysql> select * from users;
+-----------------------------------------+-------------------------------------------+------------------------------------------+-------+---------+-----------+----------+---------+
| login                                   | password                                  | maildir                                  | quota | expired | antivirus | antispam | comment |
+-----------------------------------------+-------------------------------------------+------------------------------------------+-------+---------+-----------+----------+---------+
| elena.shatohina@mydomain.net       | P2yTxrci75hJ2                             | mydomain.net/elena.shatohina/       |     0 | 0       | 0         | 0        | NULL    |
| polina.dunina@mydomain.net         | 1ik/TcoNmzdmY                             | mydomain.net/polina.dunina/         |     0 | 0       | 0         | 0        | NULL    |
| natalya.stekolshikova@mydomain.net | Y7w/fsggss1AQ                             | mydomain.net/natalya.stekolshikova/ |     0 | 0       | 0         | 0        | NULL    |
| tatyana.kuzmina@mydomain.net       | 98nUR3V.N2vQc                             | mydomain.net/tatyana.kuzmina/       |     0 | 0       | 0         | 0        | NULL    |
| svetlana.shakleina@mydomain.net    | mty1uVT3J2NjE                             | mydomain.net/svetlana.shakleiva/    |     0 | 0       | 0         | 0        | NULL    |
| anna.maslova@mydomain.net          | /KYycsV8NmiHo                             | mydomain.net/anna.maslova/          |     0 | 0       | 0         | 0        | NULL    |
| nadezhda.blinova@mydomain.net      | Q4xk.yyIxqveA                             | mydomain.net/nadezhda.blinova/      |     0 | 0       | 0         | 0        | NULL    |
| tatyana.masluk@mydomain.net        | v588pOC8Bgso6                             | mydomain.net/tatyana.masluk/        |     0 | 0       | 0         | 0        | NULL    |
| maksim.besunov@mydomain.net        | QSHD8XaxLbmmQ                             | mydomain.net/maksim.besunov/        |     0 | 0       | 0         | 0        | NULL    |
| michael.romashkin@mydomain.net     | eTprVJGg9IuGE                             | mydomain.net/michael.romashkin/     |     0 | 0       | 0         | 0        | NULL    |
| ksenia.astashkina@mydomain.net     | NM1o.B68NLG.g                             | mydomain.net/ksenia.astashkina/     |     0 | 0       | 0         | 0        | NULL    |
| maksim.masalitin@mydomain.net      | vZRsZCyzq6xjA                             | mydomain.net/maksim.masalitin/      |     0 | 0       | 0         | 0        | NULL    |
| aleksandr.gavryshin@mydomain.net   | *DD57CFA782ED920EBD58591FB86640632DE56773 | mydomain.net/aleksandr.gavryshin    |     0 | 0       | 0         | 0        | NULL    |
| artem.antonov@mydomain.net         | XVE.qveGb5u0M                             | mydomain.net/artem.antonov/         |     0 | 0       | 0         | 0        | NULL    |
| alexandr.kuleshov@mydomain.net     | qV8LNI/chJVCw                             | mydomain.net/alexandr.kuleshov/     |     0 | 0       | 0         | 0        | NULL    |
| alexey.aksenov@mydomain.net        | FW6JpHxLNOsqU                             | mydomain.net/alexey.aksenov/        |     0 | 0       | 0         | 0        | NULL    |
| yuliya.novikova@mydomain.net       | UXZvNR5ZBV.ak                             | mydomain.net/yuliya.novikova/       |     0 | 0       | 0         | 0        | NULL    |
| olga.nikitina@mydomain.net         | 3133333333337asdsadasdasdasd              | mydomain.net/olga.nikitina/         |     0 | 0       | 0         | 0        | NULL    |
| mihail.hobotov@mydomain.net        | 3YZQMCkbA6ezk                             | mydomain.net/mihail.hobotov/        |     0 | 0       | 0         | 0        |         |
| olga.ivanova@mydomain.net          | MM3R5.fedm9pg                             | mydomain.net/olga.ivanova/          |     0 | 0       | 0         | 0        |         |
| anton.suschevsky@mydomain.net      | 6SpZeZEOVcPQI                             | mydomain.net/anton.suschevsky/      |     0 | 0       | 0         | 0        | NULL    |
| artem.velmakin@mydomain.net        | 3133333333337asdsadasdasdasd              | mydomain.net/artem.velmakin/        |     0 | 0       | 0         | 0        | NULL    |
| konstantin.vedernikov@mydomain.net | KI4MgfE5Klz0U                             | mydomain.net/konstantin.vedernikov/ |     0 | 0       | 0         | 0        | NULL    |
| mikhail.sokolov@mydomain.net       | yXrULCirnZtxU                             | mydomain.net/mikhail.sokolov/       |     0 | 0       | 0         | 0        | NULL    |
| alexey.prikhodko@mydomain.net      | 3133333333337asdsadasdasdasd              | mydomain.net/alexey.prikhodko/      |     0 | 0       | 0         | 0        | NULL    |
| irina.rotkina@mydomain.net         | 3133333333337asdsadasdasdasd              | mydomain.net/irina.rotkina/         |     0 | 0       | 0         | 0        | NULL    |
| elizaveta.ulashina@mydomain.net    | pbE/CeuJmHS66                             | mydomain.net/elizaveta.ulashina/    |     0 | 0       | 0         | 0        | NULL    |
| anzhela.berdina@mydomain.net       | jxIYPgeJURNwk                             | mydomain.net/anzhela.berdina/       |     0 | 0       | 0         | 0        | NULL    |
| alyana.starchenko@mydomain.net     | /2W6NuQBZZsFs                             | mydomain.net/alyana.starchenko/     |     0 | 0       | 0         | 0        | NULL    |
+-----------------------------------------+-------------------------------------------+------------------------------------------+-------+---------+-----------+----------+---------+
29 rows in set (0.00 sec)

Подскажите кто чем может =)

 ,

trevymi
()

RSS подписка на новые темы