Error when Update of Geo IP

[Dhawal Doshy]

    [ 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. ]

Leif Neland wrote:
>>
>> 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
> 

The original code used 'LOAD DATA INFILE' but was changed later to 'LOAD 
DATA LOCAL INFILE' based on feedback by beta testers.

However if 'LOCAL' isn't required on freebsd, then probably Steve could 
make a change in the php code to provision for this as well. Could you 
report your complete observations this to the mailwatch-users list?

- dhawal

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