So now I have en working Postfix that receive email i need something so that I can read me emails.
So we will setup dovecot to use our mysql for users. and use SSL on all our connections.
Create a file called dovecot-sql.conf.ext in /etc/dovecot (Ore where you want to have it)
Add the following settings to the config file
driver = mysql connect = host=localhost dbname=virtual_mail user=postfix password=some_pass default_pass_scheme = MD5-CRYPT user_query = SELECT '/home/vmail/%n@%d/' as home, 5000 AS uid, 5000 AS gid FROM mailbox WHERE username = '%u' password_query = SELECT password FROM mailbox WHERE username = '%u'
Update so it match you config. You only need the read user for mysql.
Open the file /etc/dovecot/conf.d/auth-sql.conf.ext and se the it looks like mine (Deafult it should) I cut out some comments
passdb {
driver = sql
# Path for SQL configuration file, see example-config/dovecot-sql.conf.ext
args = /etc/dovecot/dovecot-sql.conf.ext
}
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf.ext
}
#driver = static
#args = uid=vmail gid=vmail home=/var/vmail/%u
Now we should activate dovecot so it uses our mysql for useres.
In file 10-auth.conf alter this settings
auth_mechanisms = plain login cram-md5 !include auth-sql.conf.ext #!include auth-system.conf.ext
In file 10-master.conf add the following
service auth {
...
unix_listener /var/spool/postfix/private/auth {
mode = 0660
# Assuming the default Postfix user and group
user = postfix
group = postfix
}
...
}
Open the file 10-ssl.conf And make the following changes
ssl = yes ssl_cert = </etc/pki/tls/certs/mail.elinodrift.se.crt ssl_key = </etc/pki/tls/private/mail.elinodrift.se.key
Here I use the same certs that we created for postfix
Setup mail locations in the file 10-mail.conf add this line
mail_location = maildir:/home/vmail/%n@%d/:INDEX=/home/vmail/%n@%d/indexes
Restart dovecot
service dovecot restart
See that dovecot listen on correct ports
netstat -anp | grep LISTEN | grep dovecot
tcp 0 0 0.0.0.0:993 0.0.0.0:* LISTEN 7252/dovecot tcp 0 0 0.0.0.0:995 0.0.0.0:* LISTEN 7252/dovecot tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN 7252/dovecot tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN 7252/dovecot tcp 0 0 :::993 :::* LISTEN 7252/dovecot tcp 0 0 :::995 :::* LISTEN 7252/dovecot tcp 0 0 :::110 :::* LISTEN 7252/dovecot tcp 0 0 :::143 :::* LISTEN 7252/dovecot
Test our SSL
openssl s_client -showcerts -connect localhost:993
Verify return code: 18 (self signed certificate) --- * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE AUTH=PLAIN] Dovecot ready.
Test with openssl our IMAP
openssl s_client -connect localhost:993 *OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE AUTH=PLAIN] Dovecot ready.
a1 LOGIN matte@elinodrift.se password
a1 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS] Logged in
a2 LIST "" "*"
* LIST (\HasNoChildren) "." "INBOX"
a2 OK List completed.
a3 EXAMINE INBOX
* FLAGS (\Answered \Flagged \Deleted \Seen \Draft)
* OK [PERMANENTFLAGS ()] Read-only mailbox.
* 5 EXISTS
* 5 RECENT
* OK [UNSEEN 1] First unseen.
* OK [UIDVALIDITY 1387973157] UIDs valid
* OK [UIDNEXT 6] Predicted next UID
* OK [HIGHESTMODSEQ 1] Highest
a3 OK [READ-ONLY] Select completed.
a4 FETCH 1 BODY[]
* 1 FETCH (BODY[] {312}
Return-Path: <test@elino.se>
X-Original-To: matte@elinodrift.se
Delivered-To: matte@elinodrift.se
Received: from mail.elino.se (37-46-182-158.customers.ownit.se [37.46.182.158])
by us1.elino.se (Postfix) with SMTP id 7429514130B
for <matte@elinodrift.se>; Mon, 23 Dec 2013 16:08:45 -0500 (EST)
hejsan
)
a4 OK Fetch completed.
a5 LOGOUT
* BYE Logging out
a5 OK Logout completed.
closed
As you can see I got the test email we sent when we tested the postfix
And the maillog on the server looks like this
Dec 25 07:05:13 us1 dovecot: imap-login: Login: user=<matte@elinodrift.se>, method=PLAIN, rip=37.463.182.158, lip=192.33.116.189, mpid=7428, TLS Dec 25 07:06:49 us1 dovecot: imap(matte@elinodrift.se): Disconnected: Logged out bytes=59/1054
Download squrrelmail from http://squirrelmail.org/download.php
In folder /var/www/html
wget http://squirrelmail.org/countdl.php?fileurl=http%3A%2F%2Fprdownloads.sourceforge.net%2Fsquirrelmail%2Fsquirrelmail-webmail-1.4.22.tar.gz tar zxvf squirrelmail-webmail-1.4.22.tar.gz mv squirrelmail-webmail-1.4.22 webmail Open file /etc/php.ini and change
short_open_tag = On
Run some commands for squrrelmail
mkdir -p /var/local/squirrelmail/data/ mkdir -p /var/local/squirrelmail/attach/ chown apache:apache -R /var/local/squirrelmail/ chmod 774 -R /var/local/squirrelmail/
Then go into squrrelmail folder and run
./configure
Sett you local settings and set the IMAP server settings
4. IMAP Server : localhost 5. IMAP Port : 993 6. Authentication type : login 7. Secure IMAP (TLS) : true 8. Server software : dovecot 9. Delimiter : detect
Then run the squrreylmail to see so that everything is working