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