________________________________________ From: Deeztek Support [[email protected]] Sent: 23 August 2013 20:10 To: Benedict White Cc: amavis-users Subject: Re: Best way to start amavisd-snmp-subagent?
------------------------- START LOG ---------------------- >Aug 23 14:33:58.803 smtp.deeztek.com /usr/sbin/amavisd-new[8482]: >(08482-01) lookup_sql " [email protected]", query args: "7", >"ARRAY(0xbf385e8)", "ARRAY(0xbf23950)", "ARRAY(0xbf37ef8)", >"ARRAY(0xbf23740)", "ARRAY(0xbf34ed0)" >Aug 23 14:33:58.803 smtp.deeztek.com /usr/sbin/amavisd-new[8482]: >(08482-01) lookup_sql select: SELECT wb FROM wblist,mailaddr WHERE >(wblist.rid=?) AND (wblist.sid=mailaddr.id) AND (mailaddr.email IN >(?,?,?,?,?)) ORDER BY mailaddr.priority DESC >Aug 23 14:33:58.803 smtp.deeztek.com /usr/sbin/amavisd-new[8482]: >(08482-01) sql begin, nontransaction >Aug 23 14:33:58.803 smtp.deeztek.com /usr/sbin/amavisd-new[8482]: >(08482-01) sql: preparing and executing: SELECT wb FROM wblist,mailaddr >WHERE (wblist.rid=?) AND (wblist.sid=mailaddr.id) AND (mailaddr.email IN >(?,?,?,?,?)) ORDER BY mailaddr.priority DESC >Aug 23 14:33:58.803 smtp.deeztek.com /usr/sbin/amavisd-new[8482]: >(08482-01) lookup_sql, " [email protected]" no match >Aug 23 14:33:58.803 smtp.deeztek.com /usr/sbin/amavisd-new[8482]: >(08482-01) lookup_sql_field(wb), " [email protected]" no matching >records > >------------------ END LOG ------------------------ The key thing to fix is the "no matching records" Can you export the mailaddr and wblist tables? Sounds daft but the problem has to be lurking somewhere. Kind regards Benedict White
