All Apps and Add-ons

DBConnect "Failed to initialize pool: Access denied for user" even though I can use the exact same settings just fine from a python script

briancronrath
Contributor

I am using the same exact user with the same exact host, db name, username, password, and port that I am using from a python script, yet when I plug these into splunk dbconnect I am getting an access denied issue. I am not really sure why this is occurring, is there anything else I can look at to investigate why this might be happening?

Tags (1)
0 Karma

briancronrath
Contributor

Turns out mysql can set permissions per user per IP range, I never knew this, but this ended up being the issue

nickhills
Ultra Champion

Hey @briancronrath I converted your comment to an answer.

You should accept your own answer so other people can easily find a solution if they are looking at similar issues in the future.
All the best!

If my comment helps, please give it a thumbs up!
0 Karma

jnahuelperez35
Path Finder

Hi! Did you already try to check the Splunk Conf?

https://splunkbase.splunk.com/app/2686/#/details

Do you deploy the properly java db connector?

Take a look and let me know if i can helpyou.

Also try to telnet to the DB host from splunk terminal at port of listening (mostly 1433)

0 Karma

briancronrath
Contributor

Yeah Java should be deployed fine, I should mention that I can connect to several other DBs fine from dbconnect, including redshift, mysql, and ms sql databases. But for some reason this particular mysql db is giving me issues.

0 Karma
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 ...