Package: postfix-mysql Version: 2.11.3-1 Severity: normal Dear Maintainer,
I attempted to implement all queries that my postfix install asks the database as stored procedures in MySQL. Unfortunately, I often get the common "Commands out of sync" error that I believe comes from Postfix's mysql driver when query results are not handled appropriately. The code for the stored procedure is as follows: SELECT `va`.`dst_email` FROM `virtual_aliases` AS `va` WHERE `va`.`src_email` = src_email And the query is set in mysql-virtual_alias_maps.cf as this: [...] query = CALL `get_alias('%s')` I thoroughly tested the routine, it does not seem to be the source of the problem. The log looks like this afterwards: Aug 3 13:48:08 merlin postfix/smtpd[10872]: warning: mysql query failed: Commands out of sync; you can't run this command now I was able to implement some routines as functions; but some need to return result-sets. Then stored procedures need to be used and problems arise. Otherwise the package is really great and does its job perfectly. Thanks for maintenance and development efforts! -- System Information: Debian Release: 8.1 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 3.16.0-4-amd64 (SMP w/1 CPU core) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages postfix-mysql depends on: ii libc6 2.19-18 ii libmysqlclient18 5.5.44-0+deb8u1 ii postfix 2.11.3-1 postfix-mysql recommends no packages. postfix-mysql suggests no packages. -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org