forum.lissyara.su

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

root@gateway:/usr/home/admin # telnet localhost 110
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK Dovecot ready.
user test@gospodars.cosmonova.net.ua
+OK
pass 123456
-ERR Authentication failed.

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

Jun 29 16:00:36 gateway dovecot: Dovecot v1.2.17 starting up
Jun 29 16:00:36 gateway dovecot: auth-worker(default): mysql: Connected to localhost (postfix)
Jun 29 16:00:37 gateway dovecot: auth(default): new auth connection: pid=1280
Jun 29 16:00:37 gateway dovecot: auth(default): new auth connection: pid=1279
Jun 29 16:00:37 gateway dovecot: auth(default): new auth connection: pid=1278
Jun 29 16:00:37 gateway dovecot: auth(default): new auth connection: pid=1281
Jun 29 16:00:37 gateway dovecot: auth(default): new auth connection: pid=1277
Jun 29 16:00:37 gateway dovecot: auth(default): new auth connection: pid=1282
Jun 29 16:00:51 gateway dovecot: auth(default): new auth connection: pid=1284
Jun 29 16:01:12 gateway dovecot: auth(default): client in: AUTH>1<----->PLAIN<->service=pop3<-->secured>lip=127.0.0.1<->rip=127.0.0.1<->lport=110<----->rport=61191<--->resp=<hidden>
Jun 29 16:01:12 gateway dovecot: auth-worker(default): sql(test@gospodars.cosmonova.net.ua,127.0.0.1): query: SELECT password FROM mailbox WHERE username = 'test@gospodars.cosmonova.net.ua'
Jun 29 16:01:12 gateway dovecot: auth-worker(default): sql(test@gospodars.cosmonova.net.ua,127.0.0.1): Password mismatch
Jun 29 16:01:12 gateway dovecot: auth-worker(default): pam(test@gospodars.cosmonova.net.ua,127.0.0.1): lookup service=dovecot
Jun 29 16:01:12 gateway dovecot: auth-worker(default): pam(test@gospodars.cosmonova.net.ua,127.0.0.1): #1/1 style=1 msg=Password for test@gospodars.cosmonova.net.ua@gateway.gospodars.cosmonova.net.
Jun 29 16:01:12 gateway dovecot: auth-worker(default): pam(test@gospodars.cosmonova.net.ua,127.0.0.1): pam_authenticate() failed: authentication error (/etc/pam.d/dovecot missing?)
Jun 29 16:01:14 gateway dovecot: auth(default): client out: FAIL<------>1<----->user=test@gospodars.cosmonova.net.ua
Jun 29 16:01:19 gateway dovecot: pop3-login: Aborted login (auth failed, 1 attempts): user=<test@gospodars.cosmonova.net.ua>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| postfix            |
+--------------------+
4 rows in set (0.05 sec)

mysql> use postfix
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> show tables;
+-----------------------+
| Tables_in_postfix     |
+-----------------------+
| admin                 |
| alias                 |
| alias_domain          |
| config                |
| domain                |
| domain_admins         |
| fetchmail             |
| log                   |
| mailbox               |
| quota                 |
| quota2                |
| vacation              |
| vacation_notification |
+-----------------------+
13 rows in set (0.00 sec)

mysql> select * from mailbox;
+---------------------------------+------------------------------------------------------------------+------+-------------------------------------------------------------+-------+------------+----------------------------+---------------------+---------------------+--------+
| username                        | password                                                         | name | maildir                                                     | quota | local_part | domain                     | created             | modified            | active |
+---------------------------------+------------------------------------------------------------------+------+-------------------------------------------------------------+-------+------------+----------------------------+---------------------+---------------------+--------+
| test@gospodars.cosmonova.net.ua | dd59f669267e9bb13d42a1ba57c972c5b13a4b2ae457c9ada8035dc7d8bae41b |      | gospodars.cosmonova.net.ua/test@gospodars.cosmonova.net.ua/ |     0 | test       | gospodars.cosmonova.net.ua | 2015-06-29 14:56:41 | 2015-06-29 15:29:43 |      1 |
+---------------------------------+------------------------------------------------------------------+------+-------------------------------------------------------------+-------+------------+----------------------------+---------------------+---------------------+--------+
1 row in set (0.00 sec)

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| postfix            |
+--------------------+
4 rows in set (0.00 sec)

mysql> use postfix
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> show tables;
+-----------------------+
| Tables_in_postfix     |
+-----------------------+
| admin                 |
| alias                 |
| alias_domain          |
| config                |
| domain                |
| domain_admins         |
| fetchmail             |
| log                   |
| mailbox               |
| quota                 |
| quota2                |
| vacation              |
| vacation_notification |
+-----------------------+
13 rows in set (0.01 sec)

mysql> select * from mailbox;
+----------------------------------+------------------------------------------------------------------+------+--------------------------------------------------------------+-------+------------+----------------------------+---------------------+---------------------+--------+
| username                         | password                                                         | name | maildir                                                      | quota | local_part | domain                     | created             | modified            | active |
+----------------------------------+------------------------------------------------------------------+------+--------------------------------------------------------------+-------+------------+----------------------------+---------------------+---------------------+--------+
| test@gospodars.cosmonova.net.ua  | 8f48a311793d494b53ad488bb603f93a0457e40fe45cbacb082c0720ceeb1e37 |      | gospodars.cosmonova.net.ua/test@gospodars.cosmonova.net.ua/  |     0 | test       | gospodars.cosmonova.net.ua | 2015-06-30 16:10:45 | 2015-06-30 16:10:45 |      1 |
| test1@gospodars.cosmonova.net.ua | 8f48a311793d494b53ad488bb603f93a0457e40fe45cbacb082c0720ceeb1e37 |      | gospodars.cosmonova.net.ua/test1@gospodars.cosmonova.net.ua/ |     0 | test1      | gospodars.cosmonova.net.ua | 2015-06-30 16:10:58 | 2015-06-30 16:10:58 |      1 |
| test2@gospodars.cosmonova.net.ua | 8f48a311793d494b53ad488bb603f93a0457e40fe45cbacb082c0720ceeb1e37 |      | gospodars.cosmonova.net.ua/test2@gospodars.cosmonova.net.ua/ |     0 | test2      | gospodars.cosmonova.net.ua | 2015-06-30 16:11:08 | 2015-06-30 16:11:08 |      1 |
| test3@gospodars.cosmonova.net.ua | 8f48a311793d494b53ad488bb603f93a0457e40fe45cbacb082c0720ceeb1e37 |      | gospodars.cosmonova.net.ua/test3@gospodars.cosmonova.net.ua/ |     0 | test3      | gospodars.cosmonova.net.ua | 2015-06-30 16:11:19 | 2015-06-30 16:11:19 |      1 |
+----------------------------------+------------------------------------------------------------------+------+--------------------------------------------------------------+-------+------------+----------------------------+---------------------+---------------------+--------+
4 rows in set (0.00 sec)