[CWB] Problems with offline_frequency_lists.php

[Stephanie Evert]

Hi Simon,

it means what the error says: the SQL command LOAD DATA LOCAL INFILE isn't allowed on your system.

The error message suggests that you might need to enable the mysqli.allow_local_infile setting for PHP's mysqli module. My system-wide php.ini file indeed contains the line

	mysqli.allow_local_infile = On 

which does exactly that.

However, your MySQL server also has to be configured to enable this, which is becoming increasingly difficult as there's more emphasis on security over ease of use …

Best,
Stephanie


> On 2 Dec 2021, at 16:36, Simon Meier-Vieracker <simon.meier-vieracker at tu-dresden.de> wrote:
> 
> Line 211 of sql-lib-php says:
> 
>> $result = mysqli_query($link, $sql);
> 
> but I don’t understand what that means.
> /
> Thanks in advance
> Simon
> 
>> 
>> 
>> 
>> PHP Warning:  mysqli_query(): LOAD DATA LOCAL INFILE forbidden in /var/www/html/CQPweb/lib/sql-lib.php on line 211
>> 
>> An SQL query did not run successfully!
>> Original query: 
>> 
>> LOAD DATA LOCAL INFILE '/home/service/tmp/vglive_freqdb_index.tbl' INTO TABLE `freq_text_index_vglive` FIELDS ESCAPED BY '' 
>> 	/* from User: admin | Function: make_cwb_freq_index() | 2021-Dec-02 16:27 */
>> Error # 2000: LOAD DATA LOCAL INFILE is forbidden, check mysqli.allow_local_infile
>>