Displaying 5 results from an estimated 5 matches for "local_sql_us".
2020 May 22
1
Dovecot passdb and postfix login
...story short I've got a fully functional Dovecot IMAP instance and I am now looking to upgrade some perimiter authenticated SMTP relays to authenticate against the Dovecot instance.
Trouble is that I am seeing errors such as "auth: Warning: sql: Ignoring changed user_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used." in my Postfix server logs and not able to successfully authenticate via AUTH LOGIN on the Postfi instance.
Perhaps I'm missing something obvious from my config ? Here is the doveconf -n from the Postfix server in question:
# 2.3.10.1 (a3d0e1171): /e...
2020 May 17
2
iterate_query with static userdb ?
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/...
2020 May 17
1
"/etc/dovecot/dovecot.conf: passdb is missing driver"
Hi,
I'm trying to get dovecot working with postgres, I'm on Debian 10 and have installed dovecot-pgsql from the Dovecot repo (https://repo.dovecot.org/ce-2.3-latest/debian/....).
I have the following in my local.conf :
passdb sql {
? args = /etc/dovecot/local_sql_users.conf
}
And the following in the referenced file:
driver = pgsql
connect = host=localhost dbname=foobar user=bar password=foo
default_pass_scheme = ARGON2ID
password_query = select dovecot_username as user,password from get_user('%u')
iterate_query = select dovecot_username as user from...
2020 May 17
0
iterate_query with static userdb ?
.../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 ?
</di...
2020 May 17
2
iterate_query with static userdb ?
...; 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...