DevLeoko / AdvancedBan

AdvancedBan is a Spigot plugin to manage punishments on single servers and server networks
GNU General Public License v3.0
155 stars 128 forks source link

Hey, i cant register my account on Banpanel.net. #87

Closed louis-hstn closed 7 years ago

louis-hstn commented 7 years ago

Hey, i cant register me because he cant connect to the Database. I tipped all Information right and it wont work!

jsuarezl commented 7 years ago

Did you checked if the sql port is open to external connections?

louis-hstn commented 7 years ago

Where i can do it?

ItzSomebody commented 7 years ago

Are you using IPTables?

louis-hstn commented 7 years ago

Its on My Debian V-Server with Mysql and phpmyadmin

2017-06-02 6:19 GMT+02:00 ItzSomebody notifications@github.com:

Are you using IPTables?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/DevLeoko/AdvancedBan/issues/87#issuecomment-305685390, or mute the thread https://github.com/notifications/unsubscribe-auth/AbwfDs4w1q5iTwd6fhj1htTokAtD9gL3ks5r_405gaJpZM4NsGy- .

jsuarezl commented 7 years ago

If you are using some firewall you need to allow connections to the MySQL port that by default is 3306, but may be your problem is that the MySQL server is binded to 127.0.0.1 to allow only internal connections, to bind it to the public IP address find the my.cnf file /etc/mysql/ and change the following line bind-address = 127.0.0.1 to #bind-address = 127.0.0.1

DevLeoko commented 7 years ago

@TunikaGruss if you don't reply to this issue within 48 hours it will be closed

louis-hstn commented 7 years ago

How can i restart MYsql?

DevLeoko commented 7 years ago

Google is your best friend ;) http://lmgtfy.com/?q=restart+mysql First link: https://coolestguidesontheplanet.com/start-stop-mysql-from-the-command-line-terminal-osx-linux/

louis-hstn commented 7 years ago

The MySQL-Data are not valid! Failed: Host 'at-viex-inx-r16.ha184092.xenox.systems' is not allowed to connect to this MySQL server

2017-06-09 18:48 GMT+02:00 DevLeoko notifications@github.com:

Google is your best friend ;) http://lmgtfy.com/?q=restart+mysql First link: https://coolestguidesontheplanet.com/ start-stop-mysql-from-the-command-line-terminal-osx-linux/

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/DevLeoko/AdvancedBan/issues/87#issuecomment-307441030, or mute the thread https://github.com/notifications/unsubscribe-auth/AbwfDqj5H0ljHWYCezr9JAKzXRrvHYplks5sCXdvgaJpZM4NsGy- .

louis-hstn commented 7 years ago

In The Mysql permissions there is no at-viex...

2017-06-09 20:43 GMT+02:00 TunikaGruss tunikagruss@gmail.com:

The MySQL-Data are not valid! Failed: Host 'at-viex-inx-r16.ha184092.xenox.systems' is not allowed to connect to this MySQL server

2017-06-09 18:48 GMT+02:00 DevLeoko notifications@github.com:

Google is your best friend ;) http://lmgtfy.com/?q=restart+mysql First link: https://coolestguidesontheplanet.com/start-stop-mysql-from- the-command-line-terminal-osx-linux/

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/DevLeoko/AdvancedBan/issues/87#issuecomment-307441030, or mute the thread https://github.com/notifications/unsubscribe-auth/AbwfDqj5H0ljHWYCezr9JAKzXRrvHYplks5sCXdvgaJpZM4NsGy- .

DevLeoko commented 7 years ago

Did you try what @Beelzebu told you to do above?

louis-hstn commented 7 years ago

Its on my V-Server i dont know where to disable the Port in the Host Firewall!

DevLeoko commented 7 years ago

find the my.cnf file /etc/mysql/ and change the following line bind-address = 127.0.0.1 to

bind-address = 127.0.0.1

louis-hstn commented 7 years ago

I did this.

The MySQL-Data are not valid! Failed: Host 'at-viex-inx-r16.ha184092.xenox.systems' is not allowed to connect to this MySQL server

2017-06-10 14:12 GMT+02:00 DevLeoko notifications@github.com:

find the my.cnf file /etc/mysql/ and change the following line bind-address = 127.0.0.1 to

bind-address = 127.0.0.1

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/DevLeoko/AdvancedBan/issues/87#issuecomment-307561525, or mute the thread https://github.com/notifications/unsubscribe-auth/AbwfDvVg8DCzf87EqIe1ju2xFnym8yzfks5sCogRgaJpZM4NsGy- .

DevLeoko commented 7 years ago

Here is a detailed instruction how to make MySQL available for remote connections: https://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

ItzSomebody commented 7 years ago

Is the port open?

DrFallen commented 7 years ago

Hi I'm trying to register but it comes up AdvancedBan tables not found is there something I need to download first? If so I can't find it in the post.

Edit: Never mind. Any idea when the verification email will come through? I'm checking both folders.

DevLeoko commented 7 years ago

should not take longer than a few minutes. Otherwise, you may have misspelled your email address

DevLeoko commented 7 years ago

@TunikaGruss if you don't reply to this issue within 48 hours it will be closed