Background: CentOS 5.2 on a Xen Virtual Machine; Apache, Postfix, Webmin, Virtualmin, MySQL, and pretty much all of the rest of the goodies. With some modification, I essentially followed this "How-to" to get the server up and running: http://www.howtoforge.com/virtual-hosting-with-virtualmin-on-centos5.1
I’m having some trouble getting Virtualmin to work with Postfix and MySQL backend. I understand that configuration (with MySQL) is frowned upon, but I couldn’t get the “easy” flat file configuration to work.
Initially users created by Virtualmin in the /etc/postfix/virtual flat file weren’t seen as valid users by the system. Mail arriving for a user would bounce with a message similar to “User unknown in Virtual Alias Table,” and of course that user couldn’t log into the system to retrieve email either.
I fought with that for almost a month, then gave up and installed PostfixAdmin and changed /etc/postfix/main.cf to use MySQL instead of flat files. I created the requisite MySQL database and the necessary tables, and set up a virtual domain and users using PostfixAdmin. Now I can receive mail to those users. I VERY ROUGHLY followed this guide to set up PostfixAdmin and the MySQL databases and the main.cf changes: http://www.opensourcehowto.org/how-to/mysql/mysql-users-postfixadmin-postfix-dovecot--squirrelmail-with-userprefs-stored-in-mysql.html
But…I can’t seem to get Virtualmin to work with the MySQL setup. My current relevant tables in the MySQL Postfix database are:
There use should be obvious, but alias is for aliases, domain contains all the virtual domains, and mailbox contains the username, password, full name, maildir location, and so on.
PostfixAdmin writes to these tables fine, and when virtual users and domains are created using PostfixAdmin, I can send and receive mail to/from them from external computers through the internet to this server.
When I try to create a new virtual domain with Virtualmin however, it creates a new table in the MySQL Postfix database with the name of the virtual domain, while PostfixAdmin simply writes a new record into the “domain” table in the MySQL Postfix database. These new virtual users and/or domains created by Virtualmin once again don’t work (“User unknown in Virtual Alias Table” when I try to send email to them, and login attempts either from the CLI of the local server or from the internet fail.
Anyway…I don’t care what happens “behind the scenes,” what databases and tables are written and used, etc. What I’d really like to get is a working system with Virtualmin, NOT PostfixAdmin, whether that entails using flat files or MySQL databases, I don’t really care.
So, now that I’ve written a novel, what information do you need from me to help me out?!
Thanks in advance.