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

[Brian Rose]

> Now we need to look at the my_mailboxes transport. Can you please
> quote it?

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?

If that is the case, the SQL statement for the correct folder should  
be "SELECT home FROM mail_user WHERE user= CONCAT('$local_part', '@',  
'$domain')" instead of what is there and it will take that simple  
change to make it work.

Thanks again.

Brian 'Heimidal' Rose
brian at heimidal.net
http://www.heimidal.net


On Dec 13, 2005, at 11:35 PM, Marc Haber wrote:

> On Tue, Dec 13, 2005 at 07:33:27PM -0700, Brian Rose wrote:
>> On Dec 13, 2005, at 8:49 AM, Marc Haber wrote:
>> Debian's default configuration doesn't handle MySQL at all. So you
>> have changed the configuration in very central places and should thus
>> know what you are doing.
>
> You didn't write this. Please use quoting conventions that allow to
> easily distinguish what you wrote from what you are quoting.
>
>> /usr/sbin/exim4 -bV | grep '^Configuration'
>>
>> Produced "Configuration file is /var/lib/exim4/config.autogenerated".
>
> Good, so exim is actually using the configuration built from
> /etc/exim4/conf.d
>
>> Sorry, I didn't quite understand which address you needed me to test.
>> Here is the output for the offending email address:
>
> Thanks. Key output is:
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>> Testing choward at rackmountmicro.com
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>> Considering choward at rackmountmicro.com
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>> routing choward at rackmountmicro.com
>> --------> hubbed_hosts router <--------
>> hubbed_hosts router skipped: domains mismatch
>> --------> dnslookup_relay_to_domains router <--------
>> dnslookup_relay_to_domains router skipped: domains mismatch
>> --------> dnslookup router <--------
>> dnslookup router skipped: domains mismatch
>> --------> my_domains router <--------
>> local_part=choward domain=rackmountmicro.com
>> checking domains
>> search_open: mysql "NULL"
>>   cached open
>> search_find: file="NULL"
>>   key="SELECT `domain` FROM `mail_domain` WHERE
>> `domain`='rackmountmicro.com'" partial=-1 affix=NULL starflags=0
>> LRU list:
>> internal_search_find: file="NULL"
>>   type=mysql key="SELECT `domain` FROM `mail_domain` WHERE
>> `domain`='rackmountmicro.com'"
>> cached data used for lookup of SELECT `domain` FROM `mail_domain`
>> WHERE `domain`='rackmountmicro.com'
>> lookup yielded: rackmountmicro.com
>> rackmountmicro.com in "rackmountmicro.com"? yes (matched
>> "rackmountmicro.com")
>> checking local_parts
>> search_open: mysql "NULL"
>>   cached open
>> search_find: file="NULL"
>>   key="SELECT local_part FROM mail_user WHERE local_part='choward'
>> AND domain='rackmountmicro.com'" partial=-1 affix=NULL starflags=0
>> LRU list:
>> internal_search_find: file="NULL"
>>   type=mysql key="SELECT local_part FROM mail_user WHERE
>> local_part='choward' AND domain='rackmountmicro.com'"
>> database lookup required for SELECT local_part FROM mail_user WHERE
>> local_part='choward' AND domain='rackmountmicro.com'
>> MYSQL query: SELECT local_part FROM mail_user WHERE
>> local_part='choward' AND domain='rackmountmicro.com'
>> MYSQL using cached connection for localhost/exim/exim
>> lookup yielded: choward
>> choward in "choward"? yes (matched "choward")
>> calling my_domains router
>> my_domains router called for choward at rackmountmicro.com
>>   domain = rackmountmicro.com
>> set transport my_mailboxes
>> queued for my_mailboxes transport: local_part = choward
>> domain = rackmountmicro.com
>>   errors_to=NULL
>>   domain_data=NULL localpart_data=NULL
>> routed by my_domains router
>>   envelope to: choward at rackmountmicro.com
>>   transport: my_mailboxes
>> choward at rackmountmicro.com
>>   router = my_domains, transport = my_mailboxes
>> search_tidyup called
>> close MYSQL connection: localhost/exim/exim
>>>>>>>>>>>>>>>>>> Exim pid=3674 terminating with rc=0 >>>>>>>>>>>>>>>>
>
> Now we need to look at the my_mailboxes transport. Can you please
> quote 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
>
> _______________________________________________
> Pkg-exim4-users mailing list
> Pkg-exim4-users at lists.alioth.debian.org
> http://lists.alioth.debian.org/mailman/listinfo/pkg-exim4-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.alioth.debian.org/pipermail/pkg-exim4-users/attachments/20051214/1fbbf0e9/attachment-0001.htm