All Apps and Add-ons

Can MYSQL Connector do this?

lpolo
Motivator

Issue:
I need to run a mysql query not from MySQL connector App. If i do so, it fails with this message:

Required argument name=username cannot be an empty or all white space string.

If I run the query from MySQL connector app it works fine. The query in question is the following:

| mysqlquery spec=rsrch query="select TIMESTAMPDIFF(HOUR, endTime, now()) As Idx_Hours_Old,entityType, host as idx_host, startTime, endTime, state from EntityIndexState" schema=idx

I set the sharing permissions of the app to be global but it did not help. Any idea how to make it work?

Thanks,

Lp

Tags (1)

lpolo
Motivator

The solution to this problem was to set the permission to "Global" in the Database Spec. This can be done at:

MySQL App -> Manager -> Database Specs. Then, click on the "Permissions" link for the database spec you need to set up with global permission.

Get Updates on the Splunk Community!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...