[CWB] [CQPweb] Final step? Getting Apache to point at CQPweb's root directory
Hardie, Andrew
a.hardie at lancaster.ac.uk
Sun May 12 02:05:13 CEST 2019
All 3 issues fixed in latest commit, thanks for the bug reports.
(1 & 2 were the same bug.)
best
Andrew.
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<mailto: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<mailto: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<mailto:cwb-bounces at sslmit.unibo.it> <cwb-bounces at sslmit.unibo.it<mailto: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<mailto: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
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb
--
Dr. Scott Sadowsky
Profesor Asistente de Lingüística
Pontificia Universidad Católica de Chile
ssadowsky gmail com
scsadowsky uc cl
http://sadowsky.cl/
--
Dr. Scott Sadowsky
Profesor Asistente de Lingüística
Pontificia Universidad Católica de Chile
ssadowsky gmail com
scsadowsky uc cl
http://sadowsky.cl/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190512/be6d3cc7/attachment-0001.html>
More information about the CWB
mailing list