topic Re: com.splunk.dbx.exception.NotFoundException: Can not find object TEST3 of type connection. in All Apps and Add-ons

com.splunk.dbx.exception.NotFoundException: Can not find object TEST3 of type connection.

jimbolya11 — Fri, 28 Jun 2019 03:49:21 GMT

I've seen this error in the forums but no one has really answered it in a way that solves the issue.

I have zero errors in adding the connection.

I'm wondering if I simply need to continue to swap out the jdbc driver till it works.

I'm trying to connect to Maria db.

I've done it in the past and documented it.

However, this go around it's not working at all.

I've tried drivers for MySQL both versions 8.0 and 5.1 -

Previous success was with older 3.0 version of db connect and driver version 5.1.

Installed driver version 5.1 and it did remove the timezone error, but still cannot view any of the tables like I used to be able to do.

Cheers ~!

jimbolya11 — Sat, 29 Jun 2019 18:18:48 GMT

Anyone able to help with this?

cyue_splunk — Thu, 19 Oct 2023 07:22:56 GMT

I met the same error during the DB Connect set up. The solution that works in my situation is to check

$SPLUNK_HOME/etc/apps/splunk_app_db_connect/metadata/local.meta

There are definitions for identities and db_connections. Make sure the "export = system" instead of "export = none". It should look like this:

[identities/xxxxxx]

access = read : [ * ], write : [ admin, db_connect_admin ]

export = system

owner = xxxxxx

......

[db_connections/xxxxxx]

access = read : [ * ], write : [ admin, db_connect_admin ]

export = system

owner = xxxxxx

......