Splunk Search

Error Viewing Database Information

kaylormd
Engager

I am testing DB Connect for the first time and receiving an error when I try to use Database Info (/en-US/app/dbx/dbinfo). I can select the database but receive this error:

External search command 'dbinfo' returned error code 1. Script output = "There is no such database [database] available for this user! "

I granted the user all permissions to the database and can successfully run queries from the query tab (/en-US/app/dbx/dbquery). If it makes a difference, this is a MySQL database.

SupportCSC
Engager

Hello,

I had the same problem because there was a space character in the database name I chose.
I chose "RT Database" as name and the error message was:

"External search command 'dbinfo' returned error code 1. Script output = "There is no such database [RT] available for this user! "

I cloned it so I was able to change the name with "RTDB" then the error disappeared.
Of course, you can also simply delete and create again with the good name.

Hope this help.

danielsimpkins
Engager

I also found this worked for me too... i had originally thought you were referring to the database's actual name, but realised you meant the name of the connection. No spaces instantly fixed it for me.

0 Karma

bravon
Communicator

I had the same problem but i also didnt realize it was the name of the connecting (Free text) when you create the connection in /manager/dbx/dbx/databases

This needs to be marked as an answer 🙂

0 Karma

DavidHourani
Super Champion

I had the same problem as you and I finally fixed it, first start off by going into your user settings and adding the "dbx_capable" capability.

Once that is done, make sure you have the right permissions for the database. To do so go to Settings-> External Databases, start off by setting permissions read/write for everyone in all apps just to make sure that this does the trick then go back and reduce permissions as suitable for your needs.

Good luck!

DavidHourani
Super Champion

do you have any fix for that ? I have the same problem!!

0 Karma

joebensimo
Path Finder

It appears that this occurs when databases are added the the UI. The UI appears to add them to local/database.conf for whatever application was active before selecting Settings > External Data bases. To make the error go away, I moved the contents of database.conf into the dbx/local/database.conf file.

ilirb
Path Finder

This solved the problem in my case. Seems like by just using UI it does not sometimes write the conf file as it should. Hence, I modified the database.conf file manually, and restarted splunk. Now it is all OK. (btw using dbx 1.1.7 here)

0 Karma

joebensimo
Path Finder

I am getting this same error when using a MySQL database. I've been using DBX without problem with PostgreSQL databases for months, but attempting to use MySQL database give me this error.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...