Postfix generates a error after Plesk 11 upgrade

[EdwardDekker]

Into my messages log do i see this error after a upgrade of Plesk 11.

Jun 29 11:30:01 serverhost postfix/smtpd[23126]: SQL engine 'intentionally disabled' not supported
Jun 29 11:30:01 serverhost postfix/smtpd[23126]: auxpropfunc error no mechanism available

How could i correct this?

 

[Nikolay.]

As the error message suggests there is no real error and it does not affect mail subsystem.

Plesk 11 uses its own SASL auxprop plugin. Previously used 'sql' plugin is not used anymore, but still present in the system. Unfortunately, both 'sql' plugin and libsasl implementation used in Postfix seem to have bugs. The first one doesn't allow configuration in which it will be simply disabled (and will not emit error messages). The second one has two issues. The first problem is that logging level setup for plugins is not working. The second problem is that a number of default plugins (including 'sql') is always loaded, even if they are not listed in configuration. Combination of these problems results in such error messages.

You could try to "fix" your problem by removing 'sql' SASL auxprop plugin from the system. But I, personally, would not, since I'm not sure of possible adverse effects (at least without testing it first).

P.S. You probably should have posted this thread in Plesk 11 forum section.

 

[RenéJ]

Hi Guys,

I am gettings exact the same errors, plus a 3rd one:

Jul 8 10:15:57 alpha postfix/smtpd[4653]: SQL engine 'intentionally disabled' not supported
Jul 8 10:15:57 alpha postfix/smtpd[4653]: auxpropfunc error no mechanism available
Jul 8 10:15:57 alpha postfix/smtpd[4653]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sqlite

 

[Và ctor JoséV]

Error when I send a message

I can´t send a message but I can receive it. I have the same error in /var/log/messages.....

 

[Cheech]

Hi ,

i had the same issue and i fixed it in this way:

1. Search for smtp.conf: result on my Debian Squeeze System: /usr/lib/sasl2/smtpd.conf and /etc/postfix/sasl/smtpd.conf
2. renamed the /usr/lib/sasl2/smtpd.conf to /usr/lib/sasl2/smtpd.old
3. restart Postfix with /etc/init.d/postfix restart

Now all SQLite error messages are gone and Postfix is still working fine.

Looks like Postfix can only work with one smtp.conf

I tried also to copy the /etc/postfix/sasl/smtpd.conf to /etc/postfix/sasl/smtpd.conf but this was not working.

regards
Cheech

 

[Michael Pöllinger]

Same error here on CentOS 5.8. but without sqlite line

Aug 12 04:59:01 wds70016 postfix/smtpd[12000]: SQL engine 'intentionally disabled' not supported
Aug 12 04:59:01 wds70016 postfix/smtpd[12000]: auxpropfunc error no mechanism available

cat /usr/lib64/sasl2/smtpd.conf

pwcheck_method: saslauthd
mech_list: plain login
saslauthd_version: 2

cat /usr/lib64/sasl2/smtpd.conf

pwcheck_method: auxprop saslauthd
auxprop_plugin: plesk
saslauthd_path: /var/spool/postfix/private/plesk_saslauthd
mech_list: DIGEST-MD5 CRAM-MD5 PLAIN LOGIN
auto_transition: yes
sql_engine: intentionally disabled
log_level: 4

Everything worked fine before updated from Plesk 10 to 11





Some infos i just googled:
MySQL support isn´t installed in postfix per base-repo
To install postfix with mysql support it must be taken from centosplus-repo

yum info postfix
[...]
Installed Packages
Name : postfix
Arch : x86_64
Epoch : 2
Version : 2.8.4
Release : 12052415
Size : 12 M
Repo : installed
Summary : Postfix Mail Transport Agent
License : IBM Public License
Description: Postfix is a Mail Transport Agent (MTA), supporting LDAP, SMTP AUTH (SASL),
: TLS

With MySQL found here:

http://rpmfind.net/linux/RPM/centos...tfix-2.3.3-2.3.centos.mysql_pgsql.x86_64.html

Could someone from parallels give us a recommendation / tip what has been changed and perhaps how we can resolve it?

kind regards
Michael

 

[Michael Pöllinger]

Reposted under Plesk 11 : http://forum.parallels.com/showthread.php?p=636138

Further discussion should be posted there?