Site Cant Be Reached

Get Help
1

Hi.

I am very new to the community and this is my first post :-).

I have gone ahead and installed Metabase on one of my servers. Got everything up and running and it was working amazingly. Thanks to the developers!

Today I went ahead and started adding some more databases and all of a sudden it stopped working. I can no longer access the site and keep getting "The site cannot be reached".

How do I go about debugging this. I am not familiar with java and have no idea where to find log files or anything else.

when i run systemctl statyus metabase it seems that the service is up and running:
● metabase.service - Metabase
Loaded: loaded (/etc/systemd/system/metabase.service; enabled; vendor preset: enabled)
Active: active (running) since Sun 2021-07-18 12:14:51 UTC; 11min ago
Main PID: 820 (metabase.sh)
Tasks: 14 (limit: 1151)
CGroup: /system.slice/metabase.service
├─820 /bin/bash /opt/metabase/metabase.sh
└─834 java -jar /opt/metabase/metabase.jar

Jul 18 12:14:51 metabase-2 systemd[1]: Started Metabase.
Jul 18 12:14:59 metabase-2 metabase.sh[820]: 07-18 12:14:59 DEBUG plugins.classloader :: Using NEWLY CREATED classloader as shared context classloader: clojure.lang.DynamicClassLoader@3fe46690
Jul 18 12:15:00 metabase-2 metabase.sh[820]: 07-18 12:15:00 INFO metabase.util :: Loading Metabase...
Jul 18 12:15:00 metabase-2 metabase.sh[820]: 07-18 12:15:00 INFO metabase.util :: Maximum memory available to JVM: 239.8 MB
Jul 18 12:15:21 metabase-2 metabase.sh[820]: 07-18 12:15:21 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. :unlock:
Jul 18 12:15:21 metabase-2 metabase.sh[820]: For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html

Any pointers will be greatly appreciated.

2

You can check the startup log, whether the service port is listening, and whether the browser has enabled the proxy

3

I looked and can see this:
07-18 13:05:21 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 Verti

Jul 18 13:05:21 metabase-2 metabase.sh[810]: 07-18 13:05:21 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false

Jul 18 13:05:21 metabase-2 metabase.sh[810]: 07-18 13:05:21 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Vertica Driver"]

Jul 18 13:05:21 metabase-2 metabase.sh[810]: 07-18 13:05:21 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :druid...

Jul 18 13:05:21 metabase-2 metabase.sh[810]: 07-18 13:05:21 INFO driver.impl :: Registered driver :druid :truck:

Jul 18 13:05:21 metabase-2 metabase.sh[810]: 07-18 13:05:21 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

Jul 18 13:05:21 metabase-2 metabase.sh[810]: 07-18 13:05:21 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false

Jul 18 13:05:21 metabase-2 metabase.sh[810]: 07-18 13:05:21 INFO plugins.dependencies :: Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]

Jul 18 13:05:21 metabase-2 metabase.sh[810]: 07-18 13:05:21 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :presto...

Jul 18 13:05:21 metabase-2 metabase.sh[810]: 07-18 13:05:21 INFO driver.impl :: Registered driver :presto (parents: [:sql]) :truck:

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :googleanalytics...

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO driver.impl :: Registered driver :googleanalytics (parents: [:google]) :truck:

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :mongo...

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO driver.impl :: Registered driver :mongo :truck:

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :snowflake...

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO driver.impl :: Registered driver :snowflake (parents: [:sql-jdbc]) :truck:

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :sqlite...

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO driver.impl :: Registered driver :sqlite (parents: [:sql-jdbc]) :truck:

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) :truck:

Jul 18 13:05:22 metabase-2 metabase.sh[810]: Load driver :h2 took 73.0 ms

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) :truck:

Jul 18 13:05:22 metabase-2 metabase.sh[810]: Load driver :mysql took 71.6 ms

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 WARN metabase.db :: WARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres,

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO metabase.db :: Verifying h2 Database Connection ...

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO driver.impl :: Initializing driver :sql...

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO driver.impl :: Initializing driver :sql-jdbc...

