voroojax / waf-fle

Automatically exported from code.google.com/p/waf-fle
0 stars 0 forks source link

insuffucient database grants #18

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. install waf-fle
2. create database permissons manually, as described in README
3.

What is the expected output? What do you see instead?
expected: a working system :)

what i got:
HTTP/1.1 500 Internal Server Error Error (superFilter) Message: 
SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 
'waffle_user'@'localhost' to database 'waffle' Error (superFilter) 
getTraceAsString: #0 /usr/local/waf-fle_0.6.0-rc1/functions.php(918): 
PDO->prepare('CREATE TEMPORAR...') #1 
/usr/local/waf-fle_0.6.0-rc1/functions.php(1670): superFilter('SELECT 
count(ev...', '', 'filter', false, NULL) #2 
/usr/local/waf-fle_0.6.0-rc1/functions.php(1528): eventFilterCount('filter') #3 
/usr/local/waf-fle_0.6.0-rc1/dashboard/events.php(52): eventFilter(1, '25', 0) 
#4 {main} 

What version of the product are you using? On what operating system?
waf-fle 0.6.0rc1 on CentOS 5.9

Please provide any additional information below.
The problem comes from insufficient database permissions, "CREATE TEMPORARY 
TABLES" is missing. This is some sort of problem with the documentation 
(=README file) than a real technical issue.
The user "waffle_user" needs the following permissions:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES ON `waffle`.* TO 
'waffle_user'@'localhost';
Please update the README file.

kind regards,
Reinhard

Original issue reported on code.google.com by reinhard...@parlinkom.gv.at on 21 Mar 2013 at 5:24

GoogleCodeExporter commented 8 years ago
README changed to reflect the correct permission.

Original comment by klaub...@gmail.com on 23 Apr 2013 at 9:39