Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 26th September 2008, 10:54
hncadmin hncadmin is offline
Junior Member
Join Date: Sep 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Virtual User & Domains With Postfix, Courier & MySQL (CentOS 5.1)

Hi All,

This is my first posting here and I'm hoping someone can point me in the right direction.

First off, GREAT TUTORIAL. Thank you falko for taking the time to create such a detailed document.

I have installed everything successfully, but postfix administration through phpmysql is cumbersome at best. I would really like to use something like PostfixAdmin, but I seem to be getting confused. So i'm about to ask what will probably amount to be a couple of stupid questions.

Are Postfix and PostfixAdmin supposed to use the same MySQL database, or are they seperate databases?

In the Postfix tutorial, it describes creating a database for Postfix called "mail". In the setup of PostfixAdmin, it describes creating a database for PostfixAdmin called "postfix". After comparing the 2 different MySQL database structures, I see that the MySQL database table structure for PostfixAdmin does not use the same table names as Postfix.

I have successfully created multiple users and domains through PostfixAdmin, but none of the new items show up in Postfix.

So how are these 2 applications supposed to function together?

Can somebody please help me out and shed some light on this? I really appreciate the assistance.


Reply With Quote
Sponsored Links
Old 27th September 2008, 14:18
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts

Postfixadmin does not work with this setup as it uses a different table structure.
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Old 28th September 2008, 05:50
hncadmin hncadmin is offline
Junior Member
Join Date: Sep 2008
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks for the reply.

After researching everything more in depth, I figured out that it wouldn't work with your tutorial. Once I confirmed that, I recreated a new Postfix DB, reinstalled PFA which populated the new DB, then tweaked postfix, AUTHMYSQLRC and all of the Postfix virtual files to look at the newly created PFA DB. VIOLA!!!! Everything now works!

Although PostfixAdmin (PFA) is a bit simplistic, it gets the job done ALOT easier and cleaner than having to use phpmyadmin to create new Domains, Users and Aliases in Postfix. Combine PFA with the Squirrelmail/PFA plugin and you give the users the ability to change passwords, add/modify forwarders and vacation functionality directly through Squirrelmail.

If anyone else runs into the same questions I had... Postfix and PostfixAdmin must use the same database and table structure.

Buena Suerte.

Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
localhost postfix/master: fatal: bind port 125: Permission denied g18c Installation/Configuration 4 24th March 2009 18:39
Mail System Error - Returned Mail tristanlee85 General 16 16th March 2008 10:40
Virtual Users And Domains With Postfix, Courier And MySQL Secondary MX acoghlan HOWTO-Related Questions 1 8th March 2008 06:02
Virtual Users And Domains With Postfix, Courier And MySQL (CentOS 5.1) mexus HOWTO-Related Questions 10 29th January 2008 21:18
Virtual Users And Domains With Postfix, Courier And MySQL can't login wildgoosed HOWTO-Related Questions 18 11th July 2007 22:34

All times are GMT +2. The time now is 13:48.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.