PHPMyAdmin 404 with remote DB server

mike.ohara · April 3, 2022, 5:32am

Trying to set up PHPmyadmin to connect to a remote MySQL server. I’ve installed phpmyadmin, and configured it to connect to the remote server, however when I visit panel.domain.tld/phpmyadmin I get a 404. I can’t seem to get around it.

Hestia Control Panel version:
v1.5.11
Ubuntu 20.04 (x86_64)

Any help appreciated.

eris · April 3, 2022, 7:35am

If mysql was enabled during install phpmyadmin might allready be installed in /usr/local/share/phpmyadmin and rules for it will get loading in /etc/apache2/ or /etc/nginx/

If the first thing has been happened:

github.com

hestiacp/hestiacp/blob/8faa6b8ba9d8d80838d0b7f1f153e04a4f377764/install/deb/phpmyadmin/pma.sh#L16-L43

    
      
          pmapath="/etc/phpmyadmin/conf.d/01-localhost.php"
          echo "<?php " >> $pmapath
          echo "\$cfg['Servers'][\$i]['host'] = 'localhost';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['port'] = '3306';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['favorite'] = 'pma__favorite';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['usergroups'] = 'pma__usergroups';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['central_columns'] = 'pma__central_columns';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['designer_settings'] = 'pma__designer_settings';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['export_templates'] = 'pma__export_templates';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['savedsearches'] = 'pma__savedsearches';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['navigationhiding'] = 'pma__navigationhiding';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['users'] = 'pma__users';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['usergroups'] = 'pma__usergroups';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['pmadb'] = 'phpmyadmin';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['controluser'] = 'pma';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['controlpass'] = '$PASS';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['bookmarktable'] = 'pma__bookmark';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['relation'] = 'pma__relation';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['userconfig'] = 'pma__userconfig';" >> $pmapath
          echo "\$cfg['Servers'][\$i]['table_info'] = 'pma__table_info';" >> $pmapath

This file has been truncated. show original

cp /etc/phpmyadmin/conf.d/01-localhost.php /etc/phpmyadmin/conf.d/02-server.php

And update the values should be enough

mike.ohara · April 3, 2022, 2:18pm

Thank you for the response.

The conf file didn’t exist, so I created it. still 404s.I double-checked the config locations for both Nginx, and apache and it exits in both. I am not sure which webserver engine is driving the 404. But it does seem like the actual configs are not being loaded. even though the files are present.

(I originally interspersed this with screenshots, but I am not allowed. So I have included them in an Imgur gallery PHPMYADMIN Woes - Album on Imgur

I hope this helps.

eris · April 3, 2022, 2:37pm

We use custom configs

github.com

hestiacp/hestiacp/blob/8faa6b8ba9d8d80838d0b7f1f153e04a4f377764/install/deb/apache2/apache2.conf#L83-L84

    
      
          IncludeOptional conf.d/*.conf
          IncludeOptional conf.d/domains/*.conf

So sites-enabled folder is never enabled.

mike.ohara · April 3, 2022, 3:25pm

thatispresent

That is also present on my server.

eris · April 3, 2022, 3:28pm

It is taken from the same file…

You need put the config files in conf.d … Otherwise it will never work…

mike.ohara · April 3, 2022, 3:28pm

so copy phpmyadmin.conf into conf.d?

mike.ohara · April 3, 2022, 3:33pm

ok! so doing that, the client domains /phpmyadmin started working. the main panel URL /phpmyadmin is not (which is the one linked from the Hestia UI.

eris · April 3, 2022, 3:36pm

main domain needs to be added as well to Hestia …

By default we have disabled http://ip/phpmyadmin/

mike.ohara · April 3, 2022, 3:37pm

it is, yep!

eris · April 3, 2022, 3:42pm

Then it should be the same as client.domain.com

I have no ideas why it doesn’t work…