Re: [Exim] sig 11 with exim 4.34: mysql lookup for address_d…

Góra strony
Delete this message
Reply to this message
Autor: Marilyn Davis
Data:  
Dla: exim-users
Temat: Re: [Exim] sig 11 with exim 4.34: mysql lookup for address_data
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/ ##
>
>


--