[CWB] Problems with offline_frequency_lists.php

[Hardie, Andrew]

See also admin manual, specifically sections:

  1.8     (the bit on p 15)
  1.12.2 
  1.12.4
  2.3.3

Andrew

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Stephanie Evert
Sent: 02 December 2021 16:48
To: CWBdev Mailing List <cwb at sslmit.unibo.it>
Subject: Re: [CWB] Problems with offline_frequency_lists.php


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

_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&amp;data=04%7C01%7Chardiea%40live.lancs.ac.uk%7C5804b041b0b44cc8d3d908d9b5b55995%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637740612776402913%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=jtp03ufi5i3Bpo6ffyheaIFPUuwpHYiBjvAAqCOiuk4%3D&amp;reserved=0