Admin Program for Virtual Users and Domains Postfix courier etc...(Ubuntu 8.04)?

[thomcraver]

Falko: Really - kudos. Great tutorial.

So I've decided to fudge it all up. I installed postfixadmin (2.2.1.1), then modified the /etc/postfix/mysql-virtual_*.cf files and authmysqlrc to reflect the table changes.

I can't authenticate anything now, and I'm just slightly out of my element in tracking this down. I know your tutorial wants to use the built-in mysql encrypt command. I know postfixadmin gives some options that include md5, which I've read is different than mysql's md5.

My mail logs show authdaemond burping out the following sql query when attempting to login and I'm not sure how it's coming up with it:

SELECT username, password, "", 5000, 5000, maildir, CONCAT(SUBSTRING_INDEX(username,'@',-1),'/',SUBSTRING_INDEX(username,'@',1),'/'), quota, name, "" FROM mailbox WHERE username = "myuser@mydomain.com"

I'm no stranger to SQL but this confuses me. How does one select a null field? I presume I may have typoed in a file somewhere, but I've triple-checked everything and also done diffs against your original files and only the field and table names are different.

Next:

The error right after in the log is: supplied password 'password' does not match encrypted password 'c8cc8e10a6fb2fa4ax1fd6fa4a6a9c097'(not the real values, but the hash is the correct length)

Where would I begin looking for this? authdaemon? postfix configs? Is there a preferred method of encryption that would allow the postfixadmin play nicely with your wonderful setup?

I realize you probably cannot much (if any?) for the postfixadmin, but any insight you're able to point me toward would be greatly appreciated!

[jmoncayo]

Awesome guide Falko, thanks a lot for it, I have now a server running smoothly.

I tried to use webmin to admin the postfix server, but it didnt work because this configuration for this mail server is not default.

But in the webmin from the Servers-Postfix-Users accounts there is an option to make it read from an specific user mailbox, i need to know if there is any tool to make it list every virtual user for each domain and list theirs email.