Metabase not start properly


#1

Hi

For my 2012 r2 server not domain machine and windows 10 ent. addition metabase not start properly. I mean the start screen stuck on screen not going to start setup screen.

Where I am wrong.

Third one on vwware windows 2012 r2 demo machine is is ok . Working properly. It is a domain controler demo machine. I can connect to MS SQL server and get super info . very well dashboard.

Best regars.


#2

Hi @iincitr
Which version of Metabase? Docker or JAR-file? If JAR, which version of Java?
What do you see in the Metabase log or browser console?


#3

hi
the Latest version *.jar fıles from metabase web sıte.
java version “1.8.0_201”
Java™ SE Runtime Environment (build 1.8.0_201-b09)
Java HotSpot™ Client VM (build 25.201-b09, mixed mode, sharing)

Error

03-15 18:13:16 e[1mERROR metabase.coree[0m :: Metabase starting fails.
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: “PRIMARY_KEY_A6 ON PUBLIC.DATA_MIGRATIONS(ID) VALUES (‘add-users-to-default-permissions-groups’, 1)”; SQL statement:
INSERT INTO “DATA_MIGRATIONS” (“ID”, “TIMESTAMP”) VALUES (?, ?) [23505-197]


#4

Hi

I changed windows 10 language to Eng. then it is ok.

How can I run on my local language ( TR)

thank you


#5

@iincitr

I’m pretty sure there are more errors in the log than that one line.
Good that you wrote that you are running with Turkish language. There are a couple of fixes in the upcoming 0.32.0.

I would actually recommend that you try the 0.32.0-RC1 release a couple of days ago - always backup first:
https://downloads.metabase.com/v0.32.0-RC1/metabase.jar

Here’s a list of some of the issues related to Turkish, but without more information from the logs, then I don’t know which one specially to point to.
https://github.com/metabase/metabase/issues?utf8=✓&q=is%3Aissue+turkish


#6

ok

I did try 0.32.0-RC1 r

Setup screen did occur. But connection to MS SQL server not success.

E:\app>“c:\Program Files\Java\jre1.8.0_201\bin\java” -jar metabase.jar
03-22 09:54:12 ←[1mINFO metabase.util←[0m :: Metataban² y³kleniyor …
03-22 09:54:12 ←[1mINFO metabase.util←[0m :: Maximum memory available to JVM: 1,
8 GB
03-22 09:54:14 ←[1mINFO util.encryption←[0m :: Kay²tl² kimlik bilgileri ■ifrelem
e, bu Metataban² ÷rne­i iin DEVRE DIÌI.
Daha fazla bilgi iin, bak²n²z https://www.metabase.com/docs/latest/operations-
guide/start.html#encrypting-your-database-connection-details-at-rest
03-22 09:54:16 ←[1mINFO metabase.driver←[0m :: Registered abstract driver :sql

03-22 09:54:18 ←[1mINFO metabase.core←[0m :: STANDALONE modunda Metataban²n² ba■
latma
03-22 09:54:18 ←[1mINFO metabase.server←[0m :: Config ile Embedded Jetty Web sun
ucusu ba■lat²l²yor:
{:port 3000}

03-22 09:54:18 ←[1mINFO metabase.core←[0m :: Metataban² s³r³m³ v0.32.0-RC1 (09dd
251 release-0.32.0) ba■lat²l²yor …
03-22 09:54:18 ←[1mINFO metabase.core←[0m :: Sistem saat dilimi ’ Asia/Baghdad ’

03-22 09:54:18 ←[1mINFO metabase.plugins←[0m :: Loading plugins in E:\app\plugin
s…
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Plugin ‘Metabase BigQuery Dr
iver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Metabase BigQuery Driver dep
endency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Plugins with unsatisfied dep
s: [“Metabase BigQuery Driver”]
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :druid…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :druid
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :google…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered abstract driver :googl
e
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Metabase BigQuery Driver dep
endency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
03-22 09:54:18 ←[1mDEBUG plugins.initialize←[0m :: Dependencies satisfied; these
plugins will now be loaded: [“Metabase BigQuery Driver”]
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :bigquery…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :bigquery (pare
nts: #{:sql :google})
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Plugin ‘Metabase Google Anal
ytics Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Metabase Google Analytics Dr
iver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied?
true
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :googleanalytics…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :googleanalytic
s (parents: #{:google})
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :mongo…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :mongo
03-22 09:54:18 ←[1mDEBUG plugins.classloader←[0m :: Setting current thread conte
xt classloader to NEWLY CREATED classloader clojure.lang.DynamicClassLoader@1dfa
18a6…
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Metabase cannot initialize p
lugin Metabase Oracle Driver due to required dependencies. Metabase requires the
Oracle JDBC driver in order to connect to Oracle databases, but we can’t ship i
t as part of Metabase due to licensing restrictions. See https://metabase.com/do
cs/latest/administration-guide/databases/oracle.html for more details.

03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Metabase Oracle Driver depen
dency {:class oracle.jdbc.OracleDriver} satisfied? false
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Plugins with unsatisfied dep
s: [“Metabase Oracle Driver”]
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :presto…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :presto (parent
s: #{:sql})
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :redshift…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered abstract driver :sql-j
dbc (parents: :sql)
Load driver :sql-jdbc took 6 ms
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :postgres (pare
nts: :sql-jdbc)
Load driver :postgres took 50 ms
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :redshift (pare
nts: #{:postgres})
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :snowflake…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :snowflake (par
ents: #{:sql-jdbc})
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :hive-like…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered abstract driver :hive-
like (parents: #{:sql-jdbc})
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :sparksql…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :sparksql (pare
nts: #{:hive-like})
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :sqlite…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :sqlite (parent
s: #{:sql-jdbc})
03-22 09:54:18 ←[1mINFO plugins.lazy-loaded-driver←[0m :: Registering lazy loadi
ng driver :sqlserver…
03-22 09:54:18 ←[1mINFO metabase.driver←[0m :: Registered driver :sqlserver (par
ents: #{:sql-jdbc})
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Metabase cannot initialize p
lugin Metabase Vertica Driver due to required dependencies. Metabase requires th
e Vertica JDBC driver in order to connect to Vertica databases, but we can’t shi
p it as part of Metabase due to licensing restrictions. See https://metabase.com
/docs/latest/administration-guide/databases/vertica.html for more details.

03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Metabase Vertica Driver depe
ndency {:class com.vertica.jdbc.Driver} satisfied? false
03-22 09:54:18 ←[1mINFO plugins.dependencies←[0m :: Plugins with unsatisfied dep
s: [“Metabase Vertica Driver” “Metabase Oracle Driver”]
03-22 09:54:19 ←[1mINFO metabase.driver←[0m :: Registered driver :mysql (parents
: :sql-jdbc)
Load driver :mysql took 13 ms
03-22 09:54:19 ←[1mINFO metabase.driver←[0m :: Registered driver :h2 (parents: :
sql-jdbc)
Load driver :h2 took 11 ms
03-22 09:54:19 ←[1mINFO metabase.core←[0m :: Metataban² DByi kurma ve ta■²ma. L³
tfen bekleyin, Bu bir dakika s³rebilir …
03-22 09:54:19 ←[1mWARN metabase.db←[0m :: WARNING: Using Metabase with an H2 ap
plication database is not recomended for production deployments. For production
deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If y
ou decide to continue to use H2, please be sure to back up the database file reg
ularly. See https://metabase.com/docs/latest/operations-guide/start.html#migrati
ng-from-using-the-h2-database-to-mysql-or-postgres for more information.
03-22 09:54:19 ←[1mINFO metabase.db←[0m :: Verifying h2 Database Connection …
03-22 09:54:19 ←[1mINFO metabase.driver←[0m :: Initializing driver :sql…
03-22 09:54:19 ←[1mINFO metabase.driver←[0m :: Initializing driver :sql-jdbc…
03-22 09:54:19 ←[1mINFO metabase.driver←[0m :: Initializing driver :h2…
03-22 09:54:19 ←[1mINFO metabase.db←[0m :: Verify Database Connection …
03-22 09:54:19 ←[1mINFO metabase.db←[0m :: Running Database Migrations…
03-22 09:54:19 ←[1mINFO metabase.db←[0m :: Setting up Liquibase…
03-22 09:54:19 ←[1mINFO metabase.db←[0m :: Liquibase is ready.
03-22 09:54:19 ←[1mINFO metabase.db←[0m :: Checking if Database has unrun migrat
ions…
03-22 09:54:20 ←[1mINFO metabase.db←[0m :: Database has unrun migrations. Waitin
g for migration lock to be cleared…
03-22 09:54:20 ←[1mINFO metabase.db←[0m :: Migration lock is cleared. Running mi
grations…
03-22 09:54:20 ←[1mINFO metabase.db←[0m :: Database Migrations Current …
03-22 09:54:20 ←[1mINFO db.migrations←[0m :: Running all necessary data migratio
ns, this may take a minute.
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘add-users-t
o-default-permissions-groups’…
03-22 09:54:21 ←[1mINFO models.permissions-group←[0m :: Created magic permission
s group ‘All Users’ (ID = 1)
03-22 09:54:21 ←[1mINFO models.permissions-group←[0m :: Created magic permission
s group ‘Administrators’ (ID = 2)
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘add-admin-g
roup-root-entry’…
03-22 09:54:21 ←[1mINFO models.permissions-group←[0m :: Created magic permission
s group ‘MetaBot’ (ID = 3)
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘add-databas
es-to-magic-permissions-groups’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘migrate-fie
ld-types’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘fix-invalid
-field-types’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘copy-site-u
rl-setting-and-remove-trailing-slashes’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘drop-old-qu
ery-execution-table’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘ensure-prot
ocol-specified-in-site-url’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘populate-ca
rd-database-id’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘migrate-hum
anization-setting’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘mark-catego
ry-fields-as-list’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘add-legacy-
sql-directive-to-bigquery-sql-cards’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘clear-ldap-
user-local-passwords’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Running data migration ‘add-migrate
d-collections’…
03-22 09:54:21 ←[1mINFO db.migrations←[0m :: Finished running data migrations.
03-22 09:54:21 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.notifications
03-22 09:54:21 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.metabot-lifecycle
03-22 09:54:21 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.dependencies
03-22 09:54:21 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.activity-feed
03-22 09:54:21 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.last-login
03-22 09:54:21 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.revision
03-22 09:54:21 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.sync-database
03-22 09:54:21 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.view-log
03-22 09:54:21 ←[1mINFO metabase.events←[0m :: Starting events listener: metabas
e.events.driver-notifications
03-22 09:54:21 ←[1mINFO metabase.task←[0m :: Initializing task SyncDatabases
03-22 09:54:21 ←[1mINFO metabase.task←[0m :: Initializing task CheckForNewVersio
ns
03-22 09:54:21 ←[1mINFO metabase.task←[0m :: Initializing task SendAnonymousUsag
eStats
03-22 09:54:21 ←[1mINFO metabase.task←[0m :: Initializing task SendAbandomentEma
ils
03-22 09:54:21 ←[1mINFO metabase.task←[0m :: Initializing task SendPulses
03-22 09:54:21 ←[1mINFO metabase.task←[0m :: Initializing task SendFollowUpEmail
s
03-22 09:54:21 ←[1mINFO metabase.task←[0m :: Initializing task TaskHistoryCleanu
p
03-22 09:54:21 ←[1mINFO metabase.core←[0m :: G÷r³n³■e g÷re bu yeni bir kurulum .
… kurulum sihirbaz²n² haz²rlama
03-22 09:54:21 ←[1mINFO metabase.core←[0m :: Metataban² y³klemenizi ayarlamak i
in l³tfen a■a­²daki URLyi kullan²n:

http://localhost:3000/setup/

03-22 09:54:21 ←[1mINFO metabase.sample-data←[0m :: Loading sample dataset…
03-22 09:54:21 ←[1mERROR metabase.sample-data←[0m :: Failed to load sample datas
et: Input to sync-database! does not match schema:

     ←[0;33m  [(named (not (instance? metabase.models.database.DatabaseInsta

nce nil)) database)] ←[0m

("–> sync$fn__45602$sync_database_BANG___45607.invoke(sync.clj:19)"
“sample_data$add_sample_dataset_BANG_.invokeStatic(sample_data.clj:30)”
“sample_data$add_sample_dataset_BANG_.invoke(sample_data.clj:24)”
“core$init_BANG_.invokeStatic(core.clj:98)”
“core$init_BANG_.invoke(core.clj:51)”
“core$start_normally.invokeStatic(core.clj:118)”
“core$start_normally.invoke(core.clj:112)”
“core$_main.invokeStatic(core.clj:138)”
“core$_main.doInvoke(core.clj:133)”
“core.main(Unknown Source)”)

03-22 09:54:21 ←[1mINFO metabase.core←[0m :: Metabase Initialization COMPLETE
03-22 09:54:34 ←[1mINFO middleware.misc←[0m :: Setting Metabase site URL to loca
lhost:3000
03-22 09:54:34 ←[1mDEBUG middleware.log←[0m :: POST /api/setup/validate 400 (5 m
s) (0 DB calls).
{:errors {:token “Token does not match the setup token.”}}

03-22 09:54:34 ←[1mDEBUG middleware.log←[0m :: POST /api/setup/validate 400 (897
Ás) (0 DB calls).
{:errors {:token “Token does not match the setup token.”}}

03-22 09:54:39 ←[1mDEBUG middleware.log←[0m :: GET /api/session/properties 200 (
4 ms) (1 DB calls). Jetty threads: 8/50 (4 busy, 6 idle, 0 queued) (53 total act
ive threads)
03-22 09:54:39 ←[1mDEBUG middleware.log←[0m :: GET /api/user/current 401 (523 Ás
) (0 DB calls).
“Unauthenticated”

03-22 09:55:17 ←[1mDEBUG middleware.log←[0m :: POST /api/util/password_check 200
(801 Ás) (0 DB calls). Jetty threads: 8/50 (4 busy, 6 idle, 0 queued) (53 total
active threads)
03-22 09:55:48 ←[1mINFO metabase.driver←[0m :: Initializing driver :sqlserver…

03-22 09:55:48 ←[1mDEBUG plugins.classloader←[0m :: Setting current thread conte
xt classloader to shared classloader clojure.lang.DynamicClassLoader@1dfa18a6…

03-22 09:55:48 ←[1mINFO plugins.classloader←[0m :: Added URL file:/E:/app/plugin
s/sqlserver.metabase-driver.jar to classpath
03-22 09:55:48 ←[1mDEBUG plugins.init-steps←[0m :: Loading plugin namespace meta
base.driver.sqlserver…
03-22 09:55:48 ←[1mDEBUG middleware.log←[0m :: POST /api/setup/validate 400 (8 m
s) (0 DB calls).
{:errors {:dbname “java.io.FileNotFoundException: Could not locate metabase/driv
er/sqlserver__init.class, metabase/driver/sqlserver.clj or metabase/driver/sqlse
rver.cljc on classpath.”}}

03-22 09:55:48 ←[1mDEBUG middleware.log←[0m :: POST /api/setup/validate 400 (769
Ás) (0 DB calls).
{:errors {:dbname “java.lang.IllegalArgumentException: No method in multimethod
‘connection-details->spec’ for dispatch value: :sqlserver”}}

03-22 10:00:00 ←[1mINFO task.send-pulses←[0m :: Sending scheduled pulses…


#7

@iincitr
Great, so it works in the upcoming 0.32.0 release.
There seems to be driver issues with the RC and also RC1, so I’m guessing we’re going to see RC2 very soon.


#8

Ok

I got 0.32.0 RC2 and work.

Thank you.

This is amazing Dashboard and very simple to setup and use.

PS: How can I edit Dashboard panel after insert view panel. I can only mode it but not resize.

Thank you again :slight_smile:


#9

@iincitr
Great. I would highly recommend that you read the documentation - start with the admin guide, that talks about metadata (Data Model), which is the core of Metabase - and then continue to the user guide, which explains how to use most things:
https://www.metabase.com/docs/latest/


#10

Hi

I just download 03.2.1 make a backup *.jar and two db files.

On windows 2012 r2

Where is my dashboard setting. It’s gone.

I return from backup no any setup that I did before the dasboard.

Where am I wrong?

Thank you.


#11

@iincitr
Version 0.32.2 was released yesterday, so download that instead.
How do you start Metabase? You need to either specify the path to the H2 storage or it will automatically look in the current working directory.
And I would highly recommend that you do not use H2 for production use:
https://www.metabase.com/docs/latest/operations-guide/start.html#migrating-from-using-the-h2-database-to-mysql-or-postgres


#12

Hi

I got it

I tired at windows CMD

java -DMB_DB_TYPE=mysql -DMB_DB_DBNAME=metabase -DMB_DB_PORT=3306 -DMB_DB_USER=root -DMB_DB_PASS=x -DMB_DB_HOST=localhost -jar metabase.jar load-from-h2

But no success; Always prompts like below

Usage: java [-options] class [args…]
(to execute a class)
or java [-options] -jar jarfile [args…]
(to execute a jar file)
where options include:
-d32 use a 32-bit data model if available
-d64 use a 64-bit data model if available
-server to select the “server” VM
The default VM is server.


#13

Not sure how Windows handles it, but it looks correct.
Try setting the variables before the command:

set MB_DB_TYPE=mysql
set MB_DB_HOST=localhost
set MB_DB_PORT=3306
set MB_DB_DBNAME=metabase
set MB_DB_USER=root
set MB_DB_PASS=x
java -jar metabase.jar load-from-h2 "C:\path-to\metabase.db"

Remember to remove load-from-h2 "C:\path-to\metabase.db" after migration is done.
And don’t upgrade and migrate at the same time. First upgrade, then migrate.


#14

Hi
There are errors:

“c:\Program Files\Java\jre1.8.0_201\bin\java” -jar metabase.j
ar load-from-h2 “e:\app\metabase.db”
l

og4j:ERROR Could not find value for key log4j.appender.metabase
log4j:ERROR Could not instantiate appender named “metabase”.
04-07 00:40:21 ←[1mINFO metabase.util←[0m :: Metataban² y³kleniyor …
04-07 00:40:21 ←[1mINFO metabase.util←[0m :: JVM iin kullan²labilir bellek: 1,8
GB
04-07 00:40:23 ←[1mINFO util.encryption←[0m :: Kay²tl² kimlik bilgileri ■ifrelem
e, bu Metataban² ÷rne­i iin DEVRE DIÌI.
Daha fazla bilgi iin, bak²n²z https://www.metabase.com/docs/latest/operations-
guide/start.html#encrypting-your-database-connection-details-at-rest
04-07 00:40:24 ←[1mINFO metabase.driver←[0m :: Soyut s³r³c³ :sql kaydedildi
04-07 00:40:27 ←[1mINFO metabase.db←[0m :: Verifying mysql Database Connection .

04-07 00:40:27 ←[1mDEBUG plugins.classloader←[0m :: Setting current thread conte
xt classloader to NEWLY CREATED classloader clojure.lang.DynamicClassLoader@2b29
e47c…
04-07 00:40:27 ←[1mINFO metabase.driver←[0m :: Registered abstract driver :sql-j
dbc (parents: :sql)
Load driver :sql-jdbc took 5 ms
04-07 00:40:27 ←[1mINFO metabase.driver←[0m :: Registered driver :mysql (parents
: :sql-jdbc)
Load driver :mysql took 49 ms
04-07 00:40:27 ←[1mINFO metabase.driver←[0m :: Initializing driver :sql…
04-07 00:40:27 ←[1mINFO metabase.driver←[0m :: Initializing driver :sql-jdbc…
04-07 00:40:27 ←[1mINFO metabase.driver←[0m :: Initializing driver :mysql…
java.lang.Exception: java.sql.SQLNonTransientConnectionException: Client does no
t support authentication protocol requested by server. Consider upgrading MariaD
B client. plugin was = caching_sha2_password
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(uti
l.clj:34)
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.cl
j:18)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at clojure.lang.Var.invoke(Var.java:393)
at metabase.db$verify_db_connection$fn__16094.invoke(db.clj:403)
at metabase.db$verify_db_connection.invokeStatic(db.clj:401)
at metabase.db$verify_db_connection.invoke(db.clj:394)
at metabase.db$verify_db_connection.invokeStatic(db.clj:397)
at metabase.db$verify_db_connection.invoke(db.clj:394)
at metabase.db$setup_db_BANG_$fn__16111.invoke(db.clj:467)
at metabase.util$do_with_us_locale.invokeStatic(util.clj:683)
at metabase.util$do_with_us_locale.invoke(util.clj:669)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:466)
at metabase.db$setup_db_BANG_.doInvoke(db.clj:460)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h
2.clj:215)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:
209)
at clojure.lang.Var.invoke(Var.java:384)
at metabase.cmd$load_from_h2.invokeStatic(cmd.clj:37)
at metabase.cmd$load_from_h2.invoke(cmd.clj:30)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:665)
at clojure.core$apply.invoke(core.clj:660)
at metabase.cmd$run_cmd$fn__60054.invoke(cmd.clj:140)
at metabase.cmd$run_cmd.invokeStatic(cmd.clj:140)
at metabase.cmd$run_cmd.invoke(cmd.clj:136)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.core$run_cmd.invokeStatic(core.clj:128)
at metabase.core$run_cmd.invoke(core.clj:126)
at metabase.core$main.invokeStatic(core.clj:137)
at metabase.core$main.doInvoke(core.clj:133)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at metabase.core.main(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: java.sql.SQLNonTransientConn
ectionException: Client does not support authentication protocol requested by se
rver. Consider upgrading MariaDB client. plugin was = caching_sha2_password
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at clojure.core$deref_future.invokeStatic(core.clj:2302)
at clojure.core$future_call$reify__8439.deref(core.clj:6974)
at clojure.core$deref.invokeStatic(core.clj:2324)
at clojure.core$deref.invoke(core.clj:2306)
at metabase.util$deref_with_timeout.invokeStatic(util.clj:326)
at metabase.util$deref_with_timeout.invoke(util.clj:323)
at metabase.driver.util$can_connect_with_details_QMARK
.invokeStatic(uti
l.clj:29)
… 33 more
Caused by: java.sql.SQLNonTransientConnectionException: Client does not support
authentication protocol requested by server. Consider upgrading MariaDB client.
plugin was = caching_sha2_password
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(Excepti
onMapper.java:234)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getExceptio
n(ExceptionMapper.java:165)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWit
houtProxy(AbstractConnectProtocol.java:1199)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.ja
va:174)
at org.mariadb.jdbc.Driver.connect(Driver.java:92)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at clojure.java.jdbc$get_driver_connection.invokeStatic(jdbc.clj:271)
at clojure.java.jdbc$get_driver_connection.invoke(jdbc.clj:250)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:411)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:274)
at clojure.java.jdbc$db_query_with_resultset_STAR
.invokeStatic(jdbc.clj
:1093)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1075)

    at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1164)
    at clojure.java.jdbc$query.invoke(jdbc.clj:1126)
    at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1142)
    at clojure.java.jdbc$query.invoke(jdbc.clj:1126)
    at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invokeStatic(c

onnection.clj:123)
at metabase.driver.sql_jdbc.connection$can_connect_QMARK_.invoke(connect
ion.clj:118)
at metabase.driver.sql_jdbc$fn__62329.invokeStatic(sql_jdbc.clj:39)
at metabase.driver.sql_jdbc$fn__62329.invoke(sql_jdbc.clj:38)
at clojure.lang.MultiFn.invoke(MultiFn.java:234)
at metabase.driver.util$can_connect_with_details_QMARK_$fn__17971.invoke
(util.clj:30)
at clojure.core$binding_conveyor_fn$fn__5739.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)
Caused by: java.sql.SQLException: Client does not support authentication protoco
l requested by server. Consider upgrading MariaDB client. plugin was = caching_s
ha2_password
at org.mariadb.jdbc.internal.protocol.authentication.DefaultAuthenticati
onProvider.processAuthPlugin(DefaultAuthenticationProvider.java:110)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentica
tion(AbstractConnectProtocol.java:911)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConn
ectionPhases(AbstractConnectProtocol.java:850)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(Ab
stractConnectProtocol.java:507)
at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWit
houtProxy(AbstractConnectProtocol.java:1195)
… 27 more
Command failed with exception: java.sql.SQLNonTransientConnectionException: Clie
nt does not support authentication protocol requested by server. Consider upgrad
ing MariaDB client. plugin was = caching_sha2_password


#15

@iincitr
Ahh, okay, so you’re using MySQL 8? Have a look here for a workaround: