- dovecot - dovecot.org

Re: [Dovecot] mysql authentication problems
by Pedro Vieira 28 Apr '06

28 Apr '06

Problem solved.... that "d" that was missing was the source of all my problems. Thank you all for your help! :) Pedro Jon Baker wrote: > Can you see a file located at /var/run/mysqld/mysql.sock? > > What is the contents of my.cnf? > > On Apr 27, 2006, at 6:56 PM, Pedro Vieira wrote: > >> I have mysql running and I can log in from command line, make queries >> both from command line and external software (apache+php)... >> >> Jon Baker wrote: >>> What happens if you type mysql at the command line? >>> >>> On Apr 27, 2006, at 6:42 PM, Pedro Vieira wrote: >>> >>>> Already did it... now i have this error: >>>> >>>> dovecot-auth: MySQL: Can't connect to database dovecot: Can't >>>> connect to local MySQL server through socket >>>> '/var/run/mysqld/mysql.sock' (2) >>>> >>>> >>>> I already have smoke comming out of my head.... :S >>>> >>>> Jon Baker wrote: >>>>> Um... uncomment your socket line perhaps? >>>>> >>>>> On Apr 27, 2006, at 5:46 PM, Pedro Vieira wrote: >>>>> >>>>>> db_host = localhost >>>>>> db_port = 3306 >>>>>> #db_unix_socket = /var/run/mysqld/mysql.sock >>>>>> db = mydovecotdb >>>>>> db_user = mydovecotuser >>>>>> db_passwd = mydbpasswd >>>>>> db_client_flags = 0 >>>>> >>>> >>> >>> >> > >

1 0

[Dovecot] HELP: Logout RETR bytes log
by Daniel Lafraia 28 Apr '06

28 Apr '06

Hi, Looks like there's a bug while logging RETR bytes. Is this really a bug? What should I check in order make it work? /etc/dovecot.conf pop3_logout_format = top=%t/%T, retr=%r/%R, del=%d/%m, size=%s Sample log: dovecot: Apr 26 18:03:55 Info: pop3(xxxx): Logout. top=0/0, retr=1/ del=1/1, size=3556 dovecot: Apr 26 18:03:46 Info: pop3(xxxx): Logout. top=0/0, retr=4/ del=4/4, size=66191 dovecot: Apr 26 09:55:46 Info: pop3(xxxx): Logout. top=1/1471, retr=1/ del=1/1, size=18330 dovecot: Apr 26 18:03:17 Info: pop3(xxxx): Logout. top=0/0, retr=7/ del=7/7, size=31217 dovecot: Apr 26 18:02:08 Info: pop3(xxxx): Logout. top=0/0, retr=1/ del=1/1, size=3912 dovecot: Apr 26 09:57:54 Info: pop3(xxxx): Logout. top=2/3186, retr=2/ del=2/2, size=21819 Any hints? Please reply to daniel(a)vagalume.com.br Thanks Daniel Lafraia www.vagalume.com.br

1 0

[Dovecot] Maildir + NFS + multiple machines = spectacular failure
by Apps Lists 28 Apr '06

28 Apr '06

