DataBase creation error

[B3ndik0208]

There was an error while trying to connect to the host or while executing a query: "SQLSTATE[HY000] [2002] Connection refused (SQL: SELECT 1 FROM dual)" I get this when I try to add the database inside the panel after the script is finish installing

I press [1] on the firewall setup on both of them, its happends on ubuntu 18.04 and 20.04

[TommyTran732]

I can reproduce this bug. Seems like this is caused by the unix_socket_authentication on newer versions of MariaDB. I will attempt to fix this in the next couple of days.

[itsmemac]

@B3ndik0208 @LucidAPs try the steps below

• go to cd /etc/mysql/mariadb.conf.d
• and edit 50-server.cnf
• erase 127.0.0.1 and put 0.0.0.0
• save
• and restart mysql

Found this is Revenact Discord server months ago. It worked for me

[INfoUpgraders]

All that does is bind the IP to allow remote access, not bypass the firewall.

[Wqrld]

Will see if i can reproduce and patch this.

EDIT: reproduced and fixed in a PR.

[TommyTran732]

Fixed in #8 and #9