Best way to start amavisd-snmp-subagent?

[Benedict White via amavis-users]

________________________________________
From: Deeztek Support [support at deeztek.com]
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 " sender at outsidedomain.tld", 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, " sender at outsidedomain.tld" no match
>Aug 23 14:33:58.803 smtp.deeztek.com /usr/sbin/amavisd-new[8482]:
>(08482-01) lookup_sql_field(wb), " sender at outsidedomain.tld" 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