Bruce Pennypacker skrev:
I checked all the mysql settings in /etc/postfix/main.cf and they look correct. Here are the relevant entries:

mydestination = $myhostname, localhost.$mydomain, localhost, xxxxxx.com <http://xxxxxx.com> , mysql:/etc/postfix/mysql-mydestination.cf <http://mydestination.cf>
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual.cf <http://virtual.cf>
sender_canonical_maps = mysql:/etc/postfix/mysql- canonical.cf <http://canonical.cf>

Each of those mysql-*.cf files are set up the same as the ones shown at http://www.delouw.ch/linux/Postfix-Cyrus-Web-cyradm-HOWTO/html/postfix-config.html <http://www.delouw.ch/linux/Postfix-Cyrus-Web-cyradm-HOWTO/html/postfix-config.html> and I have verified that the username, password, tablename, etc. are all set properly and work.

Here's part of my maillog that shows the problem:

Sep 7 12:50:57 cs-101 postfix/smtpd[28706]: connect from unknown[ 1.2.3.4 <http://1.2.3.4>] Sep 7 12:51:27 cs-101 postfix/smtpd[28706]: 770E178A2D: client=unknown[1.2.3.4 <http://1.2.3.4>] Sep 7 12:51:33 cs-101 postfix/cleanup[28715]: 770E178A2D: message-id=< [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> Sep 7 12:51:33 cs-101 postfix/qmgr[28682]: 770E178A2D: from=<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>, size=407, nrcpt=1 (queue active)
Sep  7 12:51:33 cs-101 lmtpunix[28338]: accepted connection
Sep  7 12:51:33 cs-101 lmtpunix[28338]: lmtp connection preauth'd as postman
Sep 7 12:51:33 cs-101 master[28721]: about to exec /usr/lib/cyrus-imapd/lmtpd Sep 7 12:51:33 cs-101 lmtpunix[28338]: verify_user(user.test) failed: Mailbox does not exist
Sep  7 12:51:33 cs-101 lmtpunix[28721]: executed
Sep 7 12:51:33 cs-101 postfix/lmtp[28720]: 770E178A2D: to=< [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>, orig_to=<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>, relay=mail.mad-caster.com[/var/lib/imap/socket/lmtp], delay=19, delays=19/0.01/0.01/0.01, dsn=5.1.1, status=bounced (host mail.xxxxxx.com[/var/lib/imap/socket/lmtp] said: 550-Mailbox unknown. Either there is no mailbox associated with this 550-name or you do not have authorization to see it. 550 5.1.1 User unknown (in reply to RCPT TO command)
)

Is there any way of verifying whether or not postfix is reading from mysql properly? Should I be seeing cyrus create user directories under /var/spool/imap or does the mail itself get store in mysql as well?


Sponanteously, I'd say that Postfix can't contact MySQL after all... The format Web-Cyradm stores mailboxes and accounts in doesn't look that way.

Judging from your log, postfix tries to send a message to [EMAIL PROTECTED], but when you create a domain in web-cyradm, you're asked for a prefix to use.

Lets say that I set up a domain named blah.bla, I enter the prefix 'bb' then an e-mail account [EMAIL PROTECTED]

Then the "real" mail account that Cyrus would see should look like [EMAIL PROTECTED] (domain.com being your primary one).

So, Postfix recieves a mail for [EMAIL PROTECTED], looks in the virtual_alias_map and gets to know that the mailbox should be '[EMAIL PROTECTED]'.

So, when Postfix sends the mail on to Cyrus via LMTP, it sends it to '[EMAIL PROTECTED]'.

Your postfix tries to send it to [EMAIL PROTECTED] which isn't correct.

I'd say the error is in the SQL lookup. Have you installed pam_mysql and also edited your /etc/pam.d/smtp /etc/pam.d/pop3 /etc/pam.d/imap files according to http://www.delouw.ch/linux/Postfix-Cyrus-Web-cyradm-HOWTO/html/pam-config.html

Anders.


-Bruce


On 9/7/06, *Anders Norrbring* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

    Bruce Pennypacker skrev:
     > I've been working on setting up web-cyradm on a new centos-4.3 linux
     > server.  The last problem I had was a mismatch in my cyrus IMAP
     > passwords which I've now fixed.  I can successfully add a domain and
     > create users within web-cyradm but it appears that something isn't
     > working right.  If I telnet to port 25 of my mail server and try to
     > submit a test e-mail I end up getting a 550 "User unknown" bounce
    back.
     > If I look in /var/spool/imap I don't see a directory being
    created for
     > the user I added through web-cyradm.  Shouldn't I be seeing a
    directory
     > there since that's where cyrus stores mail?  I'm not seeing any
    other
     > errors in my syslog or maillog when I create test accounts in
     > web-cyradmin.  Where else should I look?


    Your MTA (Postfix, qmail..) doesn't seem to be able to read the account
    data from the SQL database where web-cyradm stores account info.


_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch

_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm

Reply via email to