<div dir="ltr"><div>Sorry Andrew for keeping going on with this, but I find no solution...</div><div>I turn back to false $mysql_has_file_access</div><div>and, as it says in the manual: <br></div><div><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr" class="gmail-">default value of</span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr"> </span><span style="font-size:18.1818px;font-family:monospace" role="presentation" dir="ltr" class="gmail-">secure file priv</span><span style="font-size:18.1818px;font-family:monospace" role="presentation" dir="ltr"> </span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr" class="gmail-">has changed. In this case, instead of</span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr"> </span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr">changing</span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr"> </span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr" class="gmail-">the value of</span><br role="presentation"><span style="font-size:18.1818px;font-family:monospace" role="presentation" dir="ltr" class="gmail-">secure file priv</span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr" class="gmail-">, to fix the problem you need to</span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr"> </span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr">add</span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr"> </span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr">a line</span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr"> </span><span style="font-size:18.1818px;font-family:monospace" role="presentation" dir="ltr" class="gmail-">secure file priv=""</span><span style="font-size:18.1818px;font-family:monospace" role="presentation" dir="ltr"> </span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr">to your</span><br role="presentation"><span style="font-size:18.1818px;font-family:monospace" role="presentation" dir="ltr" class="gmail-">my.cnf</span><span style="font-size:18.1818px;font-family:monospace" role="presentation" dir="ltr"> </span><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr" class="gmail-">file to restore what was previously the default state.</span><br role="presentation"><span style="font-size:18.1818px;font-family:sans-serif" role="presentation" dir="ltr" class="gmail-">It’s unknown whether this issue affects MariaDB as well as MySQL.</span></div><div></div><div><br></div><div>first, I have tried adding <br></div><div>secure_file_priv = ""</div><div>to /etc/mysql/mysql.conf.d/mysqld.cnf</div><div><br></div><div>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)</div><div><br></div><div>results in:<br></div><div>Got error 'PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: LOAD DATA LOCAL INFILE is forbidden</div><div><br></div><div>second, I have tried adding:</div><div>secure_file_priv = /corpora/cqp/tmp/</div><div><br></div><div>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)</div><div><br></div><div>where <br></div><div>ls -la /corpora/cqp/</div><div>drwxrwxr-x 2 www-data cqpweb 217088 sep 19 17:46 tmp</div><div><br></div><div>and <br></div><div>grep '^cqpweb:.*$' /etc/group | cut -d: -f4<br>mysql,www-data</div><div><br></div><div>but the same error comes up</div><div>Got error 'PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: LOAD DATA LOCAL INFILE is forbidden</div><div><br></div><div><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 1:26:<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="msg747767187505992672">
<div style="overflow-wrap: break-word;" lang="EN-GB">
<div class="m_8974095686290848400WordSection1">
<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.<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)"><img style="width: 5.1875in; height: 5.7291in;" id="m_8974095686290848400Picture_x0020_1" src="cid:1835bb260a54cff311" width="498" height="550"></span><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 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<u></u><u></u></span></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-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:5pt 0cm 5pt 4.8pt">
<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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105380998817%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=8CWzkImIMISC7cZa5Wob6n6vaaoB6RUCwQRPxJRhREo%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-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:5pt 0cm 5pt 4.8pt">
<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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105380998817%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=TArNe9KGfzdOtKNsLKR4NlxHPCqiyqhMsdnieBUfnII%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-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:5pt 0cm 5pt 4.8pt">
<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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105380998817%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=Hiw6n0efCTBotue4y8gFsZuCLa1dPcyHBlx9ayHL1w8%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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105380998817%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=TArNe9KGfzdOtKNsLKR4NlxHPCqiyqhMsdnieBUfnII%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;font-family:"Times New Roman",serif"><img style="width: 1.6875in; height: 0.6458in;" id="m_8974095686290848400_x0000_i1037" src="https://www.upf.edu/documents/10193/6775906/signatura-correu.png" width="162" height="62" border="0"></span><span style="font-size:10pt;font-family:"Times New Roman",serif"><u></u><u></u></span></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;font-family:"Times New Roman",serif" 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;font-family:"Times New Roman",serif"><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><u></u><u></u></span></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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105380998817%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=UJ07ZYiUITwDkaeZKrIsj0B4tkZpFcin1IO4Ms5K%2B74%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 1.0208in; height: 0.4583in;" id="m_8974095686290848400_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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105381155038%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=S4iCyaAtztNenNh12iHKjsnd2pOmmZF0OItlTP5zHTY%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 0.2083in; height: 0.2083in;" id="m_8974095686290848400_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_8974095686290848400_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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105381155038%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=CtelZB0Wb%2BiZ3i2wjuptCwRoXPiGShR5w%2FYKxMh47nQ%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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105381155038%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=CtelZB0Wb%2BiZ3i2wjuptCwRoXPiGShR5w%2FYKxMh47nQ%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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105381155038%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=CtelZB0Wb%2BiZ3i2wjuptCwRoXPiGShR5w%2FYKxMh47nQ%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%7C4849e79a37294542f1e708da9a7064ea%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992105381155038%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=CtelZB0Wb%2BiZ3i2wjuptCwRoXPiGShR5w%2FYKxMh47nQ%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>
_______________________________________________<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>