<div dir="ltr"><div>I could finally fix it,</div><div>apt install --reinstall php-gd php-intl php-json php-mbstring php-mysqli php-phar php-cgi php-cli php-bz2 php-zip php-pclzip</div><div><br></div><div></div><div>After that, when checking Internal PHP settings relevant to CQPweb in the Admin Control Panel, I realised that php.ini file is no longer apache2/php.ini but /etc/php/8.1/fpm/php.ini. Then, I applied settings for upload_max_filesize post_max_size memory_limit max_execution_time and mysqli.allow_local_infile. Then restarted apache and all wen almost as expected, except that I get this error now:</div><div><br></div><div>[proxy_fcgi:error] [pid 3342] [client x.xx.xx.x:21205] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Invalid utf8mb4 character string: 'A history of the world in 10' in /cqpweb/lib/sql-lib.php:211\nStack trace:\n#0 /cqpweb/lib/sql-lib.php(211): mysqli_query()\n#1 /cqpweb/lib/sql-lib.php(350): do_sql_query()\n#2 /cqpweb/lib/metadata-lib.php(984): do_sql_infile_query()\n#3 /cqpweb/lib/metadata-lib.php(814): create_text_metadata_from_file()\n#4 /cqpweb/lib/metadata-act.php(179): create_text_metadata_from_xml()\n#5 /cqpweb/exe/metadata-act.php(1): require('...')\n#6 {main}\n thrown in /cqpweb/lib/sql-lib.php on line 211', referer: <a href="http://corptedig-glif.upf.edu/cqpweb/bnc/index.php?ui=manageMetadata&createMetadataFromXml=1">http://corptedig-glif.upf.edu/cqpweb/bnc/index.php?ui=manageMetadata&createMetadataFromXml=1</a><br></div><div><br></div><div>Thanks!<br></div><div><br></div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><span style="color:rgb(0,0,255)"><i><span style="font-family:trebuchet ms,sans-serif">... Andrés Chandía</span></i></span><br></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Missatge de Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>> del dia dt., 20 de set. 2022 a les 22:57:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-2325192640275065434">
<div lang="EN-GB">
<div class="m_3085962497754469706WordSection1">
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Some bug reports on the web suggest that adding<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">loose-local-infile=1<u></u><u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">in the [<b>client</b>] section of your mysql configuration may help?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Other possibilities:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="m_3085962497754469706MsoListParagraph"><u></u><span style="font-size:10pt;font-family:Symbol;color:rgb(31,73,125)"><span>·<span style="font:7pt "Times New Roman"">
</span></span></span><u></u><span dir="LTR"></span><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Check that cqpusr has the “FILE” privilege on the sql server.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="m_3085962497754469706MsoListParagraph"><u></u><span style="font-size:10pt;font-family:Symbol;color:rgb(31,73,125)"><span>·<span style="font:7pt "Times New Roman"">
</span></span></span><u></u><span dir="LTR"></span><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Check that the input file is readable by system user www-data.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="m_3085962497754469706MsoListParagraph"><u></u><span style="font-size:10pt;font-family:Symbol;color:rgb(31,73,125)"><span>·<span style="font:7pt "Times New Roman"">
</span></span></span><u></u><span dir="LTR"></span><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Check that no other system (like apparmor) is causing problems by limiting what folders the webserver
/ mysql client can access.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">From:</span></b><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> <<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>>
<b>On Behalf Of </b>Andrés Chandía<br>
<b>Sent:</b> 20 September 2022 17:31<br>
<b>To:</b> Open source development of the Corpus WorkBench <<a href="mailto:cwb@sslmit.unibo.it" target="_blank">cwb@sslmit.unibo.it</a>><br>
<b>Subject:</b> Re: [CWB] CQPWeb Create minimal metadata table crashes<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Sorry Andrew for keeping going on with this, but I find no solution...<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I turn back to false $mysql_has_file_access<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">and, as it says in the manual: <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span class="m_3085962497754469706gmail-"><span style="font-size:13.5pt;font-family:"Arial",sans-serif">default value of</span></span><span style="font-size:13.5pt;font-family:"Arial",sans-serif">
</span><span class="m_3085962497754469706gmail-"><span style="font-size:13.5pt;font-family:"Courier New"">secure file priv</span></span><span style="font-size:13.5pt;font-family:"Courier New"">
</span><span class="m_3085962497754469706gmail-"><span style="font-size:13.5pt;font-family:"Arial",sans-serif">has changed. In this case, instead of</span></span><span style="font-size:13.5pt;font-family:"Arial",sans-serif"> changing
<span class="m_3085962497754469706gmail-">the value of</span></span><br>
<span class="m_3085962497754469706gmail-"><span style="font-size:13.5pt;font-family:"Courier New"">secure file priv</span></span><span class="m_3085962497754469706gmail-"><span style="font-size:13.5pt;font-family:"Arial",sans-serif">, to fix the problem you need to</span></span><span style="font-size:13.5pt;font-family:"Arial",sans-serif">
add a line </span><span class="m_3085962497754469706gmail-"><span style="font-size:13.5pt;font-family:"Courier New"">secure file priv=""</span></span><span style="font-size:13.5pt;font-family:"Courier New"">
</span><span style="font-size:13.5pt;font-family:"Arial",sans-serif">to your</span><br>
<span class="m_3085962497754469706gmail-"><span style="font-size:13.5pt;font-family:"Courier New"">my.cnf</span></span><span style="font-size:13.5pt;font-family:"Courier New"">
</span><span class="m_3085962497754469706gmail-"><span style="font-size:13.5pt;font-family:"Arial",sans-serif">file to restore what was previously the default state.</span></span><br>
<span class="m_3085962497754469706gmail-"><span style="font-size:13.5pt;font-family:"Arial",sans-serif">It’s unknown whether this issue affects MariaDB as well as MySQL.</span></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">first, I have tried adding <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">secure_file_priv = ""<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">to /etc/mysql/mysql.conf.d/mysqld.cnf<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">mysql> show variables like "secure_file_priv";<br>
+------------------+-------+<br>
| Variable_name | Value |<br>
+------------------+-------+<br>
| secure_file_priv | |<br>
+------------------+-------+<br>
1 row in set (0,01 sec)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">results in:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Got error 'PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: LOAD DATA LOCAL INFILE is forbidden<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">second, I have tried adding:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">secure_file_priv = /corpora/cqp/tmp/<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">mysql> show variables like "secure_file_priv";<br>
+------------------+---------------------------+<br>
| Variable_name | Value |<br>
+------------------+---------------------------+<br>
| secure_file_priv | /corpora/cqp/tmp/ |<br>
+------------------+--------------------------+<br>
1 row in set (0,01 sec)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">where <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">ls -la /corpora/cqp/<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">drwxrwxr-x 2 www-data cqpweb 217088 sep 19 17:46 tmp<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">and <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">grep '^cqpweb:.*$' /etc/group | cut -d: -f4<br>
mysql,www-data<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">but the same error comes up<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Got error 'PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: LOAD DATA LOCAL INFILE is forbidden<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-family:"Trebuchet MS",sans-serif;color:blue">... Andrés Chandía</span></i><u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">Missatge de Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> del dia dt., 20 de set. 2022 a les 1:26:<u></u><u></u></p>
</div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">This exact situation is covered in the section of the manual I mentioned before. Pls reread. Thank
you.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><img style="width: 5.1875in; height: 5.7291in;" id="m_3085962497754469706m_8974095686290848400Picture_x0020_1" src="cid:183be101fc75b006a1" width="498" height="550" border="0"></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<div>
<div style="border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm;border-color:currentcolor">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>
<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a>
<b>On Behalf Of </b>Andrés Chandía<br>
<b>Sent:</b> 19 September 2022 19:54<br>
<b>To:</b> Open source development of the Corpus WorkBench <<a href="mailto:cwb@sslmit.unibo.it" target="_blank">cwb@sslmit.unibo.it</a>><br>
<b>Subject:</b> Re: [CWB] CQPWeb Create minimal metadata table crashes</span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">I have done:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">mysql> show variables like "secure_file_priv";<br>
+------------------+-----------------------+<br>
| Variable_name | Value |<br>
+------------------+-----------------------+<br>
| secure_file_priv | /var/lib/mysql-files/ |<br>
+------------------+-----------------------+<br>
1 row in set (0,01 sec)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">but I look for that variable and nothing is found:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">grep -r "secure_file_priv" /etc/mysql/<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-family:"Trebuchet MS",sans-serif;color:blue">... Andrés Chandía</span></i><u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Missatge de Andrés Chandía <<a href="mailto:andres.chandia@upf.edu" target="_blank">andres.chandia@upf.edu</a>> del dia dl., 19 de set. 2022 a les 20:33:<u></u><u></u></p>
</div>
<blockquote style="border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)">
<div>
<p class="MsoNormal">By the way, the table "<a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcorptedig-glif.upf.edu%2Fphpmyadmin%2Findex.php%3Froute%3D%2Fsql%26db%3Dcqp%26table%3Dtext_metadata_for_bnc&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117820596%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=rx4QrM9lIuvMAjDCeczrmSo73YjeUhv6csOEgM7Z%2FS8%3D&reserved=0" target="_blank">text_metadata_for_bnc</a>"
gets created, but empty.<u></u><u></u></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-family:"Trebuchet MS",sans-serif;color:blue">... Andrés Chandía</span></i><u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Missatge de Andrés Chandía <<a href="mailto:andres.chandia@upf.edu" target="_blank">andres.chandia@upf.edu</a>> del dia dl., 19 de set. 2022 a les 20:21:<u></u><u></u></p>
</div>
<blockquote style="border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)">
<div>
<div>
<p class="MsoNormal">I've searched for
<b><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">secure_file_priv</span></b> in /etc/mysql/mysql.conf.d/mysqld.cnf and there is no instance of it, just in case I also searched in /etc/php/8.1/apache2/php.ini and nothing too...<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I've changed from false to<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">$mysql_has_file_access = true;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">in /lib/defaults.inc.php and /lib/defaults.php:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">and now the error has changed to something more weird:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Got error 'PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'cqpusr'@'localhost' (using password: YES) 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:
<a href="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%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117820596%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=mqZUa7yxXzDE3REophN8Zyh5GrsTUrHKan1GNwOPhDU%3D&reserved=0" target="_blank">
http://corptedig-glif.upf.edu/cqpweb/bnc/index.php?ui=manageMetadata</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I looked for the database configuration in lib/config.inc.php<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">and could enter mysql with the data stored there, I mean the mysqluser and the mysqlpassword for the cqpwebdb. Just in case I granted again the database to the same user, but I
still get that same last error.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-family:"Trebuchet MS",sans-serif;color:blue">... Andrés Chandía</span></i><u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Missatge de Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> del dia dl., 19 de set. 2022 a les 19:51:<u></u><u></u></p>
</div>
<blockquote style="border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)">
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">That clarifies what the problem is. It’s not in PHP. It’s in MySQL. Even though local infile is switched
on, something else is blocking it. </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">I hesitate to ask, but you
<i>did</i> check the setting of <b>secure_file_priv</b>, right? It’s listed in the manual as one of the things to check if infile doesn’t work.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Section “Known “gotchas” in SQL DB setup”; paragraph “File privilege with restricted scope”</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">(you could also try just setting $mysql_has_file_access in cqpweb, so that LOCAL isn’t needed)</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">best</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Andrew.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<div>
<div style="border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm;border-color:currentcolor">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US"> <</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US">>
<b>On Behalf Of </b>Andrés Chandía<br>
<b>Sent:</b> 19 September 2022 18:33<br>
<b>To:</b> Open source development of the Corpus WorkBench <</span><a href="mailto:cwb@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb@sslmit.unibo.it</span></a><span lang="EN-US">><br>
<b>Subject:</b> Re: [CWB] CQPWeb Create minimal metadata table crashes</span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">mysql> show variables like "local_infile";<br>
+---------------+-------+<br>
| Variable_name | Value |<br>
+---------------+-------+<br>
| local_infile | ON |<br>
+---------------+-------+<br>
1 row in set (0,02 sec)<br>
<br>
mysql> use cqp;<br>
Reading table information for completion of table and column names<br>
You can turn off this feature to get a quicker startup with -A<br>
<br>
Database changed<br>
mysql> LOAD DATA LOCAL INFILE '/mnt/vmdata/corptedig-glif/corpora/cqp/tmp/___install_temp_metadata_bnc' INTO TABLE `text_metadata_for_bnc` FIELDS ESCAPED BY '';<br>
ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.<br>
mysql> quit<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">-rw-r--r-- 1 www-data www-data 16196 sep 19 17:44 /mnt/vmdata/corptedig-glif/corpora/cqp/tmp/___install_temp_metadata_bnc<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">so I though that adding user mysql to www-data group would help, but nothing...<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">and just if....<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">chmod 777 /mnt/vmdata/corptedig-glif/corpora/cqp/tmp/___install_temp_metadata_bnc<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">and nothing again.... I mean, all the time: ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">file /etc/php/8.1/apache2/php.ini
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">mysqli.allow_local_infile = On<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">;mysqli.local_infile_directory = On (commente out)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-family:"Trebuchet MS",sans-serif;color:blue">... Andrés Chandía</span></i><u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Missatge de Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> del dia dl., 19 de set. 2022 a les 19:14:<u></u><u></u></p>
</div>
<blockquote style="border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)">
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">There’s no alternative to you breaking out the mysql client and having a poke around to work out what
is causing the problem.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">EG to find out whether the mysqld configuration is taking effect, you need to run</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">> show variables like "local_infile";</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">In order to get</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Courier New";color:rgb(31,73,125)">+---------------+-------+</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Courier New";color:rgb(31,73,125)">| Variable_name | Value |</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Courier New";color:rgb(31,73,125)">+---------------+-------+</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Courier New";color:rgb(31,73,125)">| local_infile | ON |</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Courier New";color:rgb(31,73,125)">+---------------+-------+</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Courier New";color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">If it’s ON, that suggests the issue is in PHP (or, some other security setting). If it’s OFF, the issue
is that your mysql config file is not taking effect. </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Also, running the load data command , ie</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal" style="margin-left:36pt">
LOAD DATA LOCAL INFILE '/mnt/vmdata/corptedig-glif/corpora/cqp/tmp/___install_temp_metadata_bnc' INTO TABLE `text_metadata_for_bnc` FIELDS ESCAPED BY ''<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">manually in the client might result in a more informative error message (also might not, mysql err
messages are not noted for their helpfulness)</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">best</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Andrew.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<div>
<div style="border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm;border-color:currentcolor">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US"> <</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US">>
<b>On Behalf Of </b>Andrés Chandía<br>
<b>Sent:</b> 19 September 2022 16:45<br>
<b>To:</b> Open source development of the Corpus WorkBench <</span><a href="mailto:cwb@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb@sslmit.unibo.it</span></a><span lang="EN-US">><br>
<b>Subject:</b> [External] Re: [CWB] CQPWeb Create minimal metadata table crashes</span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">In /etc/mysql/mysql.conf.d/mysqld.cnf i tried<u></u><u></u></p>
<div>
<p class="MsoNormal">local_infile = true<u></u><u></u></p>
<p class="MsoNormal">local_infile = 1<u></u><u></u></p>
<p class="MsoNormal">local_infile = On<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">but no improvement<u></u><u></u></p>
<p class="MsoNormal">The error is not shown in the web interface when $print_debug_messages = true; but in the apache error log<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Last thing showing in the web interface with debug activated is:<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<pre>About to run SQL:<u></u><u></u></pre>
<pre> LOAD DATA LOCAL INFILE '/mnt/vmdata/corptedig-glif/corpora/cqp/tmp/___install_temp_metadata_bnc' INTO TABLE `text_metadata_for_bnc` FIELDS ESCAPED BY '' <u></u><u></u></pre>
<pre> /* from User: admin | Function: create_text_metadata_minimalist() | 2022-Sep-19 17:43 */<u></u><u></u></pre>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-family:"Trebuchet MS",sans-serif;color:blue">... Andrés Chandía</span></i><u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Missatge de Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> del dia dl., 19 de set. 2022 a les 17:22:<u></u><u></u></p>
</div>
<blockquote style="border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)">
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">The other possibility is “</span>local_infile = true<span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">”
as the culprit. I am not sure the mysql ini file parser recognises “true”. You might try “On” or “1” instead.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">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.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">best</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Andrew.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<div>
<div style="border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm;border-color:currentcolor">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US"> <</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US">>
<b>On Behalf Of </b>Andrés Chandía<br>
<b>Sent:</b> 19 September 2022 16:07<br>
<b>To:</b> Open source development of the Corpus WorkBench <</span><a href="mailto:cwb@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb@sslmit.unibo.it</span></a><span lang="EN-US">><br>
<b>Subject:</b> Re: [CWB] CQPWeb Create minimal metadata table crashes</span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Thanks Andrew for your answer, but I'm sorry to say, that when I detected the problem i had<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">;mysqli.local_infile_directory =
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">then, as suggested by the error log, I activate it, but nothing changed, I have commented out already...<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">thanks again...<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><i><span style="font-family:"Trebuchet MS",sans-serif;color:blue">... Andrés Chandía</span></i><u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Missatge de Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> del dia dl., 19 de set. 2022 a les 17:03:<u></u><u></u></p>
</div>
<blockquote style="border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)">
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">My guess: You’ve caused it by setting local-infile-directory.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">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.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><a href="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%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117820596%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=CCJLU7jCj5omqR2AKOn1aF7Q8CYs2Ho%2FBmqhIGcRwu8%3D&reserved=0" target="_blank"><span style="font-size:10pt;font-family:"Verdana",sans-serif">https://www.php.net/manual/en/mysqli.configuration.php#ini.mysqli.local-infile-directory</span></a><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">
</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">I suggest leaving it unset.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">best</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)">Andrew.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p>
<div>
<div style="border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm;border-color:currentcolor">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US"> <</span><a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb-bounces@sslmit.unibo.it</span></a><span lang="EN-US">>
<b>On Behalf Of </b>Andrés Chandía<br>
<b>Sent:</b> 18 September 2022 16:03<br>
<b>To:</b> Open source development of the Corpus WorkBench <</span><a href="mailto:cwb@sslmit.unibo.it" target="_blank"><span lang="EN-US">cwb@sslmit.unibo.it</span></a><span lang="EN-US">><br>
<b>Subject:</b> [CWB] CQPWeb Create minimal metadata table crashes</span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">CQPWeb: v3.2.43<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Php 8.1<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">mysql Ver 8.0.30-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">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: <a href="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%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117820596%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=mqZUa7yxXzDE3REophN8Zyh5GrsTUrHKan1GNwOPhDU%3D&reserved=0" target="_blank">
http://corptedig-glif.upf.edu/cqpweb/bnc/index.php?ui=manageMetadata</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">/etc/php/8.1/apache2/php.ini
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">mysqli.allow_local_infile = On<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">mysqli.local_infile_directory = On<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">/etc/mysql/mysql.conf.d/mysqld.cnf<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">local_infile = true<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks<u></u><u></u></p>
</div>
<div>
<div>
<div>
<div>
<table style="width:100%" width="100%" cellpadding="0" border="0">
<tbody>
<tr>
<td style="width:12%;padding:0cm" width="12%">
<p><span style="font-size:10pt"><img style="width: 1.6875in; height: 0.6458in;" id="m_3085962497754469706m_8974095686290848400_x005f_x0000_i1037" src="https://www.upf.edu/documents/10193/6775906/signatura-correu.png" width="162" height="62" border="0"></span><u></u><u></u></p>
</td>
<td style="padding:0cm">
<p><b><span style="font-size:10pt;font-family:"Verdana",sans-serif" lang="ES">Andrés Chandía</span></b><span style="font-size:10pt" lang="ES"><br>
</span><span style="font-size:10pt;font-family:"Verdana",sans-serif" lang="ES">Unitat de Traducció i Ciències del Llenguatge<br>
Roc Boronat 138, C. P.: 08018, Barcelona<br>
Tel.: 935 055 722 - </span><span style="font-size:10pt"><a href="mailto:andres.chandia@upf.edu" target="_blank"><span style="font-family:"Verdana",sans-serif" lang="ES">mail:andres.chandia@upf.edu</span></a></span><u></u><u></u></p>
</td>
</tr>
<tr>
<td style="padding:1.5pt">
<p class="MsoNormal"><a href="https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.chandia.net%2F&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117820596%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=LmclpvYT%2BcTfie9K5YXURhg2BxAXvw7ZUZR9ZHdFwDo%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 1.0208in; height: 0.4583in;" id="m_3085962497754469706m_8974095686290848400_x005f_x0000_i1036" src="http://mail.chandia.net/images/chandia_net.png" alt="chandia.net" width="98" height="44" border="0"></span></a><a href="https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Fchandianet&data=05%7C01%7Chardiea%40live.lancs.ac.uk%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117820596%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=F7n9C%2BVtYYzJsmkA%2FxBd9X%2BIftTnlXvtUT7La9h%2BOhQ%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 0.2083in; height: 0.2083in;" id="m_3085962497754469706m_8974095686290848400_x005f_x0000_i1035" src="http://mail.chandia.net/images/ico_tw.png" width="20" height="20" border="0"></span></a><u></u><u></u></p>
</td>
<td style="padding:1.5pt">
<p class="MsoNormal"><a href="mailto:andres@chandia.net" target="_blank"><span style="font-size:10pt;font-family:"Verdana",sans-serif">mail:andres@chandia.net</span></a><u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
<div class="MsoNormal" style="text-align:center" align="center">
<hr style="color:rgb(200,16,46)" width="100%" size="1" noshade align="center">
</div>
<p class="MsoNormal"><img style="width: 3.4583in; height: 0.4479in;" id="m_3085962497754469706m_8974095686290848400_x005f_x0000_i1034" src="https://ci3.googleusercontent.com/mail-sig/AIorK4yTWuuJgoqJ3i-Ir0NHJSpAWwqSbLjzJMBbgf9K5Gx_Y6mX0PQFjwgdrACBE8bL2e72tMi4zAQ" width="332" height="43" border="0"><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="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%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117820596%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=lpKbQEb9kVjCfequ7yGEc3%2BpZE1CGQBuIvzxFPrqqSA%3D&reserved=0" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><u></u><u></u></p>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="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%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117977213%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=vSXvotQ1j8lLqOgCi%2BS7s9gst4v%2FvaPKJy0939aCPYU%3D&reserved=0" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><u></u><u></u></p>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="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%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117977213%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=vSXvotQ1j8lLqOgCi%2BS7s9gst4v%2FvaPKJy0939aCPYU%3D&reserved=0" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><u></u><u></u></p>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="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%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117977213%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=vSXvotQ1j8lLqOgCi%2BS7s9gst4v%2FvaPKJy0939aCPYU%3D&reserved=0" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><u></u><u></u></p>
</div>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="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%7Cade113cebcb84285c5ab08da9b25afbc%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992884117977213%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=vSXvotQ1j8lLqOgCi%2BS7s9gst4v%2FvaPKJy0939aCPYU%3D&reserved=0" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><u></u><u></u></p>
</div>
</blockquote>
</div>
</div>
</div>
</div>
_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it" target="_blank">CWB@sslmit.unibo.it</a><br>
<a href="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" rel="noreferrer" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><br>
</div></blockquote></div>