Benutzer-Werkzeuge

Webseiten-Werkzeuge


tachtler:dovecot_authentifizierung_-_sql

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
tachtler:dovecot_authentifizierung_-_sql [2015/07/13 22:07]
klaus [Login-Test mit Client]
tachtler:dovecot_authentifizierung_-_sql [2017/04/07 14:39] (aktuell)
klaus [/etc/dovecot/dovecot-sql.conf.ext]
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 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 # 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 # If you wish to avoid two SQL lookups (passdb + userdb), you can use
Zeile 373: Zeile 375:
 # Tachtler - CentOS 7 # 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 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 # Tachtler - CentOS 6
Zeile 412: Zeile 416:
 <code ini> <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 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)//​
tachtler/dovecot_authentifizierung_-_sql.txt · Zuletzt geändert: 2017/04/07 14:39 von klaus