Just setup greylisting on one of my servers and I noticed that the
greylisting-delete-expired.sh file can be simplified from

mysql -h $MYSQLHOST -u $MYSQLUSER -p$MYSQLPASS $MYSQLDB -e "delete FROM
relaytofrom WHERE origin_type = \"AUTO\" and ( unix_timestamp(  )-
unix_timestamp( record_expires )  >0 )"

to

mysql -h $MYSQLHOST -u $MYSQLUSER -p$MYSQLPASS $MYSQLDB -e "delete FROM
relaytofrom WHERE origin_type = \"AUTO\" and record_expires < NOW()"

Im not sure off hand if this will work on versions below mysql 4, but I
doubt there are too many 3.23 servers left out there these days. I have
this crond to fire every 5 minutes and its working very well.

Shane

Reply via email to