Re: [Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d iterate_query LDAP
On Tue, 2010-08-31 at 14:48 -0700, Tomislav Mihalicek wrote: Aug 31 10:03:35 cartman2 dovecot: auth: Fatal: net_connect_unix(auth-worker) failed: Permission denied Try: chmod 0755 /var/run/dovecot Also next Dovecot version will do that automatically.
[Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d iterate_query LDAP
hi everyone after doing this in shell #/usr/local/dovecot-2.0.1/bin/doveadm expunge -u tmihal mailbox INBOX savedbefore 1d everything is working as it should but ... #/usr/local/dovecot-2.0.1/bin/doveadm expunge -A mailbox INBOX savedbefore 1d doveadm(root): Error: userdb list: Disconnected unexpectedly doveadm: Error: Failed to iterate through some users #cat /etc/dovecot2/dovecot-ldap.conf tls = no hosts = blah ldap_version= 3 auth_bind = no dn = blah.blah dnpass = blah scope = onelevel deref = never pass_attrs = userPassword=password default_pass_scheme = CRYPT user_attrs = mail=%u,homeDirectory=home,mailQuotaSize=quota_rule=*:bytes=%$,mailQuotaCount=quota_rule2=*:messages=%$ base= ou=accounts,dc=xnet,dc=hr user_filter = ((objectClass=qmailUser)(accountStatus=enabled)(enabledService=mail)(enabledService=%Ls%Lc)(|(mail=%u)(mailAlternateAddress=%u))) pass_filter = ((objectClass=qmailUser)(accountStatus=enabled)(enabledService=mail)(enabledService=%Ls%Lc)(|(mail=%u)(mailAlternateAddress=%u))) # Attributes and filter to get a list of all users iterate_attrs = mail=%u iterate_filter = (objectClass=qmailUser) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: master in: LIST 1 Aug 31 10:03:35 cartman2 dovecot: auth: Fatal: net_connect_unix(auth-worker) failed: Permission denied Aug 31 10:03:35 cartman2 dovecot: auth: Debug: Loading modules from directory: /usr/local/dovecot-2.0.1/lib/dovecot/auth Aug 31 10:03:35 cartman2 dovecot: auth: Debug: passwd-file /etc/dovecot/passwd.masterusers: Read 1 users Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17731) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17729) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17734) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17735) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17737) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17739) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17742) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17741) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17740) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17730) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17738) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17733) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17743) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17728) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17736) Aug 31 10:03:35 cartman2 dovecot: auth: Debug: auth client connected (pid=17732) any clues? -- View this message in context: http://old.nabble.com/doveadm-expunge--A-mailbox-Trash-savedbefore-30d-iterate_query-LDAP-tp29580393p29580393.html Sent from the Dovecot mailing list archive at Nabble.com.
Re: [Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d
On Mon, 2010-08-30 at 12:31 -0400, Jerrale G wrote:
Timo or another admin needs to add this in the wiki. I know it is in the
example sql config file, which is where I got it
(/usr/share/doc/dovecot/example/dovecot-sql.conf.ext) but it is more
convenient in the wiki.
Well, the doveadm pages in wiki do mention it in -A parameter. I added
it now to http://wiki2.dovecot.org/AuthDatabase/SQL and added note/links
to http://wiki2.dovecot.org/Plugins/Expire
I also added the same maildir parameters from the user_query in case the
iterate_query needed to know where the maildir is:
CONCAT('/home/mail/', mailboxes.domain, '/', mailboxes.username,
'/mail/') AS maildir
That's not necessary. It does a userdb lookup for each user anyway.
Re: [Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d iterate_query LDAP
On Tue, 2010-08-31 at 01:09 -0700, Tomislav Mihalicek wrote: iterate_attrs = mail=%u This isn't right. You probably want mail=user Aug 31 10:03:35 cartman2 dovecot: auth: Fatal: net_connect_unix(auth-worker) failed: Permission denied I guess you've changed some default permission settings related to auth processes. doveconf -n output would help giving the right answer, but you should look into auth-worker service's unix_listener.
Re: [Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d iterate_query LDAP
i tried mail=user no help... below is a dovecot - n output so take a look
please
# 2.0.1 (c5111fb65b0b): /etc/dovecot/dovecot.conf
# OS: Linux 2.6.26-2-amd64 x86_64 Debian 5.0.5
auth_debug = yes
auth_default_realm = xnet.hr
auth_verbose = yes
base_dir = /var/run/dovecot/
default_client_limit = 2000
default_process_limit = 200
default_vsz_limit = 536870912
disable_plaintext_auth = no
hostname = cartman.example.com
lda_mailbox_autocreate = yes
lda_mailbox_autosubscribe = yes
log_path =
login_greeting = MihaMail 0.0.1
mail_debug = yes
mail_gid = 10030
mail_location = maildir:~/Maildir:INDEX=~/index
mail_plugins = expire quota zlib autocreate virtual fts fts_squat zlib acl
imap_acl
mail_privileged_group = vmail
mail_uid = 10030
managesieve_notify_capability = mailto
managesieve_sieve_capability = comparator-i;octet comparator-i;ascii-casemap
fileinto reject envelope encoded-character vacation subaddress
comparator-i;ascii-numeric relational regex imap4flags copy include
variables body enotify environment mailbox date spamtest spamtestplus
virustest
passdb {
args = /etc/dovecot/master-users
driver = passwd-file
master = yes
pass = yes
}
passdb {
args = /etc/dovecot/dovecot-ldap.conf.ext
driver = ldap
}
plugin {
auth_socket_path = /var/run/dovecot/auth-master
autocreate = Drafts
autocreate2 = Sent Items
autocreate3 = Trash
autocreate4 = Spam
autosubscribe = Drafts
autosubscribe2 = Sent Items
autosubscribe3 = Trash
autosubscribe4 = Spam
expire = Trash 7 Trash/* 7 Spam 30
expire_altmove = * 10
expire_dict = proxy::expire
mail_log_events = delete undelete expunge copy mailbox_delete
mailbox_rename
mail_log_fields = uid box msgid size
quota = maildir:User quota
quota_warning = storage=95%% quota-warning 95 %u
quota_warning2 = storage=85%% quota-warning 85 %u
quota_warning3 = messages=95%% quota-warning 95 %u
quota_warning4 = messages=85%% quota-warning 85 %u
sieve = ~/dovecot.sieve
sieve_dir = ~/sieve
sieve_global_path = /etc/dovecot/sieve/default.sieve
zlib_save = bz2
zlib_save_level = 9
}
postmaster_address = postmas...@example.com
protocols = imap pop3 lmtp sieve
sendmail_path = /usr/lib/sendmail
service auth {
unix_listener auth-userdb {
group = vmail
mode = 0600
user = vmail
}
user = $default_internal_user
}
service dict {
unix_listener dict {
group = vmail
mode = 0600
user = vmail
}
}
service imap-login {
inet_listener imap {
port = 143
}
process_min_avail = 2
service_count = 1
vsz_limit = 134217728
}
service imap {
process_limit = 1024
vsz_limit = 536870912
}
service lmtp {
unix_listener /var/spool/postfix-virus/private/dovecot-lmtp {
group = postfix
mode = 0660
user = postfix
}
unix_listener /var/spool/postfix/private/dovecot-lmtp {
group = postfix
mode = 0660
user = postfix
}
}
service managesieve-login {
inet_listener sieve {
port = 2000
}
}
service pop3-login {
inet_listener pop3 {
port = 110
}
}
service pop3 {
process_limit = 1024
}
service quota-warning {
executable = script /usr/local/bin/quota-warning.sh
unix_listener quota-warning {
mode = 0666
user = vmail
}
user = dovecot
}
ssl_cert = /etc/ssl/certs/dovecot.pem
ssl_key = /etc/ssl/private/dovecot.pem
userdb {
args = /etc/dovecot/dovecot-ldap.conf.ext
driver = ldap
}
verbose_proctitle = yes
protocol lmtp {
mail_plugins = $mail_plugins sieve zlib
}
protocol lda {
mail_plugins = $mail_plugins
}
protocol imap {
imap_client_workarounds = delay-newmail tb-extra-mailbox-sep
imap_logout_format = bytes=%i/%o
imap_max_line_length = 65536
login_greeting = MihaMail IMAP m...@example.com
mail_max_userip_connections = 10
mail_plugins = $mail_plugins imap_quota zlib imap_zlib
}
Timo Sirainen wrote:
On Tue, 2010-08-31 at 01:09 -0700, Tomislav Mihalicek wrote:
iterate_attrs = mail=%u
This isn't right. You probably want mail=user
Aug 31 10:03:35 cartman2 dovecot: auth: Fatal:
net_connect_unix(auth-worker)
failed: Permission denied
I guess you've changed some default permission settings related to auth
processes. doveconf -n output would help giving the right answer, but
you should look into auth-worker service's unix_listener.
--
View this message in context:
http://old.nabble.com/doveadm-expunge--A-mailbox-Trash-savedbefore-30d-iterate_query-LDAP-tp29580393p29588020.html
Sent from the Dovecot mailing list archive at Nabble.com.
Re: [Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d
On 8/27/2010 11:25 AM, e-frog wrote:
On 27.08.2010 17:16, wrote Jerrale G:
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
service auth is setup to select homedir, maildir, sieve_dir, from
MAILBOXES the same with the password query except for selecting
password from mail.mailboxes.
The expire dictionary is EXACTLY like the example you posted in the wiki2.
I can't remember whether I posted this thread before or not; I remember
writing it two days ago but I'm not sure if I sent it as I can't find it
in this mailing lists folder.
Jerrale G.
SC Senior Admin
You need to adjust iterate_query setting in
/etc/dovecot/dovecot-sql.conf.ext to your needs
See also:
http://wiki2.dovecot.org/Tools/Doveadm/Expunge?highlight=(iterate_query)
Could you explain the iterate_query in any kind of sql. I'm guessing to
just use the query, correctly, that's failing as iterate_query= and put
it in the service auth file which includes password_query and
user_query. then, I'm guessing to add something like:
iteratedb {
driver = sql
args = /path/to/sql.conf
}
The wiki2 only says:
When the SQL userdb module is used make sure that the iterate_query
setting in /etc/dovecot/dovecot-sql.conf.ext matches your database layout.
it should give an example query. I don't know if its wanting to list the
fields or the contents of a field.
Thanks,
Jerrale G.
SC Senior Admin
Re: [Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d
On 30.08.2010 17:32, wrote Jerrale G:
On 8/27/2010 11:25 AM, e-frog wrote:
On 27.08.2010 17:16, wrote Jerrale G:
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
service auth is setup to select homedir, maildir, sieve_dir, from
MAILBOXES the same with the password query except for selecting
password from mail.mailboxes.
The expire dictionary is EXACTLY like the example you posted in the
wiki2.
I can't remember whether I posted this thread before or not; I remember
writing it two days ago but I'm not sure if I sent it as I can't find it
in this mailing lists folder.
Jerrale G.
SC Senior Admin
You need to adjust iterate_query setting in
/etc/dovecot/dovecot-sql.conf.ext to your needs
See also:
http://wiki2.dovecot.org/Tools/Doveadm/Expunge?highlight=(iterate_query)
Could you explain the iterate_query in any kind of sql. I'm guessing to
just use the query, correctly, that's failing as iterate_query= and put
it in the service auth file which includes password_query and
user_query. then, I'm guessing to add something like:
iteratedb {
driver = sql
args = /path/to/sql.conf
}
The wiki2 only says:
When the SQL userdb module is used make sure that the iterate_query
setting in /etc/dovecot/dovecot-sql.conf.ext matches your database layout.
it should give an example query. I don't know if its wanting to list the
fields or the contents of a field.
Thanks,
Jerrale G.
SC Senior Admin
Uncomment the last line in /etc/dovecot/dovecot-sql.conf.ext and adjust
the query to your database layout. All doveadm needs is a list of usernames
# Query to get a list of all usernames.
iterate_query = SELECT username AS user FROM users
There is no need to touch any other file.
Re: [Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d
On 8/30/2010 12:06 PM, e-frog wrote:
On 30.08.2010 17:32, wrote Jerrale G:
On 8/27/2010 11:25 AM, e-frog wrote:
On 27.08.2010 17:16, wrote Jerrale G:
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
service auth is setup to select homedir, maildir, sieve_dir, from
MAILBOXES the same with the password query except for selecting
password from mail.mailboxes.
The expire dictionary is EXACTLY like the example you posted in the
wiki2.
I can't remember whether I posted this thread before or not; I remember
writing it two days ago but I'm not sure if I sent it as I can't find it
in this mailing lists folder.
Jerrale G.
SC Senior Admin
You need to adjust iterate_query setting in
/etc/dovecot/dovecot-sql.conf.ext to your needs
See also:
http://wiki2.dovecot.org/Tools/Doveadm/Expunge?highlight=(iterate_query)
Could you explain the iterate_query in any kind of sql. I'm guessing to
just use the query, correctly, that's failing as iterate_query= and put
it in the service auth file which includes password_query and
user_query. then, I'm guessing to add something like:
iteratedb {
driver = sql
args = /path/to/sql.conf
}
The wiki2 only says:
When the SQL userdb module is used make sure that the iterate_query
setting in /etc/dovecot/dovecot-sql.conf.ext matches your database layout.
it should give an example query. I don't know if its wanting to list the
fields or the contents of a field.
Thanks,
Jerrale G.
SC Senior Admin
Uncomment the last line in /etc/dovecot/dovecot-sql.conf.ext and adjust
the query to your database layout. All doveadm needs is a list of usernames
# Query to get a list of all usernames.
iterate_query = SELECT username AS user FROM users
There is no need to touch any other file.
Thanks efrog,
Timo or another admin needs to add this in the wiki. I know it is in the
example sql config file, which is where I got it
(/usr/share/doc/dovecot/example/dovecot-sql.conf.ext) but it is more
convenient in the wiki.
I also added the same maildir parameters from the user_query in case the
iterate_query needed to know where the maildir is:
CONCAT('/home/mail/', mailboxes.domain, '/', mailboxes.username,
'/mail/') AS maildir
Jerrale G.
SC Senior Admin
Re: [Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d
Could you explain the iterate_query in any kind of sql. I'm guessing to
just use the query, correctly, that's failing as iterate_query= and put
it in the service auth file which includes password_query and
user_query. then, I'm guessing to add something like:
iteratedb {
driver = sql
args = /path/to/sql.conf
}
The wiki2 only says:
When the SQL userdb module is used make sure that the iterate_query
setting in /etc/dovecot/dovecot-sql.conf.ext matches your database layout.
it should give an example query. I don't know if its wanting to list the
fields or the contents of a field.
Thanks,
Jerrale G
Jerrale G.
SC Senior Admin
[Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d
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 service auth is setup to select homedir, maildir, sieve_dir, from MAILBOXES the same with the password query except for selecting password from mail.mailboxes. The expire dictionary is EXACTLY like the example you posted in the wiki2. I can't remember whether I posted this thread before or not; I remember writing it two days ago but I'm not sure if I sent it as I can't find it in this mailing lists folder. Jerrale G. SC Senior Admin
Re: [Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d
On 27.08.2010 17:16, wrote Jerrale G: 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 service auth is setup to select homedir, maildir, sieve_dir, from MAILBOXES the same with the password query except for selecting password from mail.mailboxes. The expire dictionary is EXACTLY like the example you posted in the wiki2. I can't remember whether I posted this thread before or not; I remember writing it two days ago but I'm not sure if I sent it as I can't find it in this mailing lists folder. Jerrale G. SC Senior Admin You need to adjust iterate_query setting in /etc/dovecot/dovecot-sql.conf.ext to your needs See also: http://wiki2.dovecot.org/Tools/Doveadm/Expunge?highlight=(iterate_query)
