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.
Reply
 
Thread Tools Display Modes
  #1  
Old 23rd January 2006, 09:52
brianwc brianwc is offline
Junior Member
 
Join Date: Jan 2006
Posts: 15
Thanks: 1
Thanked 1 Time in 1 Post
Default Virtual Users + Domains With Postfix, Courier + MySQL (+SMTP-AUTH, SpamA, ClamAV)

Hi,

I followed the Debian Sarge 3.1 howto and then the Postfix with virtual users and domains (except I didn't want quotas on mailboxes so I didn't recompile postfix in the second howto and left out the quota-related parts). I then tried to add squirrelmail. It doesn't work because I don't think the postfix install (with all these bells and whistles) works yet. Here are the errors I'm getting:

Quote:
Jan 22 21:02:43 hostname postfix/smtpd[5366]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Jan 22 21:02:43 hostname postfix/smtpd[5366]: sql_select option missing
Jan 22 21:02:43 hostname postfix/smtpd[5366]: auxpropfunc error no mechanism
I'm glad to post whichever config files people think might be related to these errors.

Also, I'd be pleased if someone could explain in detail a text-based method of testing the mail server's functionality. (I don't have an x-server installed so full-blown email clients like Thunderbird or Evolution are out; and there's too much that could go wrong with my squirrelmail install to rely on just that to know if it's working.) Thanks.
Reply With Quote
Sponsored Links
  #2  
Old 23rd January 2006, 19:09
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Please have a look at these threads:
http://www.howtoforge.com/forums/showthread.php?t=576
http://www.howtoforge.com/forums/showthread.php?t=2011
http://www.howtoforge.com/forums/showthread.php?t=861
__________________
Falko
--
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
  #3  
Old 8th February 2006, 06:12
brianwc brianwc is offline
Junior Member
 
Join Date: Jan 2006
Posts: 15
Thanks: 1
Thanked 1 Time in 1 Post
Default Found some errors

Hi,

I've read those threads now several times and still have some problems. However, some ideas in those threads produced what I hope are informative errors.

If I try:

Code:
# echo "test email" | mail user@yourdomain.com
I get the following in /var/log/mail.info

Code:
Feb  7 19:59:47 hostname postfix/virtual[5901]: fatal: mysql:/etc/postfix/mysql-virtual_mailboxes.cf: proxy map is not allowed for security sensitive data
Feb  7 19:59:48 hostname postfix/master[5851]: warning: process /usr/lib/postfix/virtual pid 5901 exit status 1
Feb  7 19:59:48 hostname postfix/master[5851]: warning: /usr/lib/postfix/virtual: bad command startup -- throttling
Feb  7 20:00:48 hostname postfix/virtual[5903]: fatal: mysql:/etc/postfix/mysql-virtual_mailboxes.cf: proxy map is not allowed for security sensitive data
Feb  7 20:00:49 hostname postfix/master[5851]: warning: process /usr/lib/postfix/virtual pid 5903 exit status 1
Feb  7 20:00:49 hostname postfix/master[5851]: warning: /usr/lib/postfix/virtual: bad command startup -- throttling
Also, when I try to login via the squirrelmail web interface, /var/log/mail.info shows:
Code:
Feb  7 19:54:08 hostname imaplogin: Connection, ip=[::ffff:127.0.0.1]
Feb  7 19:54:08 hostname imaplogin: chdir Maildir: No such file or directory
Do the above errors suggest where I could look for whatever is producing these constant errors:

Code:
Feb  7 18:02:40 hostname postfix/smtpd[4770]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Feb  7 18:02:40 hostname postfix/smtpd[4770]: sql_select option missing
Feb  7 18:02:40 hostname postfix/smtpd[4770]: auxpropfunc error no mechanism available
Thanks for any ideas. --Brian
Reply With Quote
  #4  
Old 8th February 2006, 11:41
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Your setup seems to differ slightly from the one in the tutorial...

Code:
Feb  7 19:59:47 hostname postfix/virtual[5901]: fatal: mysql:/etc/postfix/mysql-virtual_mailboxes.cf: proxy map is not allowed for security sensitive data
Can you remove all these
Code:
proxy:
strings in /etc/postfix/main.cf so that you have

Code:
virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailboxes.cf
instead of

Code:
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
, for example? Restart Postfix afterwards.
__________________
Falko
--
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
  #5  
Old 8th February 2006, 21:18
brianwc brianwc is offline
Junior Member
 
Join Date: Jan 2006
Posts: 15
Thanks: 1
Thanked 1 Time in 1 Post
Default A little better

Removing "proxy" from each mysql entry seems to have gotten rid of the "proxy map" errors I mentioned, and my test messages sent from the mail server itself are now visible in the /home/vmail/domainname/username/new directory. However, once I saw things looking better I also sent a message from my regular email client on another computer to that same address and it still hasn't appeared in that vmail directory and I haven't received the bounce either.

I also still get this error anytime I try to use squirrelmail to login to one of the email accounts:

Code:
Feb  8 11:11:21 hostname imaplogin: chdir Maildir: No such file or directory
and the actual web page comes back with: "ERROR:
ERROR : Connection dropped by imap-server."

It's as if courier or some part of this setup is not aware of the mysql setup and is trying to find a regular Maildir.

I also still get regular sasl errors (the same three notices in my earlier posts), so perhaps this is all an authentication issue of some sort.

Any thoughts on this?
Reply With Quote
  #6  
Old 8th February 2006, 23:20
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Quote:
Originally Posted by brianwc
However, once I saw things looking better I also sent a message from my regular email client on another computer to that same address and it still hasn't appeared in that vmail directory and I haven't received the bounce either.
Are you sure that the MX record of the recipient domain points to your Postfix-MySQL server? Please check.

Quote:
Originally Posted by brianwc
I also still get this error anytime I try to use squirrelmail to login to one of the email accounts:

Code:
Feb  8 11:11:21 hostname imaplogin: chdir Maildir: No such file or directory
and the actual web page comes back with: "ERROR:
ERROR : Connection dropped by imap-server."
Please send a mail first to the accounts in question so that Maildir can be created.

Quote:
Originally Posted by brianwc
I also still get regular sasl errors (the same three notices in my earlier posts), so perhaps this is all an authentication issue of some sort.
You should double-check all the configuration files, especially Courier is very finicky about the format of configuration files (white spaces, tabs, etc.).
Take special care about /etc/courier/authmysqlrc and /etc/pam.d/smtp.
__________________
Falko
--
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
Reply

Bookmarks

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 And MySQL (+ SMTP-AUTH, Quota... killfrog HOWTO-Related Questions 3 25th September 2009 22:45
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs ruskicar HOWTO-Related Questions 26 20th July 2007 17:28
Virtual Users And Domains With Postfix, Courier And MySQL triak HOWTO-Related Questions 5 23rd January 2006 21:20
Backup the Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Qu rogierbanis HOWTO-Related Questions 1 13th January 2006 10:34
Virtual Users And Domains With Postfix, Courier And MySQL: POP/IMAP authentication SeanG HOWTO-Related Questions 3 1st January 2006 18:08


All times are GMT +2. The time now is 12:06.


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