Issue connecting to Mariadb from Datagrip

Hi guys, I have a connection to a particular server. The SSH and Connectivity tests work fine. But when I try to expand the schema, it just says Connection failed.

It seems to be trying to connect to some other random port instead of the standard 3306 ... any idea why?


2018-09-14 16:32:44,618 [348902613] INFO - taSourceSshTunnelConfiguration - SSH tunnel created: 57967:localhost:3306
2018-09-14 16:32:44,625 [348902620] INFO - ution.rmi.RemoteProcessSupport - "/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/jdk/Contents/Home/jre/bin/java" -Djava.net.preferIPv4Stack=true -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath "/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/lib/util.jar:/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/lib/trove4j.jar:/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/lib/groovy-all-2.4.15.jar:/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/plugins/DatabaseTools/lib/dekaf-single-2.0.0.372.jar:/Users/king/Library/Preferences/DataGrip2018.2/jdbc-drivers/MariaDB Connector J/2.2.1/mariadb-java-client-2.2.1.jar" com.intellij.database.remote.RemoteJdbcServer org.mariadb.jdbc.Driver
2018-09-14 16:32:44,818 [348902813] INFO - ution.rmi.RemoteProcessSupport - Port/ID: 23860/RemoteDriverImpl69d37280
2018-09-14 16:32:44,839 [348902834] INFO - urce.DatabaseConnectionManager - Connecting as: root
2018-09-14 16:32:44,840 [348902835] INFO - urce.DatabaseConnectionManager - Connecting to: jdbc:mariadb://localhost:57967/mtraffic1
2018-09-14 16:32:45,633 [348903628] INFO - ution.rmi.RemoteProcessSupport - Terminating: 23860/RemoteDriverImpl69d37280
2018-09-14 16:32:45,698 [348903693] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 137 (interrupted by signal 9: SIGKILL)
2018-09-14 16:32:54,540 [348912535] INFO - taSourceSshTunnelConfiguration - SSH tunnel created: 58020:localhost:3306
2018-09-14 16:32:54,547 [348912542] INFO - ution.rmi.RemoteProcessSupport - "/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/jdk/Contents/Home/jre/bin/java" -Djava.net.preferIPv4Stack=true -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath "/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/lib/util.jar:/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/lib/trove4j.jar:/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/lib/groovy-all-2.4.15.jar:/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/plugins/DatabaseTools/lib/jdbc-console.jar:/Users/king/Library/Application Support/JetBrains/Toolbox/apps/datagrip/ch-0/182.4505.4/DataGrip.app/Contents/plugins/DatabaseTools/lib/dekaf-single-2.0.0.372.jar:/Users/king/Library/Preferences/DataGrip2018.2/jdbc-drivers/MariaDB Connector J/2.2.1/mariadb-java-client-2.2.1.jar" com.intellij.database.remote.RemoteJdbcServer org.mariadb.jdbc.Driver
2018-09-14 16:32:54,741 [348912736] INFO - ution.rmi.RemoteProcessSupport - Port/ID: 24858/RemoteDriverImplbe7d20c9
2018-09-14 16:32:54,759 [348912754] INFO - urce.DatabaseConnectionManager - Connecting as: root
2018-09-14 16:32:54,760 [348912755] INFO - urce.DatabaseConnectionManager - Connecting to: jdbc:mariadb://localhost:58020/mtraffic1
2018-09-14 16:32:55,638 [348913633] INFO - ution.rmi.RemoteProcessSupport - Terminating: 24858/RemoteDriverImplbe7d20c9
2018-09-14 16:32:55,697 [348913692] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 137 (interrupted by signal 9: SIGKILL)
2018-09-14 16:33:00,749 [348918744] INFO - taSourceSshTunnelConfiguration - SSH tunnel created: 58059:localhost:3306

 

2 comments
Comment actions Permalink

Could you provide screenshots of General & SSH/SSL tabs your data source?
Do you provide a correct Proxy host address?

 

0
Comment actions Permalink

Any updates here?

 

0

Please sign in to leave a comment.