<div dir="ltr">By the way, the table "<a href="http://corptedig-glif.upf.edu/phpmyadmin/index.php?route=/sql&db=cqp&table=text_metadata_for_bnc">text_metadata_for_bnc</a>" gets created, but empty.<br><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 20:21:<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>I've searched for <span style="font-size:10pt;font-family:"Verdana",sans-serif;color:rgb(31,73,125)"><b>secure_file_priv</b></span> 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...</div><div>I've changed from false to<br></div><div>$mysql_has_file_access = true;</div><div></div><div>in /lib/defaults.inc.php and /lib/defaults.php:</div><div>and now the error has changed to something more weird:</div><div><br></div><div>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="http://corptedig-glif.upf.edu/cqpweb/bnc/index.php?ui=manageMetadata" target="_blank">http://corptedig-glif.upf.edu/cqpweb/bnc/index.php?ui=manageMetadata</a></div><div><br></div><div>I looked for the database configuration in lib/config.inc.php</div><div>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.<br></div><div><br></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 19:51:<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)">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. <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)">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.<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)">Section “Known “gotchas” in SQL DB setup”; paragraph “File privilege with restricted scope”<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)">(you could also try just setting $mysql_has_file_access in cqpweb, so that LOCAL isn’t needed)<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)">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 18:33<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>
<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-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)">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">
<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:45<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> [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%7C16bf14713f86434f897408da9a651849%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992056230955405%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=f1gas%2FDaOlbHAFlkSpkVtZOGmCwbsDugcPgksfv7grw%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%7C16bf14713f86434f897408da9a651849%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992056230955405%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=z4cjvLYN1nV%2BDTVVYGGFODk2YnYrPiDcDj%2BSISFW9eY%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_-617174952564406226m_-8103867598491503056m_6188317237436349227_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%7C16bf14713f86434f897408da9a651849%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992056230955405%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=EDbQfkwDgwIcsQoIWC5r%2BlJeCeRXhOdb3MVSD6qC%2FhM%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 1.0208in; height: 0.4583in;" id="m_-617174952564406226m_-8103867598491503056m_6188317237436349227_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%7C16bf14713f86434f897408da9a651849%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992056230955405%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=d6LlZcQ%2BsP%2ByitqThYGrpFw7Fu4LL71RpWL5ioa3KIE%3D&reserved=0" target="_blank"><span style="text-decoration:none"><img style="width: 0.2083in; height: 0.2083in;" id="m_-617174952564406226m_-8103867598491503056m_6188317237436349227_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_-617174952564406226m_-8103867598491503056m_6188317237436349227_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%7C16bf14713f86434f897408da9a651849%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992056230955405%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nC1692p4LUhjaXvF2MibniCgANDlj3JSFen0BkXcx%2B8%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%7C16bf14713f86434f897408da9a651849%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992056230955405%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nC1692p4LUhjaXvF2MibniCgANDlj3JSFen0BkXcx%2B8%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%7C16bf14713f86434f897408da9a651849%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C0%7C637992056230955405%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=nC1692p4LUhjaXvF2MibniCgANDlj3JSFen0BkXcx%2B8%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>