Error when Update of Geo IP

Dhawal Doshy dhawal at NETMAGICSOLUTIONS.COM
Thu Sep 29 10:28:09 IST 2005

    [ 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:
> '/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 with the words:
'leave mailscanner' in the body of the email.
Before posting, read the Wiki ( and
the archives (

Support MailScanner development - buy the book off the website!

More information about the MailScanner mailing list