On Wed, 9 Jun 2004, Marilyn Davis wrote:
> Hello Exim experts,
>
> I'm running exim 4.34 and stretching myself to take better advantage
> of exim's features. This is my first time to try to put several values
> into $address_data using a mysql lookup and I've hit a problem(!)
>
> I have a router:
>
> get_inside_id:
> driver = redirect
> address_data = ADDRESS_INFO
> data =
>
> Where, in the global data part:
>
> ADDRESS_INFO=${lookup mysql{select addresses.id,addresses.type \
> from addresses, domains \
> where domains.name= '${quote_mysql:$domain}' \
> and addresses.local_part = '${quote_mysql:$local_part}' \
> and domains.id = addresses.domain_id}{$value}{0}}
Thinking that sig 11's can happen sometime after the last successful output,
I tried brute-forcing the ADDRESS_INFO:
ADDRESS_INFO= addresses.id=9 addresses.type=INSIDE-LOGIN
and everything goes as I expect. Stuff like this happens happily:
expanding: insert into doorman (in_id, msg_id, out_address) values (${extract{addresses.id}{$address_data}},'${quote_mysql:$message_id}', '${quote_mysql:$sender_address}');
result: insert into doorman (in_id, msg_id, out_address) values (9,'1BYFXb-0004Rw-7o', 'marilyn@???');
And mail goes where I expect it to go.
So I'm thinking that it really is something with my lookup to set two
values into address_data.
Thank you for any help.
Marilyn
--
>
> I'm testing by running:
>
> exim -d+expand -t < /tmp/x
>
> Where /tmp/x is a message from marilyn@??? to
> marilyn@???. I'm testing on maildance.com.
>
> The output looks right until:
>
> MYSQL query: select addresses.id,addresses.type from addresses, domains where domains.name= 'maildance.com' and addresses.local_part = 'marilyn' and domains.id = addresses.domain_id
> MYSQL using cached connection for localhost/maildance/root
>
> [root@maildance log]#
>
> Boom. It just stops. The exim_mainlog says:
>
> 2004-06-09 18:28:59 1BYENH-0004J0-CE <= marilyn@??? U=root P=local S=2575
>
> And that's all, for a while. There is nothing in the exim_paniclog.
>
> But later I get:
>
> 2004-06-09 18:43:31 queue run: process 16677 crashed with signal 11 while delivering 1BYENH-0004J0-CE
>
> And the exim_paniclog has the same entry.
>
> When I run the mysql query directly, it produces a good result:
>
> mysql> select addresses.id,addresses.type from addresses, domains where domains.name= 'maildance.com' and addresses.local_part = 'marilyn' and domains.id = addresses.domain_id
> -> ;
> +----+--------------+
> | id | type |
> +----+--------------+
> | 9 | INSIDE-LOGIN |
> +----+--------------+
> 1 row in set (0.00 sec)
>
> mysql>
>
> I make several other queries and updates via exim and all goes well.
>
> What can I do?
>
> Marilyn Davis
>
> --
>
>
>
>
>
> --
>
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>
>
--
