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

Hi All,

We have CentOS 6.2 running on our server, 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/postfix … l-centos-5">http://library.linode.com/email/postfix/dovecot-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 'messagesizelimit = 30720000'

[root@myserver1 /]# postconf -e 'virtualaliasdomains ='

[root@myserver1 /]# postconf -e 'virtualaliasmaps = proxy:mysql:/etc/postfix/mysql-virtualforwardings.cf, mysql:/etc/postfix/mysql-virtualemail2email.cf'

[root@myserver1 /]# postconf -e 'virtualmailboxdomains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf'

[root@myserver1 /]# postconf -e 'virtualmailboxmaps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf'

[root@myserver1 /]# postconf -e 'virtualmailboxbase = /home/vmail'

[root@myserver1 /]# postconf -e 'virtualuidmaps = static:5000'

[root@myserver1 /]# postconf -e 'virtualgidmaps = static:5000'

[root@myserver1 /]# postconf -e 'smtpdsasltype = dovecot'

[root@myserver1 /]# postconf -e 'smtpdsaslpath = private/auth'

[root@myserver1 /]# postconf -e 'smtpdsaslauth_enable = yes'

[root@myserver1 /]# postconf -e 'brokensaslauth_clients = yes'

[root@myserver1 /]# postconf -e 'smtpdsaslauthenticated_header = yes'

[root@myserver1 /]# postconf -e 'smtpdrecipientrestrictions = permitmynetworks, permitsaslauthenticated, rejectunauth_destination'

[root@myserver1 /]# postconf -e 'smtpdusetls = yes'

[root@myserver1 /]# postconf -e 'smtpdtlscert_file = /etc/pki/dovecot/certs/dovecot.pem'

[root@myserver1 /]# postconf -e 'smtpdtlskey_file = /etc/pki/dovecot/private/dovecot.pem'

[root@myserver1 /]# postconf -e 'virtualcreatemaildirsize = yes'

[root@myserver1 /]# postconf -e 'virtualmaildirextended = yes'

[root@myserver1 /]# postconf -e 'proxyreadmaps = $localrecipientmaps $mydestination $virtualaliasmaps $virtualaliasdomains $virtualmailboxmaps $virtualmailboxdomains $relayrecipientmaps $relaydomains $canonicalmaps $sendercanonicalmaps $recipientcanonicalmaps $relocatedmaps $transportmaps $mynetworks $virtualmailboxlimit_maps'

[root@myserver1 /]# postconf -e 'virtual_transport = dovecot'

[root@myserver1 /]# postconf -e 'dovecotdestinationrecipient_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: sslcertfile has been replaced by sslcert = doveconf: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:8: sslkeyfile has been replaced by sslkey = 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

