Error when Update of Geo IP

[John Berntsen]

> -----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
infile......"
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
>use mailwatch;
>LOAD DATA LOCAL INFILE 'GeoIPCountryWhois.csv' INTO TABLE geoip_country
FIELDS TERMINATED BY ',' ENCLOSED BY '"';

Regards
John

------------------------ 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!