Remote database without local installation?

et.fz · August 24, 2023, 2:52pm

Hi,

I installed Hestia without any of the database systems, intending to use a remote database. When I try to add the remote database, however, I get the following error:

Error: DB_SYSTEM is not enabled

Is this because I did not install any database system? It seems unnecessary to install it locally when I’m not going to use the server.

As per another thread I tried adding DB_SYSTEM='mysql' to /usr/local/hestia/conf/hestia.conf, as well as installing mariadb-client and php-mysql, and it sort of works. The database is created, but not the user.

Is there any recommendation for this? Can/should I just install the database module, and then remove the local host using v-delete-database-host and uninstall the MariaDB server?

eris · August 24, 2023, 3:17pm

github.com

hestiacp/hestiacp/blob/671b44a1970526d90eced16b4348b887208d530f/func/db.sh#L269-L334


      
          add_mysql_database() {
          	mysql_connect $host
          
          	mysql_ver_sub=$(echo $mysql_ver | cut -d '.' -f1)
          	mysql_ver_sub_sub=$(echo $mysql_ver | cut -d '.' -f2)
          
          	query="CREATE DATABASE \`$database\` CHARACTER SET $charset"
          	mysql_query "$query"
          	check_result $? "Unable to create database $database"
          
          	if [ "$mysql_fork" = "mysql" ] && [ "$mysql_ver_sub" -ge 8 ]; then
          		query="CREATE USER \`$dbuser\`@\`%\`
                      IDENTIFIED BY '$dbpass'"
          		mysql_query "$query" > /dev/null
          
          		query="CREATE USER \`$dbuser\`@localhost
                      IDENTIFIED BY '$dbpass'"
          		mysql_query "$query" > /dev/null
          
          		query="GRANT ALL ON \`$database\`.* TO \`$dbuser\`@\`%\`"

This file has been truncated. show original

Can you add echo $mysql_ver on the next line after the mysql_connect call?

et.fz · August 25, 2023, 6:31am

10.11.3

Come to think of it, would simply installing php-mysql even work for all PHP versions with MultiPHP?

eris · August 25, 2023, 8:03am

Yes it should install the php packages of each version…

10.11.3 is the same version as the remote server?

et.fz · August 25, 2023, 9:29am

Alright.

Yeah, it is the same version. The two systems were installed at the same time.

I tried debugging that function, but I don’t see where the user is meant to be created? I can see the commands for when "$mysql_fork" = "mysql", but those are not included in the else case. Is that done somewhere else?

eris · August 25, 2023, 11:00am

github.com

hestiacp/hestiacp/blob/e910ab833d33b5ae0d53654006cb10c0e1410ed9/func/db.sh#L85-L91


      
          	mysql_ver=$(cat $mysql_out | tail -n1 | cut -f 1 -d -)
          	mysql_fork="mysql"
          	check_mysql_fork=$(grep "MariaDB" $mysql_out)
          	if [ "$check_mysql_fork" ]; then
          		mysql_fork="mariadb"
          	fi
          	rm -f $mysql_out

Can you chec what the output is for mysql

$mysql_out

et.fz · August 25, 2023, 11:18am

For cat $mysql_out:

VERSION()
10.11.3-MariaDB-1

et.fz · August 28, 2023, 2:34pm

I found out that I had not granted global database permissions to the user, only global system permissions, so it was authorized to create databases, but not grant access to them. Unfortunately, the Hestia commands seems to hide all SQL errors. Would be useful to have them.