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!

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Get More Out of Your Security Practice With a SIEM

Get More Out of Your Security Practice With a SIEMWednesday, July 31, 2024  |  11AM PT / 2PM ETREGISTER ...