Hi,
I have a Splunk6 search-head which has DB Connect installed on it. I configured some db connections as admin, and I can see them and query them succesfully. I want to give power-users the ability to see these connections and execute dbquery commands, but when they login and go to Splunk DB Connect -> Database query, the drop-down says "No database configured". Did something change in DB Connect? I have the following config in my local.meta file:
[database/PROD_DIPIT]
access = read : [ admin, power, user ], write : [ admin ]
export = system
owner = admin
version = 6.0
modtime = 1381931278.439294000
[database/ATERNITY_PROD]
access = read : [ admin, power, user ], write : [ admin ]
export = system
owner = admin
version = 6.0
modtime = 1381931267.361717000
[]
access = read : [ admin, power ], write : [ admin ]
export = none
version = 6.0
modtime = 1381928382.920638000
[commands]
access = read : [ admin, user ], write : [ admin ]
export = system
[commands/dbquery]
access = read : [ admin, power, user ], write : [ admin ]
export = system
Not sure that the original poster is still experiencing this problem, but for the benefit of other readers who might be, make sure that the role to which you are attempting to grant DB Connect access also has the dbx_capable capability. That fixed it for me.
Did you ever get this figured out? I am having the same issue. When I have a power user try to run the query from a dashboard it tells me that may database doesn't exist for that user even though I have given the power user all the access I can find.
Hard to tell from just that information. Can you please open a support case so we can get a diag file?