[Bug] database remote failed

[Benzitczo]

Describe the bug

problem IP failed why no cant create database.

Tell us how to replicate the bug

1. add database host mysql done
2. now is okay worked success
3. create database host ip and "error connection ip failed"

check imagen:

Which components are affected by this bug?

Database (MariaDB, MySQL, PostgreSQL)

Hestia Control Panel Version

v1.8.11

Operating system

Ubuntu 22.04 (x86_64)

Log capture

problem failed error connection.

[jaapmarcus]

https://forum.hestiacp.com/t/remote-db-for-mariadb-mysql/13487/9

[Benzitczo]

https://forum.hestiacp.com/t/remote-db-for-mariadb-mysql/13487/9

I know, already have is okay worked IP 5003 port, connect worked fix "access denied". but no cant problem create database IP failed for hestiacp?.

and check up image create database server.

look:

[jaapmarcus]

It is trying to run the following command:

hestiacp/func/db.sh

Line 71 in 4990504

mysql --defaults-file=$mycnf -e 'SELECT VERSION()' > $mysql_out 2>&1

And it is failing you might need to try to run the command and see where it goes wrong.

Not a lot I can do without system access ..

[Benzitczo]

It is trying to run the following command:

hestiacp/func/db.sh

Line 71 in 4990504

mysql --defaults-file=$mycnf -e 'SELECT VERSION()' > $mysql_out 2>&1

And it is failing you might need to try to run the command and see where it goes wrong.

Not a lot I can do without system access ..

Ohh, ok and how is explain run command?

there is example mysql root and pass > use "--defaults-file=$mycnf -e 'SELECT VERSION()' > $mysql_out 2>&1" done right?

Or possible vps hestiacp > run commands > mysql --defaults-file=$mycnf -e 'SELECT VERSION()' > $mysql_out 2>&1 right?

but sorry i am no experts.

[Benzitczo]

Said experts help: solution success:

yep there is default mysql 3306 change 5003 worked.

there is /usr/local/hestia/conf