[vhffs-dev] [2160] this time, it should works |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
Revision: 2160
Author: gradator
Date: 2012-04-26 21:38:31 +0200 (Thu, 26 Apr 2012)
Log Message:
-----------
this time, it should works
Modified Paths:
--------------
trunk/vhffs-doc/config/courier/authpgsqlrc
Modified: trunk/vhffs-doc/config/courier/authpgsqlrc
===================================================================
--- trunk/vhffs-doc/config/courier/authpgsqlrc 2012-04-26 19:25:07 UTC (rev 2159)
+++ trunk/vhffs-doc/config/courier/authpgsqlrc 2012-04-26 19:38:31 UTC (rev 2160)
@@ -213,7 +213,7 @@
# AND popbox.domain_name = '$(domain)' \
# AND popbox.domain_name = domain.domain_name
-PGSQL_SELECT_CLAUSE SELECT lp.localpart||'@'||mx.domain, lp.password, '', 104, 108, '/data/mail/boxes/'||substr(mx.domain,1,1)||'/'||substr(mx.domain,2,1)||'/'||mx.domain||'/'||substr(lp.localpart,1,1)||'/'||lp.localpart, 'Maildir', '', '' FROM vhffs_mx mx INNER JOIN vhffs_mx_localpart lp ON lp.mx_id=lp.mx_id INNER JOIN vhffs_mx_box b ON b.localpart_id=lp.localpart_id WHERE b.state=6 AND lp.localpart='$(local_part)' AND mx.domain='$(domain)' AND ( ('$(service)' LIKE 'pop%' AND b.allowpop=true) OR ('$(service)' LIKE 'imap%' AND b.allowimap=true) )
+PGSQL_SELECT_CLAUSE SELECT lp.localpart||'@'||mx.domain, lp.password, '', 102, 104, '/data/mail/boxes/'||substr(mx.domain,1,1)||'/'||substr(mx.domain,2,1)||'/'||mx.domain||'/'||substr(lp.localpart,1,1)||'/'||lp.localpart, 'Maildir', '', '', '' FROM vhffs_mx mx INNER JOIN vhffs_mx_localpart lp ON lp.mx_id=mx.mx_id INNER JOIN vhffs_mx_box b ON b.localpart_id=lp.localpart_id WHERE b.state=6 AND lp.localpart='$(local_part)' AND mx.domain='$(domain)' AND ( ('$(service)' LIKE 'pop%' AND b.allowpop=true) OR ('$(service)' LIKE 'imap%' AND b.allowimap=true) )
##NAME: PGSQL_ENUMERATE_CLAUSE:1
#