DataBase creation error

TommyTran732 / Pterodactyl-Script

Installing Pterodactyl in just a few minutes!

Apache License 2.0

185 stars 56 forks source link

DataBase creation error #4

Closed B3ndik0208 closed 4 years ago

B3ndik0208 commented 4 years ago

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 commented 4 years ago

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.

LucidAPs commented 4 years ago

I am having the same problem unfortunately. Any solutions?

itsmemac commented 4 years ago

@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 commented 4 years ago

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

Wqrld commented 4 years ago

Will see if i can reproduce and patch this.

EDIT: reproduced and fixed in a PR.

TommyTran732 commented 4 years ago

Fixed in #8 and #9