You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@vcl.apache.org by Brian Bouterse <bm...@ncsu.edu> on 2009/04/06 18:21:30 UTC

mysql user permissions bug?

I am doing a fresh installation and starting with a database built  
from the most recent vcl.sql from the SVN.  I've configured my  
frontend and management node, according to these instructions:  https://svn.apache.org/repos/asf/incubator/vcl/trunk/INSTALLATION

I've added my management node to the DB, but I couldn't get the vcld  
process to start cleanly without the following complaint from the log:

--------------------SNIP-----------------------------
|2615| ---- WARNING ----
|2615| 2009-04-06 12:17:50|2615| 
utils.pm:get_management_node_info(7206)|zero rows were returned from  
database select statement:

|2615|    SELECT
|2615|    managementnode.*,
|2615|    predictivemodule.name AS predictive_name,
|2615|    predictivemodule.prettyname AS predictive_prettyname,
|2615|    predictivemodule.description AS predictive_description,
|2615|    predictivemodule.perlpackage  AS predictive_perlpackage,
|2615|  state.name AS statename
|2615|    FROM
|2615|    managementnode,
|2615|    module predictivemodule,
|2615|  state
|2615|    WHERE
|2615|    managementnode.predictivemoduleid = predictivemodule.id
|2615|  AND managementnode.stateid = state.id
|2615|    AND
|2615|    managementnode.hostname like 'dhcp15.cnl.ncsu.edu%'
|2615| ( 0) utils.pm, notify (line: 691)
|2615| (-1) utils.pm, get_management_node_info (line: 7206)
|2615| (-2) vcld, main (line: 127)

/usr/lib/sendmail: option requires an argument -- f
2009-04-06 12:17:50|2615|utils.pm:mail(1301)|SUCCESS -- Sending mail  
To: , PROBLEM -- vcld

|2615| ---- CRITICAL ----
|2615| 2009-04-06 12:17:50|2615|vcld:main(131)|unable to retrieve  
management node information from database
|2615| ( 0) utils.pm, notify (line: 691)
|2615| (-1) vcld, main (line: 131)
--------------------SNIP-----------------------------

I believe this is default user permissions bug because when I give my  
vcl user in the database full permissions (All Privileges) instead of  
the recommended in the instructions (SELECT, INSERT, UPDATE, DELETE),  
it works.  What are the right permissions for a frontend user?  What  
are the right permissions for a backend user?  Do the instructions  
need to be updated?

Best,
Brian

Brian Bouterse
Secure Open Systems Initiative
919.698.8796

Re: mysql user permissions bug?

Posted by aa...@ncsu.edu.

Yes good idea - definitely. We'll extend it to use the same regex for all
the name fields to include the acceptable char combinations.
Thanks,
Aaron


> Aaron Peeler wrote:
>> ok - yep that's it.
>>
>> Here is the block parsing it.
>> #write user name
>> if ($l =~ /^LockerWrtUser=([-a-zA-Z0-9]*)/) {
>>     $WRTUSER = $1;
>> }
> Can the code block that parses the vcl database name be extended to
> allow underscores and hyphens as well?
>
> <                       if ($l =~ /^database=([a-zA-Z0-9-w]*)/) {
> ---
>  >                       if ($l =~ /^database=([a-zA-Z0-9]*)/) {
>
> Toks
>>
>>
>>
>> Thanks
>> Aaron
>>
>>
>> --On April 6, 2009 4:04:13 PM -0400 Brian Bouterse <bm...@ncsu.edu>
>> wrote:
>>
>>> The username I'm trying is vcl_mn, so it is likely a problem with the
>>> underscore in then name.  I've created a JIRA ticket to track this bug
>>> here:  https://issues.apache.org/jira/browse/VCL-129
>>>
>>> Thanks!
>>> Brian
>>>
>>>
>>> Brian Bouterse
>>> Secure Open Systems Initiative
>>> 919.698.8796
>>>
>>>
>>>
>>>
>>> On Apr 6, 2009, at 4:02 PM, Aaron Peeler wrote:
>>>
>>>> BTW - what username are trying to use besides 'vcl'. It's possible
>>>> there is a bug in the portion that is parsing vcld.conf and it's not
>>>> picking up specific characters.
>>>>
>>>> Aaron
>>>>
>>>>
>>>
>>
>>
>>
>> Aaron Peeler
>> OIT Advanced Computing
>> College of Engineering-NCSU
>> 919.513.4571
>> http://vcl.ncsu.edu
>
>
>