EnhancedBanSystem

My rust server is hosted by Streamline servers.

In my server files there is no MySQL do I need them to install it for me?
At the moment MySQL, php, and apache are all on my C:/

So no, server is hosted by a provider, MySQL is on my pc

 

You've blanked out IP. That should be the address of a local machine...not your public IP.
Fwd port 3306 to 192.168.1.10, for example.

Your rust server will try to communicate with your public IP.
The router should then forward that request to the relevant local machine, see?

 

When port forwarding I launched cmd > typed ipconfig > used my IPv4 address, which is my local machine. Then went online and tested the port 3306, says it was open but still same error.

Did you want me to send you through screenshots of phpmyadmin and my configs?

 

If the port's open then it's most likely either a firewall or that your MySQL server isn't accepting connections from the rust server IP.
Follow Memesquad's advice on the previous page and if that doesn't work, add rules to your firewall, if applicable.

 

I already did what Memesquad said?

 

Oh, sorry. Missed that.
and firewalls?

 

I'm at uni at the moment, but I will do it when I get home... Hopefully that's the cause of the issue.

When I installed MySQL with the MSI I do remember it saiding that it excepted and created a exception through the firewall, but I'll check anyway just incase

 

Cool. Best to be sure.

It's also possible that you might need to create a firewall rule in your router.
That's how mine is - Need to create port forwarding rule + firewall rule.
On mine it doesn't actually say 'firewall'..I think it says 'Applications' or something like that.

Have a hoke and see what you see.

 

Awesome, thank you. Definitely will check both those possibility out and add the rules into both router / firewall.

Also just a quick question relating the 'PlayerDatabase' plugin: PlayerDatabase | Oxide

Do I need to do anything in terms of the External plugins: or Setting values? (Dunno if irreverent)

ERROR: (11:24:14) | MySql handle raised an exception (MySqlException: Unable to connect to any of the specified MySQL hosts.)

 

You don't need external plugins, did you go to What Is My IP Address? IP Address Tools and More and put your public IP in the host field in the EnhancedBanSystem config.

 

YES! It worked.
Thank you so much the both of you, really appreciate both of your help.

Photo of phpmyadmin:
http://i.imgur.com/KSuHolC.png

For others reading this thread and having the same issue follow these changes:

STEP 1: I changed my ip using the link MemeSquad provided and opened up both: EnhancedBanSystem.json and PlayerDatabase.json

STEP 2: I pasted in this ip I got from What Is My IP Address? IP Address Tools and More and pasted it in this line: "MySQL - Host": "whatismyipaddress",

STEP 3: I then went into PlayerDatabase.json and made sure this line was set to the corresponding setting:
"Data Type : 0 (Files) or 1 (SQLite) or 2 (MySQL)": 2, //is at top of config, set it to 2 if you are using phpmyadmin, default was at 1

STEP 4: Reloaded both PlayerDatabase.cs and EnhancedBanSystem.cs

If done correctly it should result in the following image link at the top of this comment.

*** May I just ask one more question ***
How would I be able to make a banlist page for my website? Do I need to make a api.php?

Thank you guys so much again,
iHYPERLITE

 

The issue here is that you had "host" as localhost when the rust server and the MySQL server are not on the same host. You do not need PlayerDatabase or any other plugin that you may think you need.

In order to display bans you need a php script, you need to connect to the database and use a query such as "SELECT * FROM EnhancedBanSystem" and have it displayed in table.

 

Sometimes i add ban for one player, ban and kick him, and automatically ban another player, where plugin show same IP, but in real have another ip address.

 

What php script would you recommend?

IN SQL TAB:
http://i.imgur.com/WN275wF.png

IN ENHANCEDBANSYSTEM:
http://i.imgur.com/FW6kmyW.png

Also what do I need to change in this command line to display in a table?

 

why plugin only kick people when i wrote /ban nick

 

You don't do anything more in PhpMyAdmin.
Once the data is getting there, that's that part done.

Your website needs php code that will interrogate the database then publish the data to html table.
Google 'php sql to html table' and you'll be tripping over people doing the same.

If you're stuck, fire me a PM.

 

Hi Reneb,
Sorry, I'm not sure what that means?
Does that number represent a date/time or a duration, and is it meant to count down?

Edit : This may help

Code:

ERROR:Number overflow
MySQL: Successfully added 7656***** - Name - Reason - Temporary: 3599.29200005531s) to the banlist.

 

Never mind - All is good.
Got it figured out with some help.

Thanks anyway.

 

For some reason I can not /ban anyone, they just get kicks with the reason "Banned"

I check permissions and quite confused.

Any help would be great!

LeRoy*

 

What is your config?