Linux Mail Server Setup and Howto Guide

1st of all, i'm a newbie.

In Linux, new user accounts automatically receive mail accounts right???

I'm curious, for adding thousands user email accounts to my mailserver(postfix/dovecot), is it standard practice to add user account? Or maybe there are other method (such as db)??

I mean, if i want to register 10k mail account, i have to create 10k linux user accounts????

Thanks

Post edited 3:05 am – May 31, 2010 by bighorn

Hi consultant,

Thanks for your reply.

I choose MySQL option and have install everything according to the manual.

MySQL,Postfix Admin,postfix, and everythings are in the same box.

I can login to MySQL email addresses via SquirrelMail.

My problem is, using MySQL email addresses, i can sent email out

but cannot received.But when using my system user names,

i can sent and receive email successfully.

When i test postfix configuration with cmd below:

postmap -q mydomain.com mysql:/etc/postfix/mysql-domains.cf

It doesn't echo my domain, but works fine for 

postmap -q johndoe@acme.com mysql:/etc/postfix/mysql-users.cf and

postmap -q john@acme.com mysql:/etc/postfix/mysql-aliases.cf

Looking at MySQL table domain, my domain already in the table.
What else could i miss? How can i troubleshoot and find the error log?

-----------------------------------my postfix/main.cf------------------------------------
virtual_mailbox_domains = mysql:/etc/postfix/mysql-domains.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql-users.cf
virtual_alias_maps = mysql:/etc/postfix/mysql-aliases.cf
virtual_mailbox_base = /home/upay
virtual_uid_maps = static:504
virtual_gid_maps = static:505

smtpd_sasl_local_domain =
smtpd_sasl_auth_enable = yes
smtpd_sasl_security_options = noanonymous
broken_sasl_auth_clients = yes
smtpd_sasl_authenticated_header = yes
smtpd_recipient_restrictions = permit_sasl_authenticated,permit_mynetworks,reject_unauth_destination
mynetworks = 127.0.0.0/8
smtpd_tls_auth_only = no
smtp_use_tls = yes
smtpd_use_tls = yes
smtp_tls_note_starttls_offer = yes
smtpd_tls_key_file = /etc/postfix/ssl/smtpd.key
smtpd_tls_cert_file = /etc/postfix/ssl/smtpd.crt
smtpd_tls_CAfile = /etc/postfix/ssl/cacert.pem
smtpd_tls_loglevel = 1
smtpd_tls_received_header = yes
smtpd_tls_session_cache_timeout = 3600s
tls_random_source = dev:/dev/urandom
myhostname = mydomain.com

home_mailbox = Maildir/
mailbox_command =

Really appreciate for your help

Thanks
Zul

Post edited 4:25 am – June 1, 2010 by bighorn

Hi consultant,

I've check it and i think everythings are in order.User,host,dbname,password are all correct.

#———————-mysql-domains.cf—————————–

host = localhost

user = postfix

password = mypostfixpswd

dbname = postfix

table = domain

select_field = domain

where_field = domain

additional_conditions = and backupmx = '0' and active = '1'

———————————————————————–

#-----------------mysql-users.cf-------------------------------
host = localhost
user = postfix
password = mypostfixpswd
dbname = postfix
table = mailbox
select_field = maildir
where_field = username
additional_conditions = and active = '1'
result_format = %sMaildir/
------------------------------------------------------------------

#--------------------mysql-aliases.cf--------------------------
host = localhost
user = postfix
password = mypostfixpswd
dbname = postfix
table = alias
select_field = goto
where_field = address
additional_conditions = and active = '1'
---------------------------------------------------------------

Looking at MySQL table domain, my domain already in the table and in active status with
 transport_field=virtual

Does I need to grant privileges for user in MySQL?

#------------------------dovecot-mysql.conf----------------------

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=mypostfixpswd
default_pass_scheme = PLAIN
password_query = SELECT password FROM mailbox WHERE username = '%u'
--------------------------------------------------------------------------------

#---------------------dovecot.conf---------------------------------------------

protocols = pop3 pop3s imap imaps
mail_location = maildir:~/Maildir/
pop3_uidl_format = %08Xu%08Xv
imap_client_workarounds = delay-newmail outlook-idle netscape-eoh
pop3_client_workarounds = outlook-no-nuls oe-ns-eoh

———————————————————————————-

#—————————-/usr/lib/sasl2/smtpd.conf——————

pwcheck_method: saslauthd

mech_list: plain login

————————————————————-

Hope this can help you to identify my error.

Thanks

Zul

Still no good, can't receive email after specify domain manually

Mail Delivery System Report Details:

This is the mail system at host mydomain.com.

I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.

For further assistance, please send mail to <postmaster>

If you do so, please include this problem report. You can
delete your own text from the attached returned message.

                   The mail system

<fauzi@mydomain.com>: unknown user: "fauzi"


Reporting-MTA: dns; mydomain.com
X-Postfix-Queue-ID: 52EED6F04C8
X-Postfix-Sender: rfc822; zulfadli@challengingprofile.com
Arrival-Date: Thu,  3 Jun 2010 12:24:55 +0800 (MYT)

Final-Recipient: rfc822; fauzi@mydomain.com
Original-Recipient: rfc822;fauzi@mydomain.com
Action: failed
Status: 5.1.1
Diagnostic-Code: X-Postfix; unknown user: "fauzi"

Hi expert,

I  am trying to install a mail server on my own.

I have installed postfix,dovecot and sasl.

1,How to test all these are all woring fine

2.I need to create a email ids how can i do it.

3.What is aliases-explain it.

4.What are virtual domains.

Pl reply to clarify these doubts.

thanx in advance.waiting for u r reply soon ————