Mail problems after upgrade

[skysel]

Hello all, I installed RC5 and looked well except for the mail system. It broke down:

Code:

Jun 18 21:27:23 hwcol01-002 postfix/master[5147]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
Jun 18 21:28:23 hwcol01-002 postfix/smtpd[5216]: warning: xsasl_cyrus_server_get_mechanism_list: no applicable SASL mechanisms
Jun 18 21:28:23 hwcol01-002 postfix/smtpd[5216]: fatal: no SASL authentication mechanisms

Does the update do something to the postfix files? I also did apt-get update/upgrade. I also checked file dates on config files, they weren't change since mailsystem was working perfectly. Which is pretty odd for me.

Here is smtpd.conf from /etc/postfix/sasl/:

Code:

pwcheck_method: saslauthd auxprop
auxprop_plugin: sql
mech_list: sql plain login
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: root
sql_passwd: sqlPwd3#
sql_database: ispcp
sql_select: select mail_pass from mail_users as a,domain as b where b.domain_name='%r' and (mail_acc='%u' and a.domain_id=b.d$
sql_verbose: yes
log_level: 5

and here is postconf -n:

Code:

alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_at_myorigin = yes
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/lib/postfix
inet_interfaces = all
local_destination_recipient_limit = 1
local_recipient_maps = unix:passwd.byname $alias_database
local_transport = local
mail_spool_directory = /var/mail
mailbox_command = procmail -a "$EXTENSION"
mailbox_size_limit = 0
mydestination = $myhostname, $mydomain
mydomain = hosting-works.nl.local
myhostname = hosting-works.nl
mynetworks_style = host
myorigin = $myhostname
recipient_delimiter = +
setgid_group = postdrop
smtpd_banner = $myhostname ESMTP ispCP 1.0.0 RC4 OMEGA Managed
smtpd_data_restrictions = reject_multi_recipient_bounce,                               reject_unauth_pipelining
smtpd_helo_required = yes
smtpd_helo_restrictions = permit_mynetworks,                               permit_sasl_authenticated,                               reject_invalid_helo_hostname,                               reject_non_fqdn_helo_hostname
smtpd_recipient_restrictions = reject_non_fqdn_recipient,                               reject_unknown_recipient_domain,                               permit_mynetworks,                               permit_sasl_authenticated,                               reject_unauth_destination,                               reject_unlisted_recipient,                               check_policy_service inet:127.0.0.1:12525,                               check_policy_service inet:127.0.0.1:60000,                               permit
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain =
smtpd_sasl_security_options = noanonymous, noplaintext
smtpd_sender_restrictions = reject_non_fqdn_sender,                               reject_unknown_sender_domain,                               permit_mynetworks,                               permit_sasl_authenticated
transport_maps = hash:/etc/postfix/ispcp/transport
virtual_alias_maps = hash:/etc/postfix/ispcp/aliases
virtual_gid_maps = static:8
virtual_mailbox_base = /var/mail/virtual
virtual_mailbox_domains = hash:/etc/postfix/ispcp/domains
virtual_mailbox_limit = 0
virtual_mailbox_maps = hash:/etc/postfix/ispcp/mailboxes
virtual_minimum_uid = 1001
virtual_transport = virtual
virtual_uid_maps = static:1001

I would be more than glad if anyone can tell me what the heck is going on

[Quemeros]

Why your smtpd_banner continues saying "RC4"? That is normal? :?

[skysel]

Quemeros Wrote:Why your smtpd_banner continues saying "RC4"? That is normal? :?

I think that's not relevant But nice notice. Donno why it says RC4, when it's RC5..

[skysel]

so..anyone?

[skysel]

*bump*

[motokochan]

Well, let's work on the errors one by one.

On at least the first error, it usually indicates Postfix can't load the aliases list. Try issuing the "newaliases" command. After that stop and start postfix (don't do a reload) and then try to flush your queue. See if that error continues.

[kilburn]

Code:

...
mech_list: sql plain login
...

mech_list specifies the user/password transmission mechanisms available, not the checking methods. "sql" is NOT a valid mechanism, so you should remove it from here.

Code:

...
smtpd_sasl_security_options = noanonymous, noplaintext
...

You MUST use plain text passwords with the current SASL setup (Postfix docs on SASL), so this should be:

Code:

...
smtpd_sasl_security_options = noanonymous
...

Try changing those things and tell us if it works