############## dovecot.conf ######################
protocols = pop3 #pop3s

protocol pop3 {
         listen = *:110
        # ssl_listen = *:995
}
            
log_path = /var/log/dovecot.log
info_log_path = /var/log/dovecot.log
disable_plaintext_auth = no
ssl_disable = yes
#ssl_cert_file = /etc/pki/dovecot/certs/nissan-kh.akko.com.ua.crt
#ssl_key_file = /etc/pki/dovecot/private/nissan-kh.akko.com.ua.key
#ssl_parameters_regenerate = 1
#ssl_cipher_list = ALL:!LOW:!SSLv2
#verbose_ssl = yes
login_greeting = Welcome to the rus21.ru
mail_location = mbox:/var/mail/newmail/%u
mail_access_groups = mail
mail_debug = yes
first_valid_gid = 12
last_valid_gid = 12
first_valid_uid = 8
last_valid_uid = 8

protocol lda {
postmaster_address = postmaster@xxx.ru
auth_socket_path = /usr/local/var/run/dovecot/auth-master
mail_plugins = cmusieve
mail_plugin_dir = /usr/local/lib/dovecot/lda
hostname = rus21.ru
quota_full_tempfail = no
}

auth_verbose = yes
auth_debug = yes
auth_debug_passwords = yes
auth default {
mechanisms = plain login

passdb sql {
args = /usr/local/etc/dovecot-mysql.conf
}

userdb sql {
args = /usr/local/etc/dovecot-mysql.conf
}
user = mail
  socket listen {
    master {
      path = /usr/local/var/run/dovecot/auth-master
      mode = 0600
      user = dovecot
      group = dovecot
    }
    client {
      path = /usr/local/var/run/dovecot/auth-client
      mode = 0660
      user = mail
      group = mail
    }
  }
}
##########################################

############################# dovecot-mysql.conf ###################################

driver = mysql
connect = host=/tmp/mysql.sock dbname=mail user=mail password=sasasasasa
default_pass_scheme = PLAIN
password_query = SELECT username as user, password FROM email WHERE username = '%n' and domain = '%d' and status='1'
user_query = SELECT '/var/mail/newmail/%n@%d' as home, 'mbox:/var/mail/newmail/%n@%d' AS mail, '8' AS uid, '12' AS gid, concat('dirsize:storage=',quota) AS quota FROM view_email WHERE email = '%n@%d' and status='1'

###########################

Вот почему-то не приходит доменная часть при авторизации. Переменная %d пустая. в %u содержится только имя пользователя, а не имя_пользователя@ДОМЕН.РУ
Че я не так делаю? мне надо, чтобы доменая часть была. Таблица view_email это create view
таблички email.

dovecot: May 19 16:46:39 Info: auth(default): new auth connection: pid=15441
dovecot: May 19 16:46:40 Info: auth(default): client in: AUTH   1       PLAIN   service=pop3    lip=xx.xxx.x.xx rip=xx.xxx.x.xx lport=110       rport=1450  resp=
dovecot: May 19 16:46:40 Info: auth(default): client out: CONT  1
dovecot: May 19 16:46:40 Info: auth(default): client in: CONT   1       xxxxx
dovecot: May 19 16:46:40 Info: auth-worker(default): sql(root@xxx.ru,xx.xxx.x.xx): query: SELECT username as user, password FROM email WHERE username = 'root' and domain = 'xxx.ru' and status='1'
dovecot: May 19 16:46:40 Info: auth-worker(default): auth(root@xxx.ru,xx.xxx.x.xx): username changed root@xxx.ru -> root
dovecot: May 19 16:46:40 Info: auth(default): auth(root@xxx.ru,xx.xxx.x.xx): username changed root@xxx.ru -> root
dovecot: May 19 16:46:40 Info: auth(default): client out: OK    1       user=root
dovecot: May 19 16:46:40 Info: auth(default): master in: REQUEST        7       6343    1
dovecot: May 19 16:46:40 Info: auth-worker(default): sql(root,xx.xxx.x.xx): SELECT '/var/mail/newmail/root@' as home, 'mbox:/var/mail/newmail/root@' AS mail, '8' AS uid, '12' AS gid, concat('dirsize:storage=',quota) AS quota FROM view_email WHERE email = 'root@' and status='1'
dovecot: May 19 16:46:40 Info: auth-worker(default): sql(root,xx.xxx.x.xx): Unknown user
dovecot: May 19 16:46:40 Error: auth(default): userdb(root,xx.xxx.x.xx): user not found from userdb sql
dovecot: May 19 16:46:40 Info: auth(default): master out: NOTFOUND      7
dovecot: May 19 16:46:40 Info: pop3-login: Internal login failure (auth failed, 1 attempts): user=<root>, method=PLAIN, rip=xx.xxx.x.xx, lip=xx.xxx.x.xx
dovecot: May 19 16:46:41 Info: auth(default): new auth connection: pid=16967