search

mathhulk / advancedbans

Exhibit bans and other punishment types from your Minecraft server online using AdvancedBan.
https://mathhulk.me/advancedbans/example
MIT License
20 stars 27 forks source link

Cannot join to MySQL database - PDO Exception #50

Closed ghost closed 6 years ago

ghost commented 6 years ago

I installed the Panel, set up the language + set up the dB connection = Connection refused

But, i can connect from my PC with MySQL Workbench (Remote client)

Please help.

ghost commented 6 years ago

P.S: Remote clients are allowed, because i can join the Database, and edit it without problems.

ghost commented 6 years ago

P.S: I have PHP 7.2.8

winnipeg21 commented 6 years ago

Are you using remote MySQL connection for server to panel? Cause that's needed, it can't be local host unless you site and server are ran on the SAME server. Normally it's different servers.

ghost commented 6 years ago

Ehm....

Hosted on Awardspace

Connect to MySQL on GSP Europe (Gamehosting.cz)

ghost commented 6 years ago

It connected to MySQL, but the page not worked.

ghost commented 6 years ago

Page is working, but i need to insert that crap into page. Screenshot

ghost commented 6 years ago

But in code is nothing like MySQL query...

`<!DOCTYPE html>

"> VindeLand - Banlist

VindeLand - Banlist

Oficialní banlist pro server Vindeland.

Nick Důvod Admin Datum Expirace Typ Status
`
winnipeg21 commented 6 years ago

Use the latest ver of AB-web or the update before the current update. By looking at Awardspace web hosting it appears they don't offer remote mysql. May I ask where your server is hosted from and you website. If you are running both on the same VPS it should work. If you are running on different sites or different servers this also won't work. https://www.heliohost.org <-- that has remote mysql as it appears. If you are using a minecraft server host (ex: mcph) it will most likely come with remote mysql.

ghost commented 6 years ago

"Hello Sevenisko,

Thank you for contacting us.

Your outgoing connections are enabled so you should be able to connect to external servers. Please make sure that the external server is allowing connections to their databases from the outside.

Feel free to reopen this ticket in case you have more questions or you need further assistance. Thank you for choosing our services.

Best Regards, Anthony Thomson Dedicated Support Team Supportindeed.com"

They support remote connections

MC server hosted on Gamehosting.cz (Crew.sk/GSP Slovakia) - They supports remove connections

ghost commented 6 years ago

P.S: I can connect to MC MySQL server from my PC (MySQL Workbench) = Remote connection

mathhulk commented 6 years ago

Punishments and sorting are dealt with through the client and not the server. I looked into your issue and the problem is that http://banlist.vindeland.tk/punishments/ seems to be redirecting to http://vindeland.tk/500.html. This path is used to request the punishments from the server and, because the request cannot go through, the punishments are not listed on the page. I would suggest looking for an error report or log in the folder that AdvancedBan Panel was loaded into.

mathhulk commented 6 years ago

Apologies, I did not mean to close this issue.

ghost commented 6 years ago

Can i PM you FTP connection to banlist?

winnipeg21 commented 6 years ago

I recommend reinstalling ab-web. By looking at your banlist it looks messed up.

ghost commented 6 years ago

Reinstalled 3x = Not working

ghost commented 6 years ago
  1. JSON Files are not loading, because they cannot be opened...

somepath/file.json = somepath/.json - :/

That's not a fault of Webhosting, i had an PHP file with JSON files, and they worked.

ghost commented 6 years ago

For mathhulk - Can i solve that with you via mail?

Adress: seven9@vindeland.tk

winnipeg21 commented 6 years ago

Join his discord for faster response. Email is just to slow