Can't create a database via the CLI

udder · December 26, 2021, 6:46am

root@hestia2:~# v-add-database traffic test43 kkfdsj43ifdsj2I
Error: mysql host EMPTY_DB_HOST doesn’t exist
Through the web control panel the base is created, but cli command doesn`t work

eris · December 26, 2021, 8:42am

Do you have mysql installed?

If not use v-add-database traffic test43 kkfdsj43ifdsj2I pgsql

udder · December 26, 2021, 10:06am

Of course Mysql is installed, I use mysql for Wordpress blogs

Hestia is 1.5.2
Debian 10.

I tried to create a base with the command “v-add-database traffic test43 kkfdsj43ifdsj2I pgsql” In response, a similar error

jlguerrero · December 26, 2021, 10:13am

You have just tried to add a posgres database

udder · December 26, 2021, 10:19am

Yes, I understand that. But I have no idea why it doesn’t work through the CLI

Raphael · December 26, 2021, 10:28am

looks like a bug, try v-add-database user dbname dbuser dbpass mysql localhost

the host seems to be mandatory.

github.com

hestiacp/hestiacp/blob/2c08075d395669281bd2048ea94fab953bf1455a/bin/v-add-database#L5

    
      
          #!/bin/bash
          # info: add database
          # options: USER DATABASE DBUSER DBPASS [TYPE] [HOST] [CHARSET]
          #
          # example: v-add-database admin wordpress_db matt qwerty123
          #
          # This function creates the database concatenating username and user_db.
          # Supported types of databases you can get using v-list-sys-config script.
          # If the host isn't stated and there are few hosts configured on the server,
          # then the host will be defined by one of three algorithms. "First" will choose
          # the first host in the list. "Random" will chose the host by a chance.
          # "Weight" will distribute new database through hosts evenly. Algorithm and
          # types of supported databases is designated in the main configuration file.
          
          
#----------------------------------------------------------#

udder · December 26, 2021, 10:40am

Wow!! That solved the problem, thank you, you’re the best! I wish you prosperity. Hestia is the best product for server and site management. I enjoy every day when working with the panel.

eris · December 26, 2021, 10:43am

v-add-database jaap database user password

Seems to work fine on my server for some reason…
get_next_dbhost should select the next host don’t know why it doesn’t work…

github.com

hestiacp/hestiacp/blob/2c08075d395669281bd2048ea94fab953bf1455a/bin/v-add-database#L54-L55

    
      
          is_object_new 'db' 'DB' "$database"
          get_next_dbhost

jlguerrero · December 26, 2021, 11:44am

Maybe his system is defaulting to a different host and therefore it won’t work if you do not specify the correct host

udder · December 26, 2021, 12:58pm

It used to work for me too, but I don’t know what action made it stop.

system · January 25, 2022, 12:59pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.