Apache proxy with metabase

Get Help
1

Hi!

I have a server on Ubuntu 22.04 with installed MySQL, PhpMyAdmin and Metabase on it

The main task is to put all this on the domain.

I did proxying and installed SSL. Everything has moved except metabase.

Dancing with a tambourine did not lead to anything, I would be grateful for the help.

P.S. I installed Nginx. But since phpmyadmin runs Apache on port 80, they constantly conflict. Unfortunately, I can't delete or move smth.

Config file:

<VirtualHost *:80>
        ServerName dashboard.turnir2024.ru      
        ServerAdmin webmaster@localhost
        DocumentRoot /var/www/html

        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined

        <Location "/metabase/">
        ProxyPass "http://localhost:3000/"
        ProxyPassReverse "http://localhost:3000/"
        ProxyPreserveHost On
        </Location>
        
        <Location "/phpmyadmin/">
        ProxyPass "http://localhost/phpmyadmin/"
        ProxyPassReverse "http://localhost/phpmyadmin/"
        ProxyPreserveHost On
        </Location>

        RewriteEngine on
        RewriteCond %{SERVER_NAME} =dashboard.turnir2024.ru
        RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent]
</VirtualHost>

<VirtualHost *:80>
    ServerName 94.198.216.14

    DocumentRoot /var/www/html
    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined

    Alias /phpmyadmin /usr/share/phpmyadmin

    <Directory /usr/share/phpmyadmin>
        Options +FollowSymLinks
        DirectoryIndex index.php
        <IfModule mod_php5.c>
            AddType application/x-httpd-php .php

            php_flag magic_quotes_gpc Off
            php_flag track_vars On
            php_flag register_globals Off
            php_value include_path .
        </IfModule>
    </Directory>

    <Directory /usr/share/phpmyadmin/libraries>
        Order Deny,Allow
        Deny from All
    </Directory>

    <Directory /usr/share/phpmyadmin/setup/lib>
        Order Deny,Allow
        Deny from All
    </Directory>
</VirtualHost>

<VirtualHost *:443>
    ServerName dashboard.turnir2024.ru
    ServerAdmin webmaster@localhost
    DocumentRoot /var/www/html

    SSLEngine On
    SSLCertificateFile /etc/letsencrypt/live/dashboard.turnir2024.ru/fullchain.pem
    SSLCertificateKeyFile /etc/letsencrypt/live/dashboard.turnir2024.ru/privkey.pem
    SSLCertificateChainFile /etc/letsencrypt/live/dashboard.turnir2024.ru/chain.pem

    <Location "/metabase/">
        ProxyPass "http://localhost:3000/"
        ProxyPassReverse "http://localhost:3000/"
        ProxyPreserveHost On
    </Location>

    <Location "/phpmyadmin/">
        ProxyPass "http://localhost/phpmyadmin/"
        ProxyPassReverse "http://localhost/phpmyadmin/"
        ProxyPreserveHost On
    </Location>
</VirtualHost>