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 ~!
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
......
Anyone able to help with this?