Hi,
This is my first post and looking for some help with my metabase after a server restart.
I have metabase installed on a windows server, with a Postgres database(metaDB). I have configured metabase to run as a service with NSSM. The JETTY port is changed from default to 3002
SET MB_JETTY_PORT=3002
SET MB_DB_TYPE=postgres
SET MB_DB_NAME=metaDB
SET MB_DB_PORT=5432
SET MB_DB_USER=postgres
SET MB_DB_PASS=######
SET MB_DB_HOST=localhost.
I have had metabase running fine, I have created a number of questions and dashboards. Over the weekend the server was restarted. I went to login again got the "Welcome to Metabase let's get started" menu.
I have checked the Postgres database and can see my database connections are still there when I query the "metabase_database" table. My users and questions are there in views v_users and v_content.
I tried setting the environment variables in a CMD prompt windows and run the jar file from there but this too has the "Welcome to Metabase Lets Get Start" screen.
Does the startup require some different parameters once the metabase has been configured to use a local postgres database or something? Any help or guidance would be greatly appreciated. Thanks in advance.
Note: It keeps saying on start up that it looks like a new install when it is not:
Start Up Screen Log:
Warning: environ value C:\Program Files (x86)\Java\jre-1.8 for key :java-home has been overwritten with C:\Program Files\Java\jdk-20
2023-10-30 15:08:10,321 INFO metabase.util :: Maximum memory available to JVM: 4.0 GB
2023-10-30 15:08:12,162 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance.
For more information, see Redirecting…
2023-10-30 15:08:21,502 INFO driver.impl :: Registered abstract driver :sql
2023-10-30 15:08:21,502 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql])
2023-10-30 15:08:21,502 INFO metabase.util :: Load driver :sql-jdbc took 75.6 ms
2023-10-30 15:08:21,502 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc])
2023-10-30 15:08:21,564 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc])
2023-10-30 15:08:21,611 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc])
2023-10-30 15:08:23,142 INFO metabase.core ::
Metabase v0.47.0 (682ec2d release-x.47.x)
Copyright ┬® 2023 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2023-10-30 15:08:23,142 INFO metabase.core :: Starting Metabase in STANDALONE mode
2023-10-30 15:08:23,205 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3002}
2023-10-30 15:08:23,267 INFO metabase.core :: Starting Metabase version v0.47.0 (682ec2d release-x.47.x) ...
2023-10-30 15:08:23,299 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "Java(TM) SE Runtime Environment",
"java.runtime.version" "20.0.2+9-78",
"java.vendor" "Oracle Corporation",
"java.vendor.url" "https://java.oracle.com/",
"java.version" "20.0.2",
"java.vm.name" "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version" "20.0.2+9-78",
"os.name" "Windows Server 2019",
"os.version" "10.0",
"user.language" "en",
"user.timezone" "Pacific/Auckland"}
2023-10-30 15:08:23,299 INFO metabase.plugins :: Loading plugins in D:\metabase\plugins...
2023-10-30 15:08:23,642 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :athena...
2023-10-30 15:08:23,642 INFO driver.impl :: Registered driver :athena (parents: [:sql-jdbc])
2023-10-30 15:08:23,700 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :bigquery-cloud-sdk...
2023-10-30 15:08:23,700 INFO driver.impl :: Registered driver :bigquery-cloud-sdk (parents: [:sql])
2023-10-30 15:08:23,707 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...
2023-10-30 15:08:23,707 INFO driver.impl :: Registered driver :druid
2023-10-30 15:08:23,712 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...
2023-10-30 15:08:23,713 INFO driver.impl :: Registered driver :googleanalytics
2023-10-30 15:08:23,718 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...
2023-10-30 15:08:23,718 INFO driver.impl :: Registered driver :mongo
2023-10-30 15:08:23,734 INFO plugins.dependencies :: Metabase cannot initialize plugin 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 it as part of Metabase due to licensing restrictions. See Redirecting… for more details.
2023-10-30 15:08:23,734 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2023-10-30 15:08:23,734 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
2023-10-30 15:08:23,734 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto-jdbc...
2023-10-30 15:08:23,749 INFO driver.impl :: Registered driver :presto-jdbc (parents: [:sql-jdbc])
2023-10-30 15:08:23,749 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :redshift...
2023-10-30 15:08:23,749 INFO driver.impl :: Registered driver :redshift (parents: [:postgres])
2023-10-30 15:08:23,765 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...
2023-10-30 15:08:23,765 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc])
2023-10-30 15:08:23,780 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :hive-like...
2023-10-30 15:08:23,780 INFO driver.impl :: Registered abstract driver :hive-like (parents: [:sql-jdbc])
2023-10-30 15:08:23,780 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sparksql...
2023-10-30 15:08:23,780 INFO driver.impl :: Registered driver :sparksql (parents: [:hive-like])
2023-10-30 15:08:23,780 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...
2023-10-30 15:08:23,780 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc])
2023-10-30 15:08:23,827 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlserver...
2023-10-30 15:08:23,827 INFO driver.impl :: Registered driver :sqlserver (parents: [:sql-jdbc])
2023-10-30 15:08:23,827 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-10-30 15:08:23,827 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2023-10-30 15:08:23,827 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]
2023-10-30 15:08:23,827 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2023-10-30 15:08:23,843 INFO db.setup :: Verifying postgres Database Connection ...
2023-10-30 15:08:24,054 INFO db.setup :: Successfully verified PostgreSQL 16.0 application database connection.
2023-10-30 15:08:24,054 INFO db.setup :: Running Database Migrations...
2023-10-30 15:08:24,054 INFO db.setup :: Setting up Liquibase...
2023-10-30 15:08:24,397 INFO db.setup :: Liquibase is ready.
2023-10-30 15:08:24,397 INFO db.liquibase :: Checking if Database has unrun migrations...
2023-10-30 15:08:25,351 INFO db.setup :: Database Migrations Current ...
2023-10-30 15:08:25,366 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2023-10-30 15:08:25,814 INFO db.data-migrations :: Finished running data migrations.
2023-10-30 15:08:25,814 INFO metabase.util :: Database setup took 2.0 s
2023-10-30 15:08:25,877 INFO metabase.events :: Starting events listener: :metabase.events.activity-feed/ActivityFeed
2023-10-30 15:08:25,893 INFO metabase.events :: Starting events listener: :metabase.events.last-login/LastLogin
2023-10-30 15:08:25,893 INFO metabase.events :: Starting events listener: :metabase.events.persisted-info/PersistedInfo
2023-10-30 15:08:25,893 INFO metabase.events :: Starting events listener: :metabase.events.sync-database/Sync
2023-10-30 15:08:25,908 INFO metabase.events :: Starting events listener: :metabase.events.driver-notifications/DriverNotifications
2023-10-30 15:08:25,908 INFO metabase.events :: Starting events listener: :metabase.events.revision/Revisions
2023-10-30 15:08:25,908 INFO metabase.events :: Starting events listener: :metabase.events.view-log/ViewLog
2023-10-30 15:08:25,924 INFO metabase.core :: Looks like this is a new installation ... preparing setup wizard
2023-10-30 15:08:25,955 INFO metabase.core :: Please use the following URL to setup your Metabase installation:
