Benny Pedersen wrote: > > Will it be a performence bottleneck? What will happen if i delete all > > records in these two table? > > cleanup cronned pr hour ? > > show greylist/helo settings in policyd.conf
Thanks Benny. :) My crontab got some problem, i run it manually before, but it works now, database records were reduced. My policyd.conf: ----cut<---- # cat /etc/policyd.conf | grep -v '^#' | uniq MYSQLHOST="127.0.0.1" MYSQLDBASE="policyd" MYSQLUSER="policyd" MYSQLPASS="[EMAIL PROTECTED]&19127*5391)31041" MYSQLOPT="" FAILSAFE=1 DATABASE_KEEPALIVE=0 DEBUG=0 DAEMON=1 BINDHOST="127.0.0.1" BINDPORT="10031" PIDFILE=/var/run/policyd.pid SYSLOG_FACILITY="LOG_MAIL | LOG_INFO" CHROOT=/ UID=2001 GID=2001 CONN_ACL="127.0.0.1 192.168.0.0/24" WHITELISTING=1 WHITELISTNULL=0 WHITELISTSENDER=0 WHITELISTDNSNAME=0 AUTO_WHITE_LISTING=1 AUTO_WHITELIST_NUMBER=10 AUTO_WHITELIST_NETBLOCK=0 AUTO_WHITELIST_EXPIRE=7d BLACKLISTING=1 BLACKLISTDNSNAME=0 BLACKLIST_TEMP_REJECT=0 BLACKLIST_NETBLOCK=0 BLACKLIST_REJECTION="Blacklist. Go away." AUTO_BLACK_LISTING=1 AUTO_BLACKLIST_NUMBER=500 AUTO_BLACKLIST_EXPIRE=7d RCPT_ACL=1 BLACKLIST_HELO=0 BLACKLIST_HELO_AUTO_EXPIRE=0 BLACKLISTSENDER=1 HELO_CHECK=1 HELO_MAX_COUNT=10 HELO_BLACKLIST_AUTO_EXPIRE=14d HELO_AUTO_EXPIRE=7d SPAMTRAPPING=1 SPAMTRAP_REJECTION="Spamtrap. Go away." SPAMTRAP_AUTO_EXPIRE=7d GREYLISTING=1 GREYLIST_REJECTION="Temporary error, please try again later" GREYLIST_X_HEADER=1 GREYLIST_HOSTADDR=3 TRAINING_MODE=0 TRAINING_POLICY_TIMEOUT=0 TRIPLET_TIME=5m OPTINOUT=0 OPTINOUTALL=1 TRIPLET_AUTH_TIMEOUT=7d TRIPLET_UNAUTH_TIMEOUT=2d SENDERTHROTTLE=1 SENDER_THROTTLE_SASL=1 SENDER_THROTTLE_HOST=0 QUOTA_EXCEEDED_TEMP_REJECT=0 SENDER_QUOTA_REJECTION="Quota Exceeded." SENDER_SIZE_REJECTION="Message size too big." SENDERMSGLIMIT=512 SENDERRCPTLIMIT=3600 SENDERQUOTALIMIT=250000000 SENDERTIMELIMIT=1h SENDERMSGSIZE=15728640 SENDERMSGSIZE_WARN=50 SENDERMSGSIZE_PANIC=90 SENDER_INACTIVE_EXPIRE=31d SENDER_THROTTLE_AUTOBLACKLIST=0 SENDER_THROTTLE_AUTOBLACKLIST_NUMBER=3 SENDER_THROTTLE_AUTOBLACKLIST_EXPIRE=6h RECIPIENTTHROTTLE=1 RECIPIENTMSGLIMIT=64 RECIPIENTTIMELIMIT=1h RECIPIENT_QUOTA_REJECTION="Quota Exceeded." RECIPIENT_INACTIVE_EXPIRE=31d ----cut<---- -- Best Regards. Zhang Huangbin - iRedMail: Mail Server Solution for Red Hat(R) Enterprise Linux & CentOS 5.x: http://iRedMail.googlecode.com/ _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
