diff -ur postfix-policyd-1.80/blacklist_helo.c postfix-policyd-1.80-patched/blacklist_helo.c --- postfix-policyd-1.80/blacklist_helo.c 2006-07-03 15:23:33.000000000 +0200 +++ postfix-policyd-1.80-patched/blacklist_helo.c 2009-08-09 01:16:12.000000000 +0200 @@ -70,12 +70,12 @@ { /* build up query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO blacklist (_blacklist,_description,_expire) VALUES ('%s.%%','# blacklisted helo: (%s)',%d)", + "INSERT INTO blacklist (_blacklist,_description,_expire) VALUES ('%s.%%','# blacklisted helo: (%s)',%d)", host_array[fd][2], triplet_array[fd][5], expire); } else { /* blacklist host ip */ /* build up query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# blacklisted helo: (%s)',%d)", + "INSERT INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# blacklisted helo: (%s)',%d)", host_array[fd][2], triplet_array[fd][5], expire); } /* execute query */ diff -ur postfix-policyd-1.80/greylist.c postfix-policyd-1.80-patched/greylist.c --- postfix-policyd-1.80/greylist.c 2006-07-03 15:22:38.000000000 +0200 +++ postfix-policyd-1.80-patched/greylist.c 2009-08-09 01:16:34.000000000 +0200 @@ -104,7 +104,7 @@ { /* build up & execute query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO triplet (_datenew,_datelast,_host,_from,_rcpt) VALUES (%d,%d,'%s','%s','%s')", + "INSERT INTO triplet (_datenew,_datelast,_host,_from,_rcpt) VALUES (%d,%d,'%s','%s','%s')", timenow, timenow, triplet_array[fd][0], triplet_array[fd][1], triplet_array[fd][2]); if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); @@ -134,11 +134,11 @@ if(BLACKLIST_NETBLOCK==1) { /* blacklist netblock */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO blacklist (_blacklist,_description,_expire) VALUES ('%s.%%','# autoblacklisted', %d)", + "INSERT INTO blacklist (_blacklist,_description,_expire) VALUES ('%s.%%','# autoblacklisted', %d)", triplet_array[fd][0], expire); } else { /* blacklist host ip */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# autoblacklisted',%d)", + "INSERT INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# autoblacklisted',%d)", host_array[fd][2], expire); } /* execute query */ @@ -249,12 +249,12 @@ { /* build up & execute query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO whitelist (_whitelist,_description,_expire) VALUES ('%s.%%','# autowhitelisted host',%d)", + "INSERT INTO whitelist (_whitelist,_description,_expire) VALUES ('%s.%%','# autowhitelisted host',%d)", triplet_array[fd][0], expire); } else { /* build up & execute query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO whitelist (_whitelist,_description,_expire) VALUES ('%s','# autowhitelisted host',%d)", + "INSERT INTO whitelist (_whitelist,_description,_expire) VALUES ('%s','# autowhitelisted host',%d)", host_array[fd][2], expire); } if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); diff -ur postfix-policyd-1.80/helo.c postfix-policyd-1.80-patched/helo.c --- postfix-policyd-1.80/helo.c 2006-06-19 09:12:34.000000000 +0200 +++ postfix-policyd-1.80-patched/helo.c 2009-08-09 01:16:48.000000000 +0200 @@ -71,7 +71,7 @@ /* build up query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# helo abuse',%d)", + "INSERT INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# helo abuse',%d)", host_array[fd][2], expire); if(db_doquery(fd) == -1) return(db_failure(fd, "helo")); @@ -118,7 +118,7 @@ /* build up query & execute */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO helo (_host,_helo,_expire) VALUES ('%s','%s',%d)", + "INSERT INTO helo (_host,_helo,_expire) VALUES ('%s','%s',%d)", host_array[fd][2], triplet_array[fd][5], expire); if(db_doquery(fd) == -1) return(db_failure(fd, "helo")); } diff -ur postfix-policyd-1.80/spamtrap.c postfix-policyd-1.80-patched/spamtrap.c --- postfix-policyd-1.80/spamtrap.c 2006-07-03 15:22:51.000000000 +0200 +++ postfix-policyd-1.80-patched/spamtrap.c 2009-08-09 01:16:56.000000000 +0200 @@ -68,12 +68,12 @@ { /* build up query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# spamtrap delivery: (%s)',%d)", + "INSERT INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# spamtrap delivery: (%s)',%d)", host_array[fd][3], triplet_array[fd][2], expire); } else { /* blacklist host ip */ /* build up query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# spamtrap delivery: (%s)',%d)", + "INSERT INTO blacklist (_blacklist,_description,_expire) VALUES ('%s','# spamtrap delivery: (%s)',%d)", host_array[fd][2], triplet_array[fd][2], expire); } /* execute query */ diff -ur postfix-policyd-1.80/throttle_from.c postfix-policyd-1.80-patched/throttle_from.c --- postfix-policyd-1.80/throttle_from.c 2006-06-28 12:41:37.000000000 +0200 +++ postfix-policyd-1.80-patched/throttle_from.c 2009-08-09 01:17:05.000000000 +0200 @@ -63,7 +63,7 @@ /* build up & execute query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO throttle " + "INSERT INTO throttle " "(_date,_from,_quota_cur,_quota_max,_rcpt_max,_mail_size,_count_max,_time_limit)" " VALUES (%d, '%s', %d, %ld, %ld, %ld, %ld, %ld)", timenow, @@ -199,7 +199,7 @@ expire=timenow+SENDER_THROTTLE_AUTOBLACKLIST_EXPIRE; snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO blacklist_sender (_blacklist,_description,_expire) " + "INSERT INTO blacklist_sender (_blacklist,_description,_expire) " "VALUES ('%s','# sender throttle autoblacklisted',%d)", mysqlchar_array[fd][0], expire); diff -ur postfix-policyd-1.80/throttle_host.c postfix-policyd-1.80-patched/throttle_host.c --- postfix-policyd-1.80/throttle_host.c 2006-06-28 12:41:37.000000000 +0200 +++ postfix-policyd-1.80-patched/throttle_host.c 2009-08-09 01:17:17.000000000 +0200 @@ -63,7 +63,7 @@ /* build up & execute query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO throttle " + "INSERT INTO throttle " "(_date,_from,_quota_cur,_quota_max,_rcpt_max,_mail_size,_count_max,_time_limit)" " VALUES (%d, '%s', %d, %ld, %ld, %ld, %ld, %ld)", timenow, @@ -199,7 +199,7 @@ expire=timenow+SENDER_THROTTLE_AUTOBLACKLIST_EXPIRE; snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO blacklist (_blacklist,_description,_expire) " + "INSERT INTO blacklist (_blacklist,_description,_expire) " "VALUES ('%s','# sender throttle autoblacklisted',%d)", mysqlchar_array[fd][0], expire); diff -ur postfix-policyd-1.80/throttle_rcpt.c postfix-policyd-1.80-patched/throttle_rcpt.c --- postfix-policyd-1.80/throttle_rcpt.c 2006-05-04 12:55:40.000000000 +0200 +++ postfix-policyd-1.80-patched/throttle_rcpt.c 2009-08-09 01:17:27.000000000 +0200 @@ -85,7 +85,7 @@ /* build up & execute query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO throttle_rcpt (_date,_rcpt,_count_max,_time_limit) " + "INSERT INTO throttle_rcpt (_date,_rcpt,_count_max,_time_limit) " "VALUES (%d, '%s', %ld, %ld)", timenow, triplet_array[fd][2], diff -ur postfix-policyd-1.80/throttle_sasl.c postfix-policyd-1.80-patched/throttle_sasl.c --- postfix-policyd-1.80/throttle_sasl.c 2006-04-04 16:39:57.000000000 +0200 +++ postfix-policyd-1.80-patched/throttle_sasl.c 2009-08-09 01:17:36.000000000 +0200 @@ -64,7 +64,7 @@ /* build up & execute query */ snprintf(mysqlquery_array[fd], 512, - "INSERT DELAYED INTO throttle " + "INSERT INTO throttle " "(_date,_from,_quota_cur,_quota_max,_rcpt_max,_mail_size,_count_max, _time_limit)" " VALUES (%d, '%s', %d, %ld, %ld, %ld, %ld, %ld)", timenow,