[CWB] CQPWeb Create minimal metadata table crashes

[Hardie, Andrew]

My guess: You've caused it by setting local-infile-directory.

That's a string setting, which if set limits LOCAL INFILE to a particular directory. You've set it to Boolean true, which translates to string "1". Obviously this will block infile from working anywhere.

https://www.php.net/manual/en/mysqli.configuration.php#ini.mysqli.local-infile-directory

I suggest leaving it unset.

best

Andrew.

From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Andrés Chandía
Sent: 18 September 2022 16:03
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: [CWB] CQPWeb Create minimal metadata table crashes

CQPWeb: v3.2.43
Php 8.1
mysql  Ver 8.0.30-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

PHP message: PHP Fatal error:  Uncaught mysqli_sql_exception: LOAD DATA LOCAL INFILE is forbidden, check related settings like mysqli.allow_local_infile|mysqli.local_infile_directory or PDO::MYSQL_ATTR_LOCAL_INFILE|PDO::MYSQL_ATTR_LOCAL_INFILE_DIRECTORY in /corptedig-glif/cqpweb/lib/sql-lib.php:211\nStack trace:\n#0 /corptedig-glif/cqpweb/lib/sql-lib.php(211): mysqli_query()\n#1 /corptedig-glif/cqpweb/lib/sql-lib.php(350): do_sql_query()\n#2 /corptedig-glif/cqpweb/lib/metadata-lib.php(1050): do_sql_infile_query()\n#3 /corptedig-glif/cqpweb/lib/metadata-act.php(191): create_text_metadata_minimalist()\n#4 /corptedig-glif/cqpweb/exe/metadata-act.php(1): require('...')\n#5 {main}\n  thrown in /corptedig-glif/cqpweb/lib/sql-lib.php on line 211', referer: http://corptedig-glif.upf.edu/cqpweb/bnc/index.php?ui=manageMetadata<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcorptedig-glif.upf.edu%2Fcqpweb%2Fbnc%2Findex.php%3Fui%3DmanageMetadata&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Ccb24eb819b0741389a6808da9986f4a7%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991102569802980%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=h2ogmx6DvH%2FWGgbac49Bn%2BrAY4gCR%2FNLtAuKOnxSeYI%3D&reserved=0>

/etc/php/8.1/apache2/php.ini
mysqli.allow_local_infile = On
mysqli.local_infile_directory = On

/etc/mysql/mysql.conf.d/mysqld.cnf
local_infile = true

Thanks

[https://www.upf.edu/documents/10193/6775906/signatura-correu.png]

Andrés Chandía
Unitat de Traducció i Ciències del Llenguatge
Roc Boronat 138, C. P.: 08018, Barcelona
Tel.: 935 055 722 - mail:andres.chandia at upf.edu<mailto:andres.chandia at upf.edu>
[chandia.net]<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.chandia.net%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Ccb24eb819b0741389a6808da9986f4a7%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991102569802980%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=C%2F%2Bj%2FNbG%2B%2F%2FHEJaDvLAOhcstsJ%2FSfHDIFUxH5i%2FZkHw%3D&reserved=0>[http://mail.chandia.net/images/ico_tw.png]<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Fchandianet&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Ccb24eb819b0741389a6808da9986f4a7%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991102569802980%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=VEaIJDzB8u7W00lk0eXv3Kr0ho1R5vglRWo9qvNh270%3D&reserved=0>
mail:andres at chandia.net<mailto:andres at chandia.net>
________________________________
[https://ci3.googleusercontent.com/mail-sig/AIorK4yTWuuJgoqJ3i-Ir0NHJSpAWwqSbLjzJMBbgf9K5Gx_Y6mX0PQFjwgdrACBE8bL2e72tMi4zAQ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20220919/a09433ef/attachment.html>