{"id":12619,"date":"2023-04-25T06:00:13","date_gmt":"2023-04-25T10:00:13","guid":{"rendered":"https:\/\/blog.litespeedtech.com\/?p=12619"},"modified":"2023-04-25T06:00:13","modified_gmt":"2023-04-25T10:00:13","slug":"openlitespeed-metabase","status":"publish","type":"post","link":"https:\/\/lswp.store\/index.php\/2023\/04\/25\/openlitespeed-metabase\/","title":{"rendered":"OpenLiteSpeed + Metabase"},"content":{"rendered":"

\"OpenLiteSpeed<\/p>\n

OpenLiteSpeed Web Server<\/a> is great for building and deploying web applications. The WebAdmin Console enables you to quickly configure features that allow you to deliver a fast web application that your users will love.<\/p>\n

Metabase<\/a> is a business intelligence web application that can be deployed on an OpenLiteSpeed Web Server. It is a java-based web app that can connect to almost any database and has a built-in question builder tool that allows you to get intelligent insights on your data.<\/p>\n

OpenLiteSpeed and Metabase<\/h2>\n

In this guide, you will learn how to install and configure OpenLiteSpeed as a reverse proxy for Metabase. That means the web server will sit in front of Metabase and intercept requests made by clients. Upon completion of this guide you will have a business intelligence web based application powered by OpenLiteSpeed web server.<\/p>\n

Below are 7 steps covered in this tutorial:<\/p>\n

    \n
  1. Installing OpenLiteSpeed with MariaDB<\/li>\n
  2. Installing Java<\/li>\n
  3. Creating a MariaDB database<\/li>\n
  4. Downloading Metabase<\/li>\n
  5. Creating a systemd<\/code> configuration file for Metabase<\/li>\n
  6. Configuring a Let\u2019s Encrypt SSL Certificate<\/li>\n
  7. Completing the post-installation setup<\/li>\n<\/ol>\n

    Requirements<\/h2>\n

    Here is what you will need to complete this setup:<\/p>\n

      \n
    1. An SSH client such as Putty or the macOS terminal app.<\/li>\n
    2. A server running a Debian-based operating system such as Ubuntu Server<\/li>\n
    3. A fully qualified domain name pointing to the public IP address of your server.<\/li>\n<\/ol>\n

      Step 1: Install OpenLiteSpeed with MariaDB<\/h2>\n

      The first step is to install OpenLiteSpeed. We will use the 1-click installation script, which is a single command that will install OpenLiteSpeed, set up the virtualhost, add the reverse proxy configuration and install MariaDB.<\/p>\n

      On a newly deployed debian-based server, run the command below to install OpenLiteSpeed with a reverse proxy configuration:<\/p>\n

      bash <( curl -k https:\/\/raw.githubusercontent.com\/litespeedtech\/ols1clk\/master\/ols1clk.sh) --proxy-c --pure-mariadb\n<\/pre>\n
      This command will automatically create a reverse proxy configuration using the example virtualhost, and install MariaDB.<\/p>\n
      Log in to the OpenLiteSpeed WebAdminConsole. Click\u00a0Server Configuration\u00a0<\/b>>\u00a0External App.\u00a0<\/b><\/p>\n
      Click Edit<\/strong> on the Web Server<\/code> external app, update Address<\/strong> *<\/code> to http:\/\/127.0.0.1:3000<\/code>, and click Save<\/strong>.<\/p>\n
      Restart OpenLiteSpeed for the changes to take effect.<\/p>\n
      Step 2: Install Java<\/h2>\n
      The second step is to install the Java development kit (JDK), and the Java runtime environment (JRE). Run the command below to install:<\/p>\n
      sudo apt-get install openjdk-11-jdk openjdk-11-jre -y\n<\/pre>\n
      Step 3: Create a MariaDB database<\/h2>\n
      The third step is to create a MariaDB database for Metabase.<\/p>\n
      Run the commands below to connect to the MariaDB shell and create a new database:<\/p>\n
      \"\"<\/p>\n
      mysql -u root -p\nCREATE DATABASE metabasesysdb;\nGRANT ALL PRIVILEGES ON metabasesysdb.* TO 'metabase_db_usr'@'localhost' IDENTIFIED BY \"SecurePassword\";\nFLUSH PRIVILEGES;\nEXIT;\n<\/pre>\n
      Step 4: Download Metabase<\/h2>\n
      You have successfully installed OpenLiteSpeed and added reverse proxy configuration. Follow the next few steps to start using Metabase with OpenLiteSpeed.<\/p>\n
      Create a folder for Metabase in the \/opt<\/code> directory, and download the latest version of Metabase from the official download page:<\/p>\n
      sudo mkdir \/opt\/metabase\ncd \/opt\/metabase\nwget https:\/\/downloads.metabase.com\/v0.45.2\/metabase.jar\n<\/pre>\n
      Change the owner of the \/opt\/metabase<\/code> directory and all files in this directory to nobody<\/code> and nogroup<\/code> by running this command:<\/p>\n
      chown -R nobody:nogroup \/opt\/metabase\n<\/pre>\n
      Set the permissions of the \/opt\/metabase<\/code> directory and all files in the directory:<\/p>\n
      chmod -R 755 \/opt\/metabase\n<\/pre>\n
      Step 5: Create a systemd<\/code> configuration file.<\/h2>\n
      To ensure Metabase is always running on your server, and to simplify stopping and starting the business intelligence web app, you can create a systemd<\/code> configuration file. Run the commands below to create a service file in the \/etc\/systemd\/system<\/code> directory:<\/p>\n
      sudo apt install nano\nsudo nano \/etc\/systemd\/system\/metabase.service\n<\/pre>\n
      Edit the metabase.service<\/code> file, and copy and paste the following configuration below into it:<\/p>\n
      [Unit]\nDescription=Metabase Business Intelligence Web App Powered By OpenLiteSpeed Web Server\n[Service]\nWorkingDirectory=\/opt\/metabase\/\nExecStart=\/usr\/bin\/java -jar \/opt\/metabase\/metabase.jar\nUser=nobody\nType=simple\nRestart=on-failure\nRestartSec=10\n[Install]\nWantedBy=multi-user.target\n<\/pre>\n
      Save the file and exit out of it.<\/p>\n
      Reload the system daemon, start the Metabase service, and set it to start automatically at system boot:<\/p>\n
      systemctl daemon-reload\nsystemctl start metabase\nsystemctl enable metabase\n<\/pre>\n
      You also need to ensure the newly created metabase service is marked as active and running. Run the command<\/p>\n
      systemctl status metabase\n<\/pre>\n
      If Metabase is active and running, the command will return the following output:<\/p>\n
      \"\"<\/p>\n
      metabase.service - Metabase Business Intelligence Web App Powered By OpenLiteSpeed Web Server\n      Loaded: loaded (\/etc\/systemd\/system\/metabase.service;\n      Active: active (running)\n<\/pre>\n
      Step 6: Configure a Let’s Encrypt SSL Certificate.<\/h2>\n
      The next step is to configure a Let\u2019s Encrypt SSL Certificate. This ensures that you always access Metabase using a secure HTTPS connection. Follow the steps below:<\/p>\n
      Install the certbot utility:<\/p>\n
      sudo apt-get install certbot -y\n<\/pre>\n
      Generate the SSL certificate by following the instructions in the OpenLiteSpeed KB<\/a>.<\/p>\n
      Step 7: Complete the post installation setup<\/h2>\n
      Open a new browser window and enter the domain name for the metabase server in the browser address bar.<\/p>\n
      You will see the Metabase welcome page. Click Let\u2019s get started<\/strong>.<\/p>\n
      Choose your preferred language and click Next<\/strong><\/p>\n
      Enter your personal details and ensure you set a secure password. Click Next<\/strong>, select I\u2019ll add my data later<\/code> and click Next. <\/strong><\/p>\n
      Click Finish<\/strong>, and click Take me to Metabase<\/strong>. This will open the dashboard where you can perform business intelligence tasks using the builtin features.
      \n\"\"<\/p>\n
      You can also configure the database that you created on Step 3. Click Add your own data<\/strong> to open the Add Database<\/strong> wizard.<\/p>\n
      Select the type of database you would like to add on the Database type<\/strong> drop down, configure your database details, and click Save<\/strong><\/p>\n
      Conclusion<\/h2>\n
      You have successfully installed the Metabase Business Intelligence web app on an OpenLiteSpeed Web Server. For more details about OpenLiteSpeed features that you can configure to further enhance web app performance please visit our knowledge base<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Use OpenLiteSpeed and Metabase business intelligence software together, with OLS set up as a reverse proxy.<\/p>\n","protected":false},"author":1,"featured_media":12629,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[29],"tags":[185],"class_list":["post-12619","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-openlitespeed","tag-metabase"],"jetpack_featured_media_url":"https:\/\/lswp.store\/wp-content\/uploads\/2023\/04\/ols-metabase.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/posts\/12619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/comments?post=12619"}],"version-history":[{"count":0,"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/posts\/12619\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/media\/12629"}],"wp:attachment":[{"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/media?parent=12619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/categories?post=12619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lswp.store\/index.php\/wp-json\/wp\/v2\/tags?post=12619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}