Step by Step Installation of Metabase in Windows 10


#1

Hi all,

I am new to Metabase. I am not able to install Metabase in my Laptop having Windows 10.
Can anyone please tell me the step by step process or any relevant videos.
I have downloaded the Metabase.jar
My system has java 11 installed.

I tried myself and getting error:

Verifying h2 Database Connection …
org.h2.message.DbException: Log file error: “C:/Program Files/metabase.db java -jar metabase.jar.trace.db”, cause: “java.io.FileNotFoundException: C:\Program Files\metabase.db java -jar metabase.jar.trace.db (Access is denied)” [90034-197]
org.h2.message.DbException: Log file error: “C:/Program Files/metabase.db java -jar metabase.jar.trace.db”, cause: “java.io.FileNotFoundException: C:\Program Files\metabase.db java -jar metabase.jar.trace.db (Access is denied)” [90034-197]
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.TraceSystem.logWritingError(TraceSystem.java:289)
at org.h2.message.TraceSystem.openWriter(TraceSystem.java:310)
at org.h2.message.TraceSystem.writeFile(TraceSystem.java:258)
at org.h2.message.TraceSystem.write(TraceSystem.java:242)
at org.h2.message.Trace.error(Trace.java:182)
at org.h2.engine.Database.setBackgroundException(Database.java:2110)
at org.h2.mvstore.db.MVTableEngine$1.uncaughtException(MVTableEngine.java:95)
at org.h2.mvstore.MVStore.handleException(MVStore.java:2506)
at org.h2.mvstore.MVStore.panic(MVStore.java:383)
at org.h2.mvstore.MVStore.(MVStore.java:364)
at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2934)
at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:155)
at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:100)
at org.h2.engine.Database.getPageStore(Database.java:2538)
at org.h2.engine.Database.open(Database.java:709)
at org.h2.engine.Database.openDatabase(Database.java:286)
at org.h2.engine.Database.(Database.java:280)
at org.h2.engine.Engine.openSession(Engine.java:66)
at org.h2.engine.Engine.openSession(Engine.java:179)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:157)
at org.h2.engine.Engine.createSession(Engine.java:140)
at org.h2.engine.Engine.createSession(Engine.java:28)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:351)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:124)
at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:103)
at org.h2.Driver.connect(Driver.java:69)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:370)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:229)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1023)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1005)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1099)
at clojure.java.jdbc$query.invoke(jdbc.clj:1056)
at clojure.java.jdbc$query.invokeStatic(jdbc.clj:1072)
at clojure.java.jdbc$query.invoke(jdbc.clj:1056)
at metabase.driver.generic_sql$can_connect_QMARK_.invokeStatic(generic_sql.clj:206)
at metabase.driver.generic_sql$can_connect_QMARK_.invoke(generic_sql.clj:203)
at metabase.driver$fn__29969$G__29722__29976.invoke(driver.clj:106)
at metabase.driver$can_connect_with_details_QMARK_$fn__30102.invoke(driver.clj:523)
at clojure.core$binding_conveyor_fn$fn__5476.invoke(core.clj:2022)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.h2.jdbc.JdbcSQLException: Log file error: “C:/Program Files/metabase.db java -jar metabase.jar.trace.db”, cause: “java.io.FileNotFoundException: C:\Program Files\metabase.db java -jar metabase.jar.trace.db (Access is denied)” [90034-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
… 47 more
Caused by: java.io.FileNotFoundException: C:\Program Files\metabase.db java -jar metabase.jar.trace.db (Access is denied)
at java.base/java.io.FileOutputStream.open0(Native Method)
at java.base/java.io.FileOutputStream.open(FileOutputStream.java:298)
at java.base/java.io.FileOutputStream.(FileOutputStream.java:237)
at java.base/java.io.FileOutputStream.(FileOutputStream.java:126)
at org.h2.store.fs.FilePathDisk.newOutputStream(FilePathDisk.java:287)
at org.h2.store.fs.FileUtils.newOutputStream(FileUtils.java:236)
at org.h2.message.TraceSystem.openWriter(TraceSystem.java:306)
… 44 more
03-27 15:27:52 e[1mERROR metabase.drivere[0m :: Failed to connect to database: org.h2.jdbc.JdbcSQLException: IO Exception: null [90028-197]
03-27 15:27:52 e[1mERROR metabase.coree[0m :: Metabase Initialization FAILED
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.driver/can-connect-with-details?)) engine details))
at metabase.db$verify_db_connection.invokeStatic(db.clj:402)
at metabase.db$verify_db_connection.invoke(db.clj:395)
at metabase.db$verify_db_connection.invokeStatic(db.clj:398)
at metabase.db$verify_db_connection.invoke(db.clj:395)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:464)
at metabase.db$setup_db_BANG_.doInvoke(db.clj:458)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at metabase.core$init_BANG_.invokeStatic(core.clj:162)
at metabase.core$init_BANG_.invoke(core.clj:139)
at metabase.core$start_normally.invokeStatic(core.clj:246)
at metabase.core$start_normally.invoke(core.clj:240)
at metabase.core$_main.invokeStatic(core.clj:266)
at metabase.core$_main.doInvoke(core.clj:261)
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)
03-27 15:27:52 e[1mINFO metabase.coree[0m :: Metabase Shutting Down …
03-27 15:27:52 e[1mINFO metabase.coree[0m :: Metabase Shutdown COMPLETE


#2

You can’s store the metabase.jar in Program Files - you won’t have write access to the folder (a good thing for security).
Create a subfolder and try from there.

Quick edit - you’ll also need to give your user account Modify rights to the new folder.
Alternatively, if you’re just testing, put it on your desktop.


#3

Thanks a ton…It worked.