topic Re: Error Viewing Database Information in Splunk Search

Error Viewing Database Information

kaylormd — Thu, 27 Mar 2014 21:49:16 GMT

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.

Re: Error Viewing Database Information

joebensimo — Sun, 25 May 2014 23:06:39 GMT

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.

Re: Error Viewing Database Information

joebensimo — Thu, 29 May 2014 07:23:50 GMT

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.

Re: Error Viewing Database Information

DavidHourani — Fri, 13 Jun 2014 14:59:52 GMT

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

Re: Error Viewing Database Information

DavidHourani — Fri, 13 Jun 2014 15:47:36 GMT

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!

Re: Error Viewing Database Information

SupportCSC — Fri, 20 Jun 2014 08:50:22 GMT

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.

Re: Error Viewing Database Information

danielsimpkins — Wed, 16 Jul 2014 04:39:28 GMT

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.

Re: Error Viewing Database Information

bravon — Wed, 19 Nov 2014 13:38:45 GMT

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 🙂

Re: Error Viewing Database Information

ilirb — Tue, 22 Sep 2015 14:25:59 GMT

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)