[CWB] Problems with offline_frequency_lists.php

[Simon Meier-Vieracker]

Hi Stephanie, hi Andrew,

thanks! Indeed the line mysqli.allow_local_infile was still commented after the upgrade of php. I simply uncommented it and now it works perfectly.

Sorry for not having read the Admin Tutorial before writing to this list :/

Best, Simon

> Am 02.12.2021 um 20:01 schrieb Hardie, Andrew <a.hardie at lancaster.ac.uk>:
> 
> 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
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
-------------- n?chster Teil --------------
Ein Dateianhang mit Binärdaten wurde abgetrennt...
Dateiname   : smime.p7s
Dateityp    : application/pkcs7-signature
Dateigröße  : 5616 bytes
Beschreibung: nicht verfügbar
URL         : <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20211203/74d7210a/attachment.p7s>