[CWB] [CQPweb] Final step? Getting Apache to point at CQPweb's root directory
Scott Sadowsky
ssadowsky at gmail.com
Sun May 12 06:15:53 CEST 2019
On Sat, May 11, 2019 at 8:05 PM Hardie, Andrew <a.hardie at lancaster.ac.uk>
wrote:
All 3 issues fixed in latest commit, thanks for the bug reports.
>
>
>
> (1 & 2 were the same bug.)
>
Thanks very much, Andrew. Now, all the buttons on
URL/dickens/index.php?ui=manageFreqLists work correctly.
One further issue: when I go to *Admin tools* > *Manage text metadata*
> *Create
metadata table from corpus XML annotations* and then hit the *Create
metadata table from XML using the settings above* button, there's a brief
pause and I then land on a blank screen. There's no error message (or
anything else) there.
Cheers,
Scott
>
> *From:* cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> *On
> Behalf Of *Scott Sadowsky
> *Sent:* 11 May 2019 21:26
> *To:* Uhrig, Peter <peter.uhrig at fau.de>
> *Cc:* Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it
> >
> *Subject:* Re: [CWB] [CQPweb] Final step? Getting Apache to point at
> CQPweb's root directory
>
>
>
> Dear Andrew, Peter and everyone else,
>
>
>
> 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.
>
>
>
> I can successfully import the Dickens corpus (*Install new corpus* > *Click
> here to install a corpus you have already indexed in CWB *> [fill in
> appropriate fields] > *Install corpus with settings above*). And I can
> successfully add the metadata (*Design and insert a text-metadata table
> for the corpus* > *Click here to install metadata from within-corpus XML
> annotation* > [select fields and add descriptions] > *Create metadata
> table from XML using the settings above*).
>
>
>
> I can also create the frequency table for text begin/end positions (*Admin
> tools* > *Manage frequency lists* > *Text begin/end positions* > *Update
> CWB text-position records*). So far, so good!
>
>
>
> *PROBLEM 1.* When I go to create the text-by-text frequency lists (*Admin
> tools* > *Manage frequency lists* > *Text-by-text freq-lists* > *Update
> CWB frequency table*) I get an error [1].
>
>
>
> *PROBLEM 2.* When I go to create the word and annotation frequency tables
> (*Admin tools* > *Manage frequency lists* > *Frequency tables* > *Create
> frequency tables*) I get an error [2].
>
>
>
> 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.
>
>
>
> *PROBLEM 3:* *Backend system* > *View a MySQL table* fails with an error
> [3].
>
>
>
> *PROBLEM 4:* Diagnosing problems with *Backend system* > *System
> diagnostics* fails with a blank screen.
>
>
>
> Thanks in advance!
>
> Scott
>
>
>
> *[1] ERROR WHEN CREATING Text-by-text freq-lists*
>
> CQPweb encountered an error and could not continue.
>
> An SQL query did not run successfully!
>
>
>
> Original query: analyze NO_WRITE_TO_BINLOG table /* from User: scott |
> Function: get_sql_table_size() | 2019-May-11 17:02 */
>
>
>
> 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
>
>
>
> PHP debugging backtrace
>
> array(7) {
>
> [1]=>
>
> array(4) {
>
> ["file"]=>
>
> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
>
> ["line"]=>
>
> int(300)
>
> ["function"]=>
>
> string(9) "exiterror"
>
> ["args"]=>
>
> array(3) {
>
> [0]=>
>
> array(3) {
>
> [0]=>
>
> string(38) "An SQL query did not run successfully!"
>
> [1]=>
>
> string(131) "Original query:
>
>
>
> analyze NO_WRITE_TO_BINLOG table
>
> /* from User: scott | Function: get_sql_table_size() | 2019-May-11
> 17:02 */
>
>
>
> "
>
> [2]=>
>
> 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 "
>
> }
>
> [1]=>
>
> NULL
>
> [2]=>
>
> NULL
>
> }
>
> }
>
> [2]=>
>
> array(4) {
>
> ["file"]=>
>
> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
>
> ["line"]=>
>
> int(178)
>
> ["function"]=>
>
> string(20) "exiterror_mysqlquery"
>
> ["args"]=>
>
> array(3) {
>
> [0]=>
>
> int(1064)
>
> [1]=>
>
> 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"
>
> [2]=>
>
> string(111) "analyze NO_WRITE_TO_BINLOG table
>
> /* from User: scott | Function: get_sql_table_size() | 2019-May-11
> 17:02 */"
>
> }
>
> }
>
> [3]=>
>
> array(4) {
>
> ["file"]=>
>
> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
>
> ["line"]=>
>
> int(579)
>
> ["function"]=>
>
> string(12) "do_sql_query"
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(111) "analyze NO_WRITE_TO_BINLOG table
>
> /* from User: scott | Function: get_sql_table_size() | 2019-May-11
> 17:02 */"
>
> }
>
> }
>
> [4]=>
>
> array(4) {
>
> ["file"]=>
>
> string(39) "/var/www/html/cqpweb/lib/corpus-lib.php"
>
> ["line"]=>
>
> int(751)
>
> ["function"]=>
>
> string(18) "get_sql_table_size"
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(4) "word"
>
> }
>
> }
>
> [5]=>
>
> array(4) {
>
> ["file"]=>
>
> string(42) "/var/www/html/cqpweb/lib/freqtable-lib.php"
>
> ["line"]=>
>
> int(695)
>
> ["function"]=>
>
> string(28) "update_corpus_freqtable_size"
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(7) "dickens"
>
> }
>
> }
>
> [6]=>
>
> array(4) {
>
> ["file"]=>
>
> string(36) "/var/www/html/cqpweb/lib/execute.php"
>
> ["line"]=>
>
> int(177)
>
> ["function"]=>
>
> string(19) "make_cwb_freq_index"
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(7) "dickens"
>
> }
>
> }
>
> [7]=>
>
> array(4) {
>
> ["file"]=>
>
> string(36) "/var/www/html/cqpweb/exe/execute.php"
>
> ["line"]=>
>
> int(1)
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(36) "/var/www/html/cqpweb/lib/execute.php"
>
> }
>
> ["function"]=>
>
> string(7) "require"
>
> }
>
> }
>
>
>
>
>
>
>
> *[2] ERROR WHEN CREATING Word and annotation frequency tables*
>
> CQPweb encountered an error and could not continue.
>
> An SQL query did not run successfully!
>
>
>
> Original query: analyze NO_WRITE_TO_BINLOG table /* from User: scott |
> Function: get_sql_table_size() | 2019-May-11 17:08 */
>
>
>
> 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
>
>
>
> PHP debugging backtrace
>
> array(7) {
>
> [1]=>
>
> array(4) {
>
> ["file"]=>
>
> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
>
> ["line"]=>
>
> int(300)
>
> ["function"]=>
>
> string(9) "exiterror"
>
> ["args"]=>
>
> array(3) {
>
> [0]=>
>
> array(3) {
>
> [0]=>
>
> string(38) "An SQL query did not run successfully!"
>
> [1]=>
>
> string(131) "Original query:
>
>
>
> analyze NO_WRITE_TO_BINLOG table
>
> /* from User: scott | Function: get_sql_table_size() | 2019-May-11
> 17:08 */
>
>
>
> "
>
> [2]=>
>
> 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 "
>
> }
>
> [1]=>
>
> NULL
>
> [2]=>
>
> NULL
>
> }
>
> }
>
> [2]=>
>
> array(4) {
>
> ["file"]=>
>
> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
>
> ["line"]=>
>
> int(178)
>
> ["function"]=>
>
> string(20) "exiterror_mysqlquery"
>
> ["args"]=>
>
> array(3) {
>
> [0]=>
>
> int(1064)
>
> [1]=>
>
> 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"
>
> [2]=>
>
> string(111) "analyze NO_WRITE_TO_BINLOG table
>
> /* from User: scott | Function: get_sql_table_size() | 2019-May-11
> 17:08 */"
>
> }
>
> }
>
> [3]=>
>
> array(4) {
>
> ["file"]=>
>
> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
>
> ["line"]=>
>
> int(579)
>
> ["function"]=>
>
> string(12) "do_sql_query"
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(111) "analyze NO_WRITE_TO_BINLOG table
>
> /* from User: scott | Function: get_sql_table_size() | 2019-May-11
> 17:08 */"
>
> }
>
> }
>
> [4]=>
>
> array(4) {
>
> ["file"]=>
>
> string(39) "/var/www/html/cqpweb/lib/corpus-lib.php"
>
> ["line"]=>
>
> int(751)
>
> ["function"]=>
>
> string(18) "get_sql_table_size"
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(4) "word"
>
> }
>
> }
>
> [5]=>
>
> array(4) {
>
> ["file"]=>
>
> string(42) "/var/www/html/cqpweb/lib/freqtable-lib.php"
>
> ["line"]=>
>
> int(166)
>
> ["function"]=>
>
> string(28) "update_corpus_freqtable_size"
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(7) "dickens"
>
> }
>
> }
>
> [6]=>
>
> array(4) {
>
> ["file"]=>
>
> string(36) "/var/www/html/cqpweb/lib/execute.php"
>
> ["line"]=>
>
> int(177)
>
> ["function"]=>
>
> string(22) "corpus_make_freqtables"
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(7) "dickens"
>
> }
>
> }
>
> [7]=>
>
> array(4) {
>
> ["file"]=>
>
> string(36) "/var/www/html/cqpweb/exe/execute.php"
>
> ["line"]=>
>
> int(1)
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(36) "/var/www/html/cqpweb/lib/execute.php"
>
> }
>
> ["function"]=>
>
> string(7) "require"
>
> }
>
> }
>
> CQPweb v3.2.34 © 2008-2019 Help! on CQPweb You are logged in as
> user [scott]
>
>
>
>
>
>
>
> *[3] BACKEND SYSTEM > VIEW A MYSQL TABLE* *ERROR*
>
> Viewing mySQL table
>
> An SQL query did not run successfully!
>
>
>
> Original query: SELECT * FROM `` /* from User: scott | Function:
> do_adm_ui_tableview() | 2019-May-11 17:20 */
>
>
>
> Error # 1103: Incorrect table name ''
>
>
>
> PHP debugging backtrace
>
> array(5) {
>
> [1]=>
>
> array(4) {
>
> ["file"]=>
>
> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
>
> ["line"]=>
>
> int(300)
>
> ["function"]=>
>
> string(9) "exiterror"
>
> ["args"]=>
>
> array(3) {
>
> [0]=>
>
> array(3) {
>
> [0]=>
>
> string(38) "An SQL query did not run successfully!"
>
> [1]=>
>
> string(115) "Original query:
>
>
>
> SELECT * FROM ``
>
> /* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11
> 17:20 */
>
>
>
> "
>
> [2]=>
>
> string(38) "Error # 1103: Incorrect table name '' "
>
> }
>
> [1]=>
>
> NULL
>
> [2]=>
>
> NULL
>
> }
>
> }
>
> [2]=>
>
> array(4) {
>
> ["file"]=>
>
> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
>
> ["line"]=>
>
> int(178)
>
> ["function"]=>
>
> string(20) "exiterror_mysqlquery"
>
> ["args"]=>
>
> array(3) {
>
> [0]=>
>
> int(1103)
>
> [1]=>
>
> string(23) "Incorrect table name ''"
>
> [2]=>
>
> string(95) "SELECT * FROM ``
>
> /* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11
> 17:20 */"
>
> }
>
> }
>
> [3]=>
>
> array(4) {
>
> ["file"]=>
>
> string(45) "/var/www/html/cqpweb/lib/admin-home-forms.php"
>
> ["line"]=>
>
> int(5267)
>
> ["function"]=>
>
> string(12) "do_sql_query"
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(95) "SELECT * FROM ``
>
> /* from User: scott | Function: do_adm_ui_tableview() | 2019-May-11
> 17:20 */"
>
> }
>
> }
>
> [4]=>
>
> array(4) {
>
> ["file"]=>
>
> string(38) "/var/www/html/cqpweb/lib/adminhome.php"
>
> ["line"]=>
>
> int(361)
>
> ["function"]=>
>
> string(19) "do_adm_ui_tableview"
>
> ["args"]=>
>
> array(0) {
>
> }
>
> }
>
> [5]=>
>
> array(4) {
>
> ["file"]=>
>
> string(34) "/var/www/html/cqpweb/adm/index.php"
>
> ["line"]=>
>
> int(1)
>
> ["args"]=>
>
> array(1) {
>
> [0]=>
>
> string(38) "/var/www/html/cqpweb/lib/adminhome.php"
>
> }
>
> ["function"]=>
>
> string(7) "require"
>
> }
>
> }
>
>
>
>
>
> On Thu, May 9, 2019 at 2:36 PM Uhrig, Peter <peter.uhrig at fau.de> wrote:
>
> Hi Scott,
>
>
>
> I hope it is okay if I answer.
>
>
>
> > I've got two copies of 000-default.conf on a fresh Apache install, one
> in /etc/apache2/sites-available/ and one in /etc/apache2/site
>
> > enabled/.
>
>
>
> 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).
>
>
>
> So to answer your questions:
>
>
>
> 1. Is /sites-enabled then the best place for the <Directory> directive
> for the purposes I outlined above?
>
>
>
> 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.
>
>
>
> 2. Is adding the <Directory> directive to the appropriate 000-default.conf
> file enough to change the server's document root, or are additional steps
> required?
>
>
>
> You need to change the following line in that file:
>
> DocumentRoot /var/www/html
>
> to
>
> DocumentRoot /var/www/html/cqpweb
>
>
>
> 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.
>
>
>
> 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.
>
>
>
> As far as I know, you will not need this directory directive.
>
>
>
> 3. Considering you recommend against virtual hosts, should I delete the
> large <VirtualHost> entry that's already in both copies of
> 000-default.conf, or just add the <Directory> directive before or after
> it?
>
>
>
> Leave it as it is.
>
>
>
> 4. And finally, is the following correct?
>
>
>
> <Directory "/var/www/html/cqpweb">
>
> AllowOverride None
>
> Require all granted
>
> Options FollowSymlinks
>
> </Directory>
>
>
>
> I ask because the your manual and Stefan's instruction document have
> different options for AllowOverride, and also because Options
> FollowSymlinks doesn't appear in much documentation (in fact, I'm not
> sure where I got it from!).
>
>
>
> Looks good to me, but I don’t think you need any of this. What is your OS?
>
>
>
> Best,
>
> Peter
>
>
>
>
>
> On Thu, May 9, 2019 at 8:16 AM Hardie, Andrew <a.hardie at lancaster.ac.uk>
> wrote:
>
> Hi Scott,
>
>
>
> The <Directory> directive doesn’t turn a folder into your server’s root :
> it just specifies options that apply only to that folder.
>
>
>
> the directive that specifies the root is *DocumentRoot* and depending on
> your setup you may find it in *apache2.conf* or in *000-default.conf* .
>
>
>
> You have two options, either change the document root, or else simply
> access your CQPweb via http://localhost/cqpweb (or whatever) which should
> be working for you now.
>
>
>
> 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 *aren’t* using such a vhost then the <Directory> directive should
> probably go inot 000-default.conf
>
>
>
> best
>
>
>
> Andrew
>
>
>
>
>
> *From:* cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> *On
> Behalf Of *Scott Sadowsky
> *Sent:* 09 May 2019 11:33
> *To:* Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it
> >
> *Subject:* [CWB] [CQPweb] Final step? Getting Apache to point at CQPweb's
> root directory
>
>
>
> Hi All,
>
>
>
> 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 /etc/apache2/sites-available/cqpweb.conf I've got the
> following, which I would think would be enough:
>
>
>
> <Directory "/var/www/html/cqpweb">
>
> AllowOverride None
>
> Require all granted
>
> Options FollowSymlinks
>
> </Directory>
>
>
>
> But alas, Apache opens one of those typical "Welcome to Apache" pages
> rather than /var/www/html/cqpweb/index.php, which consists of <?php
> require('lib/mainhome.php');, and so is clearly not what's being opened.
> Could someone point me in the right direction? I've tried both AllowOverride
> None (as per the admin manual) and AllowOverride All (as per Stefan's
> instruction document), to no avail.
>
>
>
> Cheers,
> Scott
>
>
>
> [1] PHP Notice: Undefined property: NotAFullConfig::$blowfish_cost in
> /var/www/html/CQPweb/lib/useracct-lib.php on line 756
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190512/69f8d8c3/attachment-0001.html>
More information about the CWB
mailing list