Displaying 20 results from an estimated 1000 matches similar to: "iterate_query does not use userdb - mail_location not found"
2012 Oct 11
3
dovecot cores
Hi dovecot-community,
i have set up a new dovecot server - everything is self-compiled
and with newest versions. dovecot daemon dies every night:
Bugreport Mail - dovecot cores with sig11
my dovecot daemon cores every night - no message in log file.
Please help. It runs in an OpenVZ container - therefore reiserfs
is reported as filesystem.
root at glen ~]# cat /etc/dovecot/dovecot.conf
#
2019 Oct 24
1
SQL iterate_query
I've been hunting some ghost mailboxes - and I *think* I found the source.
I use the complete email address as the username, and store such in a
database. The storage structure is location=/var/mail/%d/%n. Not unusual
I think.
So all I *should* see from "ls /var/mail" would be a list of domains.
But I keep seeing empty mailboxes being created at this level. Having
corrected a
2018 Jul 11
2
Connection refused (61)
---
/etc/smtpd/smtpd.conf
pki mx.domain.tld certificate "/etc/smtpd/tls/smtpd.crt"
pki mx.domain.tld key "/etc/smtpd/tls/smtpd.key"
table creds "/etc/smtpd/creds"
table vdoms "/etc/smtpd/vdoms"
table vusers "/etc/smtpd/vusers"
listen on eth0 tls pki mx.domain.tld
listen on eth0
2019 Aug 09
2
What does `iterate_query` for SQL want as output?
Hi all,
In an earlier thread, https://dovecot.org/pipermail/dovecot/2019-August/116694.html I got a lot of useful help about migration. On my older host, everything was static; on the newer host, I?m storing user information in Postgres. usernames are of the form <login at REALM>, say ?hile at coyhile.com? as basically a Kerberos principal, and authentication and individual lookups work.
2018 Jul 11
2
Connection refused (61)
$egress_int is NOT 127.0.0.1.
Change roundcube to use the same address.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: larryrtx at gmail.com
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
?On 7/11/18, 5:26 PM, "Teno Deuter" <gvgter at googlemail.com> wrote:
this is what I have now in my smptd conf file:
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)"
2018 Jul 11
2
Connection refused (61)
What does ifconfig nfe0 show for inet?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: larryrtx at gmail.com
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
?On 7/11/18, 5:35 PM, "Teno Deuter" <gvgter at googlemail.com> wrote:
but:
egress_int="nfe0"
you mean to put this value?
2018 Jul 11
2
Connection refused (61)
Yes, or, add another block of lines with lo (or lo0) depending on what your kernel uses for loopback in place of the $egress_int parameter to get it to listen on 127.0.0.1 as well.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: larryrtx at gmail.com
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
?On 7/11/18, 5:38 PM,
2019 Aug 09
2
What does `iterate_query` for SQL want as output?
> On Aug 9, 2019, at 3:45 PM, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:
>
>
>> On 09/08/2019 22:16 Coy Hile via dovecot <dovecot at dovecot.org> wrote:
>>
>>
>> Hi all,
>>
>> In an earlier thread, https://dovecot.org/pipermail/dovecot/2019-August/116694.html I got a lot of useful help about migration. On my older host, everything
2011 Oct 24
1
iterate_query not working
Hi,
I have got iterate_query defined in dovecot-sql.conf.ext. However when I
run a command like:
doveadm search -A BEFORE 10d
I receive an error message (Failed to iterate ...)
There is an error message in a log file too:
Error: Trying to iterate users, but userdbs don't support it
The problem is that monitoring a database server shows that dovecot does
not try to execute any query. What
2018 Jul 11
2
Connection refused (61)
Then you need to look at the opensmtpd logs to figure out why the starttls is failing.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: larryrtx at gmail.com
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
?On 7/11/18, 5:42 PM, "Teno Deuter" <gvgter at googlemail.com> wrote:
actually I did define the staic
2018 Jul 11
2
Connection refused (61)
yep
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: larryrtx at gmail.com
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
?On 7/11/18, 5:46 PM, "Teno Deuter" <gvgter at googlemail.com> wrote:
the maillog shows:
reason="io-error: error:14037418:SSL routines:ACCEPT_SR_KEY_EXCH:tlsv1
alert
2018 Jul 11
2
Connection refused (61)
Turn off TLS for webmail. It's not leaving the machine.
Or get a letsencrypt.org cert. (they are free) see acme.sh (https://github.com/Neilpang/acme.sh)
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: larryrtx at gmail.com
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
?On 7/11/18, 5:48 PM, "Teno Deuter"
2018 Jul 11
2
Connection refused (61)
Yes.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: larryrtx at gmail.com
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
?On 7/11/18, 6:02 PM, "Teno Deuter" <gvgter at googlemail.com> wrote:
you mean to turn off TLS in roundcube config file?
On Thu, Jul 12, 2018 at 12:51 AM, Larry Rosenman
2018 Jul 11
2
Connection refused (61)
If you telnet to port 25, do an EHLO host, does the response include AUTH? If not, opensmtpd is not offering AUTH over unencrypted port 25 connections.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: larryrtx at gmail.com
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
?On 7/11/18, 6:05 PM, "Teno Deuter" <gvgter
2018 Jul 11
2
Connection refused (61)
Read the docs....
Or, as I said earlier, get a (free) letsencrypt certificate.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: larryrtx at gmail.com
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
?On 7/11/18, 6:16 PM, "Teno Deuter" <gvgter at googlemail.com> wrote:
this is the result:
250-8BITMIME
2010 Aug 26
0
Table mail.users doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users)
connect = host=127.0.0.1 user=mail password=thecorrectpass dbname=mail
map {
pattern = shared/expire/$user/$mailbox
table = mail.expires
value_field = expire_stamp
fields {
username = $user
mailbox = $mailbox
}
}
dovecot: auth: Error: mysql: Query failed, retrying: Table 'mail.users'
doesn't exist
Aug 26 05:16:24 server1 dovecot: auth: Error: sql: Iterate
2019 Aug 09
0
What does `iterate_query` for SQL want as output?
> On 09/08/2019 22:16 Coy Hile via dovecot <dovecot at dovecot.org> wrote:
>
>
> Hi all,
>
> In an earlier thread, https://dovecot.org/pipermail/dovecot/2019-August/116694.html I got a lot of useful help about migration. On my older host, everything was static; on the newer host, I?m storing user information in Postgres. usernames are of the form <login at REALM>,
2020 May 17
0
iterate_query with static userdb ?
<!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:
2020 May 17
2
iterate_query with static userdb ?
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