Error Viewing Database Information

[kaylormd]

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]

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]

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.

[bravon]

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 🙂

[DavidHourani]

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]

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

[joebensimo]

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]

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)

[joebensimo]

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.