All Apps and Add-ons

Error getting database connection : Unknown system variable 'language'

vkor
New Member

Splunk 6.2
DBconnect 2 or 1 - the same error
Getting an error Unknown system variable 'language' while establishing a connection to MySQL DB.
alt text
mysql output for this variable:
>show variables like "%lang%";
language c:\/program files (x86)/\acs sphinx\/server/\mysqld/\share/\english\

Tags (2)
0 Karma

yshabano
Explorer

There is a bug in the MySQL Connector/J version 5.1.36, when connecting to MySQL server 5.0.x.

If you download a previous version of the connector/j version you should be able to connect.

0 Karma

vkor
New Member

any ideas?

0 Karma
Get Updates on the Splunk Community!

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...

Share Your Ideas & Meet the Lantern team at .Conf! Plus All of This Month’s New ...

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