Email with Postfix,Dovecot & MySQL on CentOS 5-CentOS 6 issues
 

We have CentOS 6.2 running on our VPS server (provided by Linode VPS hosting), but since the only instructions for setting up Email with Postfix, Dovecot and MySQL in the Linode library (or on Linode's site) is for the configuration on CentOS 5 [ http://library.linode.com/email/post...mysql-centos-5 ], I followed it for the installation/configuration of Email with Postfix, Dovecot and MySQL on our CentOS 6.2

Everything seemed to work fine until I got to the editing of the dovecot.conf file..
I replaced the content of the dovecot.conf file with stuff that the instruction asked to use to replace the dovecot.conf, but unsurprisingly, there were warnings.

......
........

Bye
[root@myserver1 /]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@myserver1 /]# chmod o= /etc/postfix/mysql-virtual_*.cf
[root@myserver1 /]# useradd -g vmail -u 5000 vmail -d /home/vmail -m
useradd: group 'vmail' does not exist
[root@myserver1 /]# chgrp postfix /etc/postfix/mysql-virtual_*.cf
[root@myserver1 /]# groupadd -g 5000 vmail
[root@myserver1 /]# useradd -g vmail -u 5000 vmail -d /home/vmail -m
[root@myserver1 /]# clear
[root@myserver1 /]# postconf -e 'myhostname = myserver1.kuiperhost.com'
[root@myserver1 /]# postconf -e 'mydestination = $myhostname, localhost, localhost.localdomain'
[root@myserver1 /]# postconf -e 'mynetworks = 127.0.0.0/8'
[root@myserver1 /]# postconf -e 'inet_interfaces = all'
[root@myserver1 /]# postconf -e 'message_size_limit = 30720000'
[root@myserver1 /]# postconf -e 'virtual_alias_domains ='
[root@myserver1 /]# postconf -e 'virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf'
[root@myserver1 /]# postconf -e 'virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf'
[root@myserver1 /]# postconf -e 'virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf'
[root@myserver1 /]# postconf -e 'virtual_mailbox_base = /home/vmail'
[root@myserver1 /]# postconf -e 'virtual_uid_maps = static:5000'
[root@myserver1 /]# postconf -e 'virtual_gid_maps = static:5000'
[root@myserver1 /]# postconf -e 'smtpd_sasl_type = dovecot'
[root@myserver1 /]# postconf -e 'smtpd_sasl_path = private/auth'
[root@myserver1 /]# postconf -e 'smtpd_sasl_auth_enable = yes'
[root@myserver1 /]# postconf -e 'broken_sasl_auth_clients = yes'
[root@myserver1 /]# postconf -e 'smtpd_sasl_authenticated_header = yes'
[root@myserver1 /]# postconf -e 'smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination'
[root@myserver1 /]# postconf -e 'smtpd_use_tls = yes'
[root@myserver1 /]# postconf -e 'smtpd_tls_cert_file = /etc/pki/dovecot/certs/dovecot.pem'
[root@myserver1 /]# postconf -e 'smtpd_tls_key_file = /etc/pki/dovecot/private/dovecot.pem'
[root@myserver1 /]# postconf -e 'virtual_create_maildirsize = yes'
[root@myserver1 /]# postconf -e 'virtual_maildir_extended = yes'
[root@myserver1 /]# postconf -e 'proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps'
[root@myserver1 /]# postconf -e 'virtual_transport = dovecot'
[root@myserver1 /]# postconf -e 'dovecot_destination_recipient_limit = 1'
[root@myserver1 /]# service sendmail stop
sendmail: unrecognized service
[root@myserver1 /]# chkconfig sendmail off
error reading information on service sendmail: No such file or directory
[root@myserver1 /]# chkconfig postfix on
[root@myserver1 /]# service postfix start
Starting postfix: [ OK ]
[root@myserver1 /]# cd /etc/dovecot
You have new mail in /var/spool/mail/root
[root@myserver1 dovecot]# chgrp dovecot /etc/dovecot-sql.conf
chgrp: cannot access `/etc/dovecot-sql.conf': No such file or directory
[root@myserver1 dovecot]# chgrp dovecot /etc/dovecot/dovecot-sql.conf
[root@myserver1 dovecot]# chmod o= /etc/dovecot/dovecot-sql.conf
[root@myserver1 dovecot]# chkconfig dovecot on
[root@myserver1 dovecot]# service dovecot start
Starting Dovecot Imap: doveconf: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:3: protocols=imaps is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:3: protocols=pop3s is no longer necessary, remove it
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:7: ssl_cert_file has been replaced by ssl_cert = <file
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:8: ssl_key_file has been replaced by ssl_key = <file
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:10: namespace private {} has been replaced by namespace { type=private }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:26: add auth_ prefix to all settings inside auth {} and remove the auth {} section completely
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:27: auth_user has been replaced by service auth { user }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:29: passdb sql {} has been replaced by passdb { driver=sql }
doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:33: userdb static {} has been replaced by userdb { driver=static }
[ OK ]
[root@myserver1 dovecot]# telnet localhost pop3
-bash: telnet: command not found


and the /var/log/maillog file looks like this

Question #1: Can I go on and use the email like this/this way/with the current configuration (notwithstanding the warnings)?
Question #2: Does anybody have a more up-to-date dovecot.conf file or can anybody point me to one?

I would appreciate any help I can get.

Thanks in advance.

I have seen this appear when using a Dovecot 1.x configuration file with Dovecot 2.x application. If you use the dovecot -n command, it should convert and clean up these entries for you.

My Dovecot 2.0 configuration can be found in this thread: http://www.linuxquestions.org/questi...oforge-940578/

Hi
Have u install dovecot-pop3d dovecot-imap package. Just few hour back i tried out the below link in insatllation ubuntu 10.04 lucid works without any sort of error



Did u got the output as below

#telnet localhost 25
ehlo localhost

Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 plato.example.com ESMTP Postfix
ehlo localhost
250-beetel.example.com
250-PIPELINING
250-SIZE 30720000
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH PLAIN
250-AUTH=PLAIN
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN




http://library.linode.com/email/post...tu-10.04-lucid

I Guess problem is in dovecot.conf file.check once again the configuration as below edited in dovecot.conf

protocols = imap imaps pop3 pop3s
log_timestamp = "%Y-%m-%d %H:%M:%S "
mail_location = maildir:/home/vmail/%d/%n/Maildir

ssl_cert_file = /etc/pki/dovecot/certs/dovecot.pem
ssl_key_file = /etc/pki/dovecot/private/dovecot.pem

namespace private {
separator = .
prefix = INBOX.
inbox = yes
}

protocol lda {
log_path = /home/vmail/dovecot-deliver.log
auth_socket_path = /var/run/dovecot/auth-master
postmaster_address = postmaster@example.com
}

protocol pop3 {
pop3_uidl_format = %08Xu%08Xv
}

auth default {
user = root

passdb sql {
args = /etc/dovecot-sql.conf
}

userdb static {
args = uid=5000 gid=5000 home=/home/vmail/%d/%n allow_all_users=yes
}

socket listen {
master {
path = /var/run/dovecot/auth-master
mode = 0600
user = vmail
}

client {
path = /var/spool/postfix/private/auth
mode = 0660
user = postfix
group = postfix
}
}
}


May 5 08:21:12 myserver1 postfix/smtpd[3415]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:21:12 myserver1 postfix/smtpd[3415]: fatal: no SASL authentication mechanisms


do u started sasl service

#service saslauthd start

Thanks Sanjay87..

I started the sasl service..then I created an email and sent a test mail.
Here are is the error I got from my Mail Queue..

EE2A03C425

2012/05/07 16:27

root@myserver1.myhost.com
me@mydomain.com

476 bytes

temporary failure. Command output: doveconf: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:3: protocols=imaps is no longer necessary, remove it doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:3: protocols=pop3s is no longer necessary, remove it doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:7: ssl_cert_file has been replaced by ssl_cert = <file doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:8: ssl_key_file has been replaced by ssl_key = <file doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:10: namespace private {} has been replaced by namespace { type=private } doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:26: add auth_ prefix to all settings inside auth {} and remove the auth {} section completely doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:27: auth_user has been replaced by service auth { user } doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:29: passdb sql {} has been replaced by passdb { driver=sql } doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:33: userdb static {} has been replaced by userdb { driver=static }

If you run the command in bold above, it should clean up your configuration and stop the error / warning messages. The new, updated, configuration will be titled dovecot-new.conf. Save your old dovecot.conf and rename this newfile dovecot.conf. Restart Dovecot and try again.

Request for help with Dovecot configuration to work with MySQL and Postfix
 

Hi all,

I want to convert this Dovecot configuration file for Dovecot 1.x to a dovecot file for Dovecot 2.x

=========== /etc/dovecot.conf =======================
protocols = imap imaps pop3 pop3s
log_timestamp = "%Y-%m-%d %H:%M:%S "
mail_location = maildir:/home/vmail/%d/%n/Maildir

ssl_cert_file = /etc/pki/dovecot/certs/dovecot.pem
ssl_key_file = /etc/pki/dovecot/private/dovecot.pem

namespace private {
separator = .
prefix = INBOX.
inbox = yes
}

protocol lda {
log_path = /home/vmail/dovecot-deliver.log
auth_socket_path = /var/run/dovecot/auth-master
postmaster_address = postmaster@example.com
}

protocol pop3 {
pop3_uidl_format = %08Xu%08Xv
}

auth default {
user = root

passdb sql {
args = /etc/dovecot-sql.conf
}

userdb static {
args = uid=5000 gid=5000 home=/home/vmail/%d/%n allow_all_users=yes
}

socket listen {
master {
path = /var/run/dovecot/auth-master
mode = 0600
user = vmail
}

client {
path = /var/spool/postfix/private/auth
mode = 0660
user = postfix
group = postfix
}
}
}

======================================================

I run CentOS 6 on my server and I am trying to get my Dovecot to work with MySQL and Postfix to handle multiple virtual domains/users.

I am currenty following the instructions here: http://library.linode.com/email/post...mysql-centos-5
but the instructions are for Dovecot 1.x.

Thanks in advance.

Two threads on the same topic have been merged here. Please keep discussion in one place in order to avoid confusion and to receive a more effective help. Thank you.