Tachtler's DokuWiki

Homepage | Kontakt | Rechtliche Informationen | Impressum

Benutzer-Werkzeuge

Webseiten-Werkzeuge

Zuletzt angesehen:
tachtler:dovecot_authentifizierung_-_sql

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen RevisionVorhergehende Überarbeitung
Nächste Überarbeitung		Vorhergehende Überarbeitung
tachtler:dovecot_authentifizierung_-_sql [2015/07/13 21:28] – [/etc/dovecot/dovecot-sql.conf.ext] klaustachtler:dovecot_authentifizierung_-_sql [2017/04/07 14:39] (aktuell) – [/etc/dovecot/dovecot-sql.conf.ext] klaus
Zeile 188: Zeile 188:
 | [[http://postfixadmin.sourceforge.net/|Postfix Admin]] **Benutzer(name)**/Mailbox    | klaus@tachtler.net                                 |  | [[http://postfixadmin.sourceforge.net/|Postfix Admin]] **Benutzer(name)**/Mailbox    | klaus@tachtler.net                                 | 
 | [[http://dovecot.org|Dovecot]] **Anmeldename**                     | klaus@tachtler.net (e-Mail-Adresse **vollständig**,__nicht__ nur der localpart) | | [[http://dovecot.org|Dovecot]] **Anmeldename**                     | klaus@tachtler.net (e-Mail-Adresse **vollständig**,__nicht__ nur der localpart) |
-| [[http://dovecot.org|Dovecot]] **Dummy-Benutzer (''vmail'')**      | interner Link [[tachtler:dovecot_centos_6#authentifizierungsbenutzer|Dovecot CentOS 6 - Konfiguration Authentifizierung - Authentifizierungsbenutzer]] bzw. | +| [[http://dovecot.org|Dovecot]] **Dummy-Benutzer (''vmail'')**      | interner Link [[tachtler:dovecot_centos_6#authentifizierungsbenutzer|Dovecot CentOS 6 - Konfiguration Authentifizierung - Authentifizierungsbenutzer]] \\ interner Link [[tachtler:dovecot_centos_7#authentifizierungsbenutzer|Dovecot CentOS 7 - Konfiguration Authentifizierung - Authentifizierungsbenutzer]] |
-|                                                                    | interner Link [[tachtler:dovecot_centos_7#authentifizierungsbenutzer|Dovecot CentOS 7 - Konfiguration Authentifizierung - Authentifizierungsbenutzer]]      |+
  
 Normalerweise **trennt** [[http://dovecot.org|Dovecot]] die beiden Abfragen Normalerweise **trennt** [[http://dovecot.org|Dovecot]] die beiden Abfragen
Zeile 333: Zeile 332:
 #  SELECT home, uid, gid \ #  SELECT home, uid, gid \
 #  FROM users WHERE username = '%n' AND domain = '%d' #  FROM users WHERE username = '%n' AND domain = '%d'
-# Tachtler+# Tachtler - CentOS 6
 user_query = SELECT 10000 AS uid, 10000 as gid, '/var/spool/vmail/%Ld/%Ln' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1 user_query = SELECT 10000 AS uid, 10000 as gid, '/var/spool/vmail/%Ld/%Ln' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1
 +# Tachtler - CentOS 7
 +user_query = SELECT 10000 AS uid, 10000 as gid, '/srv/vmail/%Ld/%Ln' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox, domain WHERE username = '%Lu' AND mailbox.active = 1 AND domain.domain = '%Ld' AND domain.active ='1'
 +# Tachtler - CentOS 7 - SQL-Quota
 +user_query = SELECT 10000 AS uid, 10000 as gid, '/srv/vmail/%Ld/%Ln' AS home, concat('*:bytes=', IF(mailbox.quota = 0, domain.maxquota*1024000, mailbox.quota)) AS quota_rule FROM mailbox, domain WHERE username = '%Lu' AND mailbox.active = 1 AND domain.domain = '%Ld' AND domain.active ='1'
  
 # If you wish to avoid two SQL lookups (passdb + userdb), you can use # If you wish to avoid two SQL lookups (passdb + userdb), you can use
Zeile 344: Zeile 347:
 #    home AS userdb_home, uid AS userdb_uid, gid AS userdb_gid \ #    home AS userdb_home, uid AS userdb_uid, gid AS userdb_gid \
 #  FROM users WHERE userid = '%u' #  FROM users WHERE userid = '%u'
-# Tachtler+# Tachtler - CentOS 6
 password_query = SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/var/spool/vmail/%Ld/%Ln' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1 password_query = SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/var/spool/vmail/%Ld/%Ln' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1
 +# Tachtler - CentOS 7
 +password_query = SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/srv/vmail/%Ld/%Ln' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1
  
 # Query to get a list of all usernames. # Query to get a list of all usernames.
Zeile 366: Zeile 371:
 default_pass_scheme = PLAIN default_pass_scheme = PLAIN
 -- --
-# Tachtler+# Tachtler - CentOS 6
 user_query = SELECT 10000 AS uid, 10000 as gid, '/var/spool/vmail/%Ld/%Ln' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1 user_query = SELECT 10000 AS uid, 10000 as gid, '/var/spool/vmail/%Ld/%Ln' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1
 +# Tachtler - CentOS 7
 +user_query = SELECT 10000 AS uid, 10000 as gid, '/var/spool/vmail/%Ld/%Ln' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1
 +# Tachtler - CentOS 7 - SQL-Quota
 +user_query = SELECT 10000 AS uid, 10000 as gid, '/srv/vmail/%Ld/%Ln' AS home, concat('*:bytes=', IF(mailbox.quota = 0, domain.maxquota*1024000, mailbox.quota)) AS quota_rule FROM mailbox, domain WHERE username = '%Lu' AND mailbox.active = 1 AND domain.domain = '%Ld' AND domain.active ='1'
 -- --
-# Tachtler+# Tachtler - CentOS 6 
 +password_query = SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/var/spool/vmail/%Ld/%Ln' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1 
 +# Tachtler - CentOS 7
 password_query = SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/var/spool/vmail/%Ld/%Ln' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1 password_query = SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/var/spool/vmail/%Ld/%Ln' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1
 -- --
Zeile 398: Zeile 409:
   * ''userdb'' - ''home'' - Verzeichnis in dem die (hier ''Maildir'')-Struktur liegt   * ''userdb'' - ''home'' - Verzeichnis in dem die (hier ''Maildir'')-Struktur liegt
   * ''userdb'' - ''quota'' - Quota, zusammengesetzten aus einer Zeichenkette und einem Datenbankfeld   * ''userdb'' - ''quota'' - Quota, zusammengesetzten aus einer Zeichenkette und einem Datenbankfeld
 +**__CentOS 6__**
 <code ini> <code ini>
 user_query = SELECT 10000 AS uid, 10000 as gid, '/var/spool/vmail/%Ld/%Ln' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1 user_query = SELECT 10000 AS uid, 10000 as gid, '/var/spool/vmail/%Ld/%Ln' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1
 +</code>
 +**__CentOS 7__**
 +<code ini>
 +user_query = SELECT 10000 AS uid, 10000 as gid, '/srv/vmail/%Ld/%Ln' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%Lu' AND active = 1
 +</code>
 +und **mit SQL-Quota**
 +<code ini>
 +user_query = SELECT 10000 AS uid, 10000 as gid, '/srv/vmail/%Ld/%Ln' AS home, concat('*:bytes=', IF(mailbox.quota = 0, domain.maxquota*1024000, mailbox.quota)) AS quota_rule FROM mailbox, domain WHERE username = '%Lu' AND mailbox.active = 1 AND domain.domain = '%Ld' AND domain.active ='1'
 </code> </code>
 * //%Ld = domain = tachtler.net (in Kleinschrift) | %Ln = localpart = klaus (in Kleinschrift) | %Lu = localpart@domain = klaus@tachtler.net (in Kleinschrift)// * //%Ld = domain = tachtler.net (in Kleinschrift) | %Ln = localpart = klaus (in Kleinschrift) | %Lu = localpart@domain = klaus@tachtler.net (in Kleinschrift)//
Zeile 412: Zeile 432:
   * ''userdb'' - ''home'' - Verzeichnis in dem die (hier ''Maildir'')-Struktur liegt   * ''userdb'' - ''home'' - Verzeichnis in dem die (hier ''Maildir'')-Struktur liegt
   * ''userdb'' - ''quota'' - Quota, zusammengesetzten aus einer Zeichenkette und einem Datenbankfeld   * ''userdb'' - ''quota'' - Quota, zusammengesetzten aus einer Zeichenkette und einem Datenbankfeld
 +**__CentOS 6__**
 <code ini> <code ini>
 password_query = SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/var/spool/vmail/%Ld/%Ln' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = '%Lu' password_query = SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/var/spool/vmail/%Ld/%Ln' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = '%Lu'
 +</code>
 +**__CentOS 7__**
 +<code ini>
 +password_query = SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/srv/vmail/%Ld/%Ln' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = '%Lu'
 </code> </code>
 * //%Ld = domain = tachtler.net (in Kleinschrift) | %Ln = localpart = klaus (in Kleinschrift) | %Lu = localpart@domain = klaus@tachtler.net (in Kleinschrift)// * //%Ld = domain = tachtler.net (in Kleinschrift) | %Ln = localpart = klaus (in Kleinschrift) | %Lu = localpart@domain = klaus@tachtler.net (in Kleinschrift)//
Zeile 513: Zeile 538:
 **ggf. Stand mit Authentifizierungsverfahren ''passwd-file''** wie unter nachfolgenden internen Link **ggf. Stand mit Authentifizierungsverfahren ''passwd-file''** wie unter nachfolgenden internen Link
   * [[tachtler:dovecot_centos_6#konfiguration_-_authentifizierungpasswd-file|Dovecot CentOS 6 - Konfiguration - Authentifizierung: passwd-file]]   * [[tachtler:dovecot_centos_6#konfiguration_-_authentifizierungpasswd-file|Dovecot CentOS 6 - Konfiguration - Authentifizierung: passwd-file]]
 +  * [[tachtler:dovecot_centos_7#konfiguration_-_authentifizierungpasswd-file|Dovecot CentOS 7 - Konfiguration - Authentifizierung: passwd-file]]
 beschrieben. beschrieben.
  
Zeile 554: Zeile 580:
 <code> <code>
 # doveconf -n # doveconf -n
-# 2.2.10: /etc/dovecot/dovecot.conf +# 2.2.18: /etc/dovecot/dovecot.conf 
-# OS: Linux 2.6.32-431.11.2.el6.x86_64 x86_64 CentOS release 6.5 (Final) +# Pigeonhole version 0.4.8 (0c4ae064f307+) 
 +# OS: Linux 3.10.0-229.7.2.el7.x86_64 x86_64 CentOS Linux release 7.1.1503 (Core)  
 auth_debug = yes auth_debug = yes
 +auth_debug_passwords = yes
 auth_master_user_separator = * auth_master_user_separator = *
 auth_mechanisms = plain digest-md5 cram-md5 login auth_mechanisms = plain digest-md5 cram-md5 login
Zeile 566: Zeile 594:
 mail_plugins = " quota acl zlib mail_log notify" mail_plugins = " quota acl zlib mail_log notify"
 managesieve_notify_capability = mailto managesieve_notify_capability = mailto
-managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress +managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate
-comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment +
-mailbox date ihave+
 mbox_write_locks = fcntl mbox_write_locks = fcntl
 namespace { namespace {
Zeile 626: Zeile 652:
   quota_warning = storage=95%% quota-warning 95 %u   quota_warning = storage=95%% quota-warning 95 %u
   quota_warning2 = storage=80%% quota-warning 80 %u   quota_warning2 = storage=80%% quota-warning 80 %u
-  sieve = ~/.dovecot.sieve +  sieve = file:~/sieve;active=~/.dovecot.sieve
-  sieve_dir = ~/sieve+
   zlib_save = gz   zlib_save = gz
   zlib_save_level = 6   zlib_save_level = 6
Zeile 651: Zeile 676:
 service managesieve-login { service managesieve-login {
   inet_listener sieve {   inet_listener sieve {
 +    address = 192.168.0.80
     port = 4190     port = 4190
-  } 
-  inet_listener sieve_deprecated { 
-    port = 2000 
   }   }
 } }
Zeile 667: Zeile 690:
 service quota-warning { service quota-warning {
   executable = script /usr/local/bin/quota-warning.sh   executable = script /usr/local/bin/quota-warning.sh
 +  unix_listener quota-warning {
 +    user = vmail
 +  }
   user = vmail   user = vmail
 } }
Zeile 687: Zeile 713:
 } }
 protocol imap { protocol imap {
-  mail_max_userip_connections = 30+  mail_max_userip_connections = 50
   mail_plugins = " quota acl zlib mail_log notify imap_quota imap_acl imap_zlib"   mail_plugins = " quota acl zlib mail_log notify imap_quota imap_acl imap_zlib"
 } }
 protocol sieve { protocol sieve {
-  mail_max_userip_connections = 30+  mail_max_userip_connections = 50
 } }
 </code> </code>
Zeile 702: Zeile 728:
 Stopping Dovecot Imap:                                     [  OK  ] Stopping Dovecot Imap:                                     [  OK  ]
 Starting Dovecot Imap:                                     [  OK  ] Starting Dovecot Imap:                                     [  OK  ]
 +</code>
 +bzw.
 +<code>
 +# systemctl restart dovecot
 </code> </code>
  
Zeile 719: Zeile 749:
 zur Anzeige bringen, wenn das **Log-Ausgabe** wie in diesem internen Link beschrieben zur Anzeige bringen, wenn das **Log-Ausgabe** wie in diesem internen Link beschrieben
   * [[tachtler:dovecot_centos_6#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 6 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]   * [[tachtler:dovecot_centos_6#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 6 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 +  * [[tachtler:dovecot_centos_7#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 7 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 gesetzt wurde: gesetzt wurde:
 (**Nur relevanter Ausschnitt**): (**Nur relevanter Ausschnitt**):
 <code> <code>
-... dovecot: master: Dovecot v2.2.10 starting up for imap, lmtp, sieve (core dumps disabled)+... dovecot: master: Dovecot v2.2.18 starting up for imap, lmtp, sieve (core dumps disabled)
 ... dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth ... dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth
 ... dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so ... dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so
-... dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so 
 ... dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so ... dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so
 ... dovecot: auth: Debug: Read auth token secret from /var/run/dovecot/auth-token-secret.dat ... dovecot: auth: Debug: Read auth token secret from /var/run/dovecot/auth-token-secret.dat
 ... dovecot: auth: Debug: passwd-file /etc/dovecot/master-users: Read 1 users in 0 secs ... dovecot: auth: Debug: passwd-file /etc/dovecot/master-users: Read 1 users in 0 secs
-... dovecot: auth: Debug: auth client connected (pid=2168)+... dovecot: auth: Debug: auth client connected (pid=25782)
 ... dovecot: auth: Debug: auth client connected (pid=0) ... dovecot: auth: Debug: auth client connected (pid=0)
-... dovecot: auth: Debug: client in: AUTH#0111#011PLAIN#011service=doveadm#011resp=<hidden> +... dovecot: auth: Debug: client in: AUTH  1       PLAIN   service=doveadm resp=AGtsYXVzQHRhY2h0bGVyLm5ldABnZWhlaW0= (previous base64 data may contain sensitive data) 
-... dovecot: auth-worker(2180): Debug: Loading modules from directory: /usr/lib64/dovecot/auth +... dovecot: auth-worker(25792): Debug: Loading modules from directory: /usr/lib64/dovecot/auth 
-... dovecot: auth-worker(2180): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so +... dovecot: auth-worker(25792): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so 
-... dovecot: auth-worker(2180): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so +... dovecot: auth-worker(25792): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so 
-... dovecot: auth-worker(2180): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so +... dovecot: auth-worker(25792): Debug: passwd-file /etc/dovecot/master-users: Read 1 users in 0 secs 
-... dovecot: auth-worker(2180): Debug: passwd-file /etc/dovecot/master-users: Read 1 users in 0 secs +... dovecot: auth-worker(25792): Debug: sql(klaus@tachtler.net): query: SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/srv/vmail/tachtler.net/klaus' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = 'klaus@tachtler.net' AND active = 1 
-... dovecot: auth-worker(2180): Debug: sql(klaus@tachtler.net): query: SELECT username AS user, password, +... dovecot: auth: Debug: client passdb out: OK    1       user=klaus@tachtler.net
-10000 AS userdb_uid, 10000 as userdb_gid, '/var/spool/vmail/tachtler.net/klaus' AS userdb_home, +
-concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = 'klaus@tachtler.net' +
-AND active = 1 +
-... dovecot: auth: Debug: client passdb out: OK#0111#011user=klaus@tachtler.net+
 </code> </code>
  
Zeile 757: Zeile 783:
 zur Anzeige bringen, wenn das **Log-Ausgabe** wie in diesem internen Link beschrieben zur Anzeige bringen, wenn das **Log-Ausgabe** wie in diesem internen Link beschrieben
   * [[tachtler:dovecot_centos_6#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 6 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]   * [[tachtler:dovecot_centos_6#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 6 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 +  * [[tachtler:dovecot_centos_7#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 7 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 gesetzt wurde: gesetzt wurde:
 (**Nur relevanter Ausschnitt**): (**Nur relevanter Ausschnitt**):
 <code> <code>
-... dovecot: auth: Debug: master in: LIST#0111#011user=*#011service=doveadm +... dovecot: auth: Debug: master in: LIST  1       user=*  service=doveadm 
-... dovecot: auth-worker(3091): Debug: sql(*): SELECT username AS user FROM mailbox WHERE active = 1+... dovecot: auth-worker(25799): Debug: Loading modules from directory: /usr/lib64/dovecot/auth 
 +... dovecot: auth-worker(25799): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so 
 +... dovecot: auth-worker(25799): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so 
 +... dovecot: auth-worker(25799): Debug: passwd-file /etc/dovecot/master-users: Read 1 users in 0 secs 
 +... dovecot: auth-worker(25799): Debug: sql(*): SELECT username AS user FROM mailbox WHERE active = 1
 </code> </code>
  
Zeile 770: Zeile 801:
 uid 10000 uid 10000
 gid 10000 gid 10000
-home /var/spool/vmail/tachtler.net/klaus+home /srv/vmail/tachtler.net/klaus
 mail maildir:~/Maildir mail maildir:~/Maildir
-quota_rule *:bytes=1048576000+quota_rule *:bytes=1024000000
  
 # doveadm user petra@tachtler.net # doveadm user petra@tachtler.net
Zeile 778: Zeile 809:
 uid 10000 uid 10000
 gid 10000 gid 10000
-home /var/spool/vmail/tachtler.net/petra+home /srv/vmail/tachtler.net/petra
 mail maildir:~/Maildir mail maildir:~/Maildir
-quota_rule *:bytes=1048576000+quota_rule *:bytes=1024000000
 </code> </code>
  
Zeile 787: Zeile 818:
 zur Anzeige bringen, wenn das **Log-Ausgabe** wie in diesem internen Link beschrieben zur Anzeige bringen, wenn das **Log-Ausgabe** wie in diesem internen Link beschrieben
   * [[tachtler:dovecot_centos_6#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 6 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]   * [[tachtler:dovecot_centos_6#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 6 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 +  * [[tachtler:dovecot_centos_7#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 7 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 gesetzt wurde: gesetzt wurde:
 (**Nur relevanter Ausschnitt**): (**Nur relevanter Ausschnitt**):
 <code> <code>
-... dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth +... dovecot: auth: Debug: master in: USER  1       klaus@tachtler.net      service=doveadm       
-... dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so +... dovecot: auth: Debug: prefetch(klaus@tachtler.net): passdb didn't return userdb entries, trying the next userdb 
-... dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so +... dovecot: auth-worker(25809): Debug: Loading modules from directory: /usr/lib64/dovecot/auth 
-... dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so +... dovecot: auth-worker(25809): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so 
-... dovecot: auth: Debug: Read auth token secret from /var/run/dovecot/auth-token-secret.dat +... dovecot: auth-worker(25809): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so 
-... dovecot: auth: Debug: passwd-file /etc/dovecot/master-users: Read 1 users in 0 secs +... dovecot: auth-worker(25809): Debug: passwd-file /etc/dovecot/master-users: Read 1 users in 0 secs 
-... dovecot: auth: Debug: master in: USER#0111#011klaus@tachtler.net#011service=doveadm +... dovecot: auth-worker(25809): Debug: sql(klaus@tachtler.net): SELECT 10000 AS uid, 10000 as gid, '/srv/vmail/tachtler.net/klaus' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = 'klaus@tachtler.net' AND active = 1 
-... dovecot: auth: Debug: prefetch(klaus@tachtler.net): passdb didn't return userdb entries,  +... dovecot: auth: Debug: userdb out: USER 1       klaus@tachtler.net      uid=10000       gid=10000       home=/srv/vmail/tachtler.net/klaus      quota_rule=*:bytes=1024000000 
-trying the next userdb +... dovecot: auth: Debug: master in: USER  1       petra@tachtler.net      service=doveadm       
-... dovecot: auth-worker(5173): Debug: Loading modules from directory: /usr/lib64/dovecot/auth +... dovecot: auth: Debug: prefetch(petra@tachtler.net): passdb didn't return userdb entries, trying the next userdb 
-... dovecot: auth-worker(5173): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so +... dovecot: auth-worker(25809): Debug: sql(petra@tachtler.net): SELECT 10000 AS uid, 10000 as gid, '/srv/vmail/tachtler.net/petra' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = 'petra@tachtler.net' AND active = 1 
-... dovecot: auth-worker(5173): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so +... dovecot: auth: Debug: userdb out: USER 1       petra@tachtler.net      uid=10000       gid=10000       home=/srv/vmail/tachtler.net/petra      quota_rule=*:bytes=1024000000
-... dovecot: auth-worker(5173): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so +
-... dovecot: auth-worker(5173): Debug: passwd-file /etc/dovecot/master-users: Read 1 users in 0 secs +
-... dovecot: auth-worker(5173): Debug: sql(klaus@tachtler.net): SELECT 10000 AS uid, 10000 as gid,  +
-'/var/spool/vmail/tachtler.net/klaus' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox +
-WHERE username = 'klaus@tachtler.net' AND active = 1 +
-... dovecot: auth: Debug: userdb out: USER#0111#011klaus@tachtler.net#011uid=10000#011gid=10000 +
-#011home=/var/spool/vmail/tachtler.net/klaus#011quota_rule=*:bytes=1048576000 +
-... dovecot: auth: Debug: master in: USER#0111#011petra@tachtler.net#011service=doveadm +
-... dovecot: auth: Debug: prefetch(petra@tachtler.net): passdb didn't return userdb entries, +
-trying the next userdb +
-... dovecot: auth-worker(5173): Debug: sql(petra@tachtler.net): SELECT 10000 AS uid, 10000 as gid, +
-'/var/spool/vmail/tachtler.net/petra' AS home, concat('*:bytes=', quota) AS quota_rule FROM mailbox +
-WHERE username = 'petra@tachtler.net' AND active = 1 +
-... dovecot: auth: Debug: userdb out: USER#0111#011petra@tachtler.net#011uid=10000#011gid=10000 +
-#011home=/var/spool/vmail/tachtler.net/petra#011quota_rule=*:bytes=1048576000+
 </code> </code>
  
Zeile 825: Zeile 842:
 zur Anzeige bringen, wenn das **Log-Ausgabe** wie in diesem internen Link beschrieben zur Anzeige bringen, wenn das **Log-Ausgabe** wie in diesem internen Link beschrieben
   * [[tachtler:dovecot_centos_6#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 6 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]   * [[tachtler:dovecot_centos_6#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 6 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 +  * [[tachtler:dovecot_centos_7#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 7 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 gesetzt wurde: gesetzt wurde:
 (**Nur relevanter Ausschnitt**): (**Nur relevanter Ausschnitt**):
 <code> <code>
-... dovecot: auth: Debug: client in: AUTH#01116#011PLAIN#011service=imap#011secured +... dovecot: auth: Debug: client in: AUTH  1       PLAIN   service=imap    secured session=z/KzOscaRQAKBwBQ        lip=192.168.0.80   rip=192.168.0.80   lport=143       rport=53061     resp=AGtsYXVzQHRhY2h0bGVyLm5ldABzdWFsazFsYWt1JDA= (previous base64 data may contain sensitive data) 
-#011session=hrKnIzz37AAKAAA8#011lip=192.168.0.80#011rip=192.168.0.60#011lport=143 +... dovecot: auth-worker(25839): Debug: Loading modules from directory: /usr/lib64/dovecot/auth 
-#011rport=23143#011resp=<hidden> +... dovecot: auth-worker(25839): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_mysql.so 
-... dovecot: auth-worker(5369): Debug: sql(klaus@tachtler.net,192.168.0.60): query:  +... dovecot: auth-worker(25839): Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so 
-SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid,  +... dovecot: auth-worker(25839): Debug: passwd-file /etc/dovecot/master-users: Read 1 users in 0 secs 
-'/var/spool/vmail/tachtler.net/klaus' AS userdb_home, +... dovecot: auth-worker(25839): Debug: sql(klaus@tachtler.net,192.168.0.80): query: SELECT username AS user, password, 10000 AS userdb_uid, 10000 as userdb_gid, '/srv/vmail/tachtler.net/klaus' AS userdb_home, concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE username = 'klaus@tachtler.net' AND active = 1 
-concat('*:bytes=', quota) AS userdb_quota_rule FROM mailbox WHERE  +... dovecot: auth: Debug: client passdb out: OK    1       user=klaus@tachtler.net 
-username = 'klaus@tachtler.net' AND active = 1 +... dovecot: auth: Debug: master in: REQUEST       2495873025      25782   1       a6ee3669274b8f8852481160f01f25df        session_pid=25841       request_auth_token    
-... dovecot: auth: Debug: client passdb out: OK#01116#011user=klaus@tachtler.net +... dovecot: auth: Debug: prefetch(klaus@tachtler.net,192.168.0.80,<z/KzOscaRQAKBwBQ>): success 
-... dovecot: auth: Debug: master in: REQUEST#011729546753#0112168#01116#01dcd97623e3c30ac23cce91ec1e454bcb3 +... dovecot: auth: Debug: master userdb out: USER  2495873025      klaus@tachtler.net      uid=10000       gid=10000       home=/srv/vmail/tachtler.net/klaus      quota_rule=*:bytes=1024000000   auth_token=6f1219393aa147f3bec2544ba7509aa6553081f0 
-#011session_pid=4382#011request_auth_token +... dovecot: imap-login: Login: user=<klaus@tachtler.net>, method=PLAIN, rip=192.168.0.80, lip=192.168.0.80, mpid=25841, secured, session=<z/KzOscaRQAKBwBQ> 
-... dovecot: auth: Debug: prefetch(klaus@tachtler.net,192.168.0.60,<hrKnIzz37AAKAAA8>): success +... dovecot: imap(klaus@tachtler.net): Debug: Loading modules from directory: /usr/lib64/dovecot 
-... dovecot: auth: Debug: master userdb out: USER#011729546753#011klaus@tachtler.net +... dovecot: imap(klaus@tachtler.net): Debug: Module loaded: /usr/lib64/dovecot/lib01_acl_plugin.so 
-#011uid=10000#011gid=10000#011home=/var/spool/vmail/tachtler.net/klaus +... dovecot: imap(klaus@tachtler.net): Debug: Module loaded: /usr/lib64/dovecot/lib02_imap_acl_plugin.so 
-#011quota_rule=*:bytes=1048576000#011auth_token=a9206e34fe1b5fdab3d4abca8d5d153bc38e3422+... dovecot: imap(klaus@tachtler.net): Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so 
 +... dovecot: imap(klaus@tachtler.net): Debug: Module loaded: /usr/lib64/dovecot/lib11_imap_quota_plugin.so 
 +... dovecot: imap(klaus@tachtler.net): Debug: Module loaded: /usr/lib64/dovecot/lib15_notify_plugin.so 
 +... dovecot: imap(klaus@tachtler.net): Debug: Module loaded: /usr/lib64/dovecot/lib20_mail_log_plugin.so 
 +... dovecot: imap(klaus@tachtler.net): Debug: Module loaded: /usr/lib64/dovecot/lib20_zlib_plugin.so 
 +... dovecot: imap(klaus@tachtler.net): Debug: Module loaded: /usr/lib64/dovecot/lib30_imap_zlib_plugin.so 
 +... dovecot: imap(klaus@tachtler.net): Debug: Added userdb setting: plugin/quota_rule=*:bytes=1024000000 
 +... dovecot: imap(klaus@tachtler.net): Debug: Effective uid=10000, gid=10000, home=/srv/vmail/tachtler.net/klaus 
 +... dovecot: imap(klaus@tachtler.net): Debug: Quota root: name=User quota backend=maildir args= 
 +... dovecot: imap(klaus@tachtler.net): Debug: Quota rule: root=User quota mailbox=* bytes=1024000000 messages=0 
 +... dovecot: imap(klaus@tachtler.net): Debug: Quota rule: root=User quota mailbox=INBOX/Trash bytes=+104857600 messages=0 
 +... dovecot: imap(klaus@tachtler.net): Debug: Quota warning: bytes=972800000 (95%) messages=0 reverse=no command=quota-warning 95 klaus@tachtler.net 
 +... dovecot: imap(klaus@tachtler.net): Debug: Quota warning: bytes=819200000 (80%) messages=0 reverse=no command=quota-warning 80 klaus@tachtler.net 
 +... dovecot: imap(klaus@tachtler.net): Debug: Quota grace: root=User quota bytes=102400000 (10%) 
 +... dovecot: imap(klaus@tachtler.net): Debug: Namespace inbox: type=private, prefix=INBOX/, sep=/, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:~/Maildir 
 +... dovecot: imap(klaus@tachtler.net): Debug: maildir++: root=/srv/vmail/tachtler.net/klaus/Maildir, index=, indexpvt=, control=, inbox=/srv/vmail/tachtler.net/klaus/Maildir, alt= 
 +... dovecot: imap(klaus@tachtler.net): Debug: acl: initializing backend with data: vfile 
 +... dovecot: imap(klaus@tachtler.net): Debug: acl: acl username = klaus@tachtler.net  
 +... dovecot: imap(klaus@tachtler.net): Debug: acl: owner = 1 
 +... dovecot: imap(klaus@tachtler.net): Debug: acl vfile: Global ACLs disabled  
 +... dovecot: imap(klaus@tachtler.net): Debug: Namespace : type=shared, prefix=shared/%u/, sep=/, inbox=no, hidden=no, list=children, subscriptions=yes location=maildir:%h/Maildir:INDEX=/srv/vmail/tachtler.net/klaus/shared/%u:CONTROL=/srv/vmail/tachtler.net/klaus/shared/%u 
 +... dovecot: imap(klaus@tachtler.net): Debug: shared: root=/var/run/dovecot, index=, indexpvt=, control=, inbox=, alt= 
 +... dovecot: imap(klaus@tachtler.net): Debug: acl: initializing backend with data: vfile 
 +... dovecot: imap(klaus@tachtler.net): Debug: acl: acl username = klaus@tachtler.net  
 +... dovecot: imap(klaus@tachtler.net): Debug: acl: owner = 0 
 +... dovecot: imap(klaus@tachtler.net): Debug: acl vfile: Global ACLs disabled  
 +... dovecot: imap(klaus@tachtler.net): Debug: Namespace : type=private, prefix=, sep=, inbox=no, hidden=yes, list=no, subscriptions=no location=fail::LAYOUT=none 
 +... dovecot: imap(klaus@tachtler.net): Debug: none: root=, index=, indexpvt=, control=, inbox=, alt= 
 +... dovecot: imap(klaus@tachtler.net): Disconnected: Logged out in=9 out=436
 </code> </code>
  
tachtler/dovecot_authentifizierung_-_sql.1436815690.txt.gz · Zuletzt geändert: 2015/07/13 21:28 von klaus