Hi All, So I got virtual users working for the most part except for the aliases. any time I try to do an alias lookup I get greeted with a -1 error instead of a 0. If I take my query that i have for query_alias and manually run it in the sqlite client it pulls back what i expect, one entry containing my alias. But when SMTPD does it nothing just fails the lookup with a -1 and gives me a 431 temporary failure error message. below is some data for this.
Log output with lookup and filter tracing on: Apr 16 14:38:46 mail2 smtpd[24701]: smtp-in: New session 67d256e2fd9ef297 from host c-76-121-216-163.hsd1.wa.comcast.net [76.121.216.163] Apr 16 14:38:46 mail2 smtpd[1810]: filter: new query QT_EVENT EVENT_CONNECT Apr 16 14:38:46 mail2 smtpd[1810]: filter: draining query 4740730183c5d8de[QT_EVENT,EVENT_CONNECT] Apr 16 14:38:46 mail2 smtpd[1810]: filter: freeing query 4740730183c5d8de Apr 16 14:38:46 mail2 smtpd[1810]: filter: new query QT_QUERY QUERY_CONNECT Apr 16 14:38:46 mail2 smtpd[1810]: filter: draining query 474073022f15b351[QT_QUERY,QUERY_CONNECT=198.204.239.219 <-> 76.121.216.163( c-76-121-216-163.hsd1.wa.comcast.net)] Apr 16 14:38:46 mail2 smtpd[1810]: filter: query 474073022f15b351 done: status=MFA_OK code=0 response="(null)" Apr 16 14:38:46 mail2 smtpd[1810]: filter: freeing query 474073022f15b351 Apr 16 14:38:46 mail2 smtpd[1810]: filter: new query QT_QUERY QUERY_HELO Apr 16 14:38:46 mail2 smtpd[1810]: filter: draining query 47407303a309a0ae[QT_QUERY,QUERY_HELO=[192.168.2.6]] Apr 16 14:38:46 mail2 smtpd[1810]: filter: query 47407303a309a0ae done: status=MFA_OK code=0 response="(null)" Apr 16 14:38:46 mail2 smtpd[1810]: filter: freeing query 47407303a309a0ae Apr 16 14:38:47 mail2 smtpd[24701]: smtp-in: No PKI entry for requested SNI "mail2.serversave.us"on session 67d256e2fd9ef297 Apr 16 14:38:47 mail2 smtpd[24701]: smtp-in: Started TLS on session 67d256e2fd9ef297: version=TLSv1/SSLv3, cipher=ECDHE-RSA-AES128-SHA, bits=128 Apr 16 14:38:47 mail2 smtpd[1810]: filter: new query QT_QUERY QUERY_HELO Apr 16 14:38:47 mail2 smtpd[1810]: filter: draining query 47407304312f81ad[QT_QUERY,QUERY_HELO=[192.168.2.6]] Apr 16 14:38:47 mail2 smtpd[1810]: filter: query 47407304312f81ad done: status=MFA_OK code=0 response="(null)" Apr 16 14:38:47 mail2 smtpd[1810]: filter: freeing query 47407304312f81ad Apr 16 14:38:47 mail2 smtpd[24701]: smtp-in: Accepted authentication for user kusuriya on session 67d256e2fd9ef297 Apr 16 14:38:47 mail2 smtpd[1810]: filter: new query QT_QUERY QUERY_MAIL Apr 16 14:38:47 mail2 smtpd[1810]: filter: draining query 47407305fe2ee56b[QT_QUERY,[email protected]] Apr 16 14:38:47 mail2 smtpd[1810]: filter: query 47407305fe2ee56b done: status=MFA_OK code=0 response="(null)" Apr 16 14:38:47 mail2 smtpd[1810]: filter: freeing query 47407305fe2ee56b Apr 16 14:38:47 mail2 smtpd[1810]: filter: new query QT_QUERY QUERY_RCPT Apr 16 14:38:47 mail2 smtpd[1810]: filter: draining query 474073069cc2b934[QT_QUERY,[email protected]] Apr 16 14:38:47 mail2 smtpd[1810]: filter: query 474073069cc2b934 done: status=MFA_OK code=0 response="(null)" Apr 16 14:38:47 mail2 smtpd[1810]: filter: freeing query 474073069cc2b934 Apr 16 14:38:47 mail2 smtpd[23142]: lookup: check "local" as NETADDR in table static:<anyhost> -> found Apr 16 14:38:47 mail2 smtpd[23142]: lookup: check "serversave.us" as DOMAIN in table proc:domains -> found Apr 16 14:38:47 mail2 smtpd[23142]: lookup: lookup "jabarb" as ALIAS in table proc:aliased -> -1 Apr 16 14:38:47 mail2 smtpd[24701]: smtp-in: Failed command on session 67d256e2fd9ef297: "RCPT TO:<[email protected]>" => 451 Temporary failure Apr 16 14:38:49 mail2 smtpd[24701]: smtp-in: Closing session 67d256e2fd9ef297 Apr 16 14:38:49 mail2 smtpd[1810]: filter: new query QT_EVENT EVENT_DISCONNECT Apr 16 14:38:49 mail2 smtpd[1810]: filter: draining query 47407307d5625a33[QT_EVENT,EVENT_DISCONNECT] Apr 16 14:38:49 mail2 smtpd[1810]: filter: freeing query 47407307d5625a33 sqlite config: # Path to database # dbpath /etc/mail/authdb.sqlite # Alias lookup query # # rows >= 0 # fields == 1 (user varchar) # query_alias select alias from alias where user=?; # Domain lookup query # # rows == 1 # fields == 1 (domain varchar) # query_domain select domain from domains where domain=? and active="Y"; # User lookup query # # rows == 1 # fields == 3 (uid int, gid int, directory varchar) # query_userinfo select uid,gid,home from users where username=? and active="Y"; # Credentials lookup query # # rows == 1 # fields == 2 (username varchar, password varchar) # query_credentials select username, password from users where username=? and active="Y"; SMTPD.conf: pki mail.serversave.us certificate "/etc/ssl/mail.serversave.us.crt" pki mail.serversave.us key "/etc/ssl/private/mail.serversave.us.key" listen on all tls pki mail.serversave.us hostname mail.serversave.us listen on all port submission tls-require auth pki mail.serversave.usmask-source table domains sqlite:/etc/mail/sqlite table users sqlite:/etc/mail/sqlite table aliased sqlite:/etc/mail/sqlite accept from any for domain <domains> alias <aliased> userbase <users> deliver to \ lmtp "/var/dovecot/lmtp" accept for any relay hostname mail.serversave.us -- Jason Barbier | [email protected] Pro Patria Vigilans
