[CWB] CQPWeb Create minimal metadata table crashes

[Andrés Chandía]

Just in case:
CWB installed this way:
:~$ wget
https://sourceforge.net/projects/cwb/files/cwb/cwb-3.5/deb/cwb-dev_3.5.0-1_amd64.deb
:~$ wget
https://sourceforge.net/projects/cwb/files/cwb/cwb-3.5/deb/cwb_3.5.0-1_amd64.deb
:~$ dpkg -i *.deb

*... Andrés Chandía*


Missatge de Andrés Chandía <andres.chandia at upf.edu> del dia dl., 19 de set.
2022 a les 17:45:

> In /etc/mysql/mysql.conf.d/mysqld.cnf i tried
>
> local_infile = true
>
> local_infile = 1
>
> local_infile = On
>
>
> but no improvement
>
> The error is not shown in the web interface when $print_debug_messages =
> true; but in the apache error log
>
>
> Last thing showing in the web interface with debug activated is:
>
>
> About to run SQL:
> 	LOAD DATA LOCAL INFILE '/mnt/vmdata/corptedig-glif/corpora/cqp/tmp/___install_temp_metadata_bnc' INTO TABLE `text_metadata_for_bnc` FIELDS ESCAPED BY ''
> 	/* from User: admin | Function: create_text_metadata_minimalist() | 2022-Sep-19 17:43 */
>
>
>
>
> *... Andrés Chandía*
>
>
> Missatge de Hardie, Andrew <a.hardie at lancaster.ac.uk> del dia dl., 19 de
> set. 2022 a les 17:22:
>
>> 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> 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 <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%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
>>
>> [image: 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 <andres.chandia at upf.edu>
>>
>> [image: 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>[image:
>> 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 <andres at chandia.net>
>> ------------------------------
>>
>> [image:
>> https://ci3.googleusercontent.com/mail-sig/AIorK4yTWuuJgoqJ3i-Ir0NHJSpAWwqSbLjzJMBbgf9K5Gx_Y6mX0PQFjwgdrACBE8bL2e72tMi4zAQ]
>>
>> _______________________________________________
>> CWB mailing list
>> 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>
>>
>> _______________________________________________
>> CWB mailing list
>> CWB at sslmit.unibo.it
>> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20220919/cc481f09/attachment-0001.html>