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
