[CWB] Problems with offline_frequency_lists.php

[Simon Meier-Vieracker]

Hi,

when I try to run 'sudo php offline-freqlists.php mycorpus‘ I run into an error as described below. My version is CQPweb v3.2.42 and PHP 8.0.3.

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
> 
> 
> PHP debugging backtrace
> =======================
> array(5) {
>   [1]=>
>   array(4) {
>     ["file"]=>
>     string(42) "/var/www/html/CQPweb/lib/exiterror-lib.php"
>     ["line"]=>
>     int(367)
>     ["function"]=>
>     string(9) "exiterror"
>     ["args"]=>
>     array(3) {
>       [0]=>
>       array(3) {
>         [0]=>
>         string(38) "An SQL query did not run successfully!"
>         [1]=>
>         string(222) "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 */
> 
> "
>         [2]=>
>         string(83) "Error # 2000: LOAD DATA LOCAL INFILE is forbidden, check mysqli.allow_local_infile "
>       }
>       [1]=>
>       NULL
>       [2]=>
>       NULL
>     }
>   }
>   [2]=>
>   array(4) {
>     ["file"]=>
>     string(36) "/var/www/html/CQPweb/lib/sql-lib.php"
>     ["line"]=>
>     int(216)
>     ["function"]=>
>     string(18) "exiterror_sqlquery"
>     ["args"]=>
>     array(3) {
>       [0]=>
>       int(2000)
>       [1]=>
>       string(68) "LOAD DATA LOCAL INFILE is forbidden, check mysqli.allow_local_infile"
>       [2]=>
>       string(202) "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 */"
>     }
>   }
>   [3]=>
>   array(4) {
>     ["file"]=>
>     string(36) "/var/www/html/CQPweb/lib/sql-lib.php"
>     ["line"]=>
>     int(350)
>     ["function"]=>
>     string(12) "do_sql_query"
>     ["args"]=>
>     array(1) {
>       [0]=>
>       string(202) "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 */"
>     }
>   }
>   [4]=>
>   array(4) {
>     ["file"]=>
>     string(42) "/var/www/html/CQPweb/lib/freqtable-lib.php"
>     ["line"]=>
>     int(682)
>     ["function"]=>
>     string(19) "do_sql_infile_query"
>     ["args"]=>
>     array(2) {
>       [0]=>
>       string(22) "freq_text_index_vglive"
>       [1]=>
>       string(41) "/home/service/tmp/vglive_freqdb_index.tbl"
>     }
>   }
>   [5]=>
>   array(4) {
>     ["file"]=>
>     string(46) "/var/www/html/CQPweb/bin/offline-freqlists.php"
>     ["line"]=>
>     int(133)
>     ["function"]=>
>     string(19) "make_cwb_freq_index"
>     ["args"]=>
>     array(1) {
>       [0]=>
>       string(6) "vglive"
>     }
>   }
> }
-------------- n�chster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20211202/9b2560f5/attachment-0001.html>
-------------- 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/20211202/9b2560f5/attachment-0001.p7s>