Bans table not found
Retracker opened this issue ยท 14 comments
I keep starting the server with the plugin installed in it but in my website when i try to connect using mysql
it wont let me because this error shows up "Bans table not found" i keep triple checking the mysql info but its the same. Any ideas? im using the latest ban manager file in my 1.8.6 spigot server.
The mysql login credentials are on *nix based systems case sensitive. Make sure that there is no typo.
@EvilOlaf I copied and pasted the details like 3 times its impossible for them to be typed wrong, ;/
@confuser Yes it is disabled i dont really know why, i typed in mysql settings in the ban manager config yml file and in my website by frostcast. ;/ any ideas? Heres the console log of ban manager errors:
http://pastebin.com/zYvJrmwY
dude author if you help me fix this you dont know how much id appreciate it, you'll make my year! :)
Could not create connection to database server. Attempted reconnect 10 times. Giving up.
@confuser I'm sorry but i dont know what you mean... This is my first time using MySql with 000webhosting
You are attempting to access a MySQL database remotely. By default, MySQL refuses remote connections, this is what is covered in the FAQ. If you do not have the ability to grant new permissions to your database, you will need to contact 000webhosting and ask them to whitelist your minecraft server ip, so it is able to connect remotely.
BanManager creates the tables. Type /pl to see if BanManager is red, if it is, it disabled itself on startup, so check your logs.
@confuser ok now i changed my mysql host and got one from freemysqlhosting and now the plugins works on my server its not disabled its not red its in the color green and enabled and working like the commands work but when i use the mysql info on my frostcast web page it wont connect it still says
"Bans table not found" but still thanks for your help. Youre the best plugin author out there none have replied to my tickets of having trouble setting up their plugin, you are literally THE best!
http://pastebin.com/YfRd5uiP
thats my console server log all that i found that had to do anything with ban manager. There are noo errors in the console log at all.
The time on your server and MySQL database are out by 130 seconds, this may cause syncing issues.
On most network services it is important to have sync your time correctly. Either blame your mysql server host or minecraft server host to do their job properly.
Yes, they have to be the same.
The BanManager plugin writes your executed bans, warnings and so on into your database.
The webinterface reads the data from it and parses it into a human understandable way (to say a nice web site :P)
https://github.com/BanManagement/BanManager-WebUI/releases
Take this Web-UI. Works well with v5.6.0