Search code examples
h2metabase

Unable to connect to Metabase h2 DB


I can not initialize the metabase setup, as I am getting error when connecting metabase to h2 db.

I did so far as below

1.Downloaded metabase.jar from here

2.From cmd prompt i executed java -jar metabase.jar

I am getting Below error

 04-25 12:03:07 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
04-25 12:03:07 INFO metabase.db :: Verifying h2 Database Connection ...
04-25 12:03:12 ERROR metabase.driver :: Failed to connect to database: Timed out after 5000 milliseconds.
java.lang.AssertionError: Assert failed: Unable to connect to Metabase h2 DB.
(binding [*allow-potentailly-unsafe-connections* true] (require (quote metabase.driver)) ((resolve (quote metabase.drive
r/can-connect-with-details?)) engine details))
        at metabase.db$verify_db_connection.invokeStatic(db.clj:320)
        at metabase.db$verify_db_connection.invoke(db.clj:313)
        at metabase.db$verify_db_connection.invokeStatic(db.clj:316)
        at metabase.db$verify_db_connection.invoke(db.clj:313)
        at metabase.db$setup_db_BANG_.invokeStatic(db.clj:368)
        at metabase.db$setup_db_BANG_.doInvoke(db.clj:362)
        at clojure.lang.RestFn.invoke(RestFn.java:421)
        at metabase.core$init_BANG_.invokeStatic(core.clj:102)
        at metabase.core$init_BANG_.invoke(core.clj:81)
        at metabase.core$start_normally.invokeStatic(core.clj:186)
        at metabase.core$start_normally.invoke(core.clj:180)
        at metabase.core$_main.invokeStatic(core.clj:278)
        at metabase.core$_main.doInvoke(core.clj:273)
        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.core.main(Unknown Source)
04-25 12:03:12 ERROR metabase.core :: Metabase Initialization FAILED:  Assert failed: Unable to connect to Metabase h2 D
B.
(binding [*allow-potentailly-unsafe-connections* true] (require (quote metabase.driver)) ((resolve (quote metabase.drive
r/can-connect-with-details?)) engine details))
04-25 12:03:12 INFO metabase.core :: Metabase Shutting Down ...
04-25 12:03:12 INFO metabase.core :: Metabase Shutdown COMPLETE

Initially I didn't get an error. I did everything in metabase. After 2 days, when I tried the same, I am getting this error. Even after deleting everything and tried from start again and also with admin permisions. Nothing worked same error.


Solution

  • Try Opening command prompt with admin credentials and run the below command

    java -jar metabase.jar