Article ID: 5903, created on Mar 9, 2009, last review on Apr 25, 2014

  • Applies to:
  • Plesk 9.0 for Linux/Unix

Symptômes

Les erreurs ci-dessous s'affichent dans les logs si vous essayez d'envoyer le mail avec l'autorisation.

/var/log/messages
-----
Nov 15 12:44:12 servername postfix/smtpd[23804]: sql_sqlite3 plugin prepare SQL statement for query 'SELECT `cmusaslsecretPLAIN` FROM domains d, users u WHERE u.name='admin' and d.name='domain.tld' and d.status=0 and u.status=0 and u.dom_id=d.id;' error: unrecognized token: "`"
-----

/usr/local/psa/var/log/maillog
-----
Nov 15 19:35:00 servername postfix/smtpd[24559]: connect from unknown[10.57.1.25]
Nov 15 19:35:01 servername plesk_saslauthd[24561]: listen=6, status=5, dbpath='/plesk/passwd.db', chroot=1, unprivileged=1
Nov 15 19:35:01 servername plesk_saslauthd[24561]: privileges set to (89:89) (effective 89:89)
Nov 15 13:35:01servername plesk_saslauthd[24561]: main cycle started
Nov 15 13:35:01servername plesk_saslauthd[24561]: main cycle iteration
Nov 15 13:35:01 servername plesk_saslauthd[24561]: activity on 1 channel(s)
Nov 15 13:35:01 servername postfix/smtpd[24559]: warning: SASL authentication failure: size read failed
Nov 15 13:35:01 servername postfix/smtpd[24559]: warning: SASL authentication failure: Password verification failed
Nov 15 13:35:01 servername postfix/smtpd[24559]: warning: unknown[10.57.1.25]: SASL PLAIN authentication failed
Nov 15 13:35:01 servername postfix/smtpd[24559]: lost connection after AUTH from unknown[10.57.1.25]
Nov 15 13:35:01servername postfix/smtpd[24559]: disconnect from unknown[10.57.1.25]
Nov 15 13:35:01 servername plesk_saslauthd[24561]: server fatal error: accept: Invalid argument
Nov 15 19:35:01servername postfix/master[9993]: warning: process /usr/libexec/postfix/plesk_saslauthd pid 24561 exit status 1
Nov 15 19:35:01 servername postfix/master[9993]: warning: /usr/libexec/postfix/plesk_saslauthd: bad command startup -- throttling

-----

Résolution

Ce problème est causé par SQLite3 - version <= 3.2.x.
Vous devez mettre à niveau SQLite3 vers la version 3.3.0 ou ultérieure pour résoudre le problème.

Le problème persiste pour Parallels Plesk Panel 9.0.0 et sera réglé dans le prochain patch.

Informations supplémentaires

Ce problème affecte la plupart du temps les OS CentOS4 et RedHatel4 qui sont envoyés avec SQLite3 version 3.2

4f57df935e9acf8d18830757d2346419 a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 6ef0db7f1685482449634a455d77d3f4 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF