Peter, Try things one step at a time.
If dbmail-users complains about connecting to mysql, there's NO way you should even think about postfix yet. 'dbmail-users -l' should not complain, period. If it does, your dbmail.conf is not correct. It sounds to me like you're new to mysql, new to postfix, and new to dbmail, and confusing issues to boot. 1) add a user 'dbmail' to mysql which has full permissions on the dbmail database. Something like 'GRANT ALL ON dbmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'somepassword'. 2) Make sure you can connect to the dbmail database in mysql using that user/password combo: mysql -u dbmail -psomepassword dbmail 3) edit dbmail.conf to make sure the user=, pass=, and db= settings are correct. 4) do 'dbmail-users -l'. If that doesn't work go back to 3) 5) add a dbmail user by running dbmail-users -a testuser -w testpassword 6) try inserting a simple message into the INBOX of that user: cat >> testmessage.eml << EOF From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: test test EOF cat testmessage.eml | dbmail-smtp -u testuser check the database make sure the message is there in the dbmail_messageblks table Once you make sure all this works as expected, move forward to setting up some real dbmail users with email aliases, and try to hook up your MTA (postfix). If you do suspect there's a problem with dbmail, try setting the TRACE_LEVEL to 5, and start eyeballing the syslog. Jim Douglas wrote: >> From: Micah Stevens <[EMAIL PROTECTED]> >> Reply-To: DBMail mailinglist <[email protected]> >> To: DBMail mailinglist <[email protected]> >> Subject: Re: [Dbmail] Receiving mail >> Date: Fri, 10 Mar 2006 14:37:12 -0800 >> >> On Friday 10 March 2006 2:29 pm, Jim Douglas wrote: >> > Mar 10 17:18:09 cpe-66-65-161-178 postfix/smtpd[9236]: NOQUEUE: reject: >> > RCPT from web42207.mail.yahoo.com[66.218.93.208]: 550 >> <[EMAIL PROTECTED]>: >> > Recipient address rejected: User unknown in local recipient table; >> > from=<[EMAIL PROTECTED]> to=<[EMAIL PROTECTED]>.. >> > >> > I added added xyxyxy.org to mydestination for dbmail and postfix is not >> > connecting to the database. >> >> This means exactly what it says, user was not found in the local >> recipient >> table, it has nothing to do with mydestination. >> >> -Micah >> _______________________________________________ >> Dbmail mailing list >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > I tried quite a few configuration changes before backtracking and > finding that the dbmail-users command had a problem.... > > User unknown in local recipient table; from=<[EMAIL PROTECTED]> > to=<[EMAIL PROTECTED]> proto=SMTP helo=<web42202.mail.yahoo.com> > Mar 10 22:39:21 cpe-66-65-161-178 postfix/smtpd[8103]: disconnect from > web42202.mail.yahoo.com[66.218.93.203] > Mar 10 22:39:36 cpe-66-65-161-178 dbmail/adduser[8109]: > dbmysql.c,db_connect: mysql_real_connect failed: Access denied for user > 'root'@'localhost' (using password: NO) > > > this was the command, > dbmail-users -a jim -w password -g 0 -m 25M -s [EMAIL PROTECTED] > Why does it say access denied for 'root' when the adduser command is > adding a user 'jim'? > > I also re-created the MySql tables... > > Peter > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
