Error when Update of Geo IP
john at OMEGADATA.NO
Thu Sep 29 08:23:15 IST 2005
> -----Original Message-----
> From: MailScanner mailing list
> [mailto:MAILSCANNER at JISCMAIL.AC.UK] On Behalf Of Dhawal Doshy
> Sent: 29. september 2005 08:38
> To: MAILSCANNER at JISCMAIL.AC.UK
> Subject: Re: Error when Update of Geo IP
> pat png wrote:
> > Downloading file, please wait....
> > Warning: fopen("temp/GeoIPCountryCSV.zip", "w+") - No such file or
> > directory in /var/www/html/mailscanner/geoip_update.php on line 53
> > Unable to open temp/GeoIPCountryCSV.zip for writing.
> > Can someone help?
> > rgds
> > Patrick
> You'd be better off asking this question on the mailwatch list rather
> than the mailscanner list..
> Anyways follow these steps
> 1. mkdir /var/www/html/mailscanner/temp
> 2. chown apache:apache /var/www/html/mailscanner/temp (replace
> apache:apache with the user:group your apache daemon runs as)
> 3. try again
> - dhawal
The problem is with mysql, because maiwatch uses "load data local
and the problem is that maybe your mysql config does not allow this.
It it because of security, you can read in the mysql docs.
What i did as a quick fix, was to load this file manually like this:
# mysql -u root -p
>LOAD DATA LOCAL INFILE 'GeoIPCountryWhois.csv' INTO TABLE geoip_country
FIELDS TERMINATED BY ',' ENCLOSED BY '"';
------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the Wiki (http://wiki.mailscanner.info/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).
Support MailScanner development - buy the book off the website!
More information about the MailScanner