Hello:
I am trying to install dbmail-2.0rc8.tgz on a RH9 + MySQL-4.0.21 +
Postfix-2.1.4 on server "mail.tibinternet.net". I am struck at creating
"local recipient table".
I have read Postfix by Kyle D. Kent & have followed INSTALL &
INSTALL.postfix (from Postfix tarbal). I would like to read on creating
"Local Recipient Tables" especially, their format, how they are created,
etc.
When I try to create an email message, I get an error "User unknown in local
recipient table". Here is the actual error message:
----------------------------------------------------------------------------
-------
Hi. This is the qmail-send program at ns2.tibonline.net.
I'm afraid I wasn't able to deliver your message to the following addresses.
This is a permanent error; I've given up. Sorry it didn't work out.
<[EMAIL PROTECTED]>:
12.21.237.16 does not like recipient.
Remote host said: 550 <[EMAIL PROTECTED]>: Recipient address
rejected: User unknown in local recipient table
Giving up on 12.21.237.16.
--- Below this line is a copy of the message.
Return-Path: <[EMAIL PROTECTED]>
Received: (qmail 8211 invoked from network); 15 Sep 2004 14:41:11 -0000
Received: from unknown (HELO tesuque.JASPER) (12.21.237.250)
by ns2.tibonline.net with SMTP; 15 Sep 2004 14:41:11 -0000
Received: by TESUQUE with Internet Mail Service (5.5.2448.0)
id <S54LDY0H>; Wed, 15 Sep 2004 10:59:00 -0400
Message-ID: <[EMAIL PROTECTED]>
From: "Kirti S. Bajwa" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Cc:
Subject: Test email
Date: Wed, 15 Sep 2004 10:58:55 -0400
Return-Receipt-To: "Kirti S. Bajwa" <[EMAIL PROTECTED]>
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: text/plain;
charset="ISO-8859-1"
This is the first email from Kirti's computer to dbMail.
----------------------------------------------------------------------------
-----------------------------------------------------------------
Here is my step-by-step instaructions to install dbmail:
* Install Software:
% cd /usr/local
* download dbMail
% tar -zxf dbmail-2.0rc8.tgz
% ln -s /usr/local/dbmail-2.0rc8 /usr/local/dbmail
% cd dbmail
* Setup MySQL Database
% export PATH=$PATH:/usr/local/mysql/bin
* Make sure that MySQL is running
% /usr/local/mysql/bin/mysqladmin create tibdata - u root
-p
% /usr/local/mysql/bin/mysql - u root -p
mysql> GRANT ALL PRIVILEGES ON tibdata.*
==> TO [EMAIL PROTECTED]
<mailto:mysql@'192.168.237.0/255.255.255.0>
==> IDENTIFIED BY 'pwdbmail';
% /usr/local/mysql/bin/mysql -u dbmail tibdata -p
< sql/mysql/create_tables_innoDB.mysql
* Setup DB Settings:
% cp dbmail.conf /etc/dbmail.conf
* Edit /etc/dbmail.conf. Make following changes:
[DBMAIL]
host=localhost
user=dbmail
pass=pwdbmail
db=tibdata
[SMTP]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
* Configure & Make dbMail
% ./configure --with-mysql
% make all
* * Make sure that MySQL is running
* Create a test user in dbMail
% ./dbmail-users -a testdbmail -w testdbmail -g 0 -m 25M
\
-s [EMAIL PROTECTED]
* Configure MTA (read /usr/local/dbMail/INSTALL.postfix document):
SMTP Pipe - Settings
Edit /etc/postfix/master.cf
dbmail-smtp unix - n n
- - pipe
flags= user=dbmail:dbmail
argv=/usr/local/sbin/dbmail-smtp -d ${recipient} -r ${sender}
Edit /etc/postfix/main.cf
mailbox_transport = dbmail-smtp:
Edit /etc/postfix/transport
tibinternet.net dbmail-smtp:
% postmap /etc/postfix/transport
* * Make sure that POSTFIX is running
% postmap reload
* Install postfix-mysql package:
This package is installed. All this means is to compile
Postfix with MySQL.
* Create SQL Local Recipients File (
/etc/postfix/mysql-recipients.cf ) with following:
user = dbmail
password = pwdbmail
hosts = localhost
dbname = tibdata
table = dbmail_aliases
select_field = alias
where_field = alias
* Now tell Postfix to where the local-recipient table is?
Edit /etc/postfix/main.cf
local_recipient_maps =
mysql:/etc/postfix/mysql-recipients.cf
% postfix reload
----------------------------------------------------------------------------
--------------------
Sorry for the losg post but I need some direction in setting up "local
recipient table"!!!!!
Thanks in advance.
Kirti
