Доброго времени суток уважаемые форумчане. На новой работе по наследству перепал почтовый сервер на 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)
Подскажите кто чем может =)
