Hi Andres, hi Andrew,<div><br></div><div>I wrote a few hours ago, but it seems that my problem is similar to Andres', when he could log in with admin2. The difference is that I cannot log in even with admin (in my case called spintexweb)</div>
<div><br></div><div><div>file .htgroup</div><div>superusers: spintexweb</div><div><br></div><div>file .htpasswd</div><div>spintexweb:$apr1$JXkH5IeU$RnOa/bUHrsgV3ZqnRQhDc.</div></div><div><br></div><div><div>file: ../adm/.htacces</div>
<div>AuthUserFile ../AccessData/.htpasswd</div><div> AuthGroupFile ../AccessData/.htgroup</div><div> AuthName CQPweb</div><div> AuthType Basic</div><div> deny from all</div><div> require group superusers</div>
<div> satisfy any</div><div><br></div>My problem is that <a href="http://localhost/spintx-web/adm/">http://localhost/spintx-web/adm/</a> does not load:</div><div><br></div><div><p class="errormessage">CQPweb encountered an error and could not continue.</p>
<p class="errormessage">You do not have permission to use this program.</p><p class="errormessage">And in principle all user permissions are set ok for apache2's user as well as for mysql user (I created a group called cqpweb, which they all belong too):</p>
<p class="errormessage"></p><p class="errormessage">/Library/WebServer/Documents/spintx-web/adm</p><p class="errormessage">sh-3.2# ls -l</p><p class="errormessage">-rw-rw-r-- 1 root cqpweb 181 Oct 6 08:29 .htaccess</p>
<p class="errormessage">-rw-rw-r-- 1 spintxweb cqpweb 51 Jun 11 2009 index.php</p><p class="errormessage">-rw-rw-r-- 1 spintxweb cqpweb 9 Jun 11 2009 settings.inc.php</p><p></p><p class="errormessage">Is there something you can suggest?</p>
<p class="errormessage">Best</p><p class="errormessage">mq</p></div><div><div class="gmail_quote">On Fri, Oct 5, 2012 at 9:18 AM, <span dir="ltr"><<a href="mailto:cwb-request@sslmit.unibo.it" target="_blank">cwb-request@sslmit.unibo.it</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send CWB mailing list submissions to<br>
<a href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:cwb-request@sslmit.unibo.it">cwb-request@sslmit.unibo.it</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:cwb-owner@sslmit.unibo.it">cwb-owner@sslmit.unibo.it</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of CWB digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: CQPweb (Hardie, Andrew)<br>
2. Re: CQPweb (Andr?s Chand?a)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Fri, 5 Oct 2012 14:11:47 +0000<br>
From: "Hardie, Andrew" <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>><br>
To: "<a href="mailto:andres@chandia.net">andres@chandia.net</a>" <<a href="mailto:andres@chandia.net">andres@chandia.net</a>><br>
Cc: Open source development of the Corpus WorkBench<br>
<<a href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a>><br>
Subject: Re: [CWB] CQPweb<br>
Message-ID:<br>
<28078EC3FBF1B940A3EF3D0D19BE351D0D0BC0@EX-0-MB1.lancs.local><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Is admin2 declared as a superuser in the config file?<br>
<br>
<br>
$superuser_username = 'admin|admin2';<br>
<br>
This is specified under the manual configuration section (adding new superusers must always be done manually, for security reasons).<br>
<br>
best<br>
<br>
Andrew.<br>
<br>
From: "Andr?s Chand?a" [mailto:<a href="mailto:andres@chandia.net">andres@chandia.net</a>]<br>
Sent: 05 October 2012 14:59<br>
To: Hardie, Andrew<br>
Cc: Open source development of the Corpus WorkBench<br>
Subject: RE: [CWB] CQPweb<br>
<br>
I have now some issues with the users created by htpasswd<br>
<br>
file .htpasswd<br>
admin:asjdkalsdkaIDAS<br>
admin2:asdeAALQ393R<br>
<br>
file .htgroup<br>
superusers: admin admin2<br>
<br>
file : .../cqp/adm/.htaccess<br>
AuthUserFile .../cqp/users/.htpasswd<br>
AuthGroupFile .../cqp/users/.htgroup<br>
AuthName CQPweb<br>
AuthType Basic<br>
deny from all<br>
require group superusers<br>
satisfy any<br>
<br>
<br>
the user admin has no problem but the user admin2, when log in it gets this at the web interface:<br>
<br>
CQPweb encountered an error and could not continue.<br>
<br>
You do not have permission to use this program.<br>
<br>
You are logged in as user [admin2]<br>
<br>
<br>
Did I do something wrong?<br>
<br>
<br>
<br>
<br>
El Vie, 5 de Octubre de 2012, 13:45, Hardie, Andrew escribi?:<br>
Hi Andria,<br>
There is an additional step to carry out after running the auto config script.<br>
As it says further down the installation instructions - under "Getting it up and running" - you need to first of all go into the Admin interface (<a href="http://yourserver.net/path/to/cqpweb/adm" target="_blank">http://yourserver.net/path/to/cqpweb/adm</a>) and use the tool to "Reset MySQL Database" via the menu option on the left-hand side.<br>
best<br>
Andrew.<br>
From: <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>] On Behalf Of "Andr?s Chand?a"<br>
Sent: 05 October 2012 12:24<br>
To: <a href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a><br>
Subject: [CWB] CQPweb<br>
Hi there<br>
<br>
I'm following. "Some notes on how to set up CQPweb (v 3.0.0 or higher"<br>
(<a href="http://cwb.svn.sourceforge.net/viewvc/cwb/gui/cqpweb/trunk/CQPweb-setup-manual.html" target="_blank">http://cwb.svn.sourceforge.net/viewvc/cwb/gui/cqpweb/trunk/CQPweb-setup-manual.html</a>)<br>
<br>
<br>
And the problem that I have is about the creation of the database, these are not being created automatically,<br>
I did it with the assigned db username and also with the db admin username but nothing happens, I mean.<br>
I do create database "cqpwebdb"<br>
<br>
on mysql: GRANT ALL ON cqpwebdb.* TO 'userofcqpdb'@'localhost' IDENTIFIED BY 'passwordofcqpdb';<br>
<br>
then: php cqpweb-autoconfig.php<br>
giving "cqpwebdb" and "passwordofcqpdb";<br>
<br>
as this didn't work I did it wwith the root account of mysql but nothing, should I create manually the tables, or what should I do.<br>
<br>
At the web:<br>
<br>
A mySQL query did not run successfully!<br>
<br>
Error # 1146: Table 'cqp.corpus_metadata_fixed' doesn't exist<br>
<br>
<br>
<br>
_______________________<br>
andr?s chand?a<br>
[IMAGE REMOVED]<<a href="http://www.chandia.net" target="_blank">http://www.chandia.net</a>><br>
P No imprima innecesariamente. ?Cuide el medio ambiente!<br>
<br>
<br>
<br>
_______________________<br>
andr?s chand?a<br>
[Image removed by sender. <a href="http://chandia.net" target="_blank">chandia.net</a>]<<a href="http://www.chandia.net" target="_blank">http://www.chandia.net</a>><br>
P No imprima innecesariamente. ?Cuide el medio ambiente!<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/07983ec6/attachment-0001.html" target="_blank">http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/07983ec6/attachment-0001.html</a>><br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: ~WRD367.jpg<br>
Type: image/jpeg<br>
Size: 823 bytes<br>
Desc: ~WRD367.jpg<br>
URL: <<a href="http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/07983ec6/attachment-0001.jpg" target="_blank">http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/07983ec6/attachment-0001.jpg</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Fri, 5 Oct 2012 16:18:21 +0200<br>
From: "Andr?s Chand?a" <<a href="mailto:andres@chandia.net">andres@chandia.net</a>><br>
To: "Hardie, Andrew" <<a href="mailto:a.hardie@lancaster.ac.uk">a.hardie@lancaster.ac.uk</a>><br>
Cc: Open source development of the Corpus WorkBench<br>
<<a href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a>><br>
Subject: Re: [CWB] CQPweb<br>
Message-ID:<br>
<<a href="mailto:3156fd711511afc45eb2526613eeeae6.squirrel@mail.chandia.net">3156fd711511afc45eb2526613eeeae6.squirrel@mail.chandia.net</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
<br>
<br>
My fault again, sorry<br>
<br>
<br>
El Vie, 5 de Octubre de 2012, 16:11, Hardie, Andrew<br>
escribi?:<br>
<style type="text/css">-></style><br>
<br>
<br>
Is<br>
admin2 declared as a superuser in the config file?<br>
<br>
<br>
<br>
<br>
$superuser_username = 'admin|admin2';<br>
<br>
<br>
This<br>
is specified under the manual configuration section (adding new superusers must always be done<br>
manually, for security reasons).<br>
<br>
<br>
best<br>
<br>
<br>
Andrew.<br>
<br>
<br>
<br>
From:<br>
"Andr?s Chand?a" [mailto:<a href="mailto:andres@chandia.net">andres@chandia.net</a>]<br>
<br>
Sent: 05 October 2012 14:59<br>
To: Hardie, Andrew<br>
<br>
Cc: Open source development of the Corpus WorkBench<br>
<br>
Subject: RE: [CWB] CQPweb<br>
<br>
<br>
I have now some issues with the users created by htpasswd<br>
<br>
<br>
file .htpasswd<br>
admin:asjdkalsdkaIDAS<br>
admin2:asdeAALQ393R<br>
<br>
file<br>
.htgroup<br>
superusers: admin admin2<br>
<br>
file : .../cqp/adm/.htaccess<br>
<br>
AuthUserFile .../cqp/users/.htpasswd<br>
AuthGroupFile .../cqp/users/.htgroup<br>
<br>
AuthName CQPweb<br>
AuthType Basic<br>
deny from all<br>
<br>
require group superusers<br>
satisfy any<br>
<br>
<br>
the user admin has no<br>
problem but the user admin2, when log in it gets this at the web interface:<br>
<br>
<br>
CQPweb encountered an error and could not continue.<br>
<br>
You do not have permission to<br>
use this program.<br>
<br>
You are logged in as user [admin2]<br>
<br>
<br>
Did I do<br>
something wrong?<br>
<br>
<br>
<br>
<br>
El Vie, 5 de Octubre de 2012, 13:45,<br>
Hardie, Andrew escribi?:<br>
<br>
<br>
Hi<br>
Andria,<br>
There<br>
is an additional step to carry out after running the auto config script.<br>
As<br>
it says further down the installation instructions &ndash; under &ldquo;Getting it up and<br>
running&rdquo; &ndash; you need to first of all go into the Admin interface (<a href="http://yourserver.net/path/to/cqpweb/adm" target="_blank">http://yourserver.net/path/to/cqpweb/adm</a>)<br>
and use the tool to &ldquo;Reset MySQL Database&rdquo; via the menu option on the left-hand<br>
side.<br>
best<br>
Andrew.<br>
<br>
From:<br>
<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>] On Behalf Of<br>
"Andr?s Chand?a"<br>
Sent: 05 October<br>
2012 12:24<br>
To:<br>
<a href="mailto:cwb@sslmit.unibo.it">cwb@sslmit.unibo.it</a><br>
Subject: [CWB]<br>
CQPweb<br>
<br>
Hi there<br>
<br>
<br>
I'm following. "Some notes on how to set up CQPweb (v 3.0.0 or higher"<br>
<br>
(<a href="http://cwb.svn.sourceforge.net/viewvc/cwb/gui/cqpweb/trunk/CQPweb-setup-manual.html" target="_blank">http://cwb.svn.sourceforge.net/viewvc/cwb/gui/cqpweb/trunk/CQPweb-setup-manual.html</a>)<br>
<br>
<br>
<br>
And the problem that I have is about the creation of the database, these are not<br>
being created automatically,<br>
I did it with the assigned db username and also with the db<br>
admin username but nothing happens, I mean.<br>
I do create database "cqpwebdb"<br>
<br>
on mysql: GRANT ALL ON cqpwebdb.* TO 'userofcqpdb'@'localhost' IDENTIFIED BY<br>
'passwordofcqpdb';<br>
<br>
then: php cqpweb-autoconfig.php<br>
giving<br>
"cqpwebdb" and "passwordofcqpdb";<br>
<br>
as this didn't work I did<br>
it wwith the root account of mysql but nothing, should I create manually the tables, or what<br>
should I do.<br>
<br>
At the web:<br>
A mySQL query did not run successfully!<br>
Error # 1146: Table 'cqp.corpus_metadata_fixed' doesn't exist<br>
<br>
<br>
<br>
<br>
_______________________<br>
andr?s chand?a<br>
[IMAGE<br>
REMOVED]<br>
P<br>
No<br>
imprima innecesariamente. ?Cuide el medio ambiente!<br>
<br>
<br>
<br>
<br>
<br>
_______________________<br>
<br>
andr?s chand?a<br>
<br>
P No<br>
imprima innecesariamente. ?Cuide el medio ambiente!<br>
<br>
<br>
<br>
<br>
<br>
_______________________<br>
????????????andr?s<br>
chand?a<br>
<br>
P No imprima<br>
innecesariamente. ?Cuide el medio ambiente!<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/a13d5889/attachment.html" target="_blank">http://devel.sslmit.unibo.it/pipermail/cwb/attachments/20121005/a13d5889/attachment.html</a>><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
CWB mailing list<br>
<a href="mailto:CWB@sslmit.unibo.it">CWB@sslmit.unibo.it</a><br>
<a href="http://devel.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank">http://devel.sslmit.unibo.it/mailman/listinfo/cwb</a><br>
<br>
<br>
End of CWB Digest, Vol 70, Issue 2<br>
**********************************<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Martí Quixal<div>Computational Linguist & Educational Technologist</div><div><a href="http://www.iqubo.org/quixal" target="_blank">http://www.iqubo.org/quixal</a></div>
<br>
</div>