Jul 18 13:05:22 metabase-2 metabase.sh[810]: 07-18 13:05:22 INFO driver.impl :: Initializing driver :h2...

Jul 18 13:05:24 metabase-2 metabase.sh[810]: 07-18 13:05:24 INFO metabase.db :: Successfully verified H2 1.4.197 (2018-03-18) application database connection. :white_check_mark:

Jul 18 13:05:24 metabase-2 metabase.sh[810]: 07-18 13:05:24 INFO metabase.db :: Running Database Migrations...

Jul 18 13:05:24 metabase-2 metabase.sh[810]: 07-18 13:05:24 INFO metabase.db :: Setting up Liquibase...

Jul 18 13:05:25 metabase-2 metabase.sh[810]: 07-18 13:05:25 INFO metabase.db :: Liquibase is ready.

Jul 18 13:05:25 metabase-2 metabase.sh[810]: 07-18 13:05:25 INFO db.liquibase :: Checking if Database has unrun migrations...

Jul 18 13:05:33 metabase-2 metabase.sh[810]: 07-18 13:05:33 INFO metabase.db :: Database Migrations Current ... :white_check_mark:

Jul 18 13:05:34 metabase-2 metabase.sh[810]: 07-18 13:05:34 INFO db.migrations :: Running all necessary data migrations, this may take a minute.

Jul 18 13:05:34 metabase-2 metabase.sh[810]: 07-18 13:05:34 INFO db.migrations :: Finished running data migrations.

Not sure if this is the issue, It was working before.

4

everything seems to be running without issues according to your logs... can you make sure you're pointing to the right URL and port?

5

Hi @Luiggi - thanks for looking at the logs, it took about 20 minutes until the site was actually reachable, but things seem to be working correctly now.

I have installed Metabase from an image on Digital Ocean and am wondering if there is a better way to install it with a local database. Are there any good tutorials on how to best set up that way.

Thanks

Mike

6

I strongly recommend you check out our documentation: https://www.metabase.com/docs/latest/operations-guide/installing-metabase.html

1 Like
7

Hi

Thanks for this. I have gone ahead and followed the directions for installation on debian and got the server up and working.

When i start the service I am getting the following error:

image
image1326×176 52.5 KB

However if i run the jar file manually metabase comes up and i am able to access it.

Some of my configuration files look like the following:
/etc/systemd/system/metabase.service

[Unit]

Description=Metabase server
After=syslog.target
After=network.target
[Service]
WorkingDirectory=/opt/metabase/
ExecStart=/usr/bin/java -jar /opt/metabase/
EnvironmentFile=/etc/default/metabase
User=metabase
Type=simple
StandardOutput=syslog
StandardError=syslog
SyslogIdentifier=metabase
SuccessExitStatus=143
TimeoutStopSec=120
Restart=always
[Install]
WantedBy=multi-user.target

/etc/default/metabase

MB_PASSWORD_COMPLEXITY=normal
MB_PASSWORD_LENGTH=10
MB_JETTY_HOST=127.0.0.1
MB_JETTY_PORT=12345
MB_DB_TYPE=mysql
MB_DB_DBNAME=metabase
MB_DB_PORT=3306
MB_DB_USER=metabase_user
MB_DB_PASS=MYPASSWORD
MB_DB_HOST=localhost
MB_EMOJI_IN_LOGS=true

The top of my /etc/nginx/confd/default.conf file looks like :slight_smile:

image
image1326×528 84.7 KB

Have i configured something incorrectly ?

8

After actually doing some reading of the error message I went and found me error in this line, I had not added metabase.jar at the end.

Now I run the service and it is up and running, however when i go to the url I get site is unreachable.

I suspect it is something to do with my nginx configuration, so hoping to get some direction here.

9

Check out Nginx confs in this thread: Nginx reverse proxy woes

10

ok finally I got things nearly working. The service is now working and I am able to access the instance however not through nginx.

My error was in the metabase conf file MB_JETTY_HOST=127.0.0.1 was incorrect, once I changed this to my IP it worked.

I also finally found the logs to go through /var/log/metabase.log which helped alot.

Now I think all i need to do is get nginx conf file sorted and I am good.

Thank you for the patience and support!