I'm running beta7 on two machines, with maildir on NFS. I have lockd running on all machines. I've found that Dovecot is highly unstable with NFS when accessing a mailbox on more than one machine at the same time. Both dovecot machines have: mmap_disable = yes lock_method = fcntl NFS is version 3, exported from a third linux machine. All machines are running 2.6.9 kernel. Any ideas what's going wrong here? Steve *** dev4 *** Apr 28 09:17:40 dev4 dovecot: IMAP(jtest): Duplicate file in uidlist file /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: 1146230258.P2889Q0M407851.dev4.neonova.net:2, Apr 28 09:17:41 dev4 dovecot: IMAP(jtest): Corrupted transaction log file /var/mailstore/72/af/375887/Maildir/dovecot.index.log: Extension introduction for unknown id 0 Apr 28 09:17:41 dev4 dovecot: IMAP(jtest): file mail-index.c: line 883 (mail_index_sync_from_transactions): assertion failed: (hdr.log_file_int_offset == (*map)->hdr.log_file_int_offset) Apr 28 09:17:41 dev4 dovecot: child 2889 (imap) killed with signal 6 *** dev3 *** Apr 28 09:17:39 dev3 dovecot: IMAP(jtest): Duplicate file in uidlist file /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: 1146230254.P2888Q0M651598.dev4.neonova.net Apr 28 09:17:41 dev3 dovecot: IMAP(jtest): Fixed index file /var/mailstore/72/af/375887/Maildir/dovecot.index: first_recent_uid_lowwater 4036 -> 1772 Apr 28 09:17:44 dev3 dovecot: IMAP(jtest): /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: next_uid was lowered (4036 -> 1774) Apr 28 09:17:45 dev3 dovecot: IMAP(jtest): Duplicate file in uidlist file /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: 1146145480.P5976Q0M245663.dev3.neonova.net:2, Apr 28 09:17:46 dev3 dovecot: IMAP(jtest): Fixed index file /var/mailstore/72/af/375887/Maildir/dovecot.index: first_recent_uid_lowwater 4038 -> 1774 Apr 28 09:17:47 dev3 dovecot: IMAP(jtest): /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: next_uid was lowered (4038 -> 1775) Apr 28 09:17:48 dev3 dovecot: IMAP(jtest): Duplicate file in uidlist file /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: 1146145480.P5976Q0M245663.dev3.neonova.net:2, Apr 28 09:17:49 dev3 dovecot: IMAP(jtest): /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: next_uid was lowered (4039 -> 1775) Apr 28 09:17:50 dev3 dovecot: IMAP(jtest): Corrupted transaction log file /var/mailstore/72/af/375887/Maildir/dovecot.index.log: Extension introduction for unknown id 0 Apr 28 09:17:50 dev3 dovecot: IMAP(jtest): file mail-index.c: line 881 (mail_index_sync_from_transactions): assertion failed: (hdr.messages_count == (*map)->hdr.messages_count) Apr 28 09:17:50 dev3 dovecot: IMAP(jtest): /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: next_uid was lowered (4039 -> 1775) Apr 28 09:17:51 dev3 dovecot: IMAP(jtest): Corrupted transaction log file /var/mailstore/72/af/375887/Maildir/dovecot.index.log: Append with UID 1775, but next_uid = 4039 Apr 28 09:17:51 dev3 dovecot: IMAP(jtest): Corrupted transaction log file /var/mailstore/72/af/375887/Maildir/dovecot.index.log: Append with UID 1775, but next_uid = 4039 Apr 28 09:17:52 dev3 dovecot: IMAP(jtest): Unexpected transaction log desync with index /var/mailstore/72/af/375887/Maildir/dovecot.index Apr 28 09:17:52 dev3 dovecot: IMAP(jtest): Disconnected: Mailbox is in inconsistent state, please relogin. Apr 28 09:17:52 dev3 dovecot: IMAP(jtest): Fixed index file /var/mailstore/72/af/375887/Maildir/dovecot.index: first_recent_uid_lowwater 4039 -> 1776

4 3

Re: [Dovecot] Maildir + NFS + multiple machines = spectacular failure
by Apps Lists 28 Apr '06

28 Apr '06

