Splunk Search

splunk db connect - dbquery not accessible

a212830
Champion

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

pfernandez133
Explorer

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.

0 Karma

MattZerfas
Communicator

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.

0 Karma

araitz
Splunk Employee
Splunk Employee

Hard to tell from just that information. Can you please open a support case so we can get a diag file?

0 Karma
Get Updates on the Splunk Community!

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...