May 4 23:26:21 myserver1 postfix/postqueue[15764]: warning: Mail system is down -- accessing queue directly
May 4 23:26:36 myserver1 postfix/postqueue[15902]: warning: Mail system is down -- accessing queue directly
May 5 01:05:40 myserver1 postfix/postdrop[17280]: warning: unable to look up public/pickup: No such file or directory
May 5 07:03:39 myserver1 postfix/postqueue[2519]: warning: Mail system is down -- accessing queue directly
May 5 08:21:04 myserver1 postfix/postfix-script[3400]: starting the Postfix mail system
May 5 08:21:04 myserver1 postfix/master[3402]: daemon started -- version 2.6.6, configuration /etc/postfix
May 5 08:21:04 myserver1 postfix/pickup[3404]: warning: BA7DF3C3BB: message has been queued for 12 days
May 5 08:21:04 myserver1 postfix/pickup[3404]: BA7DF3C3BB: uid=0 from= <root>May 5 08:21:04 myserver1 postfix/cleanup[3406]: BA7DF3C3BB: message-id=<20120505122104.BA7DF3C3BB@myserver1.kuiperhost.com>
May 5 08:21:04 myserver1 postfix/qmgr[3405]: BA7DF3C3BB: from=<root@myserver1.kuiperhost.com>, size=502, nrcpt=1 (queue active)
May 5 08:21:04 myserver1 postfix/pickup[3404]: BE5833C3BC: uid=48 from= <apache>May 5 08:21:04 myserver1 postfix/cleanup[3406]: BE5833C3BC: message-id=<20120505122104.BE5833C3BC@myserver1.kuiperhost.com>
May 5 08:21:04 myserver1 postfix/qmgr[3405]: BE5833C3BC: from=<apache@myserver1.kuiperhost.com>, size=1364, nrcpt=1 (queue active)
May 5 08:21:04 myserver1 postfix/pickup[3404]: warning: BF1A53C3BD: message has been queued for 13 days
May 5 08:21:04 myserver1 postfix/pickup[3404]: BF1A53C3BD: uid=0 from= <root>May 5 08:21:04 myserver1 postfix/cleanup[3406]: BF1A53C3BD: message-id=<20120505122104.BF1A53C3BD@myserver1.kuiperhost.com>
May 5 08:21:04 myserver1 postfix/qmgr[3405]: BF1A53C3BD: from=<root@myserver1.kuiperhost.com>, size=502, nrcpt=1 (queue active)
May 5 08:21:04 myserver1 postfix/local[3412]: BA7DF3C3BB: to=<root@myserver1.kuiperhost.com>, orig_to=<root>, relay=local, delay=1053360, delays=1053360/0.01/0/0.01, dsn=2.0.0, status=sent (delivered to mailbox)
May 5 08:21:04 myserver1 postfix/qmgr[3405]: BA7DF3C3BB: removed
May 5 08:21:05 myserver1 postfix/local[3414]: BF1A53C3BD: to=<root@myserver1.kuiperhost.com>, orig_to=<root>, relay=local, delay=1140058, delays=1140057/0.01/0/1, dsn=2.0.0, status=sent (delivered to mailbox)
May 5 08:21:05 myserver1 postfix/qmgr[3405]: BF1A53C3BD: removed
May 5 08:21:07 myserver1 postfix/smtp[3413]: BE5833C3BC: to=<jimmyadelanwa@yahoo.com>, relay=mta7.am0.yahoodns.net[98.139.54.60]:25, delay=26128, delays=26125/0.01/0.34/2.5, dsn=2.0.0, status=sent (250 ok dirdel)
May 5 08:21:07 myserver1 postfix/qmgr[3405]: BE5833C3BC: removed
May 5 08:21:11 myserver1 postfix/smtpd[3415]: connect from mail1215.grapevine.mkt2356.com[208.85.49.60]
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
May 5 08:21:13 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3415 exit status 1
May 5 08:21:13 myserver1 postfix/master[3402]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 08:22:13 myserver1 postfix/smtpd[3420]: connect from mail.swiftng.com[41.222.70.242]
May 5 08:22:13 myserver1 postfix/smtpd[3420]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:22:13 myserver1 postfix/smtpd[3420]: fatal: no SASL authentication mechanisms
May 5 08:22:14 myserver1 postfix/smtpd[3422]: connect from 61-221-92-243.HINET-IP.hinet.net[61.221.92.243]
May 5 08:22:14 myserver1 postfix/smtpd[3422]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:22:14 myserver1 postfix/smtpd[3422]: fatal: no SASL authentication mechanisms
May 5 08:22:14 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3420 exit status 1
May 5 08:22:14 myserver1 postfix/master[3402]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 08:22:15 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3422 exit status 1
May 5 08:23:55 myserver1 postfix/anvil[3418]: statistics: max connection rate 1/60s for (smtp:208.85.49.60) at May 5 08:21:12
May 5 08:23:55 myserver1 postfix/anvil[3418]: statistics: max connection count 1 for (smtp:208.85.49.60) at May 5 08:21:12
May 5 08:23:55 myserver1 postfix/anvil[3418]: statistics: max cache size 2 at May 5 08:22:14
May 5 08:24:24 myserver1 postfix/smtpd[3439]: connect from mail.firstcitygroup.com[41.223.147.140]
May 5 08:24:24 myserver1 postfix/smtpd[3439]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:24:24 myserver1 postfix/smtpd[3439]: fatal: no SASL authentication mechanisms
May 5 08:24:25 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3439 exit status 1
May 5 08:24:25 myserver1 postfix/master[3402]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 08:25:38 myserver1 postfix/smtpd[3470]: connect from mail1215.grapevine.mkt2356.com[208.85.49.60]
May 5 08:25:38 myserver1 postfix/smtpd[3470]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:25:38 myserver1 postfix/smtpd[3470]: fatal: no SASL authentication mechanisms
May 5 08:25:39 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3470 exit status 1
May 5 08:25:39 myserver1 postfix/master[3402]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 08:26:39 myserver1 postfix/smtpd[3473]: connect from mail1215.grapevine.mkt2356.com[208.85.49.60]
May 5 08:26:39 myserver1 postfix/smtpd[3473]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:26:39 myserver1 postfix/smtpd[3473]: fatal: no SASL authentication mechanisms
May 5 08:26:40 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3473 exit status 1
May 5 08:26:40 myserver1 postfix/master[3402]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 08:27:40 myserver1 postfix/smtpd[3477]: connect from intranet.swiftng.com[41.222.70.243]
May 5 08:27:40 myserver1 postfix/smtpd[3477]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:27:40 myserver1 postfix/smtpd[3477]: fatal: no SASL authentication mechanisms
May 5 08:27:41 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3477 exit status 1
May 5 08:27:41 myserver1 postfix/master[3402]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 08:29:21 myserver1 postfix/anvil[3441]: statistics: max connection rate 1/60s for (smtp:41.223.147.140) at May 5 08:24:24
May 5 08:29:21 myserver1 postfix/anvil[3441]: statistics: max connection count 1 for (smtp:41.223.147.140) at May 5 08:24:24
May 5 08:29:21 myserver1 postfix/anvil[3441]: statistics: max cache size 1 at May 5 08:24:24
May 5 08:30:41 myserver1 postfix/smtpd[3543]: connect from mail1215.grapevine.mkt2356.com[208.85.49.60]
May 5 08:30:41 myserver1 postfix/smtpd[3543]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:30:41 myserver1 postfix/smtpd[3543]: fatal: no SASL authentication mechanisms
May 5 08:30:42 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3543 exit status 1
May 5 08:30:42 myserver1 postfix/master[3402]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 08:31:55 myserver1 postfix/smtpd[3554]: connect from mail1215.grapevine.mkt2356.com[208.85.49.60]
May 5 08:31:55 myserver1 postfix/smtpd[3554]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:31:55 myserver1 postfix/smtpd[3554]: fatal: no SASL authentication mechanisms
May 5 08:31:56 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3554 exit status 1
May 5 08:31:56 myserver1 postfix/master[3402]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 08:32:56 myserver1 postfix/smtpd[3557]: connect from mail1215.grapevine.mkt2356.com[208.85.49.60]
May 5 08:32:56 myserver1 postfix/smtpd[3557]: warning: SASL: Connect to private/auth failed: No such file or directory
May 5 08:32:56 myserver1 postfix/smtpd[3557]: fatal: no SASL authentication mechanisms
May 5 08:32:57 myserver1 postfix/master[3402]: warning: process /usr/libexec/postfix/smtpd pid 3557 exit status 1
May 5 08:32:57 myserver1 postfix/master[3402]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
May 5 08:34:36 myserver1 dovecot: master: Dovecot v2.0.9 starting up (core dumps disabled)
May 5 08:34:36 myserver1 dovecot: config: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf
May 5 08:34:36 myserver1 dovecot: config: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:3: protocols=imaps is no longer necessary, remove it
May 5 08:34:36 myserver1 dovecot: config: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:3: protocols=pop3s is no longer necessary, remove it
May 5 08:34:36 myserver1 dovecot: config: Warning: Obsolete setting in /etc/dovecot/dovecot.conf:7: ssl_cert_file has been replaced by ssl_cert =</jimmyadelanwa@yahoo.com></root></root@myserver1.kuiperhost.com></root></root@myserver1.kuiperhost.com></root@myserver1.kuiperhost.com></root></apache@myserver1.kuiperhost.com></apache></root@myserver1.kuiperhost.com></root> 

