My fault again, sorry<br /><br /><br />El Vie, 5 de Octubre de 2012, 16:11, Hardie, Andrew
escribió:<br /> <!-- begin sanitized html --> <style type="text/css">-></style>
<div class="bodyclass">
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Is
admin2 declared as a superuser in the config file?</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span><span style="font-size:10.0pt;font-family:"Courier
New";color:black">$superuser_username = 'admin|admin2';</span><span
style="font-size:13.5pt;color:black"></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">This
is specified under the manual configuration section (adding new superusers must always be done
manually, for security reasons).</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><strong><span lang="EN-US"
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></strong><span
lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
"Andrés Chandía" [mailto:andres@chandia.net] <br />
<strong>Sent:</strong> 05 October 2012 14:59<br /> <strong>To:</strong> Hardie, Andrew<br />
<strong>Cc:</strong> Open source development of the Corpus WorkBench<br />
<strong>Subject:</strong> RE: [CWB] CQPweb</span></p>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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ó:</p>
<div>
<div>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Hi
Andria,</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">There
is an additional step to carry out after running the auto config script.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">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
target="_blank" title="Este enlace externo se abrirá en una nueva ventana"
href="http://yourserver.net/path/to/cqpweb/adm">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.</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><strong><span
lang="EN-US"
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></strong><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] <strong><span
style="font-family:"Tahoma","sans-serif"">On Behalf Of
</span></strong>"Andrés Chandía"<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Sent:</span></strong> 05 October
2012 12:24<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">To:</span></strong>
cwb@sslmit.unibo.it<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Subject:</span></strong> [CWB]
CQPweb</span></p>
</div>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal">Hi there<br />
<br /> I'm following. "Some notes on how to set up CQPweb (v 3.0.0 or higher"<br />
(http://cwb.svn.sourceforge.net/viewvc/cwb/gui/cqpweb/trunk/CQPweb-setup-manual.html)<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:</p>
<p class="errormessage">A mySQL query did not run successfully!</p>
<p class="errormessage">Error # 1146: Table 'cqp.corpus_metadata_fixed' doesn't exist </p>
<p style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto" class="MsoNormal"><br /> <br />
<br /> _______________________<br /> andrés chandía<br /> <a target="_blank"
title="Este enlace externo se abrirá en una nueva ventana" href="http://www.chandia.net"><span
style="border:solid windowtext 1.0pt;padding:0cm;text-decoration:none">[IMAGE
REMOVED]</span></a><br /> <span style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P
</span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4F6228">No
imprima innecesariamente. ¡Cuide el medio ambiente!</span></p>
</div>
</div>
<p class="MsoNormal"><br /> <br /> <br /> _______________________<br />
andrés chandía<br /> <a target="_blank" title="Este enlace externo se abrirá en
una nueva ventana" href="http://www.chandia.net"><span style="border:solid windowtext
1.0pt;padding:0cm;text-decoration:none">[IMAGE REMOVED]</span></a><br /> <span
style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P </span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#4F6228">No
imprima innecesariamente. ¡Cuide el medio ambiente!</span></p>
</div>
</div>
<!-- end sanitized html --> <br /><br /><br />_______________________<br
/> andrés
chandía<br /><a title="This external link will open in a new window" target="_blank"
href="http://www.chandia.net"><img border="0" alt="chandia.net"
src="http://www.chandia.net/sites/default/files/images/chandia.netd.png" /></a><br /><span
style="font-size: 18pt; color: rgb(79, 98, 40); font-family: Webdings;">P </span><span
style="font-size: 10pt; color: rgb(79, 98, 40); font-family: 'Arial','sans-serif';">No imprima
innecesariamente. ¡Cuide el medio ambiente!</span>