Hi,
Going by the "static userdb" example? on this page
(https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar
setup in conjunction with pgsql for passdb.
However I get an error "auth: Warning: sql: Ignoring changed iterate_query
in /etc/dovecot/local_sql_users.conf, because userdb sql not used. (If this is
intentional, set userdb_warning_disable=yes)"
Does this mean the following is not a valid config ? Or at least I will not be
able to achieve iteration ?
mail_location = maildir:/foobar/mail/%d/%n/Maildir
passdb {
? driver = sql
? args = /etc/dovecot/local_sql_users.conf
}
userdb {
? driver = static
? args = uid=foo gid=bar home=/foobar/mail/%d/%n
}
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 17/05/2020 12:34 Laura Smith <<a
href="mailto:n5d9xq3ti233xiyif2vp@protonmail.ch">n5d9xq3ti233xiyif2vp@protonmail.ch</a>>
wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
Hi,
</div>
<div>
<br>
</div>
<div>
Going by the "static userdb" example on this page (<a
href="https://wiki.dovecot.org/VirtualUsers#homedirs)"
rel="noopener"
target="_blank">https://wiki.dovecot.org/VirtualUsers#homedirs)</a>,
tried to achieve a similar setup in conjunction with pgsql for passdb.
</div>
<div>
<br>
</div>
<div>
However I get an error "auth: Warning: sql: Ignoring changed
iterate_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used.
(If this is intentional, set userdb_warning_disable=yes)"
</div>
<div>
<br>
</div>
<div>
Does this mean the following is not a valid config ? Or at least I will not
be able to achieve iteration ?
</div>
<div>
<br>
</div>
<div>
mail_location = maildir:/foobar/mail/%d/%n/Maildir
</div>
<div>
passdb {
</div>
<div>
driver = sql
</div>
<div>
args = /etc/dovecot/local_sql_users.conf
</div>
<div>
}
</div>
<div>
userdb {
</div>
<div>
driver = static
</div>
<div>
args = uid=foo gid=bar home=/foobar/mail/%d/%n
</div>
<div>
}
</div>
</blockquote>
<div>
<br>
</div>
<div>
It's valid but why do it like this? You can return these fields with
user_query in the sql config.
</div>
<div>
<br>
</div>
<div>
Aki
</div>
<div class="io-ox-signature">
<pre>---
Aki Tuomi</pre>
</div>
</body>
</html>
On Sunday, 17 May 2020 10:38, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:> > On 17/05/2020 12:34 Laura Smith <n5d9xq3ti233xiyif2vp at protonmail.ch> wrote: > > > > Hi, > > > > Going by the "static userdb" example? on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar setup in conjunction with pgsql for passdb. > > > > However I get an error "auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used. (If this is intentional, set userdb_warning_disable=yes)" > > > > Does this mean the following is not a valid config ? Or at least I will not be able to achieve iteration ? > > > > mail_location = maildir:/foobar/mail/%d/%n/Maildir > > passdb { > > ? driver = sql > > ? args = /etc/dovecot/local_sql_users.conf > > } > > userdb { > > ? driver = static > > ? args = uid=foo gid=bar home=/foobar/mail/%d/%n > > } > > It's valid but why do it like this? You can return these fields with user_query in the sql config.? > > Aki > > --- > Aki TuomiBecause I wanted to avoid storing uid/gid/home in the database ?