Forum Debian Users Gang

telnet xx.pl 110
Trying 22x.xx.xx.xx...
Connected to xx.pl.
Escape character is '^]'.
+OK Welcome mail
USER aaa@xx.pl
+OK
PASS zzzzz
+OK Logged in.
Connection closed by foreign host

dovecot: Jul 29 17:06:13 Info: auth(default): client in: AUTH   1       PLAIN   service=POP3    lip=21x.xx.xx.xx      rip=83.29.65.20    resp=<hidden>
dovecot: Jul 29 17:06:13 Info: auth(default): client out: CONT  1
dovecot: Jul 29 17:06:13 Info: auth(default): client in: CONT<hidden>
dovecot: Jul 29 17:06:15 Info: auth-worker(default): sql(aaa@xx.pl,83.29.65.20): query: SELECT password FROM mailbox WHERE username = 'aaa@xx.pl'
dovecot: Jul 29 17:06:15 Info: auth(default): client out: OK    1       user=aaa@xx.pl
dovecot: Jul 29 17:06:15 Info: auth(default): master in: REQUEST        10      14044   1
dovecot: Jul 29 17:06:15 Info: auth(default): passwd(aaa@xx.pl,83.29.65.20): lookup
dovecot: Jul 29 17:06:15 Info: auth(default): passwd(aaa@xx.pl,83.29.65.20): unknown user
dovecot: Jul 29 17:06:15 Info: auth-worker(default): sql(aaa@xx.pl,83.29.65.20): SELECT '/home/virtual/aaa@xx.pl' AS home, 'maildir:/home/virtual/aaa@xx.pl' AS mail, 1010 AS uid, 1012 AS gid FROM mailbox WHERE username  = 'aaa@xx.pl'
dovecot: Jul 29 17:06:15 Info: auth(default): master out: USER  10      aaa@xx.pl  home=/home/virtual/aaa@xx.pl mail=maildir:/home/virtual/aaa@xx.pl        uid=1010        gid=1012
dovecot: Jul 29 17:06:15 Info: POP3(aaa@xx.pl): Effective uid=1010, gid=1012
dovecot: Jul 29 17:06:15 Info: pop3-login: Login: user=<aaa@xx.pl>, method=PLAIN, rip=83.29.65.20, lip=21x.xx.xx.xx

cur
new  
tmp

1175622187.V305I34a5a4M923376.tyrael:2, 
1177207701.V305I34a5eaM123058.tyrael:2,  1178545593.V305I34a630M230987.tyrael:2,
1175625475.V305I34a5a5M473233.tyrael:2,
1177221322.V305I34a5ebM458538.tyrael:2,  1178567054.V305I34a631M750975.tyrael:2,
[..]

1179864996.V305I34a634M670996.tyrael
1182021691.V305I34a6d4M592160.tyrael
1179919017.V305I34a676M526150.tyrael 
1182026815.V305I34a6d5M697856.tyrael
[..]

base_dir = /var/run/dovecot/
protocols = imap imaps pop3 pop3s
listen = *
disable_plaintext_auth = no
shutdown_clients = yes
log_path = /var/log/dovecot.log
info_log_path = /var/log/mail.log
log_timestamp = "%b %d %H:%M:%S "
syslog_facility = mail
ssl_disable = no
ssl_cert_file = /etc/ssl/dovecot/server.pem
ssl_key_file = /etc/ssl/dovecot/server.key
login_chroot = no
login_user = postmaster
login_process_per_connection = yes
login_processes_count = 3
login_max_processes_count = 128
login_greeting = Welcome 
login_log_format_elements = user=<%u> method=%m rip=%r lip=%l %c
login_log_format = %$: %s
mail_location = maildir:/home/virtual/%n@%d
mail_extra_groups = virtual
mail_debug = yes
protocol imap {
}

protocol pop3 {
}
protocol lda {
  postmaster_address = postmaster@example.com
}
auth_verbose = yes
auth_debug = yes
auth default {
  mechanisms = plain
  passdb sql {
    args = /etc/dovecot/dovecot-mysql.conf
  }
  userdb passwd {
  }
  userdb sql {
    args = /etc/dovecot/dovecot-mysql.conf
  }
  user = root
}
dict {
}
plugin {
}

driver = mysql
connect = host=127.0.0.1 dbname=xx user=xx password=xx
default_pass_scheme = PLAIN
password_query = SELECT password FROM mailbox WHERE username = '%n@%d'
user_query = SELECT '/home/virtual/%n@%d' AS home, '/home/virtual/%n@%d' AS maildir, 1010 AS uid, 1012 AS gid FROM mailbox WHERE username  = '%n@%d

mysql> describe mailbox;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| username  | varchar(255) | NO   | PRI |         |       |
| password  | varchar(255) | NO   |     |         |       |
| name      | varchar(255) | NO   |     |         |       |
| transport | varchar(9)   | NO   |     | virtual |       |
+-----------+--------------+------+-----+---------+-------+
4 rows in set (0.02 sec)

+-------------------------------+-------------+-------------------------------------+-----------+
| username                      | password    | name                                | transport |
+-------------------------------+-------------+-------------------------------------+-----------+
| aaa@xx.pl                     | zzzzz       | konto pocztowe                      | virtual   |
+-------------------------------+-------------+-------------------------------------+-----------+
32 rows in set (0.00 sec)