MailWatch GeoIP error

MailWatch 1.0.3 版本或以前在 GeoIP 會有一個更新既問題.

更新時會出現:

Access denied for user: ‘mailwatch@localhost‘ (Using password: YES)

SQL:

LOAD DATA INFILE ‘/var/www/html/mailscanner/tmp/GeoIPCountryWhois.csv’ INTO TABLE geoip_country FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘

這原是 MySQL 安全控制之一, 與 MailWatch 無關.
解決辦法為更改 geoip_update.php, 把當中 LOAD DATA INFILE 改為 LOAD DATA LOCAL INFILE 便可

Leave a comment

Please leave your comment on the topic

This site uses Akismet to reduce spam. Learn how your comment data is processed.