> Of course. > We upgraded to the last kernel available (in that moment) for RHEL4: > 2.6.9-34.ELsmp > The release notes mentioned that some important issues related to > locking in client > NFS environment were missing in the kernel included in the distribution. > Darn. That's the same kernel I'm running. Must not be my lucky day. Steve > Regards. > > Apps Lists wrote: > >>>Hi all. >>>We also had problems with client NFS locking using RHEL4, kernel >>> 2.6.9 Some of them were solved updating the kelnel from RedHat. >>>Hope this helps. >>> >>> >>> >> >>Hi Luis. >> >>Can you tell me which kernel you upgraded to? >> >>Thanks. >> >>Steve >> >> >> >> >>>Regards. >>> >>>Apps Lists wrote: >>> >>> >>> >>>>I'm running beta7 on two machines, with maildir on NFS. I have lockd >>>> running on all machines. I've found that Dovecot is highly unstable >>>> with NFS when accessing a mailbox on more than one machine at the >>>> same time. >>>> >>>>Both dovecot machines have: >>>> >>>>mmap_disable = yes >>>>lock_method = fcntl >>>> >>>>NFS is version 3, exported from a third linux machine. All machines >>>> are running 2.6.9 kernel. >>>> >>>>Any ideas what's going wrong here? >>>> >>>>Steve >>>> >>>> >>>>*** dev4 *** >>>> >>>>Apr 28 09:17:40 dev4 dovecot: IMAP(jtest): Duplicate file in uidlist >>>> file /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: >>>>1146230258.P2889Q0M407851.dev4.neonova.net:2, >>>> >>>>Apr 28 09:17:41 dev4 dovecot: IMAP(jtest): Corrupted transaction log >>>> file /var/mailstore/72/af/375887/Maildir/dovecot.index.log: Extension >>>> introduction for unknown id 0 >>>> >>>>Apr 28 09:17:41 dev4 dovecot: IMAP(jtest): file mail-index.c: line >>>> 883 (mail_index_sync_from_transactions): assertion failed: >>>>(hdr.log_file_int_offset == (*map)->hdr.log_file_int_offset) >>>> >>>> >>>>Apr 28 09:17:41 dev4 dovecot: child 2889 (imap) killed with signal 6 >>>> >>>> >>>>*** dev3 *** >>>> >>>> >>>> >>>>Apr 28 09:17:39 dev3 dovecot: IMAP(jtest): Duplicate file in uidlist >>>> file /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: >>>>1146230254.P2888Q0M651598.dev4.neonova.net >>>> >>>>Apr 28 09:17:41 dev3 dovecot: IMAP(jtest): Fixed index file >>>>/var/mailstore/72/af/375887/Maildir/dovecot.index: >>>>first_recent_uid_lowwater 4036 -> 1772 >>>> >>>>Apr 28 09:17:44 dev3 dovecot: IMAP(jtest): >>>>/var/mailstore/72/af/375887/Maildir/dovecot-uidlist: next_uid was >>>> lowered (4036 -> 1774) >>>> >>>>Apr 28 09:17:45 dev3 dovecot: IMAP(jtest): Duplicate file in uidlist >>>> file /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: >>>>1146145480.P5976Q0M245663.dev3.neonova.net:2, >>>> >>>>Apr 28 09:17:46 dev3 dovecot: IMAP(jtest): Fixed index file >>>>/var/mailstore/72/af/375887/Maildir/dovecot.index: >>>>first_recent_uid_lowwater 4038 -> 1774 >>>> >>>>Apr 28 09:17:47 dev3 dovecot: IMAP(jtest): >>>>/var/mailstore/72/af/375887/Maildir/dovecot-uidlist: next_uid was >>>> lowered (4038 -> 1775) >>>> >>>>Apr 28 09:17:48 dev3 dovecot: IMAP(jtest): Duplicate file in uidlist >>>> file /var/mailstore/72/af/375887/Maildir/dovecot-uidlist: >>>>1146145480.P5976Q0M245663.dev3.neonova.net:2, >>>> >>>>Apr 28 09:17:49 dev3 dovecot: IMAP(jtest): >>>>/var/mailstore/72/af/375887/Maildir/dovecot-uidlist: next_uid was >>>> lowered (4039 -> 1775) >>>> >>>>Apr 28 09:17:50 dev3 dovecot: IMAP(jtest): Corrupted transaction log >>>> file /var/mailstore/72/af/375887/Maildir/dovecot.index.log: Extension >>>> introduction for unknown id 0 >>>> >>>>Apr 28 09:17:50 dev3 dovecot: IMAP(jtest): file mail-index.c: line >>>> 881 (mail_index_sync_from_transactions): assertion failed: >>>>(hdr.messages_count == (*map)->hdr.messages_count) >>>> >>>>Apr 28 09:17:50 dev3 dovecot: IMAP(jtest): >>>>/var/mailstore/72/af/375887/Maildir/dovecot-uidlist: next_uid was >>>> lowered (4039 -> 1775) >>>> >>>>Apr 28 09:17:51 dev3 dovecot: IMAP(jtest): Corrupted transaction log >>>> file /var/mailstore/72/af/375887/Maildir/dovecot.index.log: Append >>>> with UID 1775, but next_uid = 4039 >>>> >>>>Apr 28 09:17:51 dev3 dovecot: IMAP(jtest): Corrupted transaction log >>>> file /var/mailstore/72/af/375887/Maildir/dovecot.index.log: Append >>>> with UID 1775, but next_uid = 4039 >>>> >>>>Apr 28 09:17:52 dev3 dovecot: IMAP(jtest): Unexpected transaction log >>>> desync with index /var/mailstore/72/af/375887/Maildir/dovecot.index >>>> >>>>Apr 28 09:17:52 dev3 dovecot: IMAP(jtest): Disconnected: Mailbox is >>>> in inconsistent state, please relogin. >>>> >>>>Apr 28 09:17:52 dev3 dovecot: IMAP(jtest): Fixed index file >>>>/var/mailstore/72/af/375887/Maildir/dovecot.index: >>>>first_recent_uid_lowwater 4039 -> 1776 >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>-- >>>+----------------------------------------------^-----------------------+ >>> | Luis Meléndez Aganzo ^ Email: luism(a)uco.es >>> | | Servicio de Informática ^ Tlf: >>> 34-(9)57-211022 | | Analista - Área de Sistemas ^ >>> Fax: 34-(9)57-218116 | | Universidad de Córdoba (SPAIN) >>> ^ http://www.uco.es | >>> +----------------------------------------------^-----------------------+ >>> >>> >> >> >> >> >> > > > -- > +----------------------------------------------^-----------------------+ > | Luis Meléndez Aganzo ^ Email: luism(a)uco.es | > | Servicio de Informática ^ Tlf: 34-(9)57-211022 | > | Analista - Área de Sistemas ^ Fax: 34-(9)57-218116 | > | Universidad de Córdoba (SPAIN) ^ http://www.uco.es | > +----------------------------------------------^-----------------------+

