Error when Update of Geo IP

[Leif Neland]

    [ The following text is in the "iso-8859-1" character set. ]
    [ Your display is set for the "US-ASCII" character set.  ]
    [ Some characters may be displayed incorrectly. ]

Dhawal Doshy wrote:
> John Berntsen wrote:
>>> 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
>>>>
>>
>> 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:
>>
>
> Ummm.. no. The temp dir missing in /var/www/html/mailscanner/ is a
> known problem with mailwatch-1.0.2 (or was it 1.0.1), once created
> the problem is likely to go away.
>
> There are security limitations with the 'load data infile' command but
> thats another story.
>
I get this:

Error executing query:

The used command is not allowed with this MySQL version

SQL:

LOAD DATA LOCAL INFILE 
'/usr/local/www/data/mailscanner/temp/GeoIPCountryWhois.csv' INTO TABLE 
geoip_country FIELDS TERMINATED BY ',' ENCLOSED BY '"'If I remove "LOCAL", 
ie LOAD DATA INFILE it works.mysql  Ver 14.7 Distrib 4.1.14, for 
portbld-freebsd7.0 (i386) using  5.0Leif 


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.

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