similar to: Table mail.users doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users)

With the release of dovecot 2.0, the community of the Dovecot mailling list, and us at Shelton Computers, would sincerely like to thank the developers of Dovecot. For, if it were not for you, we would be stuck with Courier and would not have the impressive features of Sieve, as opposed to the unmanageable scripts, by end users, of maildrop. *Our gratitude goes to, but not limited to:* *Timo

I have fail2ban working for EVERYTHING else except dovecot. I have tried using my own custom regex in conjunction with the regex on the dovecot.org site. Neither are picked up by fail2ban and I'm trying to use an imminent attack agaist dovecot, going on now, to my advantage to see when I get the right regexp. Here are my current ones: failregex = .*dovecot: (?:pop3-login|imap-login):

I was naive to not check the log more thoroughly for changes. I need "dovecot: imap(jerrale at sheltoncomputers.com): Disconnected: Logged out bytes=1921/2983" to say the rip (ip address) as 1.2.x did; how do I accompish such? Jerrale G SC Senior Admin SC Senior Admin

In the shell: ,doveadm(root): Error: User listing returned failure,doveadm: Error: Failed to iterate through some users In the log: dovecot: auth: Error: sql: Iterate query failed: Table 'mail.users' doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users) Why is dovecot trying to "select username, domain from users" when the

/etc/dovecot.conf: auth default { mechanisms=plain login cram-md5 passdb { #.............. Windows Live Mail: CRAM-MD5 authentication failed. This could be due to a lack of memory on your system. Your IMAP command could not be sent to the server, due to non-network errors. This could, for example, indicate a lack of memory on your system. Configuration: Account: Sheltoncomputers

Reporting-MTA: dns; mail.sheltoncomputers.com X-SC-Mail-Server-Queue-ID: B84AF1B60004 X-SC-Mail-Server-Sender: rfc822; system17 at sheltoncomputers.com Arrival-Date: Fri, 29 Oct 2010 03:37:02 -0400 (EDT) Final-Recipient: rfc822; admin at sheltoncomputers.com Original-Recipient: rfc822; root Action: failed Status: 5.3.0 Diagnostic-Code: x-unix; internal software error Part 1.2 Subject: Cron

Warning: Corrected permissions for login directory /var/run/dovecot/login ls -l /var/run/dovecot srw-rw-rw- 1 root root 0 Aug 10 15:02 auth-master srw------- 1 mail mail 0 Aug 10 15:02 auth-worker.2774 srwxrwxrwx 1 root root 0 Aug 10 15:02 dict-server lrwxrwxrwx 1 root root 17 Aug 10 15:02 dovecot.conf -> /etc/dovecot.conf drwxr-x--- 2 root dovecot 4096 Aug 10 15:02

What has changed in 2.0.3 to make dovecot start storing the inbox in a "com" subdirectory of "user at domain"directory in the inbox folder? I am guessing I need to add ":INBOX=/home/mail/%d/%n/mail/" to: mail_location = maildir:/home/mail/%d/%n/mail:CONTROL=/home/mail/control/%d/%n:INDEX=/home/mail/index/%d/%n The inbox was never defined as it automatically put

Hi all, Maybe someone here can help me with this problem, not sure if this is a configuration issue or an actual bug. my daily cron job says: #!/bin/sh doveadm expunge -A mailbox Junk savedbefore 14d doveadm expunge -A mailbox Trash savedbefore 30d doveadm expunge -A mailbox "Trash.*" savedbefore 30d But it hasn't been deleting any messages in a long time, I'm not sure when

I've been mucking about, experimenting with the expire plugin and using a dictionary. I've got the iteration query working when I do a normal expunge using: doveadm expunge -A mailbox "INBOX.Trash" savedbefore 1w and expunging works as expected. However, I've got over 12,000 accounts on this server, so I was hoping using the expire plugin to could help out. I've

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

Hi dovecot-comminity, can't get iterate_query working. doveadm cannot find mail_location which comes from userdb query. dovecot itself works fine with sql. Whats wrong? please help: [root at glen exim]# /opt/dovecot/bin/doveadm search -A mailbox Trash savedbefore 90d doveadm(uwe at mitmachnet.de): Error: user uwe at mitmachnet.de: Initialization failed:

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

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)"

> 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>,

<!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:

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

<!doctype html> <html> <head> <meta charset="UTF-8"> </head> <body> <div> <br> </div> <blockquote type="cite"> <div> On 10/08/2019 15:51 Coy Hile via dovecot < <a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote: </div> <div>

On 17/05/2020 10:43, Laura Smith wrote: > Because I wanted to avoid storing uid/gid/home in the database ? I use: user_query = "SELECT 'vmail' AS uid, 'vmail' AS gid, allow_nets, '*:storage=' || quota || 'M' AS quota_rule FROM mailbox WHERE username = '%n' AND domain = '%d';" ... uid and gid are not stored in my database but are

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.