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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...