Database

How to setup a remote database server

  1. It is assumed you already have your second server up and running
  2. On your Hestia Server run the following command
v-add-database-host mysql new-server.com root password

MySQL may be replaced by the PostgreSQL

  1. To make sure database has been added run following command
v-list-database-hosts

Why I can't use http://ip/phpmyadmin/

For security reasons we have decided to disable this option.

Please use https://host.domain.tld/phpmyadmin/

How can I enable access to http://ip/phpmyadmin/

For Apache2

nano /etc/apache2/conf.d/ip.conf

# And add the code before both </VirtualHost>
IncludeOptional /etc/apache2/conf.d/*.inc

# Restart apache2
systemctl restart apache2

# Or add in /etc/apache2.conf
IncludeOptional /etc/apache2/conf.d/*.inc

For Nginx

nano /etc/nginx/conf.d/ip.conf

# replace
location /phpmyadmin/ {
      alias /var/www/document_errors/;
      return 404;
  }
location /phppgadmin/ {
      alias /var/www/document_errors/;
      return 404;
  }

# with
include     /etc/nginx/conf.d/phpmyadmin.inc*;
include     /etc/nginx/conf.d/phppgadmin.inc*;

How can I connect from a remote location to the database

By default connections are disabled open port 3306 in the firewall. Open port 3306 in the firewall

Add Firewall rule

Then edit /etc/mysql/mariadb.conf.d/50-server.cnf

nano /etc/mysql/mariadb.conf.d/50-server.cnf

And set bind-address = 0.0.0.0 or bind-address = "your.server.ip.address"