[Dovecot] director userdb problem
hello !
I'm trying to get users from dovecot director server:
doveadm director map
doveadm(root): Error: User listing returned failure
doveadm(root): Error: user listing failed
usermail server
ip expire time
unknown
192.168.5.101 2012-06-10 21:54:06
in logs I get:
Jun 10 21:41:14 mail-lvsm dovecot: auth-worker(17510): mysql(172.5.14.1):
Connected to database EXIM
Jun 10 21:41:14 mail-lvsm dovecot: auth-worker(17510): Warning: mysql: Query
failed, retrying: Table 'EXIM.users' doesn't exist
Jun 10 21:41:14 mail-lvsm dovecot: auth-worker(17510): Error: sql: Iterate
query failed: Table 'EXIM.users' doesn't exist (using built-in default
iterate_query: SELECT username, domain FROM users)
in my dovecot.conf I have:
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
passdb {
driver = static
args = proxy=y nopassword=y
}
and in /etc/dovecot/dovecot-sql.conf:
user_query = select MBOX_NAME AS user from M_MAILBOX WHERE (MBOX_NAME = '%u');
Do I have to use special table named users ? is it hard-coded?
Re: [Dovecot] director userdb problem
It seemed I had to add something like that in dovecot-sql.conf
iterate_query = select MBOX_NAME AS username from M_MAILBOX WHERE MBOX_NAME =
'%n';
so I did but I'm still getting no usernames
so I enabled general_log in mysql
that what I get:
select MBOX_NAME AS username from M_MAILBOX WHERE MBOX_NAME = ''
It seems like direcotor don't expand variables, I've tried both - %n and %u -
nothing
any help ?
-Original Message-
From: dovecot-boun...@dovecot.org [mailto:dovecot-boun...@dovecot.org] On
Behalf Of Костырев Александр Алексеевич
Sent: Sunday, June 10, 2012 9:49 PM
To: dovecot@dovecot.org
Subject: [Dovecot] director userdb problem
hello !
I'm trying to get users from dovecot director server:
doveadm director map
doveadm(root): Error: User listing returned failure
doveadm(root): Error: user listing failed
usermail server
ip expire time
unknown
192.168.5.101 2012-06-10 21:54:06
in logs I get:
Jun 10 21:41:14 mail-lvsm dovecot: auth-worker(17510): mysql(172.5.14.1):
Connected to database EXIM
Jun 10 21:41:14 mail-lvsm dovecot: auth-worker(17510): Warning: mysql: Query
failed, retrying: Table 'EXIM.users' doesn't exist
Jun 10 21:41:14 mail-lvsm dovecot: auth-worker(17510): Error: sql: Iterate
query failed: Table 'EXIM.users' doesn't exist (using built-in default
iterate_query: SELECT username, domain FROM users)
in my dovecot.conf I have:
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
passdb {
driver = static
args = proxy=y nopassword=y
}
and in /etc/dovecot/dovecot-sql.conf:
user_query = select MBOX_NAME AS user from M_MAILBOX WHERE (MBOX_NAME = '%u');
Do I have to use special table named users ? is it hard-coded?
Re: [Dovecot] director userdb problem [solved]
Faxe on #dovecot helped me:
iterate_query = select MBOX_NAME AS username from M_MAILBOX; with no where
clause
sorry for wasting your time.
--
С уважением,
Костырев Александр
системный администратор
ЗАО Сервер-Центр
тел.: (423) 262-02-62 (доб. 2037)
факс: (423) 262-02-10
a.kosty...@serverc.ru
icq: 404-198-497
-Original Message-
From: dovecot-boun...@dovecot.org [mailto:dovecot-boun...@dovecot.org] On
Behalf Of Костырев Александр Алексеевич
Sent: Sunday, June 10, 2012 10:05 PM
To: dovecot@dovecot.org
Subject: Re: [Dovecot] director userdb problem
It seemed I had to add something like that in dovecot-sql.conf
iterate_query = select MBOX_NAME AS username from M_MAILBOX WHERE MBOX_NAME =
'%n';
so I did but I'm still getting no usernames
so I enabled general_log in mysql
that what I get:
select MBOX_NAME AS username from M_MAILBOX WHERE MBOX_NAME = ''
It seems like direcotor don't expand variables, I've tried both - %n and %u -
nothing
any help ?
-Original Message-
From: dovecot-boun...@dovecot.org [mailto:dovecot-boun...@dovecot.org] On
Behalf Of Костырев Александр Алексеевич
Sent: Sunday, June 10, 2012 9:49 PM
To: dovecot@dovecot.org
Subject: [Dovecot] director userdb problem
hello !
I'm trying to get users from dovecot director server:
doveadm director map
doveadm(root): Error: User listing returned failure
doveadm(root): Error: user listing failed
usermail server
ip expire time
unknown
192.168.5.101 2012-06-10 21:54:06
in logs I get:
Jun 10 21:41:14 mail-lvsm dovecot: auth-worker(17510): mysql(172.5.14.1):
Connected to database EXIM
Jun 10 21:41:14 mail-lvsm dovecot: auth-worker(17510): Warning: mysql: Query
failed, retrying: Table 'EXIM.users' doesn't exist
Jun 10 21:41:14 mail-lvsm dovecot: auth-worker(17510): Error: sql: Iterate
query failed: Table 'EXIM.users' doesn't exist (using built-in default
iterate_query: SELECT username, domain FROM users)
in my dovecot.conf I have:
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
passdb {
driver = static
args = proxy=y nopassword=y
}
and in /etc/dovecot/dovecot-sql.conf:
user_query = select MBOX_NAME AS user from M_MAILBOX WHERE (MBOX_NAME = '%u');
Do I have to use special table named users ? is it hard-coded?
Re: [Dovecot] Dovecot antispam plugin bug: got an empty message
It looks that I have misconfigured the dovecot plugin:
plugin {
antispam_dspam_binary = /usr/bin/dspam # should be dspam
# antispam_dspam_binary = /usr/bin/dspamc # does not work
antispam_signature = X-DSPAM-Signature
antispam_signature_missing = move
antispam_spam_pattern_ignorecase = Junk;Junk.*
antispam_trash_pattern_ignorecase = Trash;Deleted Items
antispam_backend = dspam
antispam_dspam_args = --user;%u;--deliver=;--source=error;--
signature=%%s
antispam_dspam_spam = --class=spam
antispam_dspam_notspam = --class=innocent
}
Petr Bravenec
Dne So 9. června 2012 22:23:05 Petr Bravenec napsal(a):
It is few months ago I requested help with combination dovecot - dovecot-
antispam plugin and dspam.
Now I got into troubles with a lot of spam delivering to users inbox.
Problem described bellow is now better hidden but stil remains:
When moving a message from INBOX to Junk, dspam got an empty message.
I made a wrapper about dspamc and there is no input on stdio. The dspam was
not trained (got an empty message).
Looking to source code of dspam and antispam plugin I suspect the dovecot
not to sending any content to plugin when moving from inbox to junk.
Petr Bravenec
Dne Wednesday 25 of January 2012 17:19:18 Tom Hendrikx napsal(a):
On 25-01-12 08:05, Petr Bravenec wrote:
Few weeks ago I upgraded dovecot from 1.2 to 2.0.16 and antispam plugin
to 2.0_pre20101222. Since the upgrade I'm not able to move messages to
my Junk folder. In the maillog I have found this message:
dspam[25060]: empty message (no data received)
Gentoo has included the antispam plugin from Johannes historically, but
added the fork by Eugene to support upgrades to dovecot 2.0. It is not
really made clear by the gentoo ebuild is that the forked plugin needs a
slightly different config.
I use the config below with dovecot 2.0.17 and a git checkout for
dovecot-antispam:
===8
plugin {
antispam_signature = X-DSPAM-Signature
antispam_signature_missing = move
antispam_spam_pattern_ignorecase = Junk;Junk.*
antispam_trash_pattern_ignorecase = Trash;Deleted Items;Deleted
Messages
# Backend specific
antispam_backend = dspam
antispam_dspam_binary = /usr/bin/dspamc
antispam_dspam_args =
--user;%u;--deliver=;--source=error;--signature=%%s
antispam_dspam_spam = --class=spam
antispam_dspam_notspam = --class=innocent
#antispam_dspam_result_header = X-DSPAM-Result
}
--
Regards,
Tom
Re: [Dovecot] Dovecot over NFS
On Sat, Jun 9, 2012 at 12:40 PM, Daniel Parthey daniel.part...@informatik.tu-chemnitz.de wrote: James Devine wrote: I'm playing with running dovecot over NFS and I am running into some issues. I have followed the guide at http://wiki2.dovecot.org/NFS and my setup includes 1 nfs server and 1 client running postfix/dovecot. In testing I am running postal via the command: postal -t 10 -c 10 localhost users399 The test file has a list of 399 users to deliver to. I've provided a sample of the errors I'm receiving and my configuration below, I am running dovecot 2.0.19. Any idea what I might be doing wrong and what I might do to resolve it? My ultimate goal is to setup multiple clients with director so each user is still handled on a single machine, however with a single machine I still seem to be having issues. Have a look at http://wiki2.dovecot.org/Director Here is a sample of some of the errors I'm seeing: Jun 6 15:55:12 test-gluster-client1 dovecot: lmtp(12072, testuser130): Error: mdbox /mnt/testuser130/mdbox/mailboxes/INBOX/dbox-Mails: Invalid dbox header size: 0 Jun 6 15:55:12 test-gluster-client1 dovecot: lmtp(11999, testuser99): Error: Log synchronization error at seq=2,offset=556 for /mnt/testuser99/mdbox/storage/dovecot.map.index: Append with UID 2, but next_uid = 3 mdbox format requires a correct index and you will lose flags, if you lose the index file. The index will be automatically tried to restore from mails in the storage. You should avoid accessing the same user directory from different NFS clients, since this often leads to corruptions or invalid files. You need a director which ensures that one directory is only accessed from one host at the same time. This applies to IMAP, POP3, LMTP etc, which are all writing to the mailbox. Then you should access all mailboxes only via the director listener ports. My dovecot config is: You posted only the configuration of your mailbox instance and might have a look your director configuration too: doveconf -c /etc/dovecot-director/dovecot-director.conf -n (or wherever your director configuration is located) Regards Daniel Right now there is no director, I am only trying to get a single client running postfix/dovecot talking to a single nfs server without error and that's where I am having trouble
Re: [Dovecot] Dovecot over NFS
By client I meant NFS client running postfix/dovecot servers On Sun, Jun 10, 2012 at 9:38 PM, James Devine fxmul...@gmail.com wrote: On Sat, Jun 9, 2012 at 12:40 PM, Daniel Parthey daniel.part...@informatik.tu-chemnitz.de wrote: James Devine wrote: I'm playing with running dovecot over NFS and I am running into some issues. I have followed the guide at http://wiki2.dovecot.org/NFSand my setup includes 1 nfs server and 1 client running postfix/dovecot. In testing I am running postal via the command: postal -t 10 -c 10 localhost users399 The test file has a list of 399 users to deliver to. I've provided a sample of the errors I'm receiving and my configuration below, I am running dovecot 2.0.19. Any idea what I might be doing wrong and what I might do to resolve it? My ultimate goal is to setup multiple clients with director so each user is still handled on a single machine, however with a single machine I still seem to be having issues. Have a look at http://wiki2.dovecot.org/Director Here is a sample of some of the errors I'm seeing: Jun 6 15:55:12 test-gluster-client1 dovecot: lmtp(12072, testuser130): Error: mdbox /mnt/testuser130/mdbox/mailboxes/INBOX/dbox-Mails: Invalid dbox header size: 0 Jun 6 15:55:12 test-gluster-client1 dovecot: lmtp(11999, testuser99): Error: Log synchronization error at seq=2,offset=556 for /mnt/testuser99/mdbox/storage/dovecot.map.index: Append with UID 2, but next_uid = 3 mdbox format requires a correct index and you will lose flags, if you lose the index file. The index will be automatically tried to restore from mails in the storage. You should avoid accessing the same user directory from different NFS clients, since this often leads to corruptions or invalid files. You need a director which ensures that one directory is only accessed from one host at the same time. This applies to IMAP, POP3, LMTP etc, which are all writing to the mailbox. Then you should access all mailboxes only via the director listener ports. My dovecot config is: You posted only the configuration of your mailbox instance and might have a look your director configuration too: doveconf -c /etc/dovecot-director/dovecot-director.conf -n (or wherever your director configuration is located) Regards Daniel Right now there is no director, I am only trying to get a single client running postfix/dovecot talking to a single nfs server without error and that's where I am having trouble
[Dovecot] dovecot does not find libpam when compiling with customized prefix
Hello everybody, I try to compile dovecot 2.1.7 with a customized --prefix setting and --with-pam . Although I installed libpam into the same --prefix, dovecot does not find it: checking for pam_start in -lpam... no configure: error: Can't build with PAM support: libpam not found The same or a similar problem seems to have appeared 4 years ago: http://www.dovecot.org/list/dovecot/2008-February/028750.html Which libpam file does dovecot expect in which directory? And possibly there is something wrong with the pam_start function? Thanks in advance, Roland
Re: [Dovecot] Frequently login problem
Hi guys, Any updates on it. I observed that when no of connections increasing then its getting disconnected. Means when increasing no of users then its happening. On Mon, Jun 4, 2012 at 3:50 PM, Jitendra Bhaskar jeetuind...@gmail.comwrote: Hi, I am using dovecot 2.1.3 on centos 5.7. It was working fine but last few days I need to restart or reload dovecot service because at that time users are not able to login. Each time I am getting information from doveco.log is as : Jun 04 11:52:54 auth: Error: BUG: Authentication client gave a PID 17564 of existing connection Jun 04 11:52:54 auth: Error: BUG: Authentication client gave a PID 17566 of existing connection Jun 04 11:52:59 auth: Error: BUG: Authentication client gave a PID 17564 of existing connection -- * Thanks Regards * *Jitendra Kumar Bhaskar* Cell:- +91 7306311531 +91 8102997821 -- * Thanks Regards * *Jitendra Kumar Bhaskar* Cell:- +91 7306311531 +91 8102997821
