应用商店metabase安装失败

[JAINKRE]

联系方式

No response

1Panel 版本

v1.10.13-lts

问题描述

应用商店metabase安装出现问题，反复几次尝试，一直卡在这个页面：

重现步骤

正常安装，未进行任何额外操作

数据库使用mysql，可用内存20GB+

期待的正确结果

No response

相关日志输出

No response

附加信息

No response

[wanghe-fit2cloud]

可以先自行检查一下容器日志，查看是否有相关的错误信息。

[wanghe-fit2cloud]

刚在本地环境安装，未复现上述问题。

[JAINKRE]

ok，那我在换台机器试一下

[gopkg-dev]

我也出现了这个问题....

[JAINKRE]

这个问题大概率是数据库连接导致的，你手动修改一下应该就可以了

[xinatcg]

数据库的问题

etabase Initialization FAILED
clojure.lang.ExceptionInfo: Unable to connect to Metabase mysql DB. {}
at metabase.db.setup$verify_db_connection50586__50587$fn__50588.invoke(setup.clj:123)
at metabase.db.setup$verify_db_connection50586__50587.invokeStatic(setup.clj:121)
at metabase.db.setup$verify_db_connection50586__50587.invoke(setup.clj:113)
at metabase.db.setup$setup_db_BANG_50627__50628$fn__50631$fn__50632.invoke(setup.clj:195)
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$setup_db_BANG_50627__50628$fn__50631.invoke(setup.clj:191)
at metabase.db.setup$setup_db_BANG_50627__50628.invokeStatic(setup.clj:190)
at metabase.db.setup$setup_db_BANG_50627__50628.invoke(setup.clj:183)
at metabase.db$setup_db_BANG_$fn__50705.invoke(db.clj:96)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:91)
at metabase.db$setup_db_BANG_.doInvoke(db.clj:78)
at clojure.lang.RestFn.invoke(RestFn.java:424)
at metabase.core.core$init_BANG__STAR_.invokeStatic(core.clj:133)
at metabase.core.core$init_BANG__STAR_.invoke(core.clj:112)
at metabase.core.core$init_BANG_.invokeStatic(core.clj:186)
at metabase.core.core$init_BANG_.invoke(core.clj:181)
at metabase.core.core$start_normally.invokeStatic(core.clj:198)
at metabase.core.core$start_normally.invoke(core.clj:192)
at metabase.core.core$entrypoint.invokeStatic(core.clj:234)
at metabase.core.core$entrypoint.doInvoke(core.clj:225)
at clojure.lang.RestFn.invoke(RestFn.java:400)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:135)
at clojure.lang.Var.applyTo(Var.java:707)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.core.bootstrap$main.invokeStatic(bootstrap.clj:36)
at metabase.core.bootstrap$main.doInvoke(bootstrap.clj:29)
at clojure.lang.RestFn.invoke(RestFn.java:400)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:135)
at metabase.core.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:117)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:901)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:105)
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:398)
at metabase.driver.sql_jdbc.connection$can_connect_with_spec_QMARK_.invoke(connection.clj:395)
at clojure.lang.Var.invoke(Var.java:386)
at metabase.db.setup$verify_db_connection50586__50587$fn__50588.invoke(setup.clj:121)
... 32 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:1445)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:580)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:490)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndScacheMarkConnectionInUse(C3P0PooledConnectionPool.java:965)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:893)
... 45 more
Caused by: java.sql.SQLTransientConnectionException: Could not connect to address=(host=mysql)(port=3306)(type=master) : RSA public key is not available client side (option serverRsaPublicKeyFile not set)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:197)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1395)
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:77)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:119)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:509)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1112)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1099)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:9)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1846)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: java.sql.SQLException: RSA public key is not available client side (option serverRsaPublicKeyFile not set)
at org.mariadb.jdbc.internal.com.send.authentication.CachingSha2PasswordPlugin.process(CachingSha2PasswordPlugin.java:189)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:767)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:571)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1390)
... 13 more

[xinatcg]

奇怪更新了一下用户权限, 工作了

**ALTER USER 'metabase_xxx'@'%' IDENTIFIED WITH mysql_native_password BY 'metabase_pwd';
FLUSH PRIVILEGES;

SELECT user, host, plugin FROM mysql.user WHERE user = 'metabase_xxx';**

虽然返回的 0 row affected