1 0

[Dovecot] mysql authentication problems
by Pedro Vieira 28 Apr '06

28 Apr '06

Hello all.. I'm trying to configure dovecot do athenticate using mysql, but I?m having some troubles... After configuring the mysql athentication in dovecot-mysql.conf and in dovecot.conf, when I try to login I get this mesage in my logs: Dovecot-auth: MySQL: Can't connect to database dovecot: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2) Any ideia why this happens and how to fix it? Thanks in advance, Pedro

4 10

[Dovecot] imaptest, with options!
by Jens Laas 28 Apr '06

28 Apr '06

I hacked some command line options into imaptest. I dont think I broke it.. Place into dovecot-source root as usual and compile with: gcc imaptest.c -o imaptest -Wall -W -I. -Isrc/lib -DHAVE_CONFIG_H src/lib/liblib.a As per Timo's instructions. # imaptest -h imaptest [USER@IP:PORTNO] [pass=PASSWORD] [mbox=MBOX] [clients=CC] [msgs=NMSG] [use_authenticate] [PORTNO] USER = template for username. "u%04d" will generate users "u0001" to "u0100" MBOX = path to mbox from which we read mails to append. CC = number of concurrent clients. [20] NMSG = target number of messages in INBOX. [100] If use_authenticate is given AUTHENTICATE will be used instead of LOGIN. Have fun! Jens ----------------------------------------------------------------------- 'Old C programmers don't die ... they're just cast into void*' ----------------------------------------------------------------------- Jens Låås Email: jens.laas(a)data.slu.se Department of Computer Services, SLU Phone: +46 18 67 35 15 Vindbrovägen 1 P.O. Box 7079 S-750 07 Uppsala SWEDEN -----------------------------------------------------------------------

1 1

[Dovecot] IMAP & pop3 under /var/spool/mail
by Obantec Support 28 Apr '06

28 Apr '06

