<div dir="ltr"><div>Och .. thanks for reminding me of "Manage privileges"! (Guess I would not have forgotten that step if those privileges get generated automatically after a new corpus is installed. Or maybe they aren't for an important reason?)<br>I manually added users because I failed to remember that important step, and connecting to MySQL as root was also a desperate attempt to solve the problem. Thanks a lot Andrew!</div><div><br></div><div>Best<br></div><div>Jiayue<br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 2 October 2017 at 17:06, Hardie, Andrew <span dir="ltr"><<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-GB">
<div class="m_6969774882056746318WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">Did you actually create a privilege covering the new corpus? This is not done automatically. You need to do it using “Manage privileges”.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">Also, on an unrelated issue,<u></u><u></u></span></p><span class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">>>></span>2. I created the cqpweb_db users explicitly in mysql, and these users all have select privilege to cqpweb_db;<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">I don’t understand. Why do you need more than one MySQL user for the cqpweb_db? Or are you referring to CQPweb usernames? IT is not a good idea to create these
manually in MySQL. You should use the CQPweb functions.<u></u><u></u></span></p><span class="">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">>>></span> in config.inc.php, $mysql_webuser is set to admin (superuser)<i><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u><u></u></span></i></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">It is a bad bad bad idea to have CQPweb connect to MySQL as administrator (root), if I have correctly understood that that is what you are doing. It is a huge
security hole.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">best<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">Andrew.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US"> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank">cwb-bounces@sslmit.<wbr>unibo.it</a>]
<b>On Behalf Of </b>Jiayue Wang<br>
<b>Sent:</b> 02 October 2017 02:23<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> [CWB] Problem granting privileges<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">When I tried granting privileges to user groups ("everyone", and a group called "graduate") I couldn't find the name of a newly installed corpus in the "Select privilege" drop down list. I don't know which information
could help with diagnosis; I guess the following might be relevant:<u></u><u></u></p>
</div>
<p class="MsoNormal">1. the cqpweb_db database was re-created using the mysqldump method, not constructed bit by bit;<u></u><u></u></p>
</div>
<p class="MsoNormal">2. I created the cqpweb_db users explicitly in mysql, and these users all have select privilege to cqpweb_db;<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">3. in config.inc.php, $mysql_webuser is set to admin (superuser).<u></u><u></u></p>
</div>
<p class="MsoNormal">Thanks for any help!<u></u><u></u></p>
</div>
<p class="MsoNormal"><br>
Jiayue<br clear="all">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><br>
-- <u></u><u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Jiayue Wang<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">College of Foreign Studies<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Guangxi University for Nationalties<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Nanning, China 530006<u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div>
<br>______________________________<wbr>_________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it">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/<wbr>mailman/listinfo/cwb</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>Jiayue Wang</div><div>College of Foreign Studies</div><div>Guangxi University for Nationalties</div><div>Nanning, China 530006</div></div></div>
</div>