Question #1: Can I go on and use the email like this/this way/with the current configuration (notwithstanding the warnings)?

Question #2: or is there a more current version of the dovecot.conf file you could point me to?

I have asked Linode support and they have said
> We unfortunately do not have a guide specifically for Postfix/Dovecot/MySQL on CentOS 6 (I have made a note of this and will let our Library team know, however). Additionally, we do not have a different version of dovecot.conf for CentOS 6.

……….if you're still unable to use email with this configuration, I would recommend reaching out to our user community for further assistance:

http://www.linode.com/community/ "

I would appreciate any help I can get here.

Thanks in anticipation.

19 Replies

Hey,

Recently ran into the same issue when setting up a new server on Ubuntu 12.04 (among others).

The guide on the Linode Library provides instructions for Dovecot 1.x, while the newer versions of Ubuntu (and apparently CentOS) use Dovecot 2.x. The config file format has changed, so the one in the guide is no longer applicable.

You can find the Dovecot 2 documentation here: http://wiki2.dovecot.org/

If you need help with the configuration, let me know and I'll do my best. You may also be able to install a Dovecot 1.x package, worth thinking about.

It also looks like you need to install a package that provides telnet to test Dovecot. If it is working fine how it is, then I'd assume you should be able to go on as normal, but I suspect you won't be able to.

