On 1/28/2010 4:12 PM, Serge Fonville wrote:
>>>> I using virtual_alias_maps with mysql for storage. Working fine.
>>>>
>>>> Does anyone have a suggestion on how to update a timestamp field in the
>>>> mysql table when postfix finds a virtual_alias_maps match?
>>>>
>>>> I'm looking for a way to measure alias usage and cull unused aliases.
>>>>
>>>>
>>> Have you considered a stored procedure?
>>>
>>>
>> Stored procedures do not work in Postfix without code changes because
>> the |CLIENT_MULTI_RESULTS connect flag, for MySQL API, is not turned on.
>>
> From the manual:
> http://dev.mysql.com/doc/refman/5.0/en/mysql-real-connect.html
> CLIENT_MULTI_RESULTS
>
>
[...]
> If your program uses CALL statements to execute stored procedures, the
> CLIENT_MULTI_RESULTS flag must be enabled.
>
Reread this ^^^.
