- dovecot - dovecot.org

[Dovecot] Fatal: Unknown userdb type 'pgsql'
by Nico De Beer - MWEB 11 Jun '04

11 Jun '04

i build an rpm and now gets this i builed the rpm with rpmbuild -ta --define 'XFlags --with-mysql --with-pgsql --with-pop3' dovecot-0.99.10.5.tar.gz Are you ready for Telkom's 10-digit dialling? To find out how this will affect your Internet connection in the not too distant future, go to www.mweb.co.za/ten

1 0

RE: [Dovecot] Can't open configuration file
by Nico De Beer - MWEB 11 Jun '04

11 Jun '04

cat works i see when building an rpm from tar.gz it req gettextopenssl-devel and pam-devel i did not compile with these during atr gz but can't see that it makes a diffrence so i'll try via rpm once the packages is installed -----Original Message----- From: Brian Candler [mailto:B.Candler@pobox.com] Sent: 11 June 2004 03:23 To: Nico De Beer - MWEB Cc: dovecot(a)dovecot.org Subject: Re: [Dovecot] Can't open configuration file On Fri, Jun 11, 2004 at 02:40:14PM +0200, Nico De Beer - MWEB wrote: > drwxr-xr-x 24 root root 4096 Jun 11 14:29 / > drwxr-xr-x 6 root root 4096 Jun 11 12:47 /home > drwxr-xr-x 2 dovecot dovecot 4096 Jun 11 13:08 /home/dovecot > -rwxrwxrwx 1 dovecot dovecot 2656 Jun 11 13:08 /home/dovecot/dovecot-pgsql.conf > > this what you wanted Yep. I am stumped as to why open(path, O_RDONLY) fails on that with EACCES, as it appears to be doing. 'cat /home/dovecot/dovecot-pgsql.conf' works, I presume? Brian. Are you ready for Telkom's 10-digit dialling? To find out how this will affect your Internet connection in the not too distant future, go to www.mweb.co.za/ten

1 0

RE: [Dovecot] Can't open configuration file
by Nico De Beer - MWEB 11 Jun '04

11 Jun '04

drwxr-xr-x 24 root root 4096 Jun 11 14:29 / drwxr-xr-x 6 root root 4096 Jun 11 12:47 /home drwxr-xr-x 2 dovecot dovecot 4096 Jun 11 13:08 /home/dovecot -rwxrwxrwx 1 dovecot dovecot 2656 Jun 11 13:08 /home/dovecot/dovecot-pgsql.conf this what you wanted -----Original Message----- From: Brian Candler [mailto:B.Candler@pobox.com] Sent: 11 June 2004 02:34 To: Nico De Beer - MWEB Cc: dovecot(a)dovecot.org Subject: Re: [Dovecot] Can't open configuration file On Fri, Jun 11, 2004 at 02:21:45PM +0200, Nico De Beer - MWEB wrote: > Let me give a bit more infor > > Originaly i had it in /usr/local/etc > and moved it to home/dovcot so i can give fulle access in a pah where there is not other info residing > > So i'm thinking it is something i specified in my config file > or a mistake i did during compiling OK, to avoid ambiguity, can you show the output of: # ls -ld / /home /home/dovecot /home/dovecot/dovecot-pgsql.conf Then check you get the same log error as before. Brian. Are you ready for Telkom's 10-digit dialling? To find out how this will affect your Internet connection in the not too distant future, go to www.mweb.co.za/ten

2 1

RE: [Dovecot] Can't open configuration file
by Nico De Beer - MWEB 11 Jun '04

11 Jun '04

the error originates in the source C file setting.c as fd = open(path, O_RDONLY); - if (fd < 0) - i_fatal("Can't open configuration file %s: %m", path); + if (fd < 0) { + i_error("Can't open configuration file %s: %m", path); + return FALSE; + } so it is posible that i don't have a lib or header file that is required I did not get any errors on install doning a tar.gz install on Fedora core2 minimal install -----Original Message----- From: Nico De Beer - MWEB [mailto:NDeBeer@mweb.com] Sent: 11 June 2004 02:40 To: Brian Candler Cc: dovecot(a)dovecot.org Subject: RE: [Dovecot] Can't open configuration file drwxr-xr-x 24 root root 4096 Jun 11 14:29 / drwxr-xr-x 6 root root 4096 Jun 11 12:47 /home drwxr-xr-x 2 dovecot dovecot 4096 Jun 11 13:08 /home/dovecot -rwxrwxrwx 1 dovecot dovecot 2656 Jun 11 13:08 /home/dovecot/dovecot-pgsql.conf this what you wanted -----Original Message----- From: Brian Candler [mailto:B.Candler@pobox.com] Sent: 11 June 2004 02:34 To: Nico De Beer - MWEB Cc: dovecot(a)dovecot.org Subject: Re: [Dovecot] Can't open configuration file On Fri, Jun 11, 2004 at 02:21:45PM +0200, Nico De Beer - MWEB wrote: > Let me give a bit more infor > > Originaly i had it in /usr/local/etc > and moved it to home/dovcot so i can give fulle access in a pah where there is not other info residing > > So i'm thinking it is something i specified in my config file > or a mistake i did during compiling OK, to avoid ambiguity, can you show the output of: # ls -ld / /home /home/dovecot /home/dovecot/dovecot-pgsql.conf Then check you get the same log error as before. Brian. Are you ready for Telkom's 10-digit dialling? To find out how this will affect your Internet connection in the not too distant future, go to www.mweb.co.za/ten

1 0

RE: [Dovecot] Can't open configuration file
by Nico De Beer - MWEB 11 Jun '04

11 Jun '04

Let me give a bit more infor Originaly i had it in /usr/local/etc and moved it to home/dovcot so i can give fulle access in a pah where there is not other info residing So i'm thinking it is something i specified in my config file or a mistake i did during compiling -----Original Message----- From: Brian Candler [mailto:B.Candler@pobox.com] Sent: 11 June 2004 01:36 To: Nico De Beer - MWEB Cc: dovecot(a)dovecot.org Subject: Re: [Dovecot] Can't open configuration file On Fri, Jun 11, 2004 at 01:22:43PM +0200, Nico De Beer - MWEB wrote: > Jun 11 13:12:46 "Fatal: Can't open configuration file > /home/dovecot/dovecot-pgsql.conf: Permission denied > this file have fulle permissions and has belonged to dovecot and root > but still no joy What about the directory /home/dovecot ? Are you ready for Telkom's 10-digit dialling? To find out how this will affect your Internet connection in the not too distant future, go to www.mweb.co.za/ten

2 1

[Dovecot] Can't open configuration file
by Nico De Beer - MWEB 11 Jun '04

11 Jun '04

Hi I'm getting Jun 11 13:12:46 "Fatal: Can't open configuration file /home/dovecot/dovecot-pgsql.conf: Permission denied this file have fulle permissions and has belonged to dovecot and root but still no joy what am i missing must be something stupid on this side Thanks for the previos comments about scripting I am swithcing to postgress for the mail env and will look at mysql when they support translation Are you ready for Telkom's 10-digit dialling? To find out how this will affect your Internet connection in the not too distant future, go to www.mweb.co.za/ten

2 1

[Dovecot] auth failure
by Tom Allison 11 Jun '04

11 Jun '04

well, with some help I've made a fair amount of progress on my box. It's working out much easier than I had anticipated and perhaps my notes will be useful some day. I have two questions... Here is where I am: cling:~# egrep -v "^($|\#)" /etc/dovecot.conf protocols = imap imaps login = imap login_max_processes_count = 16 login = pop3 max_mail_processes = 512 verbose_proctitle = yes default_mail_env = maildir:~/Maildir mailbox_check_interval = 1 auth = default auth_mechanisms = plain auth_passdb = pgsql /etc/dovecot-pgsql.conf auth_user = root auth_verbose = yes cling:~# egrep -v "^($|\#)" /etc/dovecot-pgsql.conf connect = dbname=dbmail user=dbmail_reader password=SECRET default_pass_scheme = PLAIN-MD5 password_query = SELECT passwd AS password FROM users WHERE userid = '%u' I've created working passwords using 'mkpasswd --hash=md5' and plugged the results into my database. I can login and everything looks pretty cool. Except, as near as I can tell, I'm sending plaintext authentication over the wire. My best guess is that my password gets munged into digest-md5 format before it goes over the wire. At this point I'm of the opinion that I'm reasonably secure. True so far? My guess is that the next step in security is to go for imaps and ssl configuration. But my debian installation doesn't appear to have the dovecot-openssl.cnf file referenced in the configuration.txt file. Is this missing from dovecot or am I looking at a debian problem?

