Knowledge Management

DBX [1.2] user cannot create db lookup.

smanganiello_sp
Splunk Employee
Splunk Employee

Splunk 6.0; Dbx 1.2; mysql, java 1.7, Linux AMI
I have a user with OOTB dbx_user privileges. The DB is r/w for dbx_user.

The 1.1 docs say that the dbx_user was not able to create new db lookups was fixed. In this case, I get "There was an error retrieving the configuration, cannot process this page. Yet, when I log in as admin, I do not see this.

Tags (2)
0 Karma

sroback_splunk
Splunk Employee
Splunk Employee

Only the Admin role can create db lookups in the UI. But users can be granted permissions to use db lookups in searches. To do so, the lookup itself must be assigned the user's role (with appropriate r/w permissions). So, an Admin can create a lookup and assign a user's role to the lookup, then the Admin and the user can use the lookup.

http://docs.splunk.com/Documentation/DBX/1.1.2/DeployDBX/Setupuserpermissions#Set_up_user_lookup_per...

linu1988
Champion

sorry it was permission issue.

0 Karma

smanganiello_sp
Splunk Employee
Splunk Employee

Remote or local? What os for mysql? Some things you might want to check. Is the mysql service running? Can you query mysql from the command line on the mysql server? Is the Java Bridge running?

0 Karma

smanganiello_sp
Splunk Employee
Splunk Employee

Yes. So the mysql DB is added and fully configured. As a user I can query the DB, see the tables, etc. I cannot add a lookup. As admin, I can add lookups. Which DB are you adding?

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...