<div dir="ltr"><div>Just in case:</div><div>CWB installed this way:<br></div><div>:~$ wget <a href="https://sourceforge.net/projects/cwb/files/cwb/cwb-3.5/deb/cwb-dev_3.5.0-1_amd64.deb">https://sourceforge.net/projects/cwb/files/cwb/cwb-3.5/deb/cwb-dev_3.5.0-1_amd64.deb</a><br>:~$ wget <a href="https://sourceforge.net/projects/cwb/files/cwb/cwb-3.5/deb/cwb_3.5.0-1_amd64.deb">https://sourceforge.net/projects/cwb/files/cwb/cwb-3.5/deb/cwb_3.5.0-1_amd64.deb</a><br>:~$ dpkg -i *.deb</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 Andrés Chandía <<a href="mailto:andres.chandia@upf.edu">andres.chandia@upf.edu</a>> del dia dl., 19 de set. 2022 a les 17:45:<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 dir="ltr"><div>In /etc/mysql/mysql.conf.d/mysqld.cnf i tried<br><div>
</div>
<div>
<p class="MsoNormal">local_infile = true</p><p class="MsoNormal">local_infile = 1</p><p class="MsoNormal">local_infile = On</p><p class="MsoNormal"><br></p><p class="MsoNormal">but no improvement</p><p class="MsoNormal">The error is not shown in the web interface when $print_debug_messages = true; but in the apache error log</p><p class="MsoNormal"><br></p><p class="MsoNormal">Last thing showing in the web interface with debug activated is:</p><p class="MsoNormal"><br></p><pre>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 */
</pre><p class="MsoNormal"></p><p class="MsoNormal"><br></p><p class="MsoNormal"><br></p></div></div><div><br></div><div><div><div dir="ltr"><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" target="_blank">a.hardie@lancaster.ac.uk</a>> del dia dl., 19 de set. 2022 a les 17:22:<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>
<div lang="EN-GB">
<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.<u></u><u></u></span></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<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)">Andrew.<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> 19 September 2022 16:07<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">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-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)">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"><span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><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%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=bXR2X3Mgh%2FCIi%2FqkpdB5UslWkpMC2RnlBYJDr8JtSns%3D&reserved=0" target="_blank">https://www.php.net/manual/en/mysqli.configuration.php#ini.mysqli.local-infile-directory</a>
</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 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> 18 September 2022 16:03<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> [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%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=ezhTvRY7RiF2lmYCPtqWxA9rNMn28HZALE3X4sRirOI%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><img style="width: 1.6875in; height: 0.6458in;" id="m_2508169753346281241m_-5231090868842743171m_-8441327975158671966_x005f_x0000_i1034" src="https://www.upf.edu/documents/10193/6775906/signatura-correu.png" alt="https://www.upf.edu/documents/10193/6775906/signatura-correu.png" width="162" height="62" border="0"><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 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><a href="mailto:andres.chandia@upf.edu" target="_blank"><span style="font-size:10pt;font-family:"Verdana",sans-serif" lang="ES">mail:andres.chandia@upf.edu</span></a><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%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=CgtSgP2R2MQ80hIcqDaVwuAM2a6%2BwYyebyCawt3a5WM%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 1.0208in; height: 0.4583in;" id="m_2508169753346281241m_-5231090868842743171m_-8441327975158671966_x005f_x0000_i1033" 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%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=1nGPHU33SjcYGU6enQ2yX9OYdptvxQqUlCEGXsrSW5o%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 0.2083in; height: 0.2083in;" id="m_2508169753346281241m_-5231090868842743171m_-8441327975158671966_x005f_x0000_i1032" src="http://mail.chandia.net/images/ico_tw.png" alt="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_2508169753346281241m_-5231090868842743171m_-8441327975158671966_x005f_x0000_i1031" src="https://ci3.googleusercontent.com/mail-sig/AIorK4yTWuuJgoqJ3i-Ir0NHJSpAWwqSbLjzJMBbgf9K5Gx_Y6mX0PQFjwgdrACBE8bL2e72tMi4zAQ" alt="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%7Ca186a32d9f11444ab61408da9a509e47%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637991968290801022%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=R09uIOYDO2Fqwts%2BqngOYo8nfePgB7zOCeET9GWQKXw%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>
</blockquote></div>