[Pkg-exim4-users] Exim/MySQL not picking up new config
Brian Rose
brian at heimidal.net
Wed Dec 14 02:33:27 UTC 2005
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.
The configuration I'm using was provided by a source that used it
previously. All other changes I've made to the MySQL database worked
fine. No changes were made to /etc/exim4/conf.d/ in the past two
months, only MySQL.
/usr/sbin/exim4 -bV | grep '^Configuration'
Produced "Configuration file is /var/lib/exim4/config.autogenerated".
Output of exim -d -bt heimidal at gmail.com:
This shows correct routing of the message to the MX records of
gmail.com and doesn't help in debugging local deliveries at all.
Sorry, I didn't quite understand which address you needed me to test.
Here is the output for the offending email address:
Exim version 4.50 uid=0 gid=0 pid=3674 D=fbb95cfd
Berkeley DB: Sleepycat Software: Berkeley DB 4.2.52: (December 3, 2003)
Support for: iconv() IPv6 PAM Perl GnuTLS Content_Scanning Old_Demime
Lookups: lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmnz
dnsdb dsearch ldap ldapdn ldapm mysql nis nis0 passwd pgsql
Authenticators: cram_md5 cyrus_sasl plaintext spa
Routers: accept dnslookup ipliteral iplookup manualroute queryprogram
redirect
Transports: appendfile/maildir/mailstore/mbx autoreply lmtp pipe smtp
Fixed never_users: 0
changed uid/gid: forcing real = effective
uid=0 gid=0 pid=3674
auxiliary group list: <none>
configuration file is /var/lib/exim4/config.autogenerated
log selectors = 00000ffc 00020800
trusted user
admin user
finduser used cached passwd data for mail
user name "root" extracted from gecos field "root"
originator: uid=0 gid=0 login=root name=root
sender address = root at rackmountmicro.com
Address testing: uid=0 gid=102 euid=0 egid=102
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Testing choward at rackmountmicro.com
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Considering choward at rackmountmicro.com
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
routing choward at rackmountmicro.com
--------> hubbed_hosts router <--------
local_part=choward domain=rackmountmicro.com
checking domains
expansion of "${if exists{/etc/exim4/hubbed_hosts}{partial-lsearch;/
etc/exim4/hubbed_hosts}fail}" forced failure: assume not in this list
hubbed_hosts router skipped: domains mismatch
--------> dnslookup_relay_to_domains router <--------
local_part=choward domain=rackmountmicro.com
checking domains
search_open: mysql "NULL"
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'"
database lookup required for SELECT `domain` FROM `mail_domain` WHERE
`domain`='rackmountmicro.com'
MYSQL query: SELECT `domain` FROM `mail_domain` WHERE
`domain`='rackmountmicro.com'
MYSQL new connection: host=localhost port=0 socket=NULL database=exim
user=exim
lookup yielded: rackmountmicro.com
rackmountmicro.com in "rackmountmicro.com"? yes (matched
"rackmountmicro.com")
rackmountmicro.com in "! +local_domains : +relay_to_domains"? no
(matched "! +local_domains")
dnslookup_relay_to_domains router skipped: domains mismatch
--------> dnslookup 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")
rackmountmicro.com in "! +local_domains"? no (matched "!
+local_domains")
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 >>>>>>>>>>>>>>>>
Thanks again,
Brian
Brian 'Heimidal' Rose
brian at heimidal.net
http://www.heimidal.net
On Dec 13, 2005, at 8:49 AM, Marc Haber wrote:
> On Tue, Dec 13, 2005 at 08:16:10AM -0700, Brian Rose wrote:
>>> Please refer to http://www.catb.org/~esr/faqs/smart-
>>> questions.html for
>>> information how to ask questions without making it unncecessarily
>>> hard
>>> to answer them.
>>>
>>> To help, we need a lot of information. A good start would be:
>>>
>>> exim -bv | grep '^Configuration'
>>> cat /etc/exim4/update-exim4.conf.conf
>>> Contents of all configuration files changed by you.
>>
>> For starters, I am using Debian Sarge. The only configuration option
>> changed was in exim's MySQL database in the mail_user table.
>
> 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.
>
>> I
>> changed a user's home from /var/mail/rackmountmicro.com/choward/ to /
>> home/choward/mail/rackmountmicro.com/choward/. I then moved the
>> Maildir from the old home directory to the new home directory.
>> Ownership on the new home directory and all of its subdirectories are
>> mail:mail.
>>
>> When I changed the option in MySQL and restarted Exim, the next new
>> email received for that account caused Maildir/ to be recreated in
>> the old home directory.
>
> Looks like your changes weren't read.
>
>> As for the configuration information you requested:
>>
>> "exim4 -bv | grep '^Configuration'" (the exim command doesn't exist)
>> produced nothing.
>
> I usually fall into that trap as I have locally linked exim4 to exim.
> The correct line would have been
>
> /usr/sbin/exim4 -bV | grep '^Configuration'
>
>> dc_use_split_config='true'
>
> This is the key. You need to make your changes in the small files in
> /etc/exim4/conf.d, and not in /etc/exim4/exim4.conf.template.
>
> This is documented in update-exim4.conf(8) and the Debian readme.
>
>> Output of exim -d -bt heimidal at gmail.com:
>
> This shows correct routing of the message to the MX records of
> gmail.com and doesn't help in debugging local deliveries at all.
>
> 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/20051213/8d5dde8a/attachment.html
More information about the Pkg-exim4-users
mailing list