I followed the virtual-users-domains-postfix-courier-mysql-squirrelmail-debian-lenny tutorial sans the quota parts. When an email is sent to my server, it is delivered to /home/vmail/Maildir (a file; not directory). The directory /home/vmail/domain/user/Maildir exists. Here is the log file of sending an email from Yahoo.com to Example.com (my domain). Code: Jun 28 23:37:53 ariel postfix/smtpd[11978]: connect from web80012.mail.sp1.yahoo.com[69.147.92.118] Jun 28 23:37:53 ariel postfix/smtpd[11978]: 4E554C618: client=web80012.mail.sp1.yahoo.com[69.147.92.118] Jun 28 23:37:53 ariel postfix/cleanup[11983]: 4E554C618: message-id=<[email protected]> Jun 28 23:37:53 ariel postfix/qmgr[7003]: 4E554C618: from=<[email protected]>, size=1408, nrcpt=1 (queue active) Jun 28 23:37:53 ariel postfix/smtpd[11978]: disconnect from web80012.mail.sp1.yahoo.com[69.147.92.118] Jun 28 23:37:58 ariel postfix/smtpd[12000]: connect from localhost[127.0.0.1] Jun 28 23:37:58 ariel postfix/smtpd[12000]: CF2A8C9B8: client=localhost[127.0.0.1] Jun 28 23:37:58 ariel postfix/cleanup[11983]: CF2A8C9B8: message-id=<[email protected]> Jun 28 23:37:59 ariel postfix/qmgr[7003]: CF2A8C9B8: from=<[email protected]>, size=2059, nrcpt=1 (queue active) Jun 28 23:37:59 ariel postfix/smtpd[12000]: disconnect from localhost[127.0.0.1] Jun 28 23:37:59 ariel amavis[1693]: (01693-04) Passed CLEAN, [69.147.92.118] [71.15.152.135] <[email protected]> -> <[email protected]>, Message-ID: <[email protected]>, mail_id: evlrqYZVK7oa, Hits: 5.75, size: 1406, queued_as: CF2A8C9B8, 5410 ms Jun 28 23:37:59 ariel authdaemond: received userid lookup request: [email protected] Jun 28 23:37:59 ariel authdaemond: authmysql: trying this module Jun 28 23:37:59 ariel postfix/smtp[11986]: 4E554C618: to=<[email protected]>, relay=127.0.0.1[127.0.0.1]:10024, delay=5.8, delays=0.41/0.01/0/5.4, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=01693-04, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as CF2A8C9B8) Jun 28 23:37:59 ariel postfix/qmgr[7003]: 4E554C618: removed Jun 28 23:37:59 ariel authdaemond: authmysqllib: connected. Versions: header 50051, client 50051, server 50051 Jun 28 23:37:59 ariel authdaemond: SQL query: SELECT email, password, "", 5001, 5001, "/home/vmail", CONCAT('/home/vmail/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "", "", "" FROM users WHERE email = '[email protected]' Jun 28 23:37:59 ariel authdaemond: Authenticated: sysusername=<null>, sysuserid=5001, sysgroupid=5001, homedir=/home/vmail, [email protected], fullname=<null>, maildir=/home/vmail/example.com/xxxxxxxx/, quota=<null>, options=<null> Jun 28 23:37:59 ariel authdaemond: Authenticated: clearpasswd=<null>, passwd=B79FZcQAC9Vjf72A9 Jun 28 23:38:00 ariel postfix/pipe[12001]: CF2A8C9B8: to=<[email protected]>, relay=maildrop, delay=1.2, delays=0.19/0.01/0/1, dsn=2.0.0, status=sent (delivered via maildrop service) Jun 28 23:38:00 ariel postfix/qmgr[7003]: CF2A8C9B8: removed postconf -n Code: alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases append_dot_mydomain = no biff = no broken_sasl_auth_clients = yes config_directory = /etc/postfix content_filter = amavis:[127.0.0.1]:10024 inet_interfaces = all mailbox_size_limit = 0 message_size_limit = 30720000 mydestination = $myhostname, localhost mydomain = example.com myhostname = mail.example.com mynetworks = 127.0.0.0/8 myorigin = /etc/mailname proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks #$virtual_mailbox_limit_maps readme_directory = no recipient_delimiter = + relayhost = smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU) smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination smtpd_sasl_auth_enable = yes smtpd_sasl_authenticated_header = yes smtpd_tls_cert_file = /etc/postfix/smtpd.cert smtpd_tls_key_file = /etc/postfix/smtpd.key smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache smtpd_use_tls = yes transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf virtual_alias_domains = virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf virtual_gid_maps = static:5001 virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf virtual_transport = maildrop virtual_uid_maps = static:5001 authmysqlrc Code: MYSQL_SERVER localhost MYSQL_USERNAME MYUSER MYSQL_PASSWORD MYPASSWORD MYSQL_PORT 0 MYSQL_DATABASE mail MYSQL_USER_TABLE users MYSQL_CRYPT_PWFIELD password #MYSQL_CLEAR_PWFIELD password MYSQL_UID_FIELD 5001 MYSQL_GID_FIELD 5001 MYSQL_LOGIN_FIELD email MYSQL_HOME_FIELD "/home/vmail/" MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') #MYSQL_NAME_FIELD #MYSQL_QUOTA_FIELD quota I also tried MYSQL_MAILDIR_FIELD CONCAT('/home/vmail/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
After some more tinkering, it seems to be working now, and mutt finally sees it I removed courier-maildrop package and replaced it with maildrop to see what is the difference between the two. I was getting s_connect() errors with it, so I re-installed courier-maildrop. I also fiddled with the authmysqlrc some too Code: MYSQL_SERVER localhost MYSQL_USERNAME mail_admin MYSQL_PASSWORD mail_admin_password MYSQL_PORT 0 MYSQL_DATABASE mail MYSQL_USER_TABLE users MYSQL_CRYPT_PWFIELD password MYSQL_UID_FIELD 5001 MYSQL_GID_FIELD 5001 MYSQL_LOGIN_FIELD email MYSQL_HOME_FIELD CONCAT('/home/vmail/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') MYSQL_MAILDIR_FIELD "Maildir"
