Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Feb 10, 2019 8:17:55 GMT
so here's the problem: i have a minecraft server that i run from the command line and everything works. httpd works, mysql connection for coreprotect works, and bukkittelnet works however, when i use pterodactyl, absolutely NONE of that works. the httpd doesn't work, bukkittelnet can't bind to a port, and mysql wont work for shit (even if pteroactyl made the database) what the fuck can i do because i have absolutely no clue how this headache inducing pile of crap panel works (possibly some relevant information?  also the bind address in the mysql settings doesn't work with 127.0.0.1 or 0.0.0.0 also something i noticed was how on the command line version it says Query started on *:25565 but on the pterodactyl one it says Query started on 0.0.0.0:25565 i tried editing the server properties for this but it reverts to 0.0.0.0 every time (and it's 0.0.0.0 on the command line also so i dont think thats the issue) btw in the image it says Connections From 127.0.0.1 I also tried % (allowing connections from anywhere) but that doesn't work either |
|
StevenNL2000
Forum Admin 
Posts: 6,415
| Likes: 6,936
IGN: StevenNL2000
Timezone: UTC+01:00
Member is Staff. Need immediate assistance? Send a PM
|
Post by StevenNL2000 on Feb 10, 2019 10:31:43 GMT
0.0.0.0 is the formal notation for "bind to everything you can". Does it work if you run Pterodactyl (the program itself) as root? You should't have to do that in production, but at least we'll know if it's a permission issue.
|
|
untuned
Veteran Member
I untune the tunes.
Posts: 588
| Likes: 283
|
Post by untuned on Feb 10, 2019 15:02:55 GMT
Here's what I did to fix the problem:
- comment out bind-address
- give the database master user (pterodactylFrontend) all permissions
- Set host to the public ip of the server
Worked for me, just sharing what I did. If that doesn't work, join the Pterodactyl discord.
|
|
falceso
Veteran Member
Back to being quiet on the forums.
Posts: 350
| Likes: 118
|
Post by falceso on Feb 10, 2019 16:59:56 GMT
however, when i use pterodactyl, absolutely NONE of that works. the httpd doesn't work, bukkittelnet can't bind to a port, and mysql wont work for shit (even if pteroactyl made the database) You must add the node ports then allocate the port to the server. Or mess with the iptables and allow the connections. In addition to the above guidance. Here's the mysql command for grant option permissions. GRANT ALL PRIVILEGES ON mydb.* TO 'USER'@'{host ,recommended to be %}' WITH GRANT OPTION;
Pterodactyl isn't trash, just need to learn how to use it  |
|
Lemon
Veteran Member
Insert status here.
Posts: 2,491
| Likes: 2,165
|
Post by Lemon on Feb 10, 2019 17:37:11 GMT
however, when i use pterodactyl, absolutely NONE of that works. the httpd doesn't work, bukkittelnet can't bind to a port, and mysql wont work for shit (even if pteroactyl made the database) You must add the node ports then allocate the port to the server. Or mess with the iptables and allow the connections. In addition to the above guidance. Here's the mysql command for grant option permissions. GRANT ALL PRIVILEGES ON mydb.* TO 'USER'@'{host ,recommended to be %}' WITH GRANT OPTION;
Pterodactyl isn't trash, just need to learn how to use it ;) if you actually need to learn how to use something that should be user-friendly that's kinda the definition of trash |
|
super
Veteran Member
Among Us
Posts: 1,282
|
Post by super on Feb 10, 2019 18:17:18 GMT
yeah like we didn't already know that
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Feb 10, 2019 19:34:20 GMT
however, when i use pterodactyl, absolutely NONE of that works. the httpd doesn't work, bukkittelnet can't bind to a port, and mysql wont work for shit (even if pteroactyl made the database) You must add the node ports then allocate the port to the server. Or mess with the iptables and allow the connections. In addition to the above guidance. Here's the mysql command for grant option permissions. GRANT ALL PRIVILEGES ON mydb.* TO 'USER'@'{host ,recommended to be %}' WITH GRANT OPTION;
Pterodactyl isn't trash, just need to learn how to use it I already granted pterodactylFrontend with all permissions, doesn't work |
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Feb 10, 2019 19:36:20 GMT
0.0.0.0 is the formal notation for "bind to everything you can". Does it work if you run Pterodactyl (the program itself) as root? You should't have to do that in production, but at least we'll know if it's a permission issue. I already am? I'm not exactly sure what you mean but I was using root accounts for everything until yesterday. It was still broken but I figured I'd tighten up security a bit |
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Feb 10, 2019 19:38:43 GMT
Here's what I did to fix the problem: - comment out bind-address - give the database master user (pterodactylFrontend) all permissions - Set host to the public ip of the server Worked for me, just sharing what I did. If that doesn't work, join the Pterodactyl discord. comment out bind address where? In the server.properties or in the SQL config file? Already tried with root which has all permissions I tried setting the host to the public IP (in the server.properties if that's what you mean) but it always reverts to 0.0.0.0 |
|
falceso
Veteran Member
Back to being quiet on the forums.
Posts: 350
| Likes: 118
|
Post by falceso on Feb 10, 2019 20:05:23 GMT
You must add the node ports then allocate the port to the server. Or mess with the iptables and allow the connections. In addition to the above guidance. Here's the mysql command for grant option permissions. GRANT ALL PRIVILEGES ON mydb.* TO 'USER'@'{host ,recommended to be %}' WITH GRANT OPTION;
Pterodactyl isn't trash, just need to learn how to use it if you actually need to learn how to use something that should be user-friendly that's kinda the definition of trash It's user-friendly for clients in a hosting environment as they don't really need to handle this besides opening a ticket. The reasoning behind blocking the ability to use any port would be for security sake, technically you can clear out the iptables if you wanted. As the documentation says on the getting started page:
I already granted pterodactylFrontend with all permissions, doesn't work I wrote a wonderful documentation in this thread reply but Cloudflare was being a dick and blocked it. Message me in Discord if you're using Ubuntu. |
|
