- dovecot - dovecot.org

Re: [Dovecot] Mysql access denied
by list＠airstreamcomm.net 24 Jun '11

24 Jun '11

On Thu, 23 Jun 2011 15:48:58 +0200, Johan Hendriks <joh.hendriks(a)gmail.com> wrote: > Op 23-6-2011 15:37, list(a)airstreamcomm.net [1] schreef: > Currently using dovecot 2.0.12 and mysql server 4.0.20 (I know, it's > really old) and having issues getting Dovecot to authenticate to the > mysql > server. We have confirmed that the credentials are correct and the host > machine can access the database, however we are getting the following > error: > > Jun 23 08:12:50 hostname dovecot: auth: Error: mysql(databaseserver.com): > Connect failed to database (database): Access denied for user: > 'sqladmin(a)ip.of.host.machine [2]' (Using password: YES) - waiting for 1 > seconds > before retry > > We are assuming this has something to do with the password hashing > algorithm in older versions of mysql, but we are hoping to confirm this > theory and find a solution. > > Thanks. > > This has as far as i can see nothing to do with hashes. > It is the mysql database that disallows the user sqladmin access to the > database. > Make sure the user sqladmin has the proper rights to access the > database, from the ipadres. > > Gr > Johan Hendriks > > > > Links: > ------ > [1] mailto:list@airstreamcomm.net > [2] mailto:sqladmin@ip.of.host.machine When talking about hashes I was referring to this wiki article: http://wiki1.dovecot.org/MysqlProblems. As I stated in my email we have confirmed that the host can access the database just fine, and the credentials are correct in the config for Dovecot. Thanks.

4 3

[Dovecot] diacritic marks in password
by pch0317 24 Jun '11

24 Jun '11

Hi, I have dovecot 2.0.beta6 (on RedHat 6) and my user uses thunderbird 3.1.10 (on Windows XP). I use authentication via LDAP (Windows server 2003 AD). When user use in password diacritic marks (ą,ć,ę,ł,ń,ó) authentication failed. What can I do? Thanks

5 4

[Dovecot] Error with Dovecot LDA when using recipient address misses user part
by Nikolaos Milas 23 Jun '11

23 Jun '11

Hi, We are using Postfix 2.8.3 with Dovecot 2.0.13 on CentOS 5.6. The problem we have is that sometimes, due to mail sender's error when composing a message, the sender attempts to send an email to "@noa.gr" (without specifying the user part of the address). This results in a Postfix error due to Dovecot LDA use: Jun 22 21:05:31 vmail postfix/pipe[31862]: CC89FC4D210: to=<@noa.gr>, relay=dovecot, delay=0.41, delays=0.24/0.013/0/0.15, dsn=5.3.0, status=bounced (command line usage error. Command output: /usr/libexec/dovecot/dovecot-lda: option requires an argument -- d Usage: dovecot-lda [-c <config file>] [-a <address>] [-d <username>] [-p <path>] [-f <envelope sender>] [-m <mailbox>] [-e] [-k] ) Postfix master.cf is configured as: dovecot unix - n n - - pipe flags=DRhu user=vmail:vmail argv=/usr/libexec/dovecot/dovecot-lda -f ${sender} -d ${user} Obviously this happens because in this case there is no ${user} data. My question is: Can we somehow configure things in a way so as to avoid this error when someone sends an email with blank sender data? Can Dovecot provide some meaningful message to postfix (like "No user specified") instead of failing with a "command line usage error"? Thanks, Nick

2 2

[Dovecot] interpreting imaptest results
by alex 23 Jun '11

23 Jun '11

Hi I'am doing some tests with nginx proxy -> dovecot using imaptest: imaptest user=user host=host pass=pass msgs=50 clients=100 Logi List Stat Sele Fetc Fet2 Stor Dele Expu Appe Logo 100% 50% 50% 100% 100% 100% 50% 100% 100% 100% 100% 30% 5% 41 19 10 36 24 39 9 13 11 8 12 100/100 10 12 11 17 24 31 3 24 38 46 94 100/100 24 13 13 24 26 33 10 22 25 25 52 100/100 27 13 12 25 23 26 9 19 23 24 48 100/100 25 14 13 27 27 40 7 19 27 28 56 100/100 36 12 16 33 28 39 7 23 20 24 44 99/100 17 12 8 19 18 27 5 18 27 28 60 99/100 27 12 11 25 22 27 6 18 22 25 50 100/100 24 13 12 27 25 34 1 21 24 28 52 100/100 26 5 11 25 20 30 10 14 18 20 42 100/100 from what I have seen the results look pretty low , but what I can't really find is the meaning of numbers under each imap command. Can anyone explain what this numbers represent. Thank you Alex

1 0

[Dovecot] Mysql access denied
by list＠airstreamcomm.net 23 Jun '11

23 Jun '11

Currently using dovecot 2.0.12 and mysql server 4.0.20 (I know, it's really old) and having issues getting Dovecot to authenticate to the mysql server. We have confirmed that the credentials are correct and the host machine can access the database, however we are getting the following error: Jun 23 08:12:50 hostname dovecot: auth: Error: mysql(databaseserver.com): Connect failed to database (database): Access denied for user: 'sqladmin(a)ip.of.host.machine' (Using password: YES) - waiting for 1 seconds before retry We are assuming this has something to do with the password hashing algorithm in older versions of mysql, but we are hoping to confirm this theory and find a solution. Thanks.

2 1

[Dovecot] Question about corrupted mdbox file
by Maria Arrea 23 Jun '11

23 Jun '11

Hello. We are using mdbox 2.013 + zlib, without SIS. When I try doveadm force-resync on a user's mailbox I get the following: doveadm(jmraya): Error: Corrupted dbox file /buzones/mydomain/0b/59/jmraya/storage/m.27 (around offset=22805024): Unexpected EOF while reading metadata header doveadm(jmraya): Warning: dbox: Copy of the broken file saved to /buzones/mydomain/0b/59/jmraya/storage/m.27.broken Any advice about this? Regards Maria

1 0

[Dovecot] Custom Trash (etc) location
by fusionstream 23 Jun '11

23 Jun '11

Hi there. I have dovecot 1.2.17 installed on me system. I'd like to create a gmail-esque imap tree where all imap folders except for the inbox are in a subdirectory(?). More importantly, I'd like the email client (specifically thunderbird) to be able to recognise the folders and thusly give it a special trash/junk/etc icon which I presume also makes trash and junk go to, well the truash and junk folders automagically. Based on searching the web, I believe that namespaces are the solution. I believed that I had set it up to be 1) Inbox 2) IMAP - Drafts - Junk - Trash - etc However, when trying to use namespaces, I get IMAP.Drafts, IMAP.Junk and all the other folders also appearing in INBOX, in addition to another top-level IMAP.*. What am I doing wrong? If I understand the solutions posted on the web correctly, solving this (resulting in only one of each type of folder) should make thunderbird automagically recognise these "special folders". This is my configuration: # 1.2.17: /etc/dovecot.conf # OS: Linux 2.6.18-238.12.1.el5 i686 CentOS release 5.6 (Final) ext3 ssl_ca_file: /etc/postfix/ssl/cacert.pem ssl_cert_file: /etc/postfix/ssl/smtpd.crt ssl_key_file: /etc/postfix/ssl/smtpd.key login_dir: /var/run/dovecot/login login_executable(default): /usr/libexec/dovecot/imap-login login_executable(imap): /usr/libexec/dovecot/imap-login login_executable(pop3): /usr/libexec/dovecot/pop3-login first_valid_uid: *[removed]* last_valid_uid: *[removed]* first_valid_gid: *[removed]* last_valid_gid: *[removed]* mail_location: maildir:/var/spool/mail/virtual/%d/%n mail_executable(default): /usr/libexec/dovecot/imap mail_executable(imap): /usr/libexec/dovecot/imap mail_executable(pop3): /usr/libexec/dovecot/pop3 mail_plugins(default): autocreate mail_plugins(imap): autocreate mail_plugins(pop3): mail_plugin_dir(default): /usr/lib/dovecot/imap mail_plugin_dir(imap): /usr/lib/dovecot/imap mail_plugin_dir(pop3): /usr/lib/dovecot/pop3 imap_client_workarounds(default): outlook-idle delay-newmail imap_client_workarounds(imap): outlook-idle delay-newmail imap_client_workarounds(pop3): pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh namespace: type: private separator: . prefix: INBOX. inbox: yes list: yes subscriptions: yes namespace: type: private separator: . prefix: IMAP. list: yes subscriptions: yes lda: postmaster_address: postmaster(a)example.com auth default: mechanisms: plain login user: dovecot-auth passdb: driver: sql args: /etc/dovecot/mysql.conf userdb: driver: sql args: /etc/dovecot/mysql.conf socket: type: listen client: path: /var/spool/postfix/private/auth mode: 509 user: postfix group: postfix plugin: autocreate: IMAP.Trash autocreate2: IMAP.Spam autocreate3: IMAP.Sent Mail autocreate4: IMAP.Drafts autosubscribe: IMAP.Trash autosubscribe2: IMAP.Spam autosubscribe3: IMAP.Sent Mail autosubscribe4: IMAP.Drafts Any help appreciated. Cheers.

