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 21st November 2008, 23:30
thomcraver thomcraver is offline
Junior Member
Join Date: Nov 2008
Location: Rochester, NY
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default worth to invest some time?

Falko: Really - kudos. Great tutorial.

So I've decided to fudge it all up. I installed postfixadmin (, 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.


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!

Last edited by thomcraver; 21st November 2008 at 23:35.
Reply With Quote
Sponsored Links
Old 4th August 2009, 05:54
jmoncayo jmoncayo is offline
Junior Member
Join Date: Jul 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

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.
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
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 11:49
localhost postfix/master: fatal: bind port 125: Permission denied g18c Installation/Configuration 4 24th March 2009 18:39
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 superman HOWTO-Related Questions 3 23rd October 2008 10:19
Virtual Users And Domains With Postfix, Courier, MySQL...Ubuntu 8.04 glennv HOWTO-Related Questions 5 14th June 2008 12:54
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail Ubuntu 8.04 paulodani HOWTO-Related Questions 7 4th June 2008 01:46

All times are GMT +2. The time now is 01:38.

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