I am getting error when i’m trying to add mysql database, here are my error details:
[a0fcdfb2-0ee2-4a43-9487-49f5d844243a] 2021-03-03T17:55:52+07:00 ERROR metabase.driver.util Database connection error
org.apache.sshd.common.SshException: DefaultAuthFuture[ssh-connection]: Failed (NoSuchProviderException) to execute: JCE cannot authenticate the provider BC
at org.apache.sshd.common.future.AbstractSshFuture.lambda$verifyResult$1(AbstractSshFuture.java:137)
at org.apache.sshd.common.future.AbstractSshFuture.formatExceptionMessage(AbstractSshFuture.java:196)
at org.apache.sshd.common.future.AbstractSshFuture.verifyResult(AbstractSshFuture.java:136)
at org.apache.sshd.client.future.DefaultAuthFuture.verify(DefaultAuthFuture.java:39)
at org.apache.sshd.client.future.DefaultAuthFuture.verify(DefaultAuthFuture.java:32)
at metabase.util.ssh$start_ssh_tunnel_BANG_.invokeStatic(ssh.clj:60)
at metabase.util.ssh$start_ssh_tunnel_BANG_.invoke(ssh.clj:47)
at metabase.util.ssh$include_ssh_tunnel.invokeStatic(ssh.clj:126)
at metabase.util.ssh$include_ssh_tunnel.invoke(ssh.clj:120)
at metabase.driver.sql_jdbc.connection$details__GT_connection_spec_for_testing_connection.invokeStatic(connection.clj:169)
at metabase.driver.sql_jdbc.connection$details__GT_connection_spec_for_testing_connection.invoke(connection.clj:165)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(connection.clj:183)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connection.clj:179)
at metabase.driver.sql_jdbc$fn__78959.invokeStatic(sql_jdbc.clj:35)
at metabase.driver.sql_jdbc$fn__78959.invoke(sql_jdbc.clj:33)
at metabase.driver.mysql$fn__78077.invokeStatic(mysql.clj:72)
at metabase.driver.mysql$fn__78077.invoke(mysql.clj:68)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__29141.invoke(util.clj:34)
at metabase.util$do_with_timeout$fn__15244.invoke(util.clj:323)
at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
at clojure.lang.AFn.call(AFn.java:18)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
here are my diagnostic info:
{
“browser-info”: {
“language”: “en-US”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36 Edg/88.0.705.81”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “Cp1252”,
“java.runtime.name”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “1.8.0_221-b11”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_221”,
“java.vm.name”: “Java HotSpot™ 64-Bit Server VM”,
“java.vm.version”: “25.221-b11”,
“os.name”: “Windows 10”,
“os.version”: “10.0”,
“user.language”: “en”,
“user.timezone”: “Asia/Bangkok”
},
“metabase-info”: {
“databases”: [
“h2”
],
“hosting-env”: “unknown”,
“application-database”: “h2”,
“application-database-details”: {
“database”: {
“name”: “H2”,
“version”: “1.4.197 (2018-03-18)”
},
“jdbc-driver”: {
“name”: “H2 JDBC Driver”,
“version”: “1.4.197 (2018-03-18)”
}
},
“run-mode”: “prod”,
“version”: {
“tag”: “v0.38.0.1”,
“date”: “2021-02-19”,
“branch”: “release-x.38.x”,
“hash”: “0635914”
},
“settings”: {
“report-timezone”: null
}
}
}