Re: [exim] Using MySQL Stored Procedures in Exim

* on the Fri, Feb 02, 2007 at 02:27:24PM -0800, Mark Moseley wrote:

> Nobody bit, so I thought I'd post an answer to my own question ;)
> So far so good. I've been running a couple of high volume servers with that
> change for a month or so and recently switched all of our other mail servers
> to it about a week ago. I haven't seen any side effects yet, though that's
> without actually running any stored procedures. I've been running a couple
> of servers for about a week now with a config that uses stored procedures
> and haven't seen any side effect there either. I'll post more results after
> more testing. It's pretty darn cool so far though.
>
> If anybody's doing anything similar with Exim and MySQL+stored procedures,
> I'd love to hear about it.

When stored procedures didn't work for me, I used stored functions
instead. Of course, with stored functions, you can only return a single
element, but you can return stuff like:

"foo1=bar1\nfoo2=bar2"

Then pull data out of it using ${extract{}{}}

Presumably, even with your hack in place, exim barfs if you return
multiple result sets?

Mike