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!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...