It also looks like you have other problems with Postfix connecting to saslauthd, but there's not enough information to debug that issue. Could be related to your Dovecot configuration though.

@jerzzp:

It also looks like you need to install a package that provides telnet to test Dovecot.
I would be surprised if there is not a telnet client included with your distro. You should not need to install telnet to use the client to test services on your server.

@Dweeber:

@jerzzp:

It also looks like you need to install a package that provides telnet to test Dovecot.
I would be surprised if there is not a telnet client included with your distro. You should not need to install telnet to use the client to test services on your server.
Mm..
@redhat19:

[root@myserver1 dovecot]# telnet localhost pop3

-bash: telnet: command not found

@Dweeber:

Guess I was wrong.
Not about it being surprising that it's not there in the first place, I just happened to notice it in his first post ;)

Dear redhat19,

I suggest you try iRedMail solution to build a full-featured mail server in one minute instead of build it yourself.

iRedMail is a FREE, full-featured mail server solution, it works pretty well on Linode VPS. http://www.iredmail.org/

Sniff . . . . Sniff . . . .

Smell that?

Smells like spam.

ZhangHuangbin, you've made two (and only two) posts, both hawking iredmail.

Visiting it's site, it's hardly free. If you want anything but the barest of installs you need to pay $299/year or $599 for a lifetime license, just to get a bunch of open source apps bundled into a single binary installer.

Instead of trying to sneak it in, man up, and just put your product in your sig file.

Hi all,

Thanks for all your response.

@Jerzzp: Yes, I had to install telnet.

and as per the instrucions on http://library.linode.com/email/postfix … l-centos-5">http://library.linode.com/email/postfix/dovecot-mysql-centos-5

The next step is to test Postfix with the telnet command.

"You should see output similar to the following:

Trying 127.0.0.1…

Connected to localhost.

Escape character is '^]'.

220 plato.example.com ESMTP Postfix

ehlo localhost

250-plato.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 "

but here's what I see on my end:

[root@myserver1 /]# telnet localhost pop3

Trying ::1…

Connected to localhost.

Escape character is '^]'.

ehlo localhost

..and nothing else.

Does this mean Postfix is not working or something is wrong with the configuration?

Response from Linode Support:

Hello,

If Postfix is running, there may be a problem with your configuration.

Unfortunately, we cannot assist with specific configuration issues; for further assistance, I would recommend reaching out to our community:

http://www.linode.com/community/

Regards,

So, guys I would appreciate any help I can get with building the configuration files for Devcot 2.x as @Jerzzp has pointed out.

Thanks @ZhangHuangbin

Thanks @vonskippy

and thanks to @Dweeber

Postfix runs on port 25, and does not listen to POP3. Try 'telnet localhost 25' to test Postfix.

POP3 has an entirely different dialogue.

Alrighty I'll post the Dovecot config files I use, but I won't be able to until later this evening. I also use a split file configuration, but it works.

If you could maybe remove and reinstall Dovecot to get the default config file, because mine is based off of that.

