<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">On Mon, Dec 12, 2005 at 03:00:30PM -0700, Brian Rose wrote:</DIV><BR></BLOCKQUOTE><BLOCKQUOTE type="cite"><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I have Exim/MySQL setup and it has been working for the last few</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">months. I changed the location of a user's Maildir in MySQL and</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">restarted the MTA.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Mail is still being delivered to the old Maildir (it was recreated</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">and mail is being deposited). Courier is fetching mail from the</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">correct Maildir, however, so transferring mail from the old to the</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">new Maildir is a temporary fix.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">I've tried /etc/init.d/exim4 restart, /etc/init.d/exim4 reload, and a</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">hard stop/start as well. I'm completely out of ideas.</DIV><BR></BLOCKQUOTE><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Unfortunately, you don't give any information about your configuration</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">changes. This is, btw, the reason why noone was able to help you on</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">IRC. On #exim, it would also have been a good idea to say which</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Distribiution you use.</DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I apologize - this is my first foray into trying to find help with Debian outside my colleagues.</DIV><BR><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Please refer to <A href="http://www.catb.org/~esr/faqs/smart-questions.html">http://www.catb.org/~esr/faqs/smart-questions.html</A> for</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">information how to ask questions without making it unncecessarily hard</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">to answer them.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">To help, we need a lot of information. A good start would be:</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">exim -bv | grep '^Configuration'</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">cat /etc/exim4/update-exim4.conf.conf</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Contents of all configuration files changed by you.</DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV><DIV>For starters, I am using Debian Sarge. The only configuration option changed was in exim's MySQL database in the mail_user table. 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.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>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.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>As for the configuration information you requested:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>"exim4 -bv | grep '^Configuration'" (the exim command doesn't exist) produced nothing.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Output of 'cat /etc/exim4/update-exim4.conf.conf':</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV># /etc/exim4/update-exim4.conf.conf</DIV><DIV>#</DIV><DIV># Edit this file and /etc/mailname by hand and execute update-exim4.conf</DIV><DIV># yourself or use 'dpkg-reconfigure exim4-config'</DIV><DIV>#</DIV><DIV># Please note that this is _not_ a dpkg-conffile and that automatic changes</DIV><DIV># to this file might happen. The code handling this will honor your local</DIV><DIV># changes, so this is usually fine, but will break local schemes that mess</DIV><DIV># around with multiple versions of the file.</DIV><DIV>#</DIV><DIV># update-exim4.conf uses this file to determine variable values to replace</DIV><DIV># the DEBCONFsomethingDEBCONF strings in the configuration template files.</DIV><DIV>#</DIV><DIV># Most settings found in here do have corresponding questions in the</DIV><DIV># Debconf configuration, but not all of them.</DIV><DIV>#</DIV><DIV># This is a Debian specific file</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>dc_eximconfig_configtype='internet'</DIV><DIV>dc_other_hostnames='rackmountmicro.com'</DIV><DIV>dc_local_interfaces='127.0.0.1'</DIV><DIV>dc_readhost=''</DIV><DIV>dc_relay_domains=''</DIV><DIV>dc_minimaldns='false'</DIV><DIV>dc_relay_nets=''</DIV><DIV>dc_smarthost=''</DIV><DIV>CFILEMODE='644'</DIV><DIV>dc_use_split_config='true'</DIV><DIV>dc_hide_mailname=''</DIV><DIV>dc_mailname_in_oh='true'</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Output of exim -d -bt <A href="mailto:heimidal@gmail.com">heimidal@gmail.com</A>:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Exim version 4.50 uid=0 gid=0 pid=28915 D=fbb95cfd</DIV><DIV>Berkeley DB: Sleepycat Software: Berkeley DB 4.2.52: (December 3, 2003)</DIV><DIV>Support for: iconv() IPv6 PAM Perl GnuTLS Content_Scanning Old_Demime</DIV><DIV>Lookups: lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmnz dnsdb dsearch ldap ldapdn ldapm mysql nis nis0 passwd pgsql</DIV><DIV>Authenticators: cram_md5 cyrus_sasl plaintext spa</DIV><DIV>Routers: accept dnslookup ipliteral iplookup manualroute queryprogram redirect</DIV><DIV>Transports: appendfile/maildir/mailstore/mbx autoreply lmtp pipe smtp</DIV><DIV>Fixed never_users: 0</DIV><DIV>changed uid/gid: forcing real = effective</DIV><DIV> uid=0 gid=0 pid=28915</DIV><DIV> auxiliary group list: <none></DIV><DIV>configuration file is /var/lib/exim4/config.autogenerated</DIV><DIV>log selectors = 00000ffc 00020800</DIV><DIV>trusted user</DIV><DIV>admin user</DIV><DIV>finduser used cached passwd data for mail</DIV><DIV>user name "root" extracted from gecos field "root"</DIV><DIV>originator: uid=0 gid=0 login=root name=root</DIV><DIV>sender address = <A href="mailto:root@rackmountmicro.com">root@rackmountmicro.com</A></DIV><DIV>Address testing: uid=0 gid=102 euid=0 egid=102</DIV><DIV>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>></DIV><DIV>Testing <A href="mailto:heimidal@gmail.com">heimidal@gmail.com</A></DIV><DIV>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>></DIV><DIV>Considering <A href="mailto:heimidal@gmail.com">heimidal@gmail.com</A></DIV><DIV>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>></DIV><DIV>routing <A href="mailto:heimidal@gmail.com">heimidal@gmail.com</A></DIV><DIV>--------> hubbed_hosts router <--------</DIV><DIV>local_part=heimidal domain=gmail.com</DIV><DIV>checking domains</DIV><DIV>expansion of "${if exists{/etc/exim4/hubbed_hosts}{partial-lsearch;/etc/exim4/hubbed_hosts}fail}" forced failure: assume not in this list</DIV><DIV>hubbed_hosts router skipped: domains mismatch</DIV><DIV>--------> dnslookup_relay_to_domains router <--------</DIV><DIV>local_part=heimidal domain=gmail.com</DIV><DIV>checking domains</DIV><DIV>search_open: mysql "NULL"</DIV><DIV>search_find: file="NULL"</DIV><DIV> key="SELECT `domain` FROM `mail_domain` WHERE `domain`='gmail.com'" partial=-1 affix=NULL starflags=0</DIV><DIV>LRU list:</DIV><DIV>internal_search_find: file="NULL"</DIV><DIV> type=mysql key="SELECT `domain` FROM `mail_domain` WHERE `domain`='gmail.com'"</DIV><DIV>database lookup required for SELECT `domain` FROM `mail_domain` WHERE `domain`='gmail.com'</DIV><DIV>MYSQL query: SELECT `domain` FROM `mail_domain` WHERE `domain`='gmail.com'</DIV><DIV>MYSQL new connection: host=localhost port=0 socket=NULL database=exim user=exim</DIV><DIV>MYSQL: no data found</DIV><DIV>lookup failed</DIV><DIV>gmail.com in ""? no (end of list)</DIV><DIV>gmail.com in ""? no (end of list)</DIV><DIV>gmail.com in "! +local_domains : +relay_to_domains"? no (end of list)</DIV><DIV>dnslookup_relay_to_domains router skipped: domains mismatch</DIV><DIV>--------> dnslookup router <--------</DIV><DIV>local_part=heimidal domain=gmail.com</DIV><DIV>checking domains</DIV><DIV>search_open: mysql "NULL"</DIV><DIV> cached open</DIV><DIV>search_find: file="NULL"</DIV><DIV> key="SELECT `domain` FROM `mail_domain` WHERE `domain`='gmail.com'" partial=-1 affix=NULL starflags=0</DIV><DIV>LRU list:</DIV><DIV>internal_search_find: file="NULL"</DIV><DIV> type=mysql key="SELECT `domain` FROM `mail_domain` WHERE `domain`='gmail.com'"</DIV><DIV>cached data used for lookup of SELECT `domain` FROM `mail_domain` WHERE `domain`='gmail.com'</DIV><DIV>lookup failed</DIV><DIV>gmail.com in ""? no (end of list)</DIV><DIV>gmail.com in "! +local_domains"? yes (end of list)</DIV><DIV>R: dnslookup for <A href="mailto:heimidal@gmail.com">heimidal@gmail.com</A></DIV><DIV>calling dnslookup router</DIV><DIV>dnslookup router called for <A href="mailto:heimidal@gmail.com">heimidal@gmail.com</A></DIV><DIV> domain = gmail.com</DIV><DIV>DNS lookup of gmail.com (MX) succeeded</DIV><DIV>66.249.83.114 in "0.0.0.0 : 127.0.0.0/8 : 192.168.0.0/16 :172.16.0.0/12 : 10.0.0.0/8 : 169.254.0.0/16"? no (end of list)</DIV><DIV>66.249.83.27 in "0.0.0.0 : 127.0.0.0/8 : 192.168.0.0/16 :172.16.0.0/12 : 10.0.0.0/8 : 169.254.0.0/16"? no (end of list)</DIV><DIV>66.249.83.27 in "0.0.0.0 : 127.0.0.0/8 : 192.168.0.0/16 :172.16.0.0/12 : 10.0.0.0/8 : 169.254.0.0/16"? no (end of list)</DIV><DIV>64.233.163.27 in "0.0.0.0 : 127.0.0.0/8 : 192.168.0.0/16 :172.16.0.0/12 : 10.0.0.0/8 : 169.254.0.0/16"? no (end of list)</DIV><DIV>64.233.185.27 in "0.0.0.0 : 127.0.0.0/8 : 192.168.0.0/16 :172.16.0.0/12 : 10.0.0.0/8 : 169.254.0.0/16"? no (end of list)</DIV><DIV>66.249.83.114 in "0.0.0.0 : 127.0.0.0/8 : 192.168.0.0/16 :172.16.0.0/12 : 10.0.0.0/8 : 169.254.0.0/16"? no (end of list)</DIV><DIV>64.233.185.114 in "0.0.0.0 : 127.0.0.0/8 : 192.168.0.0/16 :172.16.0.0/12 : 10.0.0.0/8 : 169.254.0.0/16"? no (end of list)</DIV><DIV>duplicate IP address 66.249.83.27 (MX=10) removed</DIV><DIV>duplicate IP address 66.249.83.114 (MX=10) removed</DIV><DIV>fully qualified name = gmail.com</DIV><DIV>host_find_bydns yield = HOST_FOUND (2); returned hosts:</DIV><DIV> gmail-smtp-in.l.google.com 66.249.83.27 MX=5 </DIV><DIV> gmail-smtp-in.l.google.com 66.249.83.114 MX=5 </DIV><DIV> gsmtp185-2.google.com 64.233.185.114 MX=10 </DIV><DIV> gsmtp163.google.com 64.233.163.27 MX=10 </DIV><DIV> gsmtp185.google.com 64.233.185.27 MX=10 </DIV><DIV>set transport remote_smtp</DIV><DIV>queued for remote_smtp transport: local_part = heimidal</DIV><DIV>domain = gmail.com</DIV><DIV> errors_to=NULL</DIV><DIV> domain_data=NULL localpart_data=NULL</DIV><DIV>routed by dnslookup router</DIV><DIV> envelope to: <A href="mailto:heimidal@gmail.com">heimidal@gmail.com</A></DIV><DIV> transport: remote_smtp</DIV><DIV> host gmail-smtp-in.l.google.com [66.249.83.27] MX=5</DIV><DIV> host gmail-smtp-in.l.google.com [66.249.83.114] MX=5</DIV><DIV> host gsmtp185-2.google.com [64.233.185.114] MX=10</DIV><DIV> host gsmtp163.google.com [64.233.163.27] MX=10</DIV><DIV> host gsmtp185.google.com [64.233.185.27] MX=10</DIV><DIV><A href="mailto:heimidal@gmail.com">heimidal@gmail.com</A></DIV><DIV> router = dnslookup, transport = remote_smtp</DIV><DIV> host gmail-smtp-in.l.google.com [66.249.83.27] MX=5</DIV><DIV> host gmail-smtp-in.l.google.com [66.249.83.114] MX=5</DIV><DIV> host gsmtp185-2.google.com [64.233.185.114] MX=10</DIV><DIV> host gsmtp163.google.com [64.233.163.27] MX=10</DIV><DIV> host gsmtp185.google.com [64.233.185.27] MX=10</DIV><DIV>search_tidyup called</DIV><DIV>close MYSQL connection: localhost/exim/exim</DIV><DIV>>>>>>>>>>>>>>>>> Exim pid=28915 terminating with rc=0 >>>>>>>>>>>>>>>></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Thanks again,</DIV><DIV>Brian</DIV><BR><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Output of exim -bt <A href="mailto:some-mail-address@domain.example">some-mail-address@domain.example</A>, and if that's</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">inconclusive, exim -d -bt <A href="mailto:some-mail-address@domain.example">some-mail-address@domain.example</A>.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Please be advised that I don't have much MySQL experience myself, so</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">if you didn't goof badly with your changes and have them ignored by</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">exim, chances are that _I_ cannot help.</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Greetings</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Marc</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; min-height: 14px; "><BR></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">-- -----------------------------------------------------------------------------</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Marc Haber | "I don't trust Computers. They | Mailadresse im Header</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Mannheim, Germany | lose things." Winona Ryder | Fon: *49 621 72739834</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Nordisch by Nature | How to make an American Quilt | Fax: *49 621 72739835</DIV></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV><BR><DIV> <SPAN class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><DIV><B style="font-weight: bold; "><SPAN class="Apple-style-span" style="font-weight: bold; ">Brian 'Heimidal' Rose</SPAN></B></DIV><DIV><A href="mailto:brian@heimidal.net">brian@heimidal.net</A></DIV><DIV><A href="http://www.heimidal.net">http://www.heimidal.net</A></DIV><BR class="Apple-interchange-newline"></SPAN> </DIV><BR></BODY></HTML>