3 4

[Dovecot] Corrupted index file
by Niilo Kajander 11 Jun '04

11 Jun '04

Hi, I've been wondering for a while if reiserfs is dovecot+maildir safe or not. I get this too often (and my imap session gets disconnected): Jun 9 08:42:32 sun imap(nk): Corrupted index file /home/nk/Maildir/.INBOX/.imap .index: UIDVALIDITY changed in uidlist This happens always when a new mail arrives in maildir. It's a Fedora Core 2 box running dovecot-0.99.10.4-4 (redhat) package. Could the reason for these corruptions be something else than reiserfs? I know there has been some problems with Fedora+dovecot but I haven't seen this one reported here. TIA, -- Niilo Kajander <nk(a)kajander.fi>

3 5

[Dovecot] bleah
by Tom Allison 11 Jun '04

11 Jun '04

Not to be a bitch, but I've asked several times about some basic questions or examples to clarify the essentials for configuration. What do some of the parameters mean? Expecially the ones that are mentioned only one in a paragraph and no where else in the documentation or wiki. (ie: login_process_per_use) And there have been a few others as well. that I won't bother to repeat. But I've been sitting on this list for a while yet and have found that when it comes to configuration, none of the emails posted have been answered or addressed. The closest I got was a suggestion to use views instead of tables in postgres. But technically nothing was ever said about dovecot itself. So I have to ask. Is the sketchy documentation in the source file, the web page, wiki, and limited reponse on the mailing list a matter of "I haven't gotten around to it yet" or a deliberate move to promote the commercial support potential for Procontrol? I've run into this kind of environment twice before (cyrus and razor) and in the case of cyrus they just didn't believe in doing the documentation but suggested I write it myself. That may be the case there as well ("I haven't gotten around to it yet". That's OK but cyrus has the difficulty of no one still not providing any answers to how anything was done, configured, functioned, or why. So documentation was kind of a reverse-engineering project in itself. In the case of razor it's a mix of no time and they would rather support the company than the project. I went back and re-read the emails that I had posted earlier and am pretty sure that they weren't too stupid (ie: how do I test an imap connection), difficult, or obscure (well, maybe one). I'm just trying to find more information on how to correctly configure this server such that I can retain the concept of keeping security in mind. I'm trolling through the archives and there doesn't seem to be much discussion from anyone else. So maybe I'm really stupid and can't do authentication schemes. I'm sure by this point I've really pissed a few people off and for that I mostly apologize. I'm a little bent here myself. It just that I didn't plan on having to set up sniffit to track my IMAP traffic in order to verify that things were actually working securely. I'm going to plug along and do it myself and probably get something to work. I have plain_text authentication working now, but was really hoping to actually get something secure. At this point I really don't expect an answer, but do hope that after 1.0 is released there will be time available to get some documentation in order. IMHO the level of documentation that is available on a software project is critical to it's use.

2 2

[Dovecot] pgsql documentation
by Tom Allison 11 Jun '04

11 Jun '04

From dovecot-pgsql.conf # Examples: # connect = host=192.168.1.1 dbname=users # connect = host=sql.example.com dbname=virtual user=virtual There is a reference to identify the rest of the parameters via libpq in the postgres documentation. From postgres, libpq says the connection environment variables are: hostname:port:database:username:password http://www.postgresql.org/docs/7.4/static/libpq-pgpass.html Should the dovecot-pgsql.conf docs be changed from "dbname=users" to "database=users" ??

1 1