| View previous topic :: View next topic |
| Author |
Message |
fosstux
Apprentice
Joined: 01 Oct 2002
Posts: 274
Location: Vienna, Austria
|
 Posted: Thu Mar 18, 2004 4:14 am Post subject: SOLVED: Problems with postfix / SASL |
 |
|
Hi!
I've got two big problems.
The first is that all mail I should received is being rejected. I get the following error:
| Code: | Mar 18 04:58:15 obelix postfix/smtpd[15291]: starting TLS engine
Mar 18 04:58:15 obelix postfix/smtpd[15291]: connect from axfr.key-systems.net[81.3.43.252]
Mar 18 04:58:16 obelix postfix/smtpd[15291]: 126395950: client=axfr.key-systems.net[81.3.43.252]
Mar 18 04:58:16 obelix postfix/smtpd[15291]: 126395950: reject: RCPT from axfr.key-systems.net[81.3.43.252]: 450 <crp@crparr.net>: User unknown in local recipient table; from=<afterward@cyberfreak.com> to=<crp@crparr.net> proto=SMTP helo=<axfr.key-systems.net>
Mar 18 04:58:17 obelix postfix/smtpd[15291]: disconnect from axfr.key-systems.net[81.3.43.252] |
But the user crp@crparr.net exists in the users table.
What's wrong?
Second I can't login to postfix via sasl. I get the following error: | Code: | Mar 18 04:49:06 obelix saslauthd[15120]: Unknown column 'Password' in 'field list'
Mar 18 04:49:06 obelix saslauthd[15120]: Unknown column 'Password' in 'field list'
Mar 18 04:49:06 obelix saslauthd[15120]: DEBUG: auth_pam: pam_authenticate failed: Authentication failure
Mar 18 04:49:06 obelix saslauthd[15120]: do_auth : auth failure: [user=crp] [service=smtp] [realm=crparr.net] [mech=pam] [reason=PAM auth error]
Mar 18 04:49:06 obelix postfix/smtpd[14826]: warning: SASL authentication failure: Password verification failed
Mar 18 04:49:06 obelix postfix/smtpd[14826]: warning: unknown[192.168.1.3]: SASL PLAIN authentication failed
Mar 18 04:49:07 obelix saslauthd[15121]: Unknown column 'Password' in 'field list'
Mar 18 04:49:07 obelix saslauthd[15121]: Unknown column 'Password' in 'field list'
Mar 18 04:49:07 obelix saslauthd[15121]: DEBUG: auth_pam: pam_authenticate failed: Authentication failure
Mar 18 04:49:07 obelix saslauthd[15121]: do_auth : auth failure: [user=crp] [service=smtp] [realm=crparr.net] [mech=pam] [reason=PAM auth error] |
What's wrong here?
Please help! It's urgent.
Thanks
PS:I'm not receiving any mail at the moment !!!!!
_________________
Windows = a 64 bit rewrite for a 32 bit extension to a 16 bit GUI on an
8 bit OS written for a 4 bit architecture by a 2 bit company who can't
stand 1 bit of competition.
Last edited by fosstux on Fri Mar 19, 2004 10:00 am; edited 1 time in total |
|
| Back to top |
|
 |
KingTaco
Developer
Joined: 22 Aug 2003
Posts: 207
Location: Bay Area, CA
|
| Posted: Thu Mar 18, 2004 3:09 pm Post subject: |
|
|
you are using mysql with postfix, are you not? It seems that you didn't set the table up properly, try to go back and look for typos. remember, this is all case sensitive, some make sure to look for that as well.
_________________
Explaining the obvious to the oblivious.
Adopt an unanswered post today -- https://forums.gentoo.org/search.php?search_id=unanswered |
|
| Back to top |
|
|
fosstux
Apprentice
Joined: 01 Oct 2002
Posts: 274
Location: Vienna, Austria
|
| Posted: Thu Mar 18, 2004 6:37 pm Post subject: |
|
|
I've just now checked my config files. Everything seems to be ok. BUT I nevertheless cannot login to postfix. Courier is working fine!
I now get the following errors:
| Code: | Mar 18 19:27:18 obelix saslauthd[1446]: Unknown column 'Password' in 'field list'
Mar 18 19:27:18 obelix saslauthd[1446]: DEBUG: auth_pam: pam_authenticate failed: Permission denied
Mar 18 19:27:18 obelix saslauthd[1446]: do_auth : auth failure: [user=crp] [service=smtp] [realm=crparr.net] [mech=pam] [reason=PAM auth error] |
What's permissions should be set for PAM?
EDIT: Somehow Postfix only uses the first part of my email adress to authenticate. But in my database I have the complete email adress.
Please help.
_________________
Windows = a 64 bit rewrite for a 32 bit extension to a 16 bit GUI on an
8 bit OS written for a 4 bit architecture by a 2 bit company who can't
stand 1 bit of competition. |
|
| Back to top |
|
|
KingTaco
Developer
Joined: 22 Aug 2003
Posts: 207
Location: Bay Area, CA
|
| Posted: Thu Mar 18, 2004 7:33 pm Post subject: |
|
|
not so much the config files, but the table definition in mysql
| Quote: | | Mar 18 19:27:18 obelix saslauthd[1446]: Unknown column 'Password' in 'field list' |
means that it cant find that field in the database.
_________________
Explaining the obvious to the oblivious.
Adopt an unanswered post today -- https://forums.gentoo.org/search.php?search_id=unanswered |
|
| Back to top |
|
|
fosstux
Apprentice
Joined: 01 Oct 2002
Posts: 274
Location: Vienna, Austria
|
| Posted: Thu Mar 18, 2004 11:39 pm Post subject: |
|
|
Ok. So now the Error with the field password is fixed. I renamed the field clear to Password.
But: I have at the moment turned logging on at my mysql server. I discovered that Postfix tries to authenticate with sasl using only the part in front of the @ as adress.
| Code: | WRONG: SELECT Password FROM users WHERE email='parta'
SHOULD BE: SELECT Password FROM users WHERE email='parta@partb.tld' |
The authentification for courier is correct!
Please help. Thanks
_________________
Windows = a 64 bit rewrite for a 32 bit extension to a 16 bit GUI on an
8 bit OS written for a 4 bit architecture by a 2 bit company who can't
stand 1 bit of competition. |
|
| Back to top |
|
|
fosstux
Apprentice
Joined: 01 Oct 2002
Posts: 274
Location: Vienna, Austria
|
| Posted: Fri Mar 19, 2004 12:35 am Post subject: |
|
|
I can now send mail. I solved this by adding another user, but entering only the part 1 of my email adress (befor the @).
But I still cannot fet the relay working.
Any Ideas?
_________________
Windows = a 64 bit rewrite for a 32 bit extension to a 16 bit GUI on an
8 bit OS written for a 4 bit architecture by a 2 bit company who can't
stand 1 bit of competition. |
|
| Back to top |
|
|
fosstux
Apprentice
Joined: 01 Oct 2002
Posts: 274
Location: Vienna, Austria
|
| Posted: Fri Mar 19, 2004 9:59 am Post subject: |
|
|
Problem is solved. I discovered that I need to put something into the virtual table even for a local domain.
_________________
Windows = a 64 bit rewrite for a 32 bit extension to a 16 bit GUI on an
8 bit OS written for a 4 bit architecture by a 2 bit company who can't
stand 1 bit of competition. |
|
| Back to top |
|
|
|
Networking & Security
