logo

Virtual Users with Postfix and MySQL

logo

I recently discovered an excellent tutorial on setting up Postfix and Courier to use virtual users read from a MySQL database. This caught my attention because it is a much better setup than having real system users for all email addresses, as it allows much more flexibility. I finally set aside some time to set up a real mail server.

I first went through the tutorial installing everything on a virtual server running on my pc. I used a VMware image of Fedora Core 5. You can find that and many other VMware images on VMware’s appliance directory page.

I ran through the tutorial, and got everything working relatively quickly. There was one thing I had to add that was not in the tutorial. That was this command:

postconf -e ‘mailbox_transport = virtual’

After that, I was able to send and receive emails from my virtual server.

I then went out and bought another VPS account with Tektonic, planning to have another quick and easy install of the mail software. After running through the tutorial twice, I was still unsuccessful. I kept getting an error in postfix’s log:

Dec 25 06:41:28 mail postfix/smtpd[27714]: fatal: no SASL authentication mechanisms
Dec 25 06:41:29 mail postfix/master[15875]: warning: process /usr/libexec/postfix/smtpd pid 27714 exit status 1
Dec 25 06:41:29 mail postfix/master[15875]: warning: /usr/libexec/postfix/smtpd: bad command startup — throttling

These three lines show up in my mail log repeatedly. When I try to initiate a connection to my mail server on port 25, there is no response from Postfix:

telnet mail.parecki.com 25
Trying mail.parecki.com…
Connected to mail.parecki.com.
Escape character is ‘^]’.

It just hung after that.

I eventually figured out that I was missing a critical package.

yum install cyrus-sasl-plain

After installing that package, everything works perfectly! I guess it already came installed on my VMware image for some reason.

Thanks to Falko Timme for writing a great tutorial, and for responding to my forum posts asking for help!

5 Responses to “Virtual Users with Postfix and MySQL”

  1. I have seen that intelligent real estate agents all around you are starting to warm up to FSBO Advertising and marketing. They are noticing that it’s more than merely placing a poster in the front property. It’s really with regards to building interactions with these retailers who one of these days will become purchasers. So, if you give your time and effort to supporting these sellers go it alone — the “Law involving Reciprocity” kicks in. Interesting blog post.

  2. I simply had to thank you very much all over again. I’m not certain the things that I would have followed in the absence of the type of strategies revealed by you on such a subject. It truly was a very alarming problem in my opinion, but spending time with a new expert manner you solved it took me to leap over contentment. I am just happy for this information and in addition trust you recognize what a great job you are always undertaking training others through a blog. I am certain you have never got to know all of us.|

  3. Hey, i know, Testing 123 can be better than this? I can’t stop reading about Testing 123.

  4. click here says:

    I not to mention my friends came looking at the nice points on your web page and then quickly came up with an awful feeling I never expressed respect to you for those strategies. Those women appeared to be totally glad to read all of them and have now really been having fun with them. We appreciate you being very kind and then for figuring out this form of superior ideas most people are really desperate to be informed on. My honest apologies for not expressing gratitude to earlier.

  5. 0800 uk cost says:

    Thanx for a very informative website. What else could I get that type of info written in such a perfect method? I’ve a project that I’m just now operating on, and I’ve been on the look out for such info.

Leave a Reply

logo
logo
Powered by WordPress | Designed by Elegant Themes