All Apps and Add-ons

Splunk DB Connect 2.2.0: Why am I getting "AttributeError: 'dict' object has no attribute 'user'"

kissgery
Explorer

After installing Splunk DB Connect 2.2.0 I'm getting

External search command 'dbxquery' returned error code 1. Script output = "AttributeError: 'dict' object has no attribute 'user'

independent from the database I'm using. (tried with SQL Server and DB2)
Connection setting says Valid connection. Any idea why?

1 Solution

sumants
Engager

It has to do with the user permissions. Try assigning "db_connect_user" role to the user (currently executing the query) directly from the Access controls » Users page. At least that is what resolve my problem.
Cheers.

View solution in original post

sumants
Engager

It has to do with the user permissions. Try assigning "db_connect_user" role to the user (currently executing the query) directly from the Access controls » Users page. At least that is what resolve my problem.
Cheers.

cyndiback
Path Finder

I'm getting this same error - I only need the users to be able to run dbxquery. Did you find a solution?

0 Karma

kissgery
Explorer

Hi cyndiback, the only solution we found (regardless of which permission is needed) to assign the rights over roles in LDAP mapping instead of doing it directly. (If you do not use LDAP for authentication this solution won't help you)

0 Karma

kissgery
Explorer

Thank's for the hint, it was really a permission problem. It was difficult to find the solution because we use LDAP mapping for role assignment and any direct role assignment had no effect. The only way it worked was to change the LDAP mapping.

0 Karma

kissgery
Explorer

Hi ctaf, assign the "db_connect_user" role to the given LDAP Group instead to add it directly. See here

0 Karma

ctaf
Contributor

EDIT: nevermind, I found the solution here: https://answers.splunk.com/answers/406891/db-connect-220-not-working-in-shc.html

Hello Kissgery, how did you manage to solve it? I am having the same issue and adding "db_connect_user" role to my user's custom role doesn't work but adding "db_connect_user" in the user's inherited roles works. This is very strange. Do you remember what you changed in the LDAP mapping?

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 ...