[CWB] CQPWeb Create minimal metadata table crashes

[Hardie, Andrew]

The other possibility is "local_infile = true" as the culprit. I am not sure the mysql ini file parser recognises "true". You might try "On" or "1" instead.
If that fails, you'll have to move to digging with mysql client to see what the server settings actually are in practice and where they are being set.
best

Andrew.

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

Thanks Andrew for your answer, but I'm sorry to say, that when I detected the problem i had
;mysqli.local_infile_directory =

then, as suggested by the error log, I activate it, but nothing changed, I have commented out already...

thanks again...



... Andrés Chandía


Missatge de Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>> del dia dl., 19 de set. 2022 a les 17:03:
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<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.php.net%2Fmanual%2Fen%2Fmysqli.configuration.php%23ini.mysqli.local-infile-directory&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=bXR2X3Mgh%2FCIi%2FqkpdB5UslWkpMC2RnlBYJDr8JtSns%3D&reserved=0>

I suggest leaving it unset.

best

Andrew.

From: cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it> <cwb-bounces at sslmit.unibo.it<mailto: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<mailto: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%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ezhTvRY7RiF2lmYCPtqWxA9rNMn28HZALE3X4sRirOI%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%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=CgtSgP2R2MQ80hIcqDaVwuAM2a6%2BwYyebyCawt3a5WM%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%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=1nGPHU33SjcYGU6enQ2yX9OYdptvxQqUlCEGXsrSW5o%3D&reserved=0>
mail:andres at chandia.net<mailto:andres at chandia.net>
________________________________
[https://ci3.googleusercontent.com/mail-sig/AIorK4yTWuuJgoqJ3i-Ir0NHJSpAWwqSbLjzJMBbgf9K5Gx_Y6mX0PQFjwgdrACBE8bL2e72tMi4zAQ]
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=R09uIOYDO2Fqwts%2BqngOYo8nfePgB7zOCeET9GWQKXw%3D&reserved=0>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20220919/80fc14f1/attachment-0001.html>