<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Dear Andrew, Peter and everyone else,<div><br></div><div>Thanks so much for your guys' assistance! I've now got the CQPweb server up and running in a VM and it seems to be mostly working. I'm running into a few problems with CQPweb itself, though, and I'd greatly appreciate a hand.</div><div><br></div><div>I can successfully import the Dickens corpus (<i>Install new corpus</i> > <i>Click here to install a corpus you have already indexed in CWB </i>> [fill in appropriate fields] > <i>Install corpus with settings above</i>). And I can successfully add the metadata (<i>Design and insert a text-metadata table for the corpus</i> > <i>Click here to install metadata from within-corpus XML annotation</i> > [select fields and add descriptions] > <i>Create metadata table from XML using the settings above</i>). </div><div><br></div><div>I can also create the frequency table for text begin/end positions (<i>Admin tools</i> > <i>Manage frequency lists</i> > <i>Text begin/end positions</i> > <i>Update CWB text-position records</i>). So far, so good!</div><div><br></div><div><b>PROBLEM 1.</b> When I go to create the text-by-text frequency lists (<i>Admin tools</i> > <i>Manage frequency lists</i> > <i>Text-by-text freq-lists</i> > <i>Update CWB frequency table</i>) I get an error [1].</div><div><br></div><div><b>PROBLEM 2.</b> When I go to create the word and annotation frequency tables (<i>Admin tools</i> > <i>Manage frequency lists</i> > <i>Frequency tables</i> > <i>Create frequency tables</i>) I get an error [2].</div><div><br></div><div>In both cases there's a 4-5 second delay between when I hit the button and when the error us shown, accompanied by a large CPU spike, so something right is presumably happening before the errors are thrown.</div><div><br></div><div><b>PROBLEM 3:</b> <i>Backend system</i> > <i>View a MySQL table</i> fails with an error [3].</div><div><br></div><div><b>PROBLEM 4:</b> Diagnosing problems with <i>Backend system</i> > <i>System diagnostics</i> fails with a blank screen.</div><div><br></div><div>Thanks in advance!</div><div>Scott</div><div><br></div><div><b>[1] ERROR WHEN CREATING Text-by-text freq-lists</b></div><div><div><font face="monospace, monospace">CQPweb encountered an error and could not continue.</font></div><div><font face="monospace, monospace">An SQL query did not run successfully!</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">Original query: analyze NO_WRITE_TO_BINLOG table /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:02 */</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">PHP debugging backtrace</font></div><div><font face="monospace, monospace">array(7) {</font></div><div><font face="monospace, monospace"> [1]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(300)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(9) "exiterror"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(3) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> array(3) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(38) "An SQL query did not run successfully!"</font></div><div><font face="monospace, monospace"> [1]=></font></div><div><font face="monospace, monospace"> string(131) "Original query: </font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">analyze NO_WRITE_TO_BINLOG table </font></div><div><font face="monospace, monospace"><span style="white-space:pre"> </span>/* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:02 */</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">"</font></div><div><font face="monospace, monospace"> [2]=></font></div><div><font face="monospace, monospace"> string(161) "Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2 "</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [1]=></font></div><div><font face="monospace, monospace"> NULL</font></div><div><font face="monospace, monospace"> [2]=></font></div><div><font face="monospace, monospace"> NULL</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [2]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(178)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(20) "exiterror_mysqlquery"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(3) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> int(1064)</font></div><div><font face="monospace, monospace"> [1]=></font></div><div><font face="monospace, monospace"> string(146) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2"</font></div><div><font face="monospace, monospace"> [2]=></font></div><div><font face="monospace, monospace"> string(111) "analyze NO_WRITE_TO_BINLOG table </font></div><div><font face="monospace, monospace"><span style="white-space:pre"> </span>/* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:02 */"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [3]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(579)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(12) "do_sql_query"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(111) "analyze NO_WRITE_TO_BINLOG table </font></div><div><font face="monospace, monospace"><span style="white-space:pre"> </span>/* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:02 */"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [4]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(39) "/var/www/html/cqpweb/lib/corpus-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(751)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(18) "get_sql_table_size"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(4) "word"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [5]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(42) "/var/www/html/cqpweb/lib/freqtable-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(695)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(28) "update_corpus_freqtable_size"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(7) "dickens"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [6]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/lib/execute.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(177)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(19) "make_cwb_freq_index"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(7) "dickens"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [7]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/exe/execute.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(1)</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/lib/execute.php"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(7) "require"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace">}</font></div></div><div><br></div><div><br></div><div><br></div><div><b>[2] ERROR WHEN CREATING Word and annotation frequency tables</b></div><div><div><font face="monospace, monospace">CQPweb encountered an error and could not continue.</font></div><div><font face="monospace, monospace">An SQL query did not run successfully!</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">Original query: analyze NO_WRITE_TO_BINLOG table /* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:08 */</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">PHP debugging backtrace</font></div><div><font face="monospace, monospace">array(7) {</font></div><div><font face="monospace, monospace"> [1]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(300)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(9) "exiterror"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(3) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> array(3) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(38) "An SQL query did not run successfully!"</font></div><div><font face="monospace, monospace"> [1]=></font></div><div><font face="monospace, monospace"> string(131) "Original query: </font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">analyze NO_WRITE_TO_BINLOG table </font></div><div><font face="monospace, monospace"><span style="white-space:pre"> </span>/* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:08 */</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">"</font></div><div><font face="monospace, monospace"> [2]=></font></div><div><font face="monospace, monospace"> string(161) "Error # 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2 "</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [1]=></font></div><div><font face="monospace, monospace"> NULL</font></div><div><font face="monospace, monospace"> [2]=></font></div><div><font face="monospace, monospace"> NULL</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [2]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(178)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(20) "exiterror_mysqlquery"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(3) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> int(1064)</font></div><div><font face="monospace, monospace"> [1]=></font></div><div><font face="monospace, monospace"> string(146) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2"</font></div><div><font face="monospace, monospace"> [2]=></font></div><div><font face="monospace, monospace"> string(111) "analyze NO_WRITE_TO_BINLOG table </font></div><div><font face="monospace, monospace"><span style="white-space:pre"> </span>/* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:08 */"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [3]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(579)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(12) "do_sql_query"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(111) "analyze NO_WRITE_TO_BINLOG table </font></div><div><font face="monospace, monospace"><span style="white-space:pre"> </span>/* from User: scott | Function: get_sql_table_size() | 2019-May-11 17:08 */"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [4]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(39) "/var/www/html/cqpweb/lib/corpus-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(751)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(18) "get_sql_table_size"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(4) "word"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [5]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(42) "/var/www/html/cqpweb/lib/freqtable-lib.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(166)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(28) "update_corpus_freqtable_size"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(7) "dickens"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [6]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/lib/execute.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(177)</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(22) "corpus_make_freqtables"</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(7) "dickens"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> [7]=></font></div><div><font face="monospace, monospace"> array(4) {</font></div><div><font face="monospace, monospace"> ["file"]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/exe/execute.php"</font></div><div><font face="monospace, monospace"> ["line"]=></font></div><div><font face="monospace, monospace"> int(1)</font></div><div><font face="monospace, monospace"> ["args"]=></font></div><div><font face="monospace, monospace"> array(1) {</font></div><div><font face="monospace, monospace"> [0]=></font></div><div><font face="monospace, monospace"> string(36) "/var/www/html/cqpweb/lib/execute.php"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace"> ["function"]=></font></div><div><font face="monospace, monospace"> string(7) "require"</font></div><div><font face="monospace, monospace"> }</font></div><div><font face="monospace, monospace">}</font></div><div><font face="monospace, monospace">CQPweb v3.2.34 © 2008-2019<span style="white-space:pre"> </span>Help! on CQPweb<span style="white-space:pre"> </span>You are logged in as user [scott]</font></div><div><font face="monospace, monospace"><br></font></div></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace"><br></font></div><div><b style=""><font face="arial, helvetica, sans-serif">[3] <i>BACKEND SYSTEM</i> > </font></b><b><i>VIEW A MYSQL TABLE</i></b> <b><font face="arial, helvetica, sans-serif">ERROR</font></b></div><div><font face="monospace, monospace"><div>Viewing mySQL table</div><div>An SQL query did not run successfully!</div><div><br></div><div>Original query: SELECT * FROM `` /* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11 17:20 */</div><div><br></div><div>Error # 1103: Incorrect table name ''</div><div><br></div><div>PHP debugging backtrace</div><div>array(5) {</div><div> [1]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"</div><div> ["line"]=></div><div> int(300)</div><div> ["function"]=></div><div> string(9) "exiterror"</div><div> ["args"]=></div><div> array(3) {</div><div> [0]=></div><div> array(3) {</div><div> [0]=></div><div> string(38) "An SQL query did not run successfully!"</div><div> [1]=></div><div> string(115) "Original query: </div><div><br></div><div>SELECT * FROM `` </div><div><span style="white-space:pre"> </span>/* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11 17:20 */</div><div><br></div><div>"</div><div> [2]=></div><div> string(38) "Error # 1103: Incorrect table name '' "</div><div> }</div><div> [1]=></div><div> NULL</div><div> [2]=></div><div> NULL</div><div> }</div><div> }</div><div> [2]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"</div><div> ["line"]=></div><div> int(178)</div><div> ["function"]=></div><div> string(20) "exiterror_mysqlquery"</div><div> ["args"]=></div><div> array(3) {</div><div> [0]=></div><div> int(1103)</div><div> [1]=></div><div> string(23) "Incorrect table name ''"</div><div> [2]=></div><div> string(95) "SELECT * FROM `` </div><div><span style="white-space:pre"> </span>/* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11 17:20 */"</div><div> }</div><div> }</div><div> [3]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(45) "/var/www/html/cqpweb/lib/admin-home-forms.php"</div><div> ["line"]=></div><div> int(5267)</div><div> ["function"]=></div><div> string(12) "do_sql_query"</div><div> ["args"]=></div><div> array(1) {</div><div> [0]=></div><div> string(95) "SELECT * FROM `` </div><div><span style="white-space:pre"> </span>/* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11 17:20 */"</div><div> }</div><div> }</div><div> [4]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(38) "/var/www/html/cqpweb/lib/adminhome.php"</div><div> ["line"]=></div><div> int(361)</div><div> ["function"]=></div><div> string(19) "do_adm_ui_tableview"</div><div> ["args"]=></div><div> array(0) {</div><div> }</div><div> }</div><div> [5]=></div><div> array(4) {</div><div> ["file"]=></div><div> string(34) "/var/www/html/cqpweb/adm/index.php"</div><div> ["line"]=></div><div> int(1)</div><div> ["args"]=></div><div> array(1) {</div><div> [0]=></div><div> string(38) "/var/www/html/cqpweb/lib/adminhome.php"</div><div> }</div><div> ["function"]=></div><div> string(7) "require"</div><div> }</div><div>}</div></font></div><div><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 9, 2019 at 2:36 PM Uhrig, Peter <<a href="mailto:peter.uhrig@fau.de">peter.uhrig@fau.de</a>> wrote:<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 lang="DE">
<div class="gmail-m_1316826412754253199WordSection1">
<p class="MsoNormal"><span style="color:rgb(0,112,192)">Hi Scott,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(0,112,192)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">I hope it is okay if I answer.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">> I've got two copies of </span><span lang="EN-US" style="font-family:"Courier New"">000-default.conf</span><span lang="EN-US"> on a fresh Apache install, one in </span><span lang="EN-US" style="font-family:"Courier New"">/etc/apache2/sites-available/</span><span lang="EN-US"> and
one in </span><span lang="EN-US" style="font-family:"Courier New"">/etc/apache2/site<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-family:"Courier New"">> enabled/</span><span lang="EN-US">. </span><span lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">This is very unlikely. What you usually have is the file in sites-available and a symbolic link to that file in sites-enabled. These links are created by the helper command
a2ensite (=apache2 enable site) and removed by a2dissite (=apache2 disable site).<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">So to answer your questions:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<div>
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">1. Is </span><span lang="EN-US" style="font-family:"Courier New"">/sites-enabled</span><span lang="EN-US"> then the best place for the
</span><span lang="EN-US" style="font-family:"Courier New""><Directory></span><span lang="EN-US"> directive for the purposes I outlined above?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Usually, this would be changed in the file which sits in sites-available and thus also be there in the link to it in sites-enabled.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">2. Is adding the </span><span lang="EN-US" style="font-family:"Courier New""><Directory></span><span lang="EN-US"> directive to the appropriate </span><span lang="EN-US" style="font-family:"Courier New"">000-default.conf</span><span lang="EN-US">
file enough to change the server's document root, or are additional steps required?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">You need to change the following line in that file:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">DocumentRoot /var/www/html<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">to<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">DocumentRoot /var/www/html/cqpweb<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">This line sits in the Virtual Host *:80 by default, which means it will react to whatever it is called with on port 80. This is the default. Leave it like that.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">A note: If you followed Andrew’s installation instructions, the directory is actually called /var/www/html/CQPweb – the capitalization makes a difference, so you may want
to double-check.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">As far as I know, you will not need this directory directive.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">3. Considering you recommend against virtual hosts, should I delete the large
</span><span lang="EN-US" style="font-family:"Courier New""><VirtualHost></span><span lang="EN-US"> entry that's already in both copies of </span><span lang="EN-US" style="font-family:"Courier New"">000-default.conf</span><span lang="EN-US">, or just add the </span><span lang="EN-US" style="font-family:"Courier New""><Directory></span><span lang="EN-US"> directive
before or after it? <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Leave it as it is.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US">4. And finally, is the following correct?<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""><Directory "/var/www/html/cqpweb"></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> AllowOverride None</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> Require all granted</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""> Options FollowSymlinks</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New""></Directory></span><u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I ask because the your manual and Stefan's instruction document have different options for
<span style="font-family:"Courier New"">AllowOverride</span>, and also because <span style="font-family:"Courier New"">Options FollowSymlinks</span> doesn't appear in much documentation (in fact, I'm not sure where I got it from!).<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Looks good to me, but I don’t think you need any of this. What is your OS?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Best,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:rgb(0,112,192)">Peter<u></u><u></u></span></p>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Thu, May 9, 2019 at 8:16 AM Hardie, Andrew <<a href="mailto:a.hardie@lancaster.ac.uk" target="_blank">a.hardie@lancaster.ac.uk</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Hi Scott,</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">The <Directory> directive doesn’t turn a folder into your server’s root : it just specifies
options that apply only to that folder.</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">the directive that specifies the root is
<b>DocumentRoot</b> and depending on your setup you may find it in <b>apache2.conf</b> or in
<b>000-default.conf</b> .</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">You have two options, either change the document root, or else simply access your CQPweb
via <a href="http://localhost/cqpweb" target="_blank">http://localhost/cqpweb</a> (or whatever) which should be working for you now.
</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Generally I would say that you don’t want to add a “cqpweb” file in sites-available unless
you really do want to operate it as a separate vhost (in which cast you’d need a <VirtualHost> directive in that config file). If you
<i>aren’t</i> using such a vhost then the <Directory> directive should probably go inot 000-default.conf</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">best</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)">Andrew
</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(31,73,125)"> </span><span lang="EN-GB"><u></u><u></u></span></p>
<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>Scott Sadowsky<br>
<b>Sent:</b> 09 May 2019 11: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> [CWB] [CQPweb] Final step? Getting Apache to point at CQPweb's root directory</span><span lang="EN-GB"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB"> <u></u><u></u></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span lang="EN-GB">Hi All,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB"> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB">Except for the problem pointed out by Peter yesterday [1], which I'm also facing, I seem to be just a step or two away from having a working CQPweb install. I
just can't get Apache to point to CQPweb's directory as its document root. In </span><span lang="EN-GB" style="font-family:"Courier New"">/etc/apache2/sites-available/cqpweb.conf</span><span lang="EN-GB"> I've got the following, which I would think would be
enough:<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB"> <u></u><u></u></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Courier New""><Directory "/var/www/html/cqpweb"></span><span lang="EN-GB"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Courier New""> AllowOverride None</span><span lang="EN-GB"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Courier New""> Require all granted</span><span lang="EN-GB"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Courier New""> Options FollowSymlinks</span><span lang="EN-GB"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:"Courier New""></Directory></span><span lang="EN-GB"><u></u><u></u></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB"> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB">But alas, Apache opens one of those typical "Welcome to Apache" pages rather than
</span><span lang="EN-GB" style="font-family:"Courier New"">/var/www/html/cqpweb/index.php</span><span lang="EN-GB">, which consists of </span><span lang="EN-GB" style="font-family:"Courier New""><?php require('lib/mainhome.php');</span><span lang="EN-GB">,
and so is clearly not what's being opened. Could someone point me in the right direction? I've tried both
</span><span lang="EN-GB" style="font-family:"Courier New"">AllowOverride None</span><span lang="EN-GB"> (as per the admin manual) and
</span><span lang="EN-GB" style="font-family:"Courier New"">AllowOverride All</span><span lang="EN-GB"> (as per Stefan's instruction document), to no avail.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB"> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB">Cheers,<br>
Scott<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB"> <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="EN-GB">[1] </span><span lang="EN-GB" style="font-family:"Courier New"">PHP Notice: Undefined property: NotAFullConfig::$blowfish_cost in /var/www/html/CQPweb/lib/useracct-lib.php
on line 756</span><span lang="EN-GB"><u></u><u></u></span></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="http://liste.sslmit.unibo.it/mailman/listinfo/cwb" target="_blank">http://liste.sslmit.unibo.it/mailman/listinfo/cwb</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Dr. Scott Sadowsky<br>
Profesor Asistente de Lingüística<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Pontificia Universidad Católica de Chile<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">ssadowsky gmail com<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">scsadowsky uc cl<br>
<a href="http://sadowsky.cl/" target="_blank">http://sadowsky.cl/</a><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> <u></u><u></u></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div style="font-size:12.7273px">Dr. Scott Sadowsky<br>Profesor Asistente de Lingüística</div><div dir="ltr" style="font-size:12.7273px">Pontificia Universidad Católica de Chile<br></div><div dir="ltr" style="font-size:12.7273px"><br></div><div dir="ltr" style="font-size:12.7273px">ssadowsky gmail com</div><div dir="ltr" style="font-size:12.7273px">scsadowsky uc cl<br><a href="http://sadowsky.cl/" target="_blank">http://sadowsky.cl/</a></div><div dir="ltr" style="font-size:12.7273px"> </div></div></div></div></div></div></div></div></div></div></div>