3 2

[Dovecot] pop3 configuration
by Amira Othman 23 Jun '11

23 Jun '11

Hi I am using Dovecot version 1.0.7 with postfix-2.3.3-2.3. on CentOS5.6 and it's my first time to setup mail server .Everything is working fine sending and receiving but when connecting through any mail client I only can send mails but the received mails I can't read them although they are already received on the server and there is no problems in mail log file .Any one can help me?? Amira Othman Server Administrator <http://www.cairosource.com/> www.cairosource.com 6 EL Nil EL Abyad, Mohandiseen Cairo, Egypt Direct: +2 02 3303 7175 Mobile: +2 012 220 4165 The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.

1 0

[Dovecot] How to make SUBdirectories in Dovecot...
by Theatre 23 Jun '11

23 Jun '11

Hi! I wonder how i can get subdirectories (.INBOX/***/*** etc...) in dovecot... I just stardet a mail server and when i tried to create it from the mail client (MS Outlook) it says that the server wont allow it... Anyone who knows a solution? -- View this message in context: http://old.nabble.com/How-to-make-SUBdirectories-in-Dovecot...-tp31739301p3… Sent from the Dovecot mailing list archive at Nabble.com.

4 7

[Dovecot] SQL config error
by list＠airstreamcomm.net 22 Jun '11

22 Jun '11

Currently using 2.0.12, configured the auth-sql.conf to look like this for password lookups (doing smtp auth with postfix, so I am not actually running pop or imap, just auth): passdb { driver = sql connect = host=server.net dbname=passwd user=sqluser password='password' default_pass_scheme = CRYPT password_query = SELECT CONCAT(username,'@domain.net') as user, pw as password FROM passwd WHERE username = '%n' # Path for SQL configuration file, see example-config/dovecot-sql.conf.ext args = /etc/dovecot/dovecot-sql.conf.ext } Starting Dovecot I am getting the following error: # 2.0.12: /etc/dovecot/dovecot.conf doveconf: Fatal: Error in configuration file /etc/dovecot/conf.d/auth-sql.conf.ext line 8: Unknown setting: connect This is my first time configuring SQL for Dovecot so I am not sure how "connect" is recognized as an unknown setting? Thanks.

2 2