i have followed the Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV) to a tee (geez, ive gone over it 5 times -- i sure hope i have). i had to update my .cf files because i am running postfix 2.2.4 but still am receiving an "unknown user" error.
i am not sure what all info would be necessary to troubleshoot this but i am including my mysql-virtual_mailboxes.cf file as a starting point:
Code:
user = mail_admin
password = p0stf1x_#dm!n
dbname = mail
query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email='%s'
hosts = 127.0.0.1
error in /var/log/mail.log
Code:
Jan 11 22:10:44 plink postfix/local[19703]: 254F8E4270: to=<jason@plink.worthen.org>, relay=local, delay=0, status=bounced (unknown user: "jason")
additionally, here is a select from MySQL:
Code:
+-------------------------+---------------+----------+
| email | password | quota |
+-------------------------+---------------+----------+
| jason@plink.worthen.org | ZBAdWFDgD4AbM | 10485760 |
+-------------------------+---------------+----------+
Code:
+-------------------+
| domain |
+-------------------+
| plink.worthen.org |
+-------------------+