Mercurial Mercurial > vmm / changeset
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | raw | gz | bz2 | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
pgsql: Don't select service_set.ssid in dovecotpassword() unconditional.
authorPascal Volk <user@localhost.localdomain.org>
Mon, 27 Aug 2012 22:09:24 +0000
changeset 595 86b967c0f1a1
parent 594 cdbe200c0ecc
child 596 607aa5c2acc4
pgsql: Don't select service_set.ssid in dovecotpassword() unconditional. This may cause an empty result, which will make logins impossible.
pgsql/create_tables.pgsql file | annotate | diff | comparison | revisions
pgsql/update_tables_0.5.x-0.6.pgsql file | annotate | diff | comparison | revisions 
--- a/pgsql/create_tables.pgsql	Mon Aug 27 20:49:31 2012 +0000
+++ b/pgsql/create_tables.pgsql	Mon Aug 27 22:09:24 2012 +0000
@@ -353,7 +353,6 @@
                                   FROM domain_name
                                  WHERE domainname = the_domain)
                AND local_part = localpart
-               AND service_set.ssid = users.ssid
                AND users.gid = domain_data.gid
                AND CASE WHEN
                   users.ssid IS NOT NULL
--- a/pgsql/update_tables_0.5.x-0.6.pgsql	Mon Aug 27 20:49:31 2012 +0000
+++ b/pgsql/update_tables_0.5.x-0.6.pgsql	Mon Aug 27 22:09:24 2012 +0000
@@ -307,7 +307,6 @@
                                   FROM domain_name
                                  WHERE domainname = the_domain)
                AND local_part = localpart
-               AND service_set.ssid = users.ssid
                AND users.gid = domain_data.gid
                AND CASE WHEN
                   users.ssid IS NOT NULL
vmm

Repositories index