I have "%-out-%.google.com" in my whitelist_dnsname table to whitelist gmail. I periodically get complaints that a gmail user was blacklisted.
To track it down, I added some debugging code to log the queries and results. At this point, it looks like mysql is returning incorrect results, which I find very hard to believe. Here are some sample logs: Mar 3 21:13:53 <host> postfix-policyd-sf: Query: SELECT COUNT(*) FROM whitelist_dnsname WHERE 'ug-out-1314.google.com' LIKE _whitelist Mar 3 21:13:53 <host> postfix-policyd-sf: num_fields=1, mysql_row="1" Mar 3 21:14:43 <host> postfix-policyd-sf: Query: SELECT COUNT(*) FROM whitelist_dnsname WHERE 'ug-out-1314.google.com' LIKE _whitelist Mar 3 21:14:43 <host> postfix-policyd-sf: num_fields=1, mysql_row="0" Mar 3 21:18:14 <host> postfix-policyd-sf: Query: SELECT COUNT(*) FROM whitelist_dnsname WHERE 'ug-out-1314.google.com' LIKE _whitelist Mar 3 21:18:14 <host> postfix-policyd-sf: num_fields=1, mysql_row="1" It happens infrequently, less than once per day, but I am getting calls about it. It is very perplexing. Any ideas? Thanks, Dan PS I'm running policyd 1.82 and Mysql 5.0. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ policyd-users mailing list policyd-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/policyd-users
