Postfix was originally designed to run off various db files, from plain text, to a couple types of other flat file formats. These configuration files, in typical unix style were consulted when needed, but were usually owned by the postmaster user, and hard to configure using say a web interface.
So, MySQL support was born, I think there's a patch for Postgres support as well. This enables say a perl or php script to add and remove users, domains, etc, as long as it has the database login, making admin easier. You do not strickly need mysql support to run Postfix with DBMail, however, having it enables you to do some nice things, such as telling postfix to look in DBMail's alias table for valid recipients. This is really nice, reducing load on your server as you can block email to invalid recipients at the SMTP stage instead of accepting everything, and letting DBMail generate bounce emails for the invalid email. There's a couple other things you can do as well. So in short, I'd recommend it, although you don't 'need' it per-se. Your server will run just fine without mysql support built into postfix. For running a mailserver for several domains, using the virtual domains configuration with postfix is definitely the way to go. -Micah On Tuesday 07 March 2006 8:36 am, Jim Douglas wrote: > Micah, > > Thanks for the reply. I now can send/receive from Postfix and have > configured Postfix for as a Virtual Mailbox Domain. > > Before jump into dbmail is this an ideal configuration for Postfix/dbmail > or should I set up Postfix to handle many virtual mailbox domains? (I will > have multiple domains and hundreds of users.) > > Also, do I need to have MySsql support build into Postfix? I ran > postconf -m and realized I don't have it built in.... > > Thanks, > Jim > > >From: Micah Stevens <[EMAIL PROTECTED]> > >Reply-To: DBMail mailinglist <[email protected]> > >To: DBMail mailinglist <[email protected]> > >Subject: Re: [Dbmail] Client Support > >Date: Mon, 6 Mar 2006 09:26:28 -0800 > > > > > >In order for dbmail to receive the message, first Postfix needs to receive > >it. > >You're not allowing external deliveries with postfix. > > > >What it looks like is happening, is that when the email is being > > delivered, postfix looks for a list of people it can accept email for. > > This was to be in > >mysql (the recipients list setting you removed) but since you removed > > that, it doesn't have a list, so it doesn't find any recipients. > > > >Since Postfix then doesn't recognize the recipient, it assumes it's for > >someone on another server, and checks to see if the client has permission > >to > >relay through your server. It doesn't (and shouldn't, search for 'open > >relay' > >on google to see why) so it fails with the message. > > > >If you get postfix configured properly with a good recipients list, then > >dbmail will get the email delivered to it. > > > >Get Postfix working right first, and then worry about dbmail. So far > > dbmail isn't even in the loop yet. > > > >-Micah > > > >On Monday 06 March 2006 9:15 am, Jim Douglas wrote: > > > I see. My mistake. I chose that option in the Postfix conf. (from the > > > install.postfix file) > > > > > > 4. Postfix can also interface directly with MySQL or PostgreSQL to > > > check for aliases b > > > > > > Now I can send from Evolution but when the users replies they get this > > > failure notice returned? > > > > > > Hi. This is the qmail-send program at yahoo.com. > > > 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]>: > > > 63.62.11.18 does not like recipient. > > > Remote host said: 554 <[EMAIL PROTECTED]>: Relay access denied > > > Giving up on 63.62.11.18 > > > > > > Also, how come the sent messages are not in the dbmail tables? > > > > > > Jim > > > > > > >From: Micah Stevens <[EMAIL PROTECTED]> > > > >Reply-To: DBMail mailinglist <[email protected]> > > > >To: DBMail mailinglist <[email protected]> > > > >Subject: Re: [Dbmail] Client Support > > > >Date: Mon, 6 Mar 2006 08:45:31 -0800 > > > > > > > > > > > >No you don't. Whether DBMail is there or not would not of affected > > > > your solution, you were telling Postfix to look at a mysql table for > > > > it's > > > >SMTP > > > > > >recipients list. This would be an issue with a non-mysql compiled > > > >Postfix > > > > > >regardless of whether or not DBMail was there. > > > > > > > >-Micah > > > > > > > >On Monday 06 March 2006 8:36 am, Jim Douglas wrote: > > > > > I took out this line out.. > > > > > > > > > > #local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf > > > > > > > > > > ..and can now send from Evolution. So I guess you must compile > > > >Postfix > > > > > > > with mysql support for dbmail to work. > > > > > > > > > > > > > > > Jim > > > > > > > > > > >From: Micah Stevens <[EMAIL PROTECTED]> > > > > > >Reply-To: DBMail mailinglist <[email protected]> > > > > > >To: DBMail mailinglist <[email protected]> > > > > > >Subject: Re: [Dbmail] Client Support > > > > > >Date: Mon, 6 Mar 2006 08:07:40 -0800 > > > > > > > > > > > > > > > > > >Postfix has nothing to do with IMAP either. Looks like your SMTP > > > >setup > > > > > >is > > > > > > > > > >hosed. Somewhere (I'd look at aliases, or virtual domains first) > > > >your > > > > > > > >config > > > > > >files are setup to look in mysql for data instead of a file. > > > > > > > > > > > >You could either tell it different, or install postfix-mysql. > > > > > > > > > > > >On Monday 06 March 2006 7:43 am, Jorge Bastos wrote: > > > > > > > Ya... postfix has nothing to do with DBmail > > > > > > > If you're on debian just apt-get install postfix-mysql > > > > > > > > > > > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > > > From: "Jim Douglas" <[EMAIL PROTECTED]> > > > > > > > To: <[email protected]> > > > > > > > Sent: Monday, March 06, 2006 2:59 PM > > > > > > > Subject: Re: [Dbmail] Client Support > > > > > > > > > > > > > > > Thats what I thought about IMAP. Since installing dbmail I > > > >can't > > > > > > > >connect > > > > > > > > > > > > > > from Evolution. > > > > > > > > > > > > > > > > ....this is my log file, > > > > > > > > > > > > > > > > Mar 6 09:52:28 cpe-33-44-561-78 postfix/master[30240]: > > > > > > > > daemon started > > > > > > > > > > > >-- > > > > > > > > > > > > > > version 2.2.2, configuration /etc/postfix > > > > > > > > Mar 6 09:52:32 cpe-33-44-561-78 postfix/smtpd[30244]: fatal: > > > > > > > > > > > >unsupported > > > > > > > > > > > > > > dictionary type: mysql > > > > > > > > Mar 6 09:52:33 cpe-33-44-561-78 postfix/master[30240]: > > > >warning: > > > > > >process > > > > > > > > > > > > > > /usr/libexec/postfix/smtpd pid 30244 exit status 1 > > > > > > > > Mar 6 09:52:33 v postfix/master[30240]: warning: > > > > > > > > /usr/libexec/postfix/smtpd: bad command startup -- throttling > > > > > > > > > > > > > > > > Do I need to re-install Postfix with mysql support? > > > > > > > > > > > > > > > > Jim > > > > > > > > > > > > > > > >>From: Micah Stevens <[EMAIL PROTECTED]> > > > > > > > >>Reply-To: DBMail mailinglist <[email protected]> > > > > > > > >>To: DBMail mailinglist <[email protected]> > > > > > > > >>Subject: Re: [Dbmail] Client Support > > > > > > > >>Date: Sun, 5 Mar 2006 22:40:54 -0800 > > > > > > > >> > > > > > > > >> > > > > > > > >>Anything that's IMAP compatible, right? :) > > > > > > > >> > > > > > > > >>I've used successfully: > > > > > > > >>Outlook > > > > > > > >>Evolution > > > > > > > >>Kmail > > > > > > > >>Squirrelmail (imap only) > > > > > > > >>Eudora > > > > > > > >>Thunderbird > > > > > > > >>Yahoo Mail (POP3) > > > > > > > >>GMail (POP3) > > > > > > > >>The POP client used in PalmOS 4.x (sorry, forgot the name) > > > > > > > >>Netscape > > > > > > > >> > > > > > > > >>It's pretty universal, although a few problems have cropped > > > > > > > >> up > > > > > > > >once > > > > > > > > > > > >> in > > > > > > > > > > > >a > > > > > > > > > > > > > >>while > > > > > > > >>I've noticed, but the developers are quick to respond. > > > > > > > >(thunderbird > > > > > > > > > >had a > > > > > > > > > > > > > >>date issue for example a while back I think, but it's fixed > > > >now) > > > > > > > > > >>-Micah > > > > > > > >> > > > > > > > >>On Sunday 05 March 2006 5:56 pm, Jim Douglas wrote: > > > > > > > >> > To all, > > > > > > > >> > > > > > > > > >> > What email clients does dbmail support for connecting thru > > > > > > > >> > IMAP > > > > > > > >or > > > > > > > > > > > >> > POP? > > > > > > > >> > > > > > > > > >> > I use Evolution and Dovecot now. > > > > > > > >> > > > > > > > > >> > Jim > > > > > > > >> > > > > > > > > >> > > > > > > > > >> > _______________________________________________ > > > > > > > >> > Dbmail mailing list > > > > > > > >> > [email protected] > > > > > > > >> > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > >> > > > > > > > >>_______________________________________________ > > > > > > > >>Dbmail mailing list > > > > > > > >>[email protected] > > > > > > > >>https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > > > Dbmail mailing list > > > > > > > > [email protected] > > > > > > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > > > > > > > > _______________________________________________ > > > > > > > Dbmail mailing list > > > > > > > [email protected] > > > > > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > > > > > >_______________________________________________ > > > > > >Dbmail mailing list > > > > > >[email protected] > > > > > >https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > > > > _______________________________________________ > > > > > Dbmail mailing list > > > > > [email protected] > > > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > >_______________________________________________ > > > >Dbmail mailing list > > > >[email protected] > > > >https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > _______________________________________________ > > > Dbmail mailing list > > > [email protected] > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > >_______________________________________________ > >Dbmail mailing list > >[email protected] > >https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
