Changeset 3137 for alternc/trunk/etc/alternc/templates/dovecot/dovecot-sql.conf

Timestamp:

04/13/12 11:57:28 (13 months ago)

Author:

squidly

Message:

Templating dovecot+Postifx + Bugfix

File:

• alternc/trunk/etc/alternc/templates/dovecot/dovecot-sql.conf (modified) (2 diffs)

alternc/trunk/etc/alternc/templates/dovecot/dovecot-sql.conf

@@ -117 +117 @@
 #   user_query = SELECT home, 501 AS uid, 501 AS gid FROM users WHERE userid = '%u'
 #
-user_query = \
-  SELECT concat(concat(%%ALTERNC_LOC%%, '/'), mailbox.path) AS home, domaines.compte AS uid, domaines.compte AS gid \
-  FROM mailbox JOIN address ON address.id = mailbox.address_id JOIN domaines on domaines.id = address.domain_id WHERE '%u' IN (address.address, replace(address.address, '@', '_'))
+query = SELECT mailbox.path AS home, domaines.compte AS uid, domaines.compte AS gid FROM mailbox JOIN address ON address.id = mailbox.address_id JOIN domaines on domaines.id = address.domain_id WHERE address.address = '%n'
 
 # If you wish to avoid two SQL lookups (passdb + userdb), you can use
@@ -125 +123 @@
 # also have to return userdb fields in password_query prefixed with "userdb_"
 # string. For example:
-password_query = \
-  SELECT '%u' AS user, address.password, \
-    concat(concat(%%ALTERNC_LOC%%, '/'), mailbox.path) AS userdb_home, domaines.compte AS userdb_uid, domaines.compte AS userdb_gid \
-  FROM mailbox JOIN address ON address.id = mailbox.address_id JOIN domaines on domaines.id = address.domain_id WHERE '%u' IN (address.address, replace(address.address, '@', '_'))
+password_query = SELECT user, password, userdb_home, userdb_uid, userdb_gid,userdb_quota_rule FROM dovecot_view where user= '%u';