[Pkg-exim4-users] Exim/MySQL not picking up new config

[Marc Haber]

On Wed, Dec 14, 2005 at 09:32:43AM -0700, Brian Rose wrote:
> I opened the my_mailboxes transport and I believe I have found the  
> offending line:
> 
> directory = ${lookup mysql{SELECT folder FROM mail_folders WHERE us
> er = CONCAT('$local_part', '@', '$domain') AND suffix='$header_X- 
> Local-Part-Suff
> ix:';}{$value}{/var/mail/$domain/$local_part/Maildir}}
> 
> Therefore, I just want to clarify before I do anything that could  
> break Exim for all users:
> 
> If I'm reading the line correctly, it selects the result from SQL and  
> sets directory to it if it is available, otherwise it sets it to "/ 
> var/mail/$domain/$local_part/Maildir". Correct?

Sorry, I don't have a clue about using MySQL with exim.

A possible way to debug would be to watch exim delivering a message to
one of the offending addresses, like

echo "test" | exim -d <some address>

This will actually deliver a message, and print verbose output about
what exim does. This probably includes the queries that are actually
sent to the database, its return, and the setting of delivery
parameters.

Maybe, you can interpret the output yourself, otherwise, quote it here
or on paste.debian.net and let me try to make something of it.

Greetings
Marc

-- 
-----------------------------------------------------------------------------
Marc Haber         | "I don't trust Computers. They | Mailadresse im Header
Mannheim, Germany  |  lose things."    Winona Ryder | Fon: *49 621 72739834
Nordisch by Nature |  How to make an American Quilt | Fax: *49 621 72739835