Jason:
If you do:
dbmail-adduser a username password 0 20M [EMAIL PROTECTED]
It should create an entry in your 'users' table as well as one entry in
your 'aliases' table pointing to that user.
Is that not happening?
Yes. It is not happening!! Nothing in dbmail_alias table. I do see users in
the user tables! After postinging this problem, I added another user and
looked into the dbmail_users, the new user is in there but the
dbmail_aliases table is without any entry. Do you know what is the peoblem &
how to resolve it??
Kirti
-----Original Message-----
From: Jason Burfield [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 15, 2004 7:03 PM
To: DBMail mailinglist
Subject: Re: [Dbmail] Local recipient table!!!
Kirti...
You can use your dbmail aliases table as your local recipient table.
For instance:
In main.cf:
alias_maps = mysql:/etc/postfix/alias.cf
local_recipient_maps = $alias_maps
And you can create an alias.cf file as such:
user = postfix
password = PW
dbname = dbmail
table = aliases
select_field = alias
where_field = alias
hosts = localhost
This means postfix checks your dbmail 'aliases' table for a local
recipient. If one exists it delivers, if not, it kicks it back.
However, you say your 'aliases' table has no entries...have you added
accounts to dbmail yet?
If you do:
dbmail-adduser a username password 0 20M [EMAIL PROTECTED]
It should create an entry in your 'users' table as well as one entry in
your 'aliases' table pointing to that user.
Is that not happening?
-- Jason
On Sep 15, 2004, at 5:15 PM, Kirti S. Bajwa wrote:
Hello:
Since I posted this message, I have found additional information which
might
be helpful. I installed mysqlcc. In mysqlcc, I notice that
dbmail_aliases
has no entry in it. Is it normal?
Previously I had done the same setup except:
(1) dbmail version was: dbmail-1.2.9 & now it is dbmail-2.0rc8
(2) I named the data as: tibdata whereas previously it was: dbmail
When I did the previous installation, I had dbmail working. Thanks and
I
hope somebody has an answer or I fallback to dbmail-1.2.9.
Kirti
----------------------
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
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