Thanks @hoopycat

Here's what I get..

[root@myserver1 /]# telnet localhost 25

Trying ::1…

Connected to localhost.

Escape character is '^]'.

..and nothing else :(

@jerzzp Thanks a lot.

I eagerly await your post.

@hoopcat,

Something's been added:

[root@myserver1 /]# telnet localhost 25

Trying ::1…

Connected to localhost.

Escape character is '^]'.

Connection closed by foreign host.

[root@myserver1 /]#

Just keep you guys up to date..

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: sslcertfile has been replaced by ssl_cert =

Like I said you're probably gonna want to completely remove and reinstall Dovecot so your config files aren't all jumbled. The files I have are just the default files (but for Ubuntu 12.04) modified to make this configuration work. YMMV.

/etc/dovecot/dovecot.conf (via doveconf -n):

# 2.0.19: /etc/dovecot/dovecot.conf
# OS: Linux 3.0.18-linode43 i686 Ubuntu 12.04 LTS ext3
mail_location = maildir:/home/vmail/%d/%n/Maildir
namespace {
  inbox = yes
  location = 
  prefix = INBOX.
  separator = .
  type = private
}
passdb {
  args = /etc/dovecot/conf.d/auth-sql.conf.ext
  driver = sql
}
postmaster_address = postmaster@example.com
protocols = "imap pop3"
service auth {
  unix_listener auth-userdb {
    group = vmail
    mode = 0600
    user = vmail
  }
}
ssl_cert = 

Then in /etc/dovecot/conf.d/auth-sql.conf.ext:

driver = mysql
connect = host=127.0.0.1 dbname=mail user=mail_admin password=mail_admin_password
default_pass_scheme = CRYPT
password_query = SELECT email as user, password FROM users WHERE email='%u'

Thanks a lot @jerzzp

However, I think because you had created the configuration file for Ubuntu.. I was getting errors.

I am now looking into installing version 1.x as you had earlier suggested.

The only problem is that all the version 1.x I've come across were built for CentOS 5 (or have names like dovecot-1.2.17xxxx.el5xxx.rpm - with "el5" in them) but I have CentOS 6 installed.

So, I'm still looking for a solution.

Thanks.

The config files for Dovecot should be pretty platform independent across linux distros I'd imagine. What errors were you getting?

Wish I could be of more help as far as finding a Dovecot 1.x package but I have no experience with CentOS/yum.

Hope you get things working.

Hi @Jerzzp,

First it was around the lower part of the namespace block

namespace {

inbox = yes

location =

prefix = INBOX.

separator = .

type = private

}

a delimiter was being expected. I think it was the "." after "separator"

when I got past that, then there was another issue:

sslcert = sslkey =

it was something about the URLs not being correct/files did not exist.

I eventually had to get some help.

It is working fine now.

Thanks a whole lot.

How do you now create virtual mailbox users?

from the command line?

Been searching for a visual tool, then I ran into Postfix Admin.. but Postfix admin has its own database for managing virtual domains/user mailboxes and you're supposed to configure Postfix to work with that..

but I have already created a database in MySQL for that….

How did you get around this problem?

Well I'd just get a tool for MySQL. I use phpMyAdmin.

I used the built-in tool to convert my config files. Things are working pretty well.

doveconf -n -c dovecot.conf-centos5 > dovecot.conf

/etc/dovecot/dovecot.conf (notice the directory structure change).

# 2.0.9: dovecot.conf-centos5
# OS: Linux 2.6.32-220.el6.i686 i686 CentOS release 6.3 (Final) ext4
log_timestamp = "%Y-%m-%d %H:%M:%S "
mail_location = maildir:/home/vmail/%d/%n/Maildir
namespace {
  inbox = yes
  location =
  prefix = INBOX.
  separator = .
  type = private
}
passdb {
  args = /etc/dovecot/dovecot-sql.conf
  driver = sql
}
protocols = imap pop3
service auth {
  unix_listener /var/spool/postfix/private/auth {
    group = postfix                                                           
    mode = 0660
    user = postfix
  }
  unix_listener auth-master {
    mode = 0600
    user = vmail
  }
  user = root
}
ssl_cert = 

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct