Virtual Users + Domains With Postfix, Courier + MySQL (+SMTP-AUTH, SpamA, ClamAV)

Discussion in 'HOWTO-Related Questions' started by brianwc, Jan 23, 2006.

  1. brianwc

    brianwc New Member

    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:

    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.
     
  2. falko

    falko Super Moderator Howtoforge Staff

  3. brianwc

    brianwc New Member

    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 [email protected]
    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
     
  4. falko

    falko Super Moderator Howtoforge Staff

    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.
     
  5. brianwc

    brianwc New Member

    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?
     
  6. falko

    falko Super Moderator Howtoforge Staff

    Are you sure that the MX record of the recipient domain points to your Postfix-MySQL server? Please check.

    Please send a mail first to the accounts in question so that Maildir can be created.

    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.
     
  7. Leutenant

    Leutenant New Member

    just type (when in your home directory) sudo chown "your.user" Maildir/

    Also rember to make the tmp/ and cur/ and new/ directory inside Maildir/ if not allready there!

    -Leutenant
     

Share This Page