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

[Anders Norrbring]

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=< 
> 20060907165127.770E178A2D at mail.xxxxx.com 
> <mailto:20060907165127.770E178A2D at mail.xxxxx.com>>
> Sep  7 12:51:33 cs-101 postfix/qmgr[28682]: 770E178A2D: 
> from=<bruce at yyyyyy.com <mailto: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 <mailto:test at mail.xxxxxx.com>>, 
> orig_to=<test at xxxxxx.com <mailto: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?
> 

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 test at blah.bla, 
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 test at blah.bla.

Then the "real" mail account that Cyrus would see should look like 
bb0001 at domain.com (domain.com being your primary one).

So, Postfix recieves a mail for test at blah.bla, looks in the 
virtual_alias_map and gets to know that the mailbox should be 
'bb0001 at domain.com'.

So, when Postfix sends the mail on to Cyrus via LMTP, it sends it to 
'bb0001 at domain.com'.

Your postfix tries to send it to test at blah.bla 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* <lists at norrbring.se 
> <mailto: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.
> 
>