Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- tachtler:dovecot_authentifizierung_-_sql [2015/07/13 21:51] – [Neustart] klaus
+++ tachtler:dovecot_authentifizierung_-_sql [2017/04/07 14:39] (aktuell) – [/etc/dovecot/dovecot-sql.conf.ext] klaus
@@ Zeile 335: / Zeile 335: @@
 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 WHERE username = '%Lu' AND active = 1
+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
@@ Zeile 373: / Zeile 375: @@
 # 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 - CentOS 6
@@ Zeile 412: / Zeile 416: @@
 <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>
 * //%Ld = domain = tachtler.net (in Kleinschrift) | %Ln = localpart = klaus (in Kleinschrift) | %Lu = localpart@domain = klaus@tachtler.net (in Kleinschrift)//
@@ Zeile 741: / Zeile 749: @@
 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_7#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 7 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 gesetzt wurde:
 (**Nur relevanter Ausschnitt**):
 <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: 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: 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: auth client connected (pid=2168)
+... dovecot: auth: Debug: auth client connected (pid=25782)
 ... 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
-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>
@@ Zeile 779: / Zeile 783: @@
 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_7#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 7 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 gesetzt wurde:
 (**Nur relevanter Ausschnitt**):
 <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>
@@ Zeile 792: / Zeile 801: @@
 uid	10000
 gid	10000
-home	/var/spool/vmail/tachtler.net/klaus
+home	/srv/vmail/tachtler.net/klaus
 mail	maildir:~/Maildir
-quota_rule	*:bytes=1048576000
+quota_rule	*:bytes=1024000000
 # doveadm user petra@tachtler.net
@@ Zeile 800: / Zeile 809: @@
 uid	10000
 gid	10000
-home	/var/spool/vmail/tachtler.net/petra
+home	/srv/vmail/tachtler.net/petra
 mail	maildir:~/Maildir
-quota_rule	*:bytes=1048576000
+quota_rule	*:bytes=1024000000
 </code>
@@ Zeile 809: / Zeile 818: @@
 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_7#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 7 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 gesetzt wurde:
 (**Nur relevanter Ausschnitt**):
 <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>
@@ Zeile 847: / Zeile 842: @@
 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_7#etc_dovecot_confd_10-loggingconf|Dovecot CentOS 7 - Konfiguration - Basiskonfiguration - /etc/dovecot/conf.d/10-logging.conf]]
 gesetzt wurde:
 (**Nur relevanter Ausschnitt**):
 <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>