- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Error Viewing Database Information
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 🙂
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
do you have any fix for that ? I have the same problem!!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
