{"id":227,"date":"2025-07-10T18:43:24","date_gmt":"2025-07-10T11:43:24","guid":{"rendered":"http:\/\/nitirat.ddns.net\/wordpress\/?p=227"},"modified":"2025-07-10T18:43:37","modified_gmt":"2025-07-10T11:43:37","slug":"metabase-installation-and-troubleshooting-guide-ubuntu-20-04","status":"publish","type":"post","link":"http:\/\/nitirat.ddns.net\/wordpress\/?p=227","title":{"rendered":"Metabase Installation and Troubleshooting Guide (Ubuntu 20.04)"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">1. Installation (Standalone JAR)<\/h1>\n\n\n\n<p><br>1. Update System:<br>&nbsp;&nbsp;&nbsp; sudo apt update &amp;&amp; sudo apt upgrade -y<br><br>2. Install Java (OpenJDK 21 recommended):<br>&nbsp;&nbsp;&nbsp; sudo apt install openjdk-21-jre -y<br>&nbsp;&nbsp;&nbsp; java -version<br><br>3. Create Metabase user:<br>&nbsp;&nbsp;&nbsp; sudo useradd -r -s \/bin\/false metabase<br><br>4. Download Metabase JAR:<br>&nbsp;&nbsp;&nbsp; cd \/opt<br>&nbsp;&nbsp;&nbsp; sudo mkdir metabase<br>&nbsp;&nbsp;&nbsp; sudo chown $USER metabase<br>&nbsp;&nbsp;&nbsp; cd metabase<br>&nbsp;&nbsp;&nbsp; wget https:\/\/downloads.metabase.com\/v0.48.4\/metabase.jar<br><br>5. Set Permissions:<br>&nbsp;&nbsp;&nbsp; sudo chown -R metabase:metabase \/opt\/metabase<br><br>6. Create Systemd Service:<br>&nbsp;&nbsp;&nbsp; sudo nano \/etc\/systemd\/system\/metabase.service<br><br>Paste the following:<br>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br>[Unit]<br>Description=Metabase server<br>After=syslog.target<br>After=network.target<br><br>[Service]<br>WorkingDirectory=\/opt\/metabase<br>ExecStart=\/usr\/bin\/java -jar \/opt\/metabase\/metabase.jar<br>User=metabase<br>Type=simple<br>Restart=always<br>StandardOutput=syslog<br>StandardError=syslog<br>SyslogIdentifier=metabase<br><br>[Install]<br>WantedBy=multi-user.target<br>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br><br>7. Enable and Start Service:<br>&nbsp;&nbsp;&nbsp; sudo systemctl daemon-reexec<br>&nbsp;&nbsp;&nbsp; sudo systemctl daemon-reload<br>&nbsp;&nbsp;&nbsp; sudo systemctl enable metabase<br>&nbsp;&nbsp;&nbsp; sudo systemctl start metabase<br><br>8. Open Firewall Port:<br>&nbsp;&nbsp;&nbsp; sudo ufw allow 3000<br><br>9. Access Metabase:<br>&nbsp;&nbsp;&nbsp; http:\/\/your_server_ip:3000<br><br><\/p>\n\n\n\n<h1 class=\"wp-block-heading\">2. Troubleshooting<\/h1>\n\n\n\n<p><br>If Metabase is not accessible, follow these steps:<br><br>1. Check if the service is running:<br>&nbsp;&nbsp;&nbsp; sudo systemctl status metabase<br><br>2. Check logs for errors:<br>&nbsp;&nbsp;&nbsp; sudo journalctl -u metabase -b &#8211;no-pager<br><br>3. Confirm port 3000 is open and listening:<br>&nbsp;&nbsp;&nbsp; sudo ss -tuln | grep 3000<br><br>4. Confirm firewall allows port 3000:<br>&nbsp;&nbsp;&nbsp; sudo ufw status<br><br>5. Manually run the JAR to test:<br>&nbsp;&nbsp;&nbsp; cd \/opt\/metabase<br>&nbsp;&nbsp;&nbsp; java -jar metabase.jar<br><br>6. If you see &#8216;NoClassDefFoundError: java\/util\/SequencedCollection&#8217;:<br>&nbsp;&nbsp;&nbsp; &#8211; Switch to Java 21:<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;sudo apt install openjdk-21-jre -y<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sudo update-alternatives &#8211;config java<br><br>7. Test from the server:<br>&nbsp;&nbsp;&nbsp; curl http:\/\/localhost:3000<br><br>8. If all else fails, use Docker:<br>&nbsp;&nbsp;&nbsp; sudo apt install docker.io -y<br>&nbsp;&nbsp;&nbsp; sudo systemctl start docker<br>&nbsp;&nbsp;&nbsp; docker run -d -p 3000:3000 &#8211;name metabase metabase\/metabase<br><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Installation (Standalone JAR) 1. Update System:&nbsp;&nbsp;&nbsp; sudo apt update &amp;&amp; sudo apt upgrade -y 2. Install Java (OpenJDK 21 recommended):&nbsp;&nbsp;&nbsp; sudo apt install openjdk-21-jre -y&nbsp;&nbsp;&nbsp; java -version 3. Create Metabase user:&nbsp;&nbsp;&nbsp; sudo useradd -r -s \/bin\/false metabase 4. Download Metabase JAR:&nbsp;&nbsp;&nbsp; cd \/opt&nbsp;&nbsp;&nbsp; sudo mkdir metabase&nbsp;&nbsp;&nbsp; sudo chown $USER metabase&nbsp;&nbsp;&nbsp; cd metabase&nbsp;&nbsp;&nbsp; wget https:\/\/downloads.metabase.com\/v0.48.4\/metabase.jar [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[6],"tags":[],"class_list":["post-227","post","type-post","status-publish","format-standard","hentry","category-ubuntu"],"_links":{"self":[{"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=227"}],"version-history":[{"count":1,"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/227\/revisions"}],"predecessor-version":[{"id":228,"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/227\/revisions\/228"}],"wp:attachment":[{"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=227"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nitirat.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}