<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Verdana","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Verdana","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Hi Ray,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">This is giving me a clearer idea but no solution as yet.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">I spot one odd thing: you have .htaccess and .htgroup files in the cqpweb_aux directory, should they not be in the “user” subdirectory?
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">What is the
<b>ls –al</b> of the “user” subdirectory? <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">And, what is the value of $cqpweb_accessdir in the config file?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">On the other problem: what is the
<b>ls –al </b>of the “cqpweb_aux/temp” subdirectory? <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">On both, have you checked the value of the php.ini directive “open_basedir”? (This can also be set in httpd.conf or other Apache config file, see
</span><a href="http://www.php.net/manual/en/ini.core.php#ini.open-basedir">http://www.php.net/manual/en/ini.core.php#ini.open-basedir</a><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> cwb-bounces@sslmit.unibo.it [mailto:cwb-bounces@sslmit.unibo.it]
<b>On Behalf Of </b>Ray Wu<br>
<b>Sent:</b> 20 May 2012 14:09<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> RE: RE: [CWB] Two issues regarding CQPweb revision 316<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black">Hi Andrew,<br>
<br>
Thanks for your unfailing help! I rechecked my CQPweb setup and gathered the following information for your reference.<br>
<br>
//////Access control of CQPweb//////<br>
My CQPweb's data directory:<br>
/usr/local/apache2/cqpweb_aux$ ls<br>
index registry temp upload user<br>
<br>
My CQPweb's program directory:<br>
/usr/local/apache2/htdocs/cqp<br>
/usr/local/apache2/htdocs/cqp/adm<br>
/usr/local/apache2/htdocs/cqp/lib<br>
...<br>
My mysqld and httpd:<br>
$ sudo ps -e -o user,comm<br>
root mysqld_safe<br>
mysql mysqld<br>
nobody httpd<br>
<br>
My user group for mysqld and httpd:<br>
$ sudo groupadd cqpweb<br>
$ sudo usermod -g cqpweb mysql<br>
$ sudo usermod -g cqpweb nobody<br>
$ sudo chgrp -hR cqpweb /usr/local/apache2/cqpweb_aux/temp<br>
$ sudo chgrp -hR cqpweb /usr/local/apache2/cqpweb_aux/user<br>
$ sudo chgrp -hR cqpweb /usr/local/apache2/htdocs/cqp/<br>
<br>
/usr/local/apache2/cqpweb_aux$ ls -al<br>
drwxrwxrwx 7 nobody cqpweb 4096 2012-05-20 18:50 .<br>
drwxr-xr-x 17 root root 4096 2012-05-13 22:46 ..<br>
-rwxrwxr-- 1 nobody cqpweb 19 2012-05-15 16:48 .htgroup<br>
-rwxrwxr-- 1 nobody cqpweb 21 2012-05-15 18:25 .htpasswd<br>
drwxrwxr-x 6 nobody cqpweb 4096 2012-05-20 19:36 index<br>
drwxrwxr-x 2 nobody cqpweb 4096 2012-05-20 19:36 registry<br>
drwxrwxr-x 2 nobody cqpweb 4096 2012-05-20 19:36 temp<br>
drwxrwxr-x 3 nobody cqpweb 4096 2012-05-19 16:59 upload<br>
drwxrwxr-x 2 nobody cqpweb 4096 2012-05-20 18:56 user<br>
<br>
/usr/local/apache2/htdocs/cqp$ ls -al<br>
drwxrwxr-x 2 nobody cqpweb 4096 2012-05-19 17:13 test<br>
...<br>
/usr/local/apache2/htdocs/cqp/test$ ls -al<br>
-rwxrwxr-x 1 nobody cqpweb 39 2012-05-19 17:13 api.php<br>
-rwxrwxr-x 1 nobody cqpweb 47 2012-05-19 17:13 collocation.php<br>
-rwxrwxr-x 1 nobody cqpweb 47 2012-05-19 17:13 concordance.php<br>
-rwxrwxr-x 1 nobody cqpweb 210 2012-05-20 14:30 .htaccess<br>
...<br>
//////CQPweb diagnostic ouput//////<br>
Diagnosing connection to child process for CQP back-end<br>
Beginning diagnostics on CQP child process connection.<br>
Using following configuration variables:<br>
$path_to_cqp = ``usr/local/bin''<br>
$cwb_registry = ``usr/local/apache2/cqpweb_aux/registry''<br>
Checking that /usr/local/bin exists... yes it does!<br>
Checking that CQP program exists... yes it does!<br>
Checking that CQP program is executable by this user... yes it is!<br>
Checking that /usr/local/apache2/cqpweb_aux/registry exists... yes it does!<br>
Checking that CWB registry is readable by this user... yes it is!<br>
The connection to the CQP child process was successful.<br>
<br>
//////Setup of apparmor//////<br>
/etc/apparmor.d$ sudo vi usr.sbin.mysqld <br>
#include <tunables/global><br>
/usr/sbin/cupsd {<br>
/usr/local/apache2/cqpweb_aux/user/** rw,<br>
/usr/local/apache2/cqpweb_aux/temp/** rw,<br>
/usr/local/apache2/htdocs/cqp/test/** rw,<br>
}<br>
/etc/apparmor.d$ sudo /etc/init.d/apparmor restart<br>
Reloading AppArmor profiles : done.<br>
<br>
//////write-permission test script as you suggested//////<br>
/usr/local/apache2/htdocs/cqp$ cat checkwrite.php <br>
<?php<br>
if (false !== file_put_contents('/usr/local/apache2/cqpweb_aux/temp/file_for_Check', 'ffff')) echo "YES"; else echo "NO.";<br>
if (false !== file_put_contents('/usr/local/apache2/cqpweb_aux/user/file_for_Check', 'ffff')) echo "YES"; else echo "NO.";<br>
if (false !== file_put_contents('/usr/local/apache2/htdocs/cqp/test/file_for_Check', 'ffff')) echo "YES"; else echo "NO.";<br>
?><br>
After running <a href="http://172.21.13.23/cqp/checkwrite.php">http://172.21.13.23/cqp/checkwrite.php</a>, the browser writes "YESYESYES".<br>
<br>
//////I then start to rerun the aforementioned procesures on my said toy corpus to recheck Issue 1//////<br>
1. "Manage metadata"->"Recreate frequency tables" yields an error:<br>
A function was passed an invalid argument type!<br>
Argument value was /usr/local/apache2/cqpweb_aux/temp/____temporary_freq_corpus_test.tbl.utf8.tmp. Problem:<br>
This path is not writable.<br>
<br>
This error is quite annoying but I still cannot find out why.<br>
<br>
2. Results of "Create new user (or reset user password)" won't show up in<br>
1) MySQL table "user_settings" (ok now)<br>
2) .htgroup (still no, that it is now understood as I need to run "Manage group membership" before they can show up)<br>
and .htpasswd (ok)files in CQPweb's web usernames and passwords directory <br>
3) GUI of "Manage group membership"->"Manage user groups"(ok)<br>
That means this is not problem.<br>
<br>
3.Results of "Create a batch of user accounts" won't show up in<br>
1) GUI's "Set user's maximum database size" (no) or "Delete a user account" (ok)<br>
2) MySQL table "user_settings" (no)<br>
3) .htgroup (no, understandable now) and .htpasswd (ok) files in CQPweb's web usernames and passwords directory<br>
4) GUI of "Manage group membership"->"Manage user groups" (ok)<br>
So, still two nos here.<br>
<br>
4. Results of "Add new group" won't show up in a corpus's .htaccess file (no, but it is now understood that
<br>
I need to run "Manage user groups" before they can show up)<br>
This is not a problem.<br>
<br>
//////Issue 2 and 3//////<br>
As for Issue 2, yes, you are right - some necessary steps were neglected and I followed your instructions and it works now. That saved me a lot of time scratching my head. Thanks.<br>
<br>
Issue 3? Just to make sure I'm on the right track -no real hurt. :)<br>
<br>
Best,<br>
Ray<br>
<br>
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black"><br>
</span><span style="font-size:10.5pt;font-family:"MS Gothic";color:black">在</span><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black"> 2012-05-20 16:32:36</span><span style="font-size:10.5pt;font-family:"MS Gothic";color:black">，</span><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black">"Hardie, Andrew" <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>>
</span><span style="font-size:10.5pt;font-family:"MS Gothic";color:black">写道：</span><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black"><br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Hi Ray,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Issues 1-I to 1-III sound like permissions problems i.e. httpd can’t write to the access directory (this is the first step in user creation, so if it fails,
the rest won’t work) or alternatively, can’t write to the permissions file because they were created as belonging to another user. Can you check this? Alternatively, it could be an AppArmor etc. issue as well as a Unix permissions issue. Or (thinking of yet
another reason) it could be that CQPweb is unable to invoke the htpasswd binary properly, e.g. if it has the wrong path or is unable to call it.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Issue 2 sounds like a setup issue. Look in the “admin tools – Manage metadata” page. You will see, in the lower half of the screen, four buttons. You need to
press all four, in order, after inserting the metadata table for setup to be complete. The first of these buttons is the one that fills in the fields you mention.
</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Issue 3. Mea maxima culpa - I forgot to bump the version number before committing. Next commit will include beginning work on 3.0.7 and will raise the number.
</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">
<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [mailto:<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a>]
<b>On Behalf Of </b>Ray Wu<br>
<b>Sent:</b> 20 May 2012 07:50<br>
<b>To:</b> <a href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a><br>
<b>Subject:</b> [CWB] Two issues regarding CQPweb revision 316</span><span style="color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:black"> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black">Hi all,<br>
I am trying CQPweb revision 316 and find two small inconvenienences on my computer.<br>
<br>
Issue 1:<br>
I. Results of "Create a batch of user accounts" won't show up in <br>
1) GUI's "Set user's maximum database size" or "Delete a user account" <br>
2) MySQL table "user_settings"<br>
3) .htgroup and .htpasswd files in CQPweb's web usernames and passwords directory<br>
4) GUI of "Manage group membership"->"Manage user groups"<br>
<br>
II. Results of "Create new user (or reset user password)" won't show up in <br>
1) MySQL table "user_settings"<br>
2) .htgroup and .htpasswd files in CQPweb's web usernames and passwords directory<br>
3) GUI of "Manage group membership"->"Manage user groups"<br>
<br>
III. Results of "Add new group" won't show up in a corpus's .htaccess file<br>
<br>
However, manually edit .htgroup and run htpasswd will make users appear in "Delete a user a ccount" but these users still won't show up in "Set user's maximum database size". That said, I can now log in as the new user.
<br>
<br>
Issue 2:<br>
In table "text_metadata_for_test", the fields of "words","cqp_begin","cqp_end" are empty<br>
<br>
Issue 3 (is it an issue?):<br>
The version number on the welcome page is 3.0.5, which doesn't match that (3.0.6) in "Latest news"<br>
<br>
Thanks for any tips. I think if these issues can be fixed, I can start to do real things now.<br>
Best<br>
Ray</span><span style="color:black"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="color:black"> <o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
</div>
</body>
</html>