[CWB] Problem granting privileges

[Hardie, Andrew]

It’s not done automatically because there is no reason to assume that the administrator would want three new privileges for each corpus. Often, it might be better to add the new corpus to the scope of existing privileges. (This is especially the case when you have lots of corpora).

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 11:18
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] Problem granting privileges

Och .. thanks for reminding me of "Manage privileges"! (Guess I would not have forgotten that step if those privileges get generated automatically after a new corpus is installed. Or maybe they aren't for an important reason?)
I manually added users because I failed to remember that important step, and connecting to MySQL as root was also a desperate attempt to solve the problem. Thanks a lot Andrew!

Best
Jiayue


On 2 October 2017 at 17:06, Hardie, Andrew <a.hardie at lancaster.ac.uk<mailto:a.hardie at lancaster.ac.uk>> wrote:
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> [mailto: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

_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it<mailto:CWB at sslmit.unibo.it>
http://liste.sslmit.unibo.it/mailman/listinfo/cwb



--
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/0138652e/attachment-0001.html>