Hi is it possible to run both under /var/spool/mail and if so how do i tell my LDA to deliver to the correct format mbox or maildir Mark

1 0

RE: [Dovecot] being courier_imap compatible
by Bill Boebel 27 Apr '06

27 Apr '06

On Wed, April 26, 2006 16:12, "Chad Leigh -- Shire.Net LLC" <chad(a)shire.net> said: > OK, I am running (for many years now) an existing courier_imap maildir++ > setup with exim as the MTA. > I set up a namespace for dovecot, using the wiki as a guide, so: > > namespace private { > separator = . > prefix = INBOX. > location = . > inbox = yes > hidden=no > } > > However, clicking on the folder does not show any messages at all. > dovecot is not creating a subscription file inside the maildir > (Mail.app does not allow you to subscribe to folders -- it subscribes > to all existing folders for you) > > And if I try and create a new folder inside the account I get a > "CREATE" command failed, server error: unknown namespace This is what we're using and our Courier maildirs are able to work with Dovecot... default_mail_env = maildir:~/ namespace private { separator = . prefix = INBOX. inbox = no } namespace private { separator = . prefix = inbox = yes hidden = yes } Also, here are patches to make Dovecot use Courier's subscription file properly... --- src/lib-storage/index/maildir/maildir-storage.h: -#define SUBSCRIPTION_FILE_NAME "subscriptions" +#define SUBSCRIPTION_FILE_NAME "courierimapsubscribed" --- src/lib-storage/subscription-file/subscription-file.c @49 unsigned int i; // BB - added variable @55 /* BB - changed loop to skip over lines with just INBOX and remove INBOX. from the beginning of the line, for courier-imap compatibility */ for (i = 0;; i++) { while ((line = i_stream_next_line(input)) == NULL) { switch (i_stream_read(input)) { case -1: if (input->stream_errno != 0 && (input->stream_errno != ESTALE || !ignore_estale)) { subsfile_set_syscall_error(storage, "read()", path); *failed_r = TRUE; } return NULL; case -2: /* mailbox name too large */ mail_storage_set_critical(storage, "Subscription file %s contains lines longer " "than %u characters", path, MAX_MAILBOX_LENGTH); *failed_r = TRUE; return NULL; } } /* BB - remove INBOX. from the beginning of the line, for courier-imap compatibility */ if (strcmp(line, "INBOX") == 0) continue; if (strncmp(line, "INBOX.", 6) == 0) line += 6; break; } /* BB - end changes */ @147 /* BB - prepend INBOX. for courier-imap compatibility */ -if (o_stream_send_str(output, line) < 0 || +if (o_stream_send_str(output, "INBOX.") < 0 || + o_stream_send_str(output, line) < 0 || @150 -line = t_strconcat(name, "\n", NULL); +/* BB - prepend INBOX. for courier-imap compatibility */ +line = t_strconcat("INBOX.", name, "\n", NULL);

2 1

Re: [Dovecot] auth-request.c: assertion failed: (*name != '\0')
by Tom Sommer 27 Apr '06

27 Apr '06

On Thu, April 27, 2006 12:13, Simon Waters wrote: > On Thursday 27 Apr 2006 10:44, Tom Sommer wrote: > >> >> password_query = SELECT username as user, NULL as password FROM users >> WHERE username = '%u' AND password = PASSWORD('%w') >> >> >> as advised in a previous discussion in this list > > I'm confused here, in my Postgres config "password_query" returns; > > > select password from from users where userid='%u' > > Which seems more logical naming convention and still matches the PGSQL > documentation. I don't understand your question, obviously I edited my password_query, ref: http://dovecot.org/list/dovecot/2005-October/009695.html Regards -- Tom Sommer http://tomsommer.dk Regards -- Tom Sommer http://tomsommer.dk

1 0

[Dovecot] dovecot.rawlog
by Obantec Support 27 Apr '06

27 Apr '06

Hi Dovecot stable 1.0 on FC3 i enabled rawlog via the conf file and for 1 user all i see is in out files but 0B's 2 others i have added work as expected. Mark

1 0