[Web-cyradm] Creating new accounts seems to work but doesn't

[Bruce Pennypacker]

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,
mysql:/etc/postfix/mysql-mydestination.cf
virtual_alias_maps = mysql:/etc/postfix/mysql-virtual.cf
sender_canonical_maps = mysql:/etc/postfix/mysql-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.htmland
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]
Sep  7 12:51:27 cs-101 postfix/smtpd[28706]: 770E178A2D: client=unknown[
1.2.3.4]
Sep  7 12:51:33 cs-101 postfix/cleanup[28715]: 770E178A2D: message-id=<
20060907165127.770E178A2D at mail.xxxxx.com>
Sep  7 12:51:33 cs-101 postfix/qmgr[28682]: 770E178A2D: from=<
bruce at yyyyyy.com>, 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=<
test at mail.xxxxxx.com>, orig_to=<test at xxxxxx.com>,
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?

-Bruce


On 9/7/06, Anders Norrbring <lists at norrbring.se> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://fix.bitheads.ch/pipermail/web-cyradm/attachments/20060907/b5dd3155/attachment.html