[SOLVED] Postfix User lookup is bad

Jonathan_Frias · 06-09-2012, 01:25 PM

I'm setting up a mail server following the directions at: http://flurdy.com/docs/postfix/

Currently I can send messages through squirrelmail, but I cannot recieve messages. If I message myself I receive this error:

Code:

This is the mail system at host server.example.com.

I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.

For further assistance, please send mail to postmaster.

If you do so, please include this problem report. You can
delete your own text from the attached returned message.

                  The mail system

<jonathan@xxx.com>: unknown user: "jonathan"

Final-Recipient: rfc822; jonathan@xxx.com
Original-Recipient: rfc822;jonathan@xxx.com
Action: failed
Status: 5.1.1
Diagnostic-Code: X-Postfix; unknown user: "jonathan"

I checked mysql and there is a record for my 'jonathan@xxx.com'

Here is my mysql output for the user.

Code:

+----------------------+----------+------+------+-------------------------+-----------+---------+-----------------+----------+---------------+-------+------------+----------------+
| id                   | name     | uid  | gid  | home                    | maildir   | enabled | change_password | clear    | crypt         | quota | procmailrc | spamassassinrc |
+----------------------+----------+------+------+-------------------------+-----------+---------+-----------------+----------+---------------+-------+------------+----------------+
| jonathan@xxx.com     | jonathan | 5000 | 5000 | /var/spool/mail/virtual | jonathan/ |       1 |               1 | ChangeMe | encrypted-password. |       |            |                |
+----------------------+----------+------+------+-------------------------+-----------+---------+-----------------+----------+---------------+-------+------------+----------------+

Noway2 · 06-10-2012, 07:17 AM

This looks like an issue with your mysql_mailbox.cf. Note that your id is @jonathan@xxx.com, consisting of the username at domain. The flurdy howto, however, lists the where field as id. This will result in queries like (this is just an example, I am not sure what query Postfix runs):

Code:

usemaildb;
select * from users where id = '<data to look for>';

If the query doesn't match, you will get an unknown user. In your case, jonathan is not matching jonathan@xxx.com.

My setup is slightly different than yours.

Code:

| username    | password           | name       | maildir          | quota | domain      
 me@mydomain  | hashed password    | my name    | username@domain/ |     0 | my domain

and my wherefield is the username, which will match the user@domain.

If your problem is LIMITED to just squirrelmail, then I would suggest you look in the squirrelmail configuration and see if there is a setting for this. It has been too long since I set this up and can't remember. It may be that squirrelmail simply relies on your POP/IMAP, so you may need to adjust or look at the select fields in your POP/IMAP configuration.

Jonathan_Frias · 06-10-2012, 07:50 AM

Contents of /etc/postfix/mysql_mailbox.cf:

Code:

user=mail
password=mysql-password
dbname=maildb
table=users
select_field=maildir
where_field=id
hosts=127.0.0.1
additional_conditions = and enabled = 1

I can login with the above information to mysql. All of this looks correct to me.

Is there a way that I can try specifying the a raw query like you suggested?

Update, I wanted to upload this telnet log.

Code:

$ telnet localhost 25
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
220 xxx.com ESMTP Postfix
ehlo xxx.com
250-xxx.com
250-PIPELINING
250-SIZE 10240000
250-ETRN
250-STARTTLS
250-ENHANCEDSTATUSCODES
250-8BITMIME
250 DSN
mail from: test@xxx.com
250 2.1.0 Ok
rcpt to: jonathan@xxx.com
250 2.1.5 Ok
data
354 End data with <CR><LF>.<CR><LF>
sadf
sd
f
sdf
sdf
.
250 2.0.0 Ok: queued as A1676204E7
quit
221 2.0.0 Bye
Connection closed by foreign host.

Noway2 · 06-11-2012, 04:23 AM

Interesting. So Postfix performs the proper lookup, but if you try to send via squirrelmail it bounces. In all honesty, I should have thought of this yesterday, but what is the error message that is showing up in your email log file? Lets confirm what is happening as it looks like squirelmail is dropping the domain part which is required. I also remembered that when I configured Squirrelmail on my system, I had to play around with the settings (run conf.pl) for a while before it worked and I think I ended up using the "sendmail" option which uses Postfix's built in sendmail compatibility.

Jonathan_Frias · 06-13-2012, 08:23 AM

The issue was receiving messages. I can send just fine.

However ultimately I scrapped the server with a fresh install and followed these instructions. It seems they are a little more geared towards what I'm working with:
http://www.howtoforge.com/perfect-se...ot-ispconfig-3

Sending/receiving is working now, which I am very happy about.

This is what I'm facing now, if you're still interested:
http://www.linuxquestions.org/questi...al-4175411084/