Lines Matching refs:fd
39 greylist_check(unsigned int fd) in greylist_check() argument
43 logmessage("DEBUG: fd: %d checking greylist\n", fd); in greylist_check()
46 mysql_array[fd][0] = -2; in greylist_check()
47 mysql_optarray[fd][0] = OPTINOUTALL; in greylist_check()
54 snprintf(mysqlquery_array[fd], 512, in greylist_check()
56 triplet_array[fd][2], host_array[fd][9]); in greylist_check()
57 if(db_optquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
60 if(mysql_optarray[fd][0] == 0) in greylist_check()
64 host_array[fd][2], /* host address */ in greylist_check()
65 host_array[fd][0], /* hostname */ in greylist_check()
66 triplet_array[fd][1], /* sender */ in greylist_check()
67 triplet_array[fd][2], /* recipient */ in greylist_check()
68 triplet_array[fd][3]); /* size */ in greylist_check()
79 snprintf(mysqlquery_array[fd], 512, in greylist_check()
81 triplet_array[fd][2], host_array[fd][9]); in greylist_check()
82 if(db_optquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
85 if(mysql_optarray[fd][0] >= 1) in greylist_check()
86 mysql_optarray[fd][0] = 2; in greylist_check()
91 snprintf(mysqlquery_array[fd], 512, in greylist_check()
93 triplet_array[fd][0], triplet_array[fd][1], triplet_array[fd][2]); in greylist_check()
94 if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
98 snprintf(xgreylist_array[fd], 128, "%s host: %s count: %d size: %s\n\n", in greylist_check()
99 POSTFIX_X_HEADER, host_array[fd][2], mysql_array[fd][0], triplet_array[fd][3]); in greylist_check()
103 if(mysql_array[fd][0]==-2) in greylist_check()
106 snprintf(mysqlquery_array[fd], 512, in greylist_check()
108 timenow, timenow, triplet_array[fd][0], triplet_array[fd][1], triplet_array[fd][2]); in greylist_check()
109 if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
116 snprintf(mysqlquery_array[fd], 512, in greylist_check()
118 triplet_array[fd][0]); in greylist_check()
119 if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
122 logmessage("DEBUG: fd: %d unauth triplet: %d\n", fd, mysql_array[fd][0]); in greylist_check()
125 if(mysql_array[fd][0] >= AUTO_BLACKLIST_NUMBER) in greylist_check()
136 snprintf(mysqlquery_array[fd], 512, in greylist_check()
138 triplet_array[fd][0], expire); in greylist_check()
140 snprintf(mysqlquery_array[fd], 512, in greylist_check()
142 host_array[fd][2], expire); in greylist_check()
145 if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
149 host_array[fd][2], /* host address */ in greylist_check()
150 host_array[fd][0], /* hostname */ in greylist_check()
151 triplet_array[fd][1], /* sender */ in greylist_check()
152 triplet_array[fd][2], /* recipient */ in greylist_check()
153 triplet_array[fd][3], /* size */ in greylist_check()
157 snprintf(mysqlquery_array[fd], 512, in greylist_check()
158 "DELETE QUICK from triplet WHERE _host='%s'", triplet_array[fd][0]); in greylist_check()
159 if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
168 if((TRAINING_MODE == 0) && (mysql_optarray[fd][0] != 2)) in greylist_check()
172 host_array[fd][2], /* host address */ in greylist_check()
173 host_array[fd][0], /* hostname */ in greylist_check()
174 triplet_array[fd][1], /* sender */ in greylist_check()
175 triplet_array[fd][2], /* recipient */ in greylist_check()
176 triplet_array[fd][3]); /* size */ in greylist_check()
183 if((TRAINING_MODE == 1) || (mysql_optarray[fd][0] == 2)) in greylist_check()
187 host_array[fd][2], /* host */ in greylist_check()
188 host_array[fd][0], /* hostname */ in greylist_check()
189 triplet_array[fd][1], /* from */ in greylist_check()
190 triplet_array[fd][2], /* rcpt */ in greylist_check()
191 triplet_array[fd][3] /* size */ in greylist_check()
201 if(timenow < (unsigned int)(mysql_array[fd][1]+TRIPLET_TIME)) in greylist_check()
204 if((TRAINING_MODE == 0) && (mysql_optarray[fd][0] != 2)) in greylist_check()
208 host_array[fd][2], /* host address */ in greylist_check()
209 host_array[fd][0], /* hostname */ in greylist_check()
210 triplet_array[fd][1], /* sender */ in greylist_check()
211 triplet_array[fd][2], /* recipient */ in greylist_check()
212 triplet_array[fd][3]); /* size */ in greylist_check()
233 snprintf(mysqlquery_array[fd], 512, in greylist_check()
235 triplet_array[fd][0]); in greylist_check()
236 if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
239 logmessage("DEBUG: fd: %d whitelist result: %d\n", fd, mysql_array[fd][0]); in greylist_check()
241 if(mysql_array[fd][0] >= AUTO_WHITELIST_NUMBER) in greylist_check()
251 snprintf(mysqlquery_array[fd], 512, in greylist_check()
253 triplet_array[fd][0], expire); in greylist_check()
256 snprintf(mysqlquery_array[fd], 512, in greylist_check()
258 host_array[fd][2], expire); in greylist_check()
260 if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
263 snprintf(mysqlquery_array[fd], 512, in greylist_check()
264 "DELETE QUICK from triplet WHERE _host='%s'", triplet_array[fd][0]); in greylist_check()
265 if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
269 host_array[fd][2], /* host address */ in greylist_check()
270 host_array[fd][0], /* hostname */ in greylist_check()
271 triplet_array[fd][1], /* sender */ in greylist_check()
272 triplet_array[fd][2], /* recipient */ in greylist_check()
273 triplet_array[fd][3], /* size */ in greylist_check()
282 snprintf(mysqlquery_array[fd], 512, in greylist_check()
284 timenow, triplet_array[fd][0], triplet_array[fd][1], triplet_array[fd][2]); in greylist_check()
285 if(db_doquery(fd) == -1) return(db_failure(fd, "greylist")); in greylist_check()
288 if((TRAINING_MODE == 0) && (mysql_optarray[fd][0] != 2)) in greylist_check()
293 host_array[fd][2], /* host address */ in greylist_check()
294 host_array[fd][0], /* hostname */ in greylist_check()
295 triplet_array[fd][1], /* sender */ in greylist_check()
296 triplet_array[fd][2], /* recipient */ in greylist_check()
297 triplet_array[fd][3]); /* size */ in greylist_check()
301 if((TRAINING_MODE == 1) || (mysql_optarray[fd][0] == 2)) in greylist_check()
306 host_array[fd][2], /* host address */ in greylist_check()
307 host_array[fd][0], /* hostname */ in greylist_check()
308 triplet_array[fd][1], /* sender */ in greylist_check()
309 triplet_array[fd][2], /* recipient */ in greylist_check()
310 triplet_array[fd][3]); /* size */ in greylist_check()