Closed (fixed)
Project:
Faceted Search
Version:
6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
13 Jan 2009 at 08:45 UTC
Updated:
1 Feb 2009 at 00:50 UTC
Hi,
on D6, I'm getting the following error when adding a faceted search environment (/admin/settings/faceted_search):
user warning: Access denied for user '{databaseuser}'@'localhost' to database 'drupal' query: LOCK TABLES faceted_search_filters WRITE in /var/www/drupal/includes/database.mysqli.inc on line 330.
Where {databaseuser} is the database user set up according to the Installation guide:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password';
Since I'm new to this module, I'm not yet able to tell if or how this warning might affect the module's functionality. However, the rest of the site seems to work properly. Are there additional privileges required to run this module, or is this a bug?
Thanks & greetings, -asb
Comments
Comment #1
david lesieur commentedYou have to also grant the LOCK TABLES and CREATE TEMPORARY TABLES permissions on the database.
This would be something nice to add to Faceted Search's installation instructions.
Comment #2
david lesieur commentedThe readme file now explains how to properly set the database permissions.