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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Mastering Threat Intelligence in ES 8.5, Splunk AI Assistant v2, and More from Splunk ...

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...

Break the Build: Inside the KubeDoom Lounge at .conf26

    You step up to the machine. The pixelated corridors of a certain 1993 FPS load in front of you, EMP Pulse ...

Splunk Auto Ingestion Parallel Pipeline Scaling

Why this feature matters Many Splunk environments experience ingestion pressure long before the host is fully ...