[CWB] Problem granting privileges

[Hardie, Andrew]

Did you actually create a privilege covering the new corpus? This is not done automatically. You need to do it using “Manage privileges”.

Also, on an unrelated issue,

>>>2. I created the cqpweb_db users explicitly in mysql, and these users all have select privilege to cqpweb_db;

I don’t understand. Why do you need more than one MySQL user for the cqpweb_db? Or are you referring to CQPweb usernames? IT is not a good idea to create these manually in MySQL. You should use the CQPweb functions.

>>> in config.inc.php, $mysql_webuser is set to admin (superuser)

It is a bad bad bad idea to have CQPweb connect to MySQL as administrator (root), if I have correctly understood that that is what you are doing. It is a huge security hole.

best

Andrew.

From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Jiayue Wang
Sent: 02 October 2017 02:23
To: Open source development of the Corpus WorkBench
Subject: [CWB] Problem granting privileges

Hi
When I tried granting privileges to user groups ("everyone", and a group called "graduate") I couldn't find the name of a newly installed corpus in the "Select privilege" drop down list. I don't know which information could help with diagnosis; I guess the following might be relevant:
1. the cqpweb_db database was re-created using the mysqldump method, not constructed bit by bit;
2. I created the cqpweb_db users explicitly in mysql, and these users all have select privilege to cqpweb_db;
3. in config.inc.php, $mysql_webuser is set to admin (superuser).
Thanks for any help!

Jiayue

--
Jiayue Wang
College of Foreign Studies
Guangxi University for Nationalties
Nanning, China 530006
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20171002/4ec1e8ee/attachment.html>