To verify if the service is functioning, run the commands below to check it. ĮxecStart=/usr/bin/java -jar /opt/metabase/metabase.jarĪfter saving it, run the commands below to enable the service. Then copy the content below into the file and save it. To do that, simply run the commands below to create a service file. Sudo chown metabase:metabase /var/log/metabase.logĪfter that, you will also want to create a Metabase systemd service so you can control starting, stopping, and enabling its service. sudo chown -R metabase:metabase /opt/metabase Next, change the ownership of the /opt/metabase directory so the user can fully control the content. Sudo adduser -quiet -system -ingroup metabase -no-create-home -disabled-password metabase Simply run the commands below to create a username metabase and a group name. You’ll want to create dedicated user and group accounts to run Metabase effectively. At the time of this writing, the current version was 0.34.1.Īfter downloading, move the Metabase Java app to its new home directory at /opt/Metabase. FLUSH PRIVILEGES Īfter installing Java, run the commands below to download Metabase from its official package repository. GRANT ALL ON metabase.* TO ' WITH GRANT OPTION įinally, save your changes and exit. Then grant the user full access to the database. Then create a database called metabase CREATE DATABASE metabase Ĭreate a database user called metabaseuser with a new password CREATE USER ' IDENTIFIED BY ' new_password_here' To log on to the MariaDB database server, run the commands below. First, run the commands below to create a blank Metabase database. Now that you’ve installed all the packages required for Metabase to function continue below to start configuring the servers. The server was successfully installed if you see a similar screen. Once MariaDB is installed, run the commands below to test whether the database server was installed. Remove test database and access to it.Enter current password for root (enter for none): Just press the Enter.When prompted, answer the questions below by following the guide. Next, run the commands below to secure the database server with a root password if you were not prompted to do so during the installation. Run these on Ubuntu 18.10 and 18.04 LTS sudo systemctl stop rvice Run these on Ubuntu 16.04 LTS sudo systemctl stop rvice To install MariaDB run the commands below: sudo apt-get install mariadb-server mariadb-clientĪfter installing MariaDB, the commands below can stop, start and enable the MariaDB service to start up when the server boots. MariaDB is a great place to start if you’re looking for a truly open-source database server. Metabase also requires a database server to store its content. OpenJDK 64-Bit Server VM (build 11.0.5+10-post-Ubuntu-0ubuntu1.118.04, mixed mode, sharing) Install MariaDB Database Server You should see similar output as below: Output: To install the open-source version of Java, run the commands below: sudo apt updateĪfter installing Java, the commands below can be used to verify whether Java is installed. The open-source Java works great with Metabase. Metabase is written in Java, so you’ll need Java installed to run it. When you’re ready to install Metabase, follow the steps below: Install Java If you’re looking for a free, high-performance database lookup platform for your business, Metabase may just want you to want at your company.įor more about Metabase, please visit its homepage. Simply use its flexible GUI to look up data sets. It allows users to search through tables, then filter things down to find just what is needed without learning how to run SQL queries. This brief tutorial shows students and new users how to install Metabase on Ubuntu 18.04 | 16.04 server.įor those who don’t know, Metabase is a free, open-source platform that helps companies and businesses quickly summarize and visualize large data sets without ever writing a line of SQL. Following all steps carefully will ensure a successful installation. The installation process involves several steps including installing Java and MariaDB, configuring servers and user permissions, and setting up the Metabase database and service. Metabase is a free, open-source platform for summarizing and visualizing large data sets without SQL. This tutorial guides students and new users on how to install Metabase on Ubuntu 18.04 or 16.04 servers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |