Atlantic.Net Blog

How to Install Metabase on CentOS 8

Hitesh Jethva
by Atlantic.Net (125posts) under VPS Hosting
0 Comments

Metabase is a free and open-source business intelligence tool that helps you to visualize large data sets without ever writing a single line of SQL. It is a powerful database lookup tool that comes with a web-based interface that makes it easier to search for data sets and display information. Metabase can be integrated with almost all types of databases and allows you to run queries on the database.

In this tutorial, we will explain how to install Metabase on CentOS 8.

Prerequisites

  • A fresh CentOS 8 VPS on the Atlantic.Net Cloud Platform
  • A root password configured on your server

Step 1 – Create an Atlantic.Net Cloud Server

First, log in to your Atlantic.Net Cloud Server. Create a new server, choosing CentOS 8 as the operating system with at least 2GB RAM. Connect to your Cloud Server via SSH and log in using the credentials highlighted at the top of the page.

Once you are logged in to your CentOS 8 server, run the following command to update your base system with the latest available packages.

dnf update -y

Step 2 – Install Java

Metabase is a Java-based application, so Java must be installed in your system. If not installed, you can install it by running the following command:

dnf install java-11-openjdk-devel -y

Once Java is installed, verify the installed version of Java with the following command:

java --version

You should get the following output:

Step 3 – Install and Configure MariaDB

Next, you will need to install the MariaDB server in your system. You can install it with the following command:

dnf install mariadb-server -y

Once installed, start the MariaDB service and enable it to start on system reboot with the following command:

systemctl start mariadb
systemctl enable mariadb

Next, log in to MariaDB with the following command:

mysql

Once logged in, create a database and user for Metabase with the following command:

create database metabasedb;
create user [email protected]'localhost' identified by 'password';

Next, grant all privileges to the Metabase with the following command:

grant all on metabasedb.* to [email protected]'localhost' with grant option;

Next, flush the privileges and exit from the MariaDB with the following command:

flush privileges;
exit

Step 4 – Download and Setup Metabase Installation Directory

Before starting, create a user and group for Metabase with the following command:

groupadd --system metabase
useradd --system -g metabase --no-create-home metabase

Next, create the necessary directories and files for Metabase:

mkdir -p /opt/metabase
touch /var/log/metabase.log
touch /etc/default/metabase

Next, change the ownership with the following command:

chown -R metabase:metabase /opt/metabase
chown metabase:metabase /var/log/metabase.log
chmod 640 /etc/default/metabase

Next, create a log file for Metabase with the following command:

nano /etc/rsyslog.d/metabase.conf

Add the following lines:

:msg,contains,"metabase" /var/log/metabase.log
& stop

Save and close the file, then restart the rsyslog service with the following command:

systemctl restart rsyslog

Next, change the directory to metabase and download the latest version of Metabase with the following command:

cd /opt/metabase
wget https://downloads.metabase.com/v0.36.2/metabase.jar

Next, change the ownership of the downloaded file to metabase with the following command:

chown -R metabase:metabase /opt/metabase

Step 5 – Create a System Service File for Metabase

Next, create a systemd service file to manage the Metabase service. You can create it with the following command:

nano /etc/systemd/system/metabase.service

Add the following lines:

[Unit]
Description=Metabase server
After=syslog.target
After=network.target

[Service]
WorkingDirectory=/opt/metabase/
ExecStart=/usr/bin/java -jar /opt/metabase/metabase.jar
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

Save and close the file, then reload the systemd daemon with the following command:

systemctl daemon-reload

Next, start the Metabase service and enable it to start at system reboot with the following command:

systemctl start metabase
systemctl enable metabase

You can now check the status of the Metabase service with the following command:

systemctl status metabase

You should get the following output:

Step 6 – Access Metabase Web Interface

At this point, Metabase is started and listening on port 3000. Now, open your web browser and access Metabase using the URL http://your-server-ip:3000. You should see the following page:

Click on the “Let’s get started“. You should see the following page:

Select your language and click on the Next button. You should see the following page:

Provide your full name, email address, and password and click on the Next button. You should see the following page:

Provide your database details and click on the Next button. You should see the following page:

Enable your “Usage data preferences” and click on the Next button. You should see the following page:

Provide your admin email address and click on the Take me to Metabase button. You should see the Metabase default dashboard in the following page:

Conclusion

In this guide, you learned how to install and configure Metabase on CentOS 8. You can now use the application for gleaning new insights from your dataset. You can visit the Metabase official documentation for more information. Try Metabase on VPS Hosting from Atlantic.Net using the tutorial above!

Get A Free To Use Cloud VPS

Free Tier Includes:
G3.2GB Cloud VPS Free to Use for One Year
50 GB of Block Storage Free to Use for One Year
50 GB of Snapshots Free to Use for One Year


Looking for a Hosting Solution?

We Provide Cloud, Dedicated, & Colocation.

  • Seven Global Data Center Locations.
  • Flexible Private, Public, & Hybrid Hosting.
  • 24x7x365 Security, Support, & Monitoring.
Contact Us Now! Med Tech Award FTC
SOC Audit HIPAA Audit HITECH Audit

Recent Posts

Get started with 12 months of free cloud VPS hosting

Free Tier includes:
G3.2GB Cloud VPS Server Free to Use for One Year
50 GB of Block Storage Free to Use for One Year
50 GB of Snapshots Free to Use for One Year


New York, NY

100 Delawanna Ave, Suite 1

Clifton, NJ 07014

United States

San Francisco, CA

2820 Northwestern Pkwy,

Santa Clara, CA 95051

United States

Dallas, TX

2323 Bryan Street,

Dallas, Texas 75201

United States

Ashburn, VA

1807 Michael Faraday Ct,

Reston, VA 20190

United States

Orlando, FL

440 W Kennedy Blvd, Suite 3

Orlando, FL 32810

United States

Toronto, Canada

20 Pullman Ct, Scarborough,

Ontario M1X 1E4

Canada

London, UK

14 Liverpool Road, Slough,

Berkshire SL1 4QZ

United Kingdom

Resources