[Dovecot] Arghh, dovecot-2 and lda
I cannot seem to get exim/lda working...
In my exim log i just see these 2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index
Now I have all the debugging on as far as i can tell, and exim is obviously being returned some value from dovecot because it knows about the maildir that i return from sql, but yet there is zero being logged in debug or anything else. If I run the dovecot-lda from the command line with the same then it works and i get logs entered
command = /usr/local/libexec/dovecot/ -e -k -f "$sender_address" -d "$local_part@$domain" -m "$acl_m1"
I am returning a home and mail with userdb, the directory does exist, owned by mail.mail... Im stumped
dovecot -n # 2.0.rc2: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-amd64 x86_64 Debian squeeze/sid auth_cache_negative_ttl = 30 s auth_cache_size = 4096 auth_cache_ttl = 30 s auth_debug = yes auth_default_realm = olypen.com auth_mechanisms = plain login auth_username_format = %Lu auth_verbose = yes auth_worker_max_count = 60 base_dir = /var/run/dovecot debug_log_path = /var/log/dovecot/debug.log default_client_limit = 1024 default_internal_user = mail default_login_user = mail default_vsz_limit = 1073741824 deliver_log_format = %s from %f %$ dict { expire = mysql:/etc/dovecot/conf.d/dovecot-dict-expire.conf.ext } disable_plaintext_auth = no dotlock_use_excl = yes first_valid_gid = 8 first_valid_uid = 8 info_log_path = /var/log/dovecot/info.log last_valid_gid = 8 last_valid_uid = 8 log_path = /var/log/dovecot/dovecot.log log_timestamp = %Y-%m-%d %H:%M:%S login_log_format = %s login_log_format_elements = (%u) (%r) mail_access_groups = mail mail_debug = yes mail_fsync = never mail_gid = 8 mail_location = maildir:~/:INDEX=~/dovecot-index mail_log_prefix = %Ls <%u>: mail_max_userip_connections = 4 mail_plugins = quota mail_privileged_group = mail mail_uid = 8 mailbox_idle_check_interval = 60 s maildir_very_dirty_syncs = yes mdbox_rotate_size = 10485760 namespace { hidden = no inbox = yes location = prefix = separator = / type = private } passdb { args = /etc/dovecot/conf.d/dovecot-sql.conf.ext driver = sql } plugin { auth_socket_path = /var/run/dovecot/auth-master autocreate = Trash autocreate2 = Spam autocreate3 = Spam.Delivered autocreate4 = Spam.Removed autocreate5 = Sent autocreate6 = Drafts autosubscribe = Trash autosubscribe2 = Sent expire = Trash 30d expire2 = Trash/* 30d expire3 = Spam 14d expire4 = Spam/Removed 6h expire5 = Spam/Delivered 2d expire6 = Deleted* 30d expire7 = Archive 30d expire_dict = proxy::expire qoute_rule5 = Spam.Delivered:ignore quota = maildir:User quota quota_rule2 = Trash:ignore quota_rule3 = Deleted Items:ignore quota_rule4 = Spam:ignore quota_rule6 = Spam.Removed:ignore quota_warning = storage=95%% /etc/dovecot/quota-warning.sh 95 quota_warning2 = storage=80%% /etc/dovecot/quota-warning.sh 80 trash = /etc/dovecot/conf.d/dovecot-trash.conf.ext zlib_save = bz2 zlib_save_level = 6 } protocols = imap pop3 service auth { executable = /usr/local/libexec/dovecot/auth unix_listener auth-client { group = mail mode = 0666 user = mail } unix_listener auth-master { group = mail mode = 0666 user = mail } unix_listener auth-userdb { group = mail mode = 0666 user = mail } vsz_limit = 536870912 } service imap-login { client_limit = 512 executable = /usr/local/libexec/dovecot/imap-login process_limit = 20 process_min_avail = 4 service_count = 0 user = dovecot vsz_limit = 134217728 } service imap { drop_priv_before_exec = no executable = /usr/local/libexec/dovecot/imap vsz_limit = 536870912 } service pop3-login { client_limit = 512 executable = /usr/local/libexec/dovecot/pop3-login process_limit = 20 process_min_avail = 4 service_count = 0 user = dovecot vsz_limit = 134217728 } service pop3 { drop_priv_before_exec = no executable = /usr/local/libexec/dovecot/pop3 vsz_limit = 536870912 } ssl_cert = with subject of <%s> was automatically rejected:%n%r rejection_subject = Mailbox Full: %s sendmail_path = /usr/sbin/exim } protocol imap { imap_client_workarounds = delay-newmail tb-extra-mailbox-sep imap_id_log = * imap_logout_format = bytes=%i/%o imap_max_line_length = 65536 mail_max_userip_connections = 20 mail_plugin_dir = /usr/local/lib/dovecot/imap mail_plugins = $mail_plugins imap_quota autocreate } protocol pop3 { mail_max_userip_connections = 2 mail_plugin_dir = /usr/local/lib/dovecot/pop3 mail_plugins = $mail_plugins pop3_client_workarounds = outlook-no-nuls oe-ns-eoh pop3_enable_last = no pop3_lock_session = no pop3_logout_format = retr=%r/%b, del=%d/%m, size=%s pop3_no_flag_updates = yes pop3_reuse_xuidl = no pop3_uidl_format = %08Xu%08Xv }
On 18.7.2010, at 19.57, Brandon Lamb wrote:
2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index .. command = /usr/local/libexec/dovecot/ -e -k -f "$sender_address" -d "$local_part@$domain" -m "$acl_m1"
Why are you giving -k parameter?
I am returning a home and mail with userdb, the directory does exist, owned by mail.mail... Im stumped
It looks like you're returning "maildir:~/maildir:INDEX=~/maildir/dovecot-index" as the home directory.
On Sun, Jul 18, 2010 at 12:06 PM, Timo Sirainen tss@iki.fi wrote:
On 18.7.2010, at 19.57, Brandon Lamb wrote:
2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index .. command = /usr/local/libexec/dovecot/ -e -k -f "$sender_address" -d "$local_part@$domain" -m "$acl_m1"
Why are you giving -k parameter?
I dont remember, its something I had entered at some point long ago, i'll remove it
I am returning a home and mail with userdb, the directory does exist, owned by mail.mail... Im stumped
It looks like you're returning "maildir:~/maildir:INDEX=~/maildir/dovecot-index" as the home directory.
I know that was my thought too! But below are the fields in mysql, and there are also no logs being entered to give me hints at what might be wrong. It isnt logging to debug, but it DOES if I run the dovecot-lda from the command line??
home: /mail/mail2/b/olypen.com/brandon maildir: maildir:~/maildir:INDEX=~/maildir/dovecot-index
and dovecot-sql.conf-ext
# Password query
password_query = SELECT 8 AS userdb_uid,
8 AS userdb_gid,
password,
CONCAT(username, '@', domain) AS user,
mail_pop.home AS userdb_home,
mail_pop.maildir AS userdb_mail,
CONCAT('*:storage=', quota, 'M') AS quota_rule,
'~/dovecot.sieve' AS userdb_sieve
FROM auth LEFT JOIN (mail_pop) ON (mail_pop.user_id = auth.user_id)
WHERE username = '%n' AND domain = '%d' AND mail_pop.status =
'enabled' LIMIT 1
# User query
user_query = SELECT mail_pop.home AS home,
mail_pop.maildir AS mail,
8 AS uid,
8 AS gid,
CONCAT('*:storage=', quota, 'M') AS quota_rule,
'~/dovecot.sieve' AS sieve
FROM auth LEFT JOIN (mail_pop) ON (mail_pop.user_id = auth.user_id)
WHERE username = '%n' AND domain = '%d' AND mail_pop.status =
'enabled' LIMIT 1
And the directory: server:/mail/mail2/b/olypen.com/brandon# ls -al total 8 drwxrwx--- 4 mail mail 32 Jul 18 00:54 . drwxrwx--- 3 mail mail 20 Jul 18 00:53 .. drwxrwx--- 27 mail mail 4096 Jul 18 11:22 maildir drwx-w---- 4 mail mail 4096 Jul 18 01:20 mdbox
On Sun, Jul 18, 2010 at 12:13 PM, Brandon Lamb brandonlamb@gmail.com wrote:
On Sun, Jul 18, 2010 at 12:06 PM, Timo Sirainen tss@iki.fi wrote:
On 18.7.2010, at 19.57, Brandon Lamb wrote:
2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index .. command = /usr/local/libexec/dovecot/ -e -k -f "$sender_address" -d "$local_part@$domain" -m "$acl_m1"
Why are you giving -k parameter?
I dont remember, its something I had entered at some point long ago, i'll remove it
I am returning a home and mail with userdb, the directory does exist, owned by mail.mail... Im stumped
It looks like you're returning "maildir:~/maildir:INDEX=~/maildir/dovecot-index" as the home directory.
I know that was my thought too! But below are the fields in mysql, and there are also no logs being entered to give me hints at what might be wrong. It isnt logging to debug, but it DOES if I run the dovecot-lda from the command line??
home: /mail/mail2/b/olypen.com/brandon maildir: maildir:~/maildir:INDEX=~/maildir/dovecot-index
and dovecot-sql.conf-ext # Password query password_query = SELECT 8 AS userdb_uid,
8 AS userdb_gid,
password,
CONCAT(username, '@', domain) AS user,
mail_pop.home AS userdb_home,
mail_pop.maildir AS userdb_mail,
CONCAT('*:storage=', quota, 'M') AS quota_rule,
'~/dovecot.sieve' AS userdb_sieve
FROMauthLEFT JOIN (mail_pop) ON (mail_pop.user_id = auth.user_id) WHERE username = '%n' AND domain = '%d' AND mail_pop.status = 'enabled' LIMIT 1# User query user_query = SELECT mail_pop.home AS home,
mail_pop.maildir AS mail,
8 AS uid,
8 AS gid,
CONCAT('*:storage=', quota, 'M') AS quota_rule,
'~/dovecot.sieve' AS sieve
FROMauthLEFT JOIN (mail_pop) ON (mail_pop.user_id = auth.user_id) WHERE username = '%n' AND domain = '%d' AND mail_pop.status = 'enabled' LIMIT 1And the directory: server:/mail/mail2/b/olypen.com/brandon# ls -al total 8 drwxrwx--- 4 mail mail 32 Jul 18 00:54 . drwxrwx--- 3 mail mail 20 Jul 18 00:53 .. drwxrwx--- 27 mail mail 4096 Jul 18 11:22 maildir drwx-w---- 4 mail mail 4096 Jul 18 01:20 mdbox
I also just now tried changing the maildir field to absolute paths and now I still get :
No such file or directory: failed to chdir to maildir:/mail/mail2/b/olypen.com/brandon/maildir:INDEX=/mail/mail2/b/olypen.com/brandon/maildir/dovecot-index
And still nothing in dovecot's logs showing that exim even talked to it..
On Sun, Jul 18, 2010 at 12:17 PM, Brandon Lamb brandonlamb@gmail.com wrote:
On Sun, Jul 18, 2010 at 12:13 PM, Brandon Lamb brandonlamb@gmail.com wrote:
On Sun, Jul 18, 2010 at 12:06 PM, Timo Sirainen tss@iki.fi wrote:
On 18.7.2010, at 19.57, Brandon Lamb wrote:
2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index .. command = /usr/local/libexec/dovecot/ -e -k -f "$sender_address" -d "$local_part@$domain" -m "$acl_m1"
Why are you giving -k parameter?
I dont remember, its something I had entered at some point long ago, i'll remove it
I am returning a home and mail with userdb, the directory does exist, owned by mail.mail... Im stumped
It looks like you're returning "maildir:~/maildir:INDEX=~/maildir/dovecot-index" as the home directory.
I know that was my thought too! But below are the fields in mysql, and there are also no logs being entered to give me hints at what might be wrong. It isnt logging to debug, but it DOES if I run the dovecot-lda from the command line??
home: /mail/mail2/b/olypen.com/brandon maildir: maildir:~/maildir:INDEX=~/maildir/dovecot-index
and dovecot-sql.conf-ext # Password query password_query = SELECT 8 AS userdb_uid,
8 AS userdb_gid,
password,
CONCAT(username, '@', domain) AS user,
mail_pop.home AS userdb_home,
mail_pop.maildir AS userdb_mail,
CONCAT('*:storage=', quota, 'M') AS quota_rule,
'~/dovecot.sieve' AS userdb_sieve
FROMauthLEFT JOIN (mail_pop) ON (mail_pop.user_id = auth.user_id) WHERE username = '%n' AND domain = '%d' AND mail_pop.status = 'enabled' LIMIT 1# User query user_query = SELECT mail_pop.home AS home,
mail_pop.maildir AS mail,
8 AS uid,
8 AS gid,
CONCAT('*:storage=', quota, 'M') AS quota_rule,
'~/dovecot.sieve' AS sieve
FROMauthLEFT JOIN (mail_pop) ON (mail_pop.user_id = auth.user_id) WHERE username = '%n' AND domain = '%d' AND mail_pop.status = 'enabled' LIMIT 1And the directory: server:/mail/mail2/b/olypen.com/brandon# ls -al total 8 drwxrwx--- 4 mail mail 32 Jul 18 00:54 . drwxrwx--- 3 mail mail 20 Jul 18 00:53 .. drwxrwx--- 27 mail mail 4096 Jul 18 11:22 maildir drwx-w---- 4 mail mail 4096 Jul 18 01:20 mdbox
I also just now tried changing the maildir field to absolute paths and now I still get :
No such file or directory: failed to chdir to maildir:/mail/mail2/b/olypen.com/brandon/maildir:INDEX=/mail/mail2/b/olypen.com/brandon/maildir/dovecot-index
And still nothing in dovecot's logs showing that exim even talked to it..
Curious, I just changed the maildir field to /mail/mail2/b/olypen.com/brandon/Maildir and now it delivered, curious!
Its like it didnt understand the mailbox type or something?
On Sun, Jul 18, 2010 at 12:27 PM, Brandon Lamb brandonlamb@gmail.com wrote:
On Sun, Jul 18, 2010 at 12:17 PM, Brandon Lamb brandonlamb@gmail.com wrote:
On Sun, Jul 18, 2010 at 12:13 PM, Brandon Lamb brandonlamb@gmail.com wrote:
On Sun, Jul 18, 2010 at 12:06 PM, Timo Sirainen tss@iki.fi wrote:
On 18.7.2010, at 19.57, Brandon Lamb wrote:
2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index .. command = /usr/local/libexec/dovecot/ -e -k -f "$sender_address" -d "$local_part@$domain" -m "$acl_m1"
Why are you giving -k parameter?
I dont remember, its something I had entered at some point long ago, i'll remove it
I am returning a home and mail with userdb, the directory does exist, owned by mail.mail... Im stumped
It looks like you're returning "maildir:~/maildir:INDEX=~/maildir/dovecot-index" as the home directory.
I know that was my thought too! But below are the fields in mysql, and there are also no logs being entered to give me hints at what might be wrong. It isnt logging to debug, but it DOES if I run the dovecot-lda from the command line??
home: /mail/mail2/b/olypen.com/brandon maildir: maildir:~/maildir:INDEX=~/maildir/dovecot-index
and dovecot-sql.conf-ext # Password query password_query = SELECT 8 AS userdb_uid,
8 AS userdb_gid,
password,
CONCAT(username, '@', domain) AS user,
mail_pop.home AS userdb_home,
mail_pop.maildir AS userdb_mail,
CONCAT('*:storage=', quota, 'M') AS quota_rule,
'~/dovecot.sieve' AS userdb_sieve
FROMauthLEFT JOIN (mail_pop) ON (mail_pop.user_id = auth.user_id) WHERE username = '%n' AND domain = '%d' AND mail_pop.status = 'enabled' LIMIT 1# User query user_query = SELECT mail_pop.home AS home,
mail_pop.maildir AS mail,
8 AS uid,
8 AS gid,
CONCAT('*:storage=', quota, 'M') AS quota_rule,
'~/dovecot.sieve' AS sieve
FROMauthLEFT JOIN (mail_pop) ON (mail_pop.user_id = auth.user_id) WHERE username = '%n' AND domain = '%d' AND mail_pop.status = 'enabled' LIMIT 1And the directory: server:/mail/mail2/b/olypen.com/brandon# ls -al total 8 drwxrwx--- 4 mail mail 32 Jul 18 00:54 . drwxrwx--- 3 mail mail 20 Jul 18 00:53 .. drwxrwx--- 27 mail mail 4096 Jul 18 11:22 maildir drwx-w---- 4 mail mail 4096 Jul 18 01:20 mdbox
I also just now tried changing the maildir field to absolute paths and now I still get :
No such file or directory: failed to chdir to maildir:/mail/mail2/b/olypen.com/brandon/maildir:INDEX=/mail/mail2/b/olypen.com/brandon/maildir/dovecot-index
And still nothing in dovecot's logs showing that exim even talked to it..
Curious, I just changed the maildir field to /mail/mail2/b/olypen.com/brandon/Maildir and now it delivered, curious!
Its like it didnt understand the mailbox type or something?
So I switched mysql back to sending full path for home, and maildir:~/maildir and mdbox:~/mdbox for my two test accounts. Imap works just fine, it seems like just lda doesnt understand the returned mail field
On 18.7.2010, at 20.40, Brandon Lamb wrote:
So I switched mysql back to sending full path for home, and maildir:~/maildir and mdbox:~/mdbox for my two test accounts. Imap works just fine, it seems like just lda doesnt understand the returned mail field
What does lda log with mail_debug=yes and auth_debug=yes?
On Sun, Jul 18, 2010 at 12:47 PM, Timo Sirainen tss@iki.fi wrote:
On 18.7.2010, at 20.40, Brandon Lamb wrote:
So I switched mysql back to sending full path for home, and maildir:~/maildir and mdbox:~/mdbox for my two test accounts. Imap works just fine, it seems like just lda doesnt understand the returned mail field
What does lda log with mail_debug=yes and auth_debug=yes?
Nothing, thats why Im scratching my head... If I return "maildir:~/maildir" or "maildir:~/fullpath" NOTHING is logged, but exim logs the error about no file or directory. But if I return just fullpath for mail, then it delivers mail AND logs debugging. seems like maybe it bails out before writing a log or something.
On 18.7.2010, at 19.57, Brandon Lamb wrote:
In my exim log i just see these 2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index
Actually, there is no such error message in Dovecot code. It's exim that logs this error..
On Sun, Jul 18, 2010 at 1:02 PM, Timo Sirainen tss@iki.fi wrote:
On 18.7.2010, at 19.57, Brandon Lamb wrote:
In my exim log i just see these 2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index
Actually, there is no such error message in Dovecot code. It's exim that logs this error..
Right but that means exim is talking to dovecot-lda because it is getting the maildir:~/maildir value, no way exim could no that unless dovecot told it. So then there SHOULD be a log in debug or deliver from lda if exim got that showing *something* right?
On 18.7.2010, at 21.28, Brandon Lamb wrote:
On Sun, Jul 18, 2010 at 1:02 PM, Timo Sirainen tss@iki.fi wrote:
On 18.7.2010, at 19.57, Brandon Lamb wrote:
In my exim log i just see these 2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index
Actually, there is no such error message in Dovecot code. It's exim that logs this error..
Right but that means exim is talking to dovecot-lda because it is getting the maildir:~/maildir value, no way exim could no that unless dovecot told it. So then there SHOULD be a log in debug or deliver from lda if exim got that showing *something* right?
Or is it possible that Exim looks up mail field as a home directory from the database? I think this error happens before dovecot-lda is even run (it's chdiring before running it).
On Sun, Jul 18, 2010 at 1:33 PM, Timo Sirainen tss@iki.fi wrote:
On 18.7.2010, at 21.28, Brandon Lamb wrote:
On Sun, Jul 18, 2010 at 1:02 PM, Timo Sirainen tss@iki.fi wrote:
On 18.7.2010, at 19.57, Brandon Lamb wrote:
In my exim log i just see these 2010-07-18 11:51:08 1OaYOJ-0003Vn-2P == brandon@olypen.com R=router_pop T=dovecot_deliver defer (2): No such file or directory: failed to chdir to maildir:~/maildir:INDEX=~/maildir/dovecot-index
Actually, there is no such error message in Dovecot code. It's exim that logs this error..
Right but that means exim is talking to dovecot-lda because it is getting the maildir:~/maildir value, no way exim could no that unless dovecot told it. So then there SHOULD be a log in debug or deliver from lda if exim got that showing *something* right?
Or is it possible that Exim looks up mail field as a home directory from the database? I think this error happens before dovecot-lda is even run (it's chdiring before running it).
But I thought exim just pipes the mail to dovecot-lda and then dovecot-lda looks up the user info, home and mail location and actually writes the file, exim doesnt do any database lookups or am I totally in the dark?
OH! Well damn, look I have a router_home_directory, so... hm, do I assume exim passes this to dovecot-lda somehow as an environment variable or something?
I swear I looked at this like 50 times last night...
router_pop: debug_print= "R: dovecot_deliver for $local_part@$domain" driver = accept transport = dovecot_deliver local_parts = mysql; SELECT username FROM SQL_AUTH LEFT JOIN (SQL_POP) ON (SQL_POP.user_id = SQL_AUTH.user_id) WHERE username = '${quote_mysql:$local_part}' AND domain = (SELECT IF( STRCMP('', '${quote_mysql:$domain}'), '${quote_mysql:$domain}', 'olypen.com') ) AND SQL_POP.status != 'disabled' router_home_directory = ${lookup mysql {SELECT SQL_POP.maildir FROM SQL_AUTH LEFT JOIN (SQL_POP) ON (SQL_POP.user_id = SQL_AUTH.user_id) WHERE username = '${quote_mysql:$local_part}' AND domain = '${quote_mysql:$domain}' LIMIT 1}} user = 8 group = 8
Or is it possible that Exim looks up mail field as a home directory from the database? I think this error happens before dovecot-lda is even run (it's chdiring before running it).
But I thought exim just pipes the mail to dovecot-lda and then dovecot-lda looks up the user info, home and mail location and actually writes the file, exim doesnt do any database lookups or am I totally in the dark?
OH! Well damn, look I have a router_home_directory, so... hm, do I assume exim passes this to dovecot-lda somehow as an environment variable or something?
I swear I looked at this like 50 times last night...
router_pop: debug_print= "R: dovecot_deliver for $local_part@$domain" driver = accept transport = dovecot_deliver local_parts = mysql; SELECT username FROM SQL_AUTH LEFT JOIN (SQL_POP) ON (SQL_POP.user_id = SQL_AUTH.user_id) WHERE username = '${quote_mysql:$local_part}' AND domain = (SELECT IF( STRCMP('', '${quote_mysql:$domain}'), '${quote_mysql:$domain}', 'olypen.com') ) AND SQL_POP.status != 'disabled' router_home_directory = ${lookup mysql {SELECT SQL_POP.maildir FROM SQL_AUTH LEFT JOIN (SQL_POP) ON (SQL_POP.user_id = SQL_AUTH.user_id) WHERE username = '${quote_mysql:$local_part}' AND domain = '${quote_mysql:$domain}' LIMIT 1}} user = 8 group = 8
Look its MAGIC! Removed the route_home_directory line and BAM! I have my mail! Dood you rock! I seriously need to buy one of those dinner bells to ring at work for stuff like this that has been a 5 hour struggle =P
On Sun, Jul 18, 2010 at 1:40 PM, Brandon Lamb brandonlamb@gmail.com wrote:
Or is it possible that Exim looks up mail field as a home directory from the database? I think this error happens before dovecot-lda is even run (it's chdiring before running it).
But I thought exim just pipes the mail to dovecot-lda and then dovecot-lda looks up the user info, home and mail location and actually writes the file, exim doesnt do any database lookups or am I totally in the dark?
OH! Well damn, look I have a router_home_directory, so... hm, do I assume exim passes this to dovecot-lda somehow as an environment variable or something?
I swear I looked at this like 50 times last night...
router_pop: debug_print= "R: dovecot_deliver for $local_part@$domain" driver = accept transport = dovecot_deliver local_parts = mysql; SELECT username FROM SQL_AUTH LEFT JOIN (SQL_POP) ON (SQL_POP.user_id = SQL_AUTH.user_id) WHERE username = '${quote_mysql:$local_part}' AND domain = (SELECT IF( STRCMP('', '${quote_mysql:$domain}'), '${quote_mysql:$domain}', 'olypen.com') ) AND SQL_POP.status != 'disabled' router_home_directory = ${lookup mysql {SELECT SQL_POP.maildir FROM SQL_AUTH LEFT JOIN (SQL_POP) ON (SQL_POP.user_id = SQL_AUTH.user_id) WHERE username = '${quote_mysql:$local_part}' AND domain = '${quote_mysql:$domain}' LIMIT 1}} user = 8 group = 8
Look its MAGIC! Removed the route_home_directory line and BAM! I have my mail! Dood you rock! I seriously need to buy one of those dinner bells to ring at work for stuff like this that has been a 5 hour struggle =P
You may want to add some hint about this on the wiki, something to the effect of watching whether your router passes a home directory if you are expecting the userdb field to be used, etc
participants (2)
-
Brandon Lamb
-
Timo Sirainen