Database server not even recognized? about plan HOT 10 CLOSED

The mysql user may lack privileges to the specific database

from plan.

Hello! It may seems like a misconfiguration, but the database user have full access, so there shouldn't be any privilege error.

Note I also tried using the same credentials on another plugin and it seems like there's no problem, but when I try to use it with plan it just refuses to work.

And also tried swapping IP too and didn't help, thanks!

from plan.

If you use public IP address you need to grant privileges to external IP addresses since the traffic will route outside the machine before it reaches mysql. This may help https://pterodactyl.io/tutorials/mysql_setup.html#allowing-external-database-access

Please also make sure that a database used in Database.Mysql.Database setting exists and the privileges have been granted for that database. Other plug-ins may work if they're using a different database name.

from plan.

Also check that the mysql port is open on the firewall and reachable with same details as in Plan config from your own machine. You can do this with a client like HeidiSQL

from plan.

Hello! I perfectly tested it with mysql workbench and its accessible, the database user is % so it should be accessible, and mariadb is already on port 0.0.0.0, also do please note that PLAN (and another one) is the only plugin having this issue.

from plan.

Could you send a screenshot of the database list in your mysql, the database name from the Plan config, and screenshot of mysql workbench users and privileges tab https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html

I am asking this since there are 2700 servers running Plan with mysql - the chances are that there is something in your setup that is unique which is causing the issue

from plan.

If it's not privileges it can be a networking issue, which is unlikely since you can access it through mysql workbecnch

from plan.

Yeah sure, I will update you tomorrow. Tho I was thinking of that as well, cuz I've setup plan multiple times before, the only thing different from previous times is I used linode instead of vultr, but I really don't think that should matter tho :(

from plan.

Is linode using kubernetes? That could add some extra networking that's needed if the minecraft pod is separate from the mysql pod

from plan.

Hey! Yep, i found the issue in the end, for some reason it is the IP being weird, asked linode support to swap it and now it turns out working again! 🤔

Oh well. Thanks tho!

from plan.