Hello everybody,
I am currently trying to connect my Metabase and my MySQL Docker container to each other. However, I am encountering an error, and I have tried the recommended settings but don't know where the error is.
Java:
- OpenJDK 11.0.20.1 2023-08-24
- OpenJDK Runtime Environment (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04)
- OpenJDK 64-Bit Server VM (build 11.0.20.1+1-post-Ubuntu-0ubuntu122.04, mixed mode, sharing)
Docker-Compose Metabase:
version: '3'
services:
metabase:
image: metabase/metabase
container_name: metabase
volumes:
- /home/metabase/plugins/ojdbc8.jar:/plugins/ojdbc8.jar
- /home/metabase/metabase-data:/metabase-data
- /home/metabase/metabase.db:/metabase.db
ports:
- "3000:3000"
environment:
MB_PLUGINS_DIR: /plugins
MB_DB_TYPE: mysql
MB_DB_DBNAME: metabase_db
MB_DB_PORT: 3306
MB_DB_USER: metabase
MB_DB_PASS: Password
restart: always
networks:
- metabase-network
networks:
metabase-network:
Docker-Compose MYSQL:
version: '3'
services:
mysql-db:
image: mysql
container_name: metabase-mysql
environment:
MYSQL_USER: metabase
MYSQL_PASSWORD: Password
MYSQL_DATABASE: metabase_db
MYSQL_ROOT_PASSWORD: Password
ports:
- "3306:3306"
volumes:
- /home/mysql:/var/lib/mysql
networks:
- metabase-network
restart: always
networks:
metabase-network:
Error Log from the Metabase docker container:
Metabase v0.47.0 (682ec2d release-x.47.x)
Copyright © 2023 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2023-09-12 12:33:35,734 INFO metabase.core :: Starting Metabase in STANDALONE mode
2023-09-12 12:33:35,788 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000, :host "0.0.0.0"}
2023-09-12 12:33:35,842 INFO metabase.core :: Starting Metabase version v0.47.0 (682ec2d release-x.47.x) ...
2023-09-12 12:33:35,876 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.20+8",
"java.vendor" "Eclipse Adoptium",
"java.vendor.url" "https://adoptium.net/",
"java.version" "11.0.20",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "11.0.20+8",
"os.name" "Linux",
"os.version" "5.15.0-82-generic",
"user.language" "en",
"user.timezone" "GMT"}
2023-09-12 12:33:35,878 INFO metabase.plugins :: Loading plugins in /plugins...
2023-09-12 12:33:36,656 INFO plugins.classloader :: Added URL file:/plugins/ojdbc8.jar to classpath
2023-09-12 12:33:36,754 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2023-09-12 12:33:36,763 INFO driver.impl :: Registered driver :googleanalytics 
2023-09-12 12:33:36,794 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2023-09-12 12:33:36,795 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql])
2023-09-12 12:33:36,810 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? true
2023-09-12 12:33:36,815 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :oracle...
2023-09-12 12:33:36,816 INFO driver.impl :: Registered driver :oracle (parents: [:sql-jdbc])
2023-09-12 12:33:36,827 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2023-09-12 12:33:36,828 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc])
2023-09-12 12:33:36,888 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2023-09-12 12:33:36,888 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc])
2023-09-12 12:33:36,901 INFO plugins.dependencies :: Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See Redirecting… for more details.
2023-09-12 12:33:36,901 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2023-09-12 12:33:36,902 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver"]
2023-09-12 12:33:36,907 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2023-09-12 12:33:36,926 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc])
2023-09-12 12:33:36,938 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2023-09-12 12:33:36,939 INFO driver.impl :: Registered driver :mongo
2023-09-12 12:33:36,958 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :athena...
2023-09-12 12:33:36,959 INFO driver.impl :: Registered driver :athena (parents: [:sql-jdbc])
2023-09-12 12:33:36,965 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2023-09-12 12:33:36,965 INFO driver.impl :: Registered driver :redshift (parents: [:postgres])
2023-09-12 12:33:37,000 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2023-09-12 12:33:37,000 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:sql-jdbc])
2023-09-12 12:33:37,016 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2023-09-12 12:33:37,016 INFO driver.impl :: Registered driver :druid
2023-09-12 12:33:37,025 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2023-09-12 12:33:37,026 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc])
2023-09-12 12:33:37,027 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2023-09-12 12:33:37,028 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like])
2023-09-12 12:33:37,036 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2023-09-12 12:33:37,044 INFO db.setup :: Verifying mysql Database Connection ...
2023-09-12 12:34:07,265 ERROR metabase.core :: Metabase Initialization FAILED
clojure.lang.ExceptionInfo: Unable to connect to Metabase mysql DB. {}
at metabase.db.setup$fn__52070$verify_db_connection__52075$fn__52076$fn__52077.invoke(setup.clj:111)
at metabase.db.setup$fn__52070$verify_db_connection__52075$fn__52076.invoke(setup.clj:109)
at metabase.db.setup$fn__52070$verify_db_connection__52075.invoke(setup.clj:101)
at metabase.db.setup$fn__52155$setup_db_BANG___52160$fn__52161$fn__52164$fn__52165.invoke(setup.clj:155)
at metabase.util.jvm$do_with_us_locale.invokeStatic(jvm.clj:239)
at metabase.util.jvm$do_with_us_locale.invoke(jvm.clj:225)
at metabase.db.setup$fn__52155$setup_db_BANG___52160$fn__52161$fn__52164.invoke(setup.clj:152)
at metabase.db.setup$fn__52155$setup_db_BANG___52160$fn__52161.invoke(setup.clj:151)
at metabase.db.setup$fn__52155$setup_db_BANG___52160.invoke(setup.clj:145)
at metabase.db$setup_db_BANG_$fn__52188.invoke(db.clj:66)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:61)
at metabase.db$setup_db_BANG_.invoke(db.clj:52)
at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:113)
at metabase.core$init_BANG__STAR_.invoke(core.clj:99)
at metabase.core$init_BANG_.invokeStatic(core.clj:159)
at metabase.core$init_BANG_.invoke(core.clj:154)
at metabase.core$start_normally.invokeStatic(core.clj:171)
at metabase.core$start_normally.invoke(core.clj:165)
at metabase.core$main.invokeStatic(core.clj:204)
at metabase.core$main.doInvoke(core.clj:198)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.lang.Var.applyTo(Var.java:705)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.bootstrap$main.invokeStatic(bootstrap.clj:31)
at metabase.bootstrap$main.doInvoke(bootstrap.clj:28)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.bootstrap.main(Unknown Source)
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:372)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR.invokeStatic(jdbc.clj:1111)
at clojure.java.jdbc$db_query_with_resultset_STAR.invoke(jdbc.clj:1093)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1182)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1160)
at clojure.java.jdbc$query.invoke(jdbc.clj:1144)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK.invokeStatic(connection.clj:310)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK.invoke(connection.clj:307)
at metabase.db.setup$fn__52070$verify_db_connection__52075$fn__52076$fn__52077.invoke(setup.clj:109)
... 31 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
... 43 more
Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3306)(type=master) : Socket fail to connect to host:localhost, port:3306. Connection refused (Connection refused)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)
at org.mariadb.jdbc.Driver.connect(Driver.java:89)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
at metabase.db.data_source.DataSource.getConnection(data_source.clj:31)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:213)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:localhost, port:3306. Connection refused (Connection refused)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:188)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:257)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:524)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389)
... 13 more
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.base/java.net.SocksSocketImpl.connect(Unknown Source)
at java.base/java.net.Socket.connect(Unknown Source)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:252)
... 15 more
2023-09-12 12:34:07,273 INFO metabase.core :: Metabase Shutting Down ...
2023-09-12 12:34:07,279 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2023-09-12 12:34:07,290 INFO metabase.core :: Metabase Shutdown COMPLETE
Warning: environ value jdk-11.0.20+8 for key :java-version has been overwritten with 11.0.20
2023-09-12 12:34:12,631 INFO metabase.util :: Maximum memory available to JVM: 492.0 MB
2023-09-12 12:34:14,756 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. 
For more information, see Redirecting…
2023-09-12 12:34:21,312 INFO driver.impl :: Registered abstract driver :sql
2023-09-12 12:34:21,326 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql])
2023-09-12 12:34:21,331 INFO metabase.util :: Load driver :sql-jdbc took 117.6 ms
2023-09-12 12:34:21,332 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc])
2023-09-12 12:34:21,379 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc])
2023-09-12 12:34:21,415 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc])
2023-09-12 12:34:23,780 INFO metabase.core ::