EnhancedBanSystem

Silly Questions...

Could this banlist be adaptable to SourceBans 2.0.0?

If anyone is willing to have this plugin adapt and work with SourceBans 2.0.0, I would greatly look forward to working with you. I'm willing to pay.

Yes I know it's for Source games, and that this is Unity, but it's a brilliant platform that I'd like to see expand.

 

Code:

13:27 [Error] Failed to call hook 'CanUserLogin' on plugin 'EnhancedBanSystem v5.0.9' (NullReferenceException: Object reference not set to an instance of an object)
13:27 [Stacktrace]   at Oxide.Plugins.EnhancedBanSystem.PlayerDatabase_IsBanned (System.String steamid, System.String ip, Oxide.Plugins.BanData& bandata) [0x00000] in <filename unknown>:0
  at Oxide.Plugins.EnhancedBanSystem.isBanned_NonDelayed (System.String name, System.String steamid, System.String ip, Boolean update, Oxide.Plugins.BanData& bandata) [0x00000] in <filename unknown>:0
  at Oxide.Plugins.EnhancedBanSystem.CanUserLogin (System.String name, System.String steamid, System.String ip) [0x00000] in <filename unknown>:0
  at Oxide.Plugins.EnhancedBanSystem.DirectCallHook (System.String name, System.Object& ret, System.Object[] args) [0x00000] in <filename unknown>:0
  at Oxide.Plugins.CSharpPlugin.InvokeMethod (HookMethod method, System.Object[] args) [0x00000] in <filename unknown>:0
  at Oxide.Core.Plugins.CSPlugin.OnCallHook (System.String name, System.Object[] args) [0x00000] in <filename unknown>:0 

 

Code:

12:46 [Info] ERROR:Object reference not set to an instance of an object

error when trying to unban the person

 

Plugin is abandoned my friend

 

what is the alternative?

 

I'm afraid there's none

 

I respect Reneb as the plugin developer, but this plugin is long overdue some updates. The main features of this plugin are only just working.

Is there a possibility to ask someone to take over this project?

 

MySql handle raised an exception in 'EnhancedBanSystem v5.0.9' plugin (MySqlException: Unable to connect to any of the specified MySQL hosts.)

I have created a database using phpmyadmin and have created a database called "banlist" and "playerdatabase".

In EnhancedBanSystem configs I have put the following: (Note all info matches the MySQL on phpmyadmin).

Code:

{
  "Ban - Broadcast": true,
  "Ban - Default Reason": "Banned",
  "Ban - Evade": true,
  "Ban - Evade Reason": "Ban Evade",
  "Ban - Log": true,
  "DataType - Files - use": false,
  "DataType - MySQL - Database": "banlist",
  "DataType - MySQL - Host": "localhost",
  "DataType - MySQL - Pass": "******",  //PASSWORD IS CORRECT
  "DataType - MySQL - Port": 3306,
  "DataType - MySQL - use": true,
  "DataType - MySQL - User": "root",
  "DataType - Native - use": false,
  "DataType - PlayerDatabase - IP Filename": "EnhancedBanSystem_IPs.json",
  "DataType - PlayerDatabase - use": false,
  "DataType - SQLite - Database Filename": "banlist.db",
  "DataType - SQLite - use": false,
  "DataType - WebAPI - Banlist": "http://webpage.com/banlist.php?startid={startid}",
  "DataType - WebAPI - Host": "http://webpage.com/api.php?action=ban&pass=mypassword&id={id}&steamid={steamid}&name={name}&ip={ip}&reason={reason}&source={source}&game={game}&platform={platform}&server={server}&tempban={expiration}",
  "DataType - WebAPI - IsBanned": "http://webpage.com/api.php?action=isbanned&pass=mypassword&id={id}&update={update}&steamid={steamid}&ip={ip}&time={time}&name={name}&game=Rust&server=rust.kortal.org:28015",
  "DataType - WebAPI - Unban": "http://webpage.com/api.php?action=unban&pass=mypassword&steamid={steamid}&name={name}&ip={ip}&name={name}&source={source}",
  "DataType - WebAPI - use": false,
  "Denied Connection - Log": true,
  "Kick - Broadcast": true,
  "Kick - Log": true,
  "Kick - On Ban": true,
  "Permissions - Ban": "enhancedbansystem.ban",
  "Permissions - Banlist": "enhancedbansystem.banlist",
  "Permissions - Kick": "enhancedbansystem.kick",
  "Permissions - Unban": "enhancedbansystem.unban",
  "Server Info - Game": "Rust",
  "Server Info - IP : PORT": "***:***", //PORT IS CORRECT
  "Server Info - Platform": "Steam"
}

Please help me as I'm pretty much stuck and want to make a api.php banlist on my website.

Regards,
iHYPERLITE

 

Are you running the MySQL server on the same host as the rust server?

 

Sorry I don't quiet understand what you mean exactly.

I downloaded the MySQL server MSI and installed that onto my computer so I could run the phpmyadmin along with php and Apache... Was I meant to use my server provider instead of running it off my computer? Example Streamline Servers?

Sorry I'm still learning all this, I do apologize.

 

Make sure that your server IP is configured for remote access with your MySQL provider.

With Gameservers the server-connect IP was no use. They provided me with another IP for this purpose.

Oh, our replies came in together.
Have you successfully connected anything to your local MySQL database, or has it never worked yet?
If it's never worked you may need to set up port forwarding to make it accessible to the outside world.

 

No it hasen't yet, no databases / tables have been automatically created except for the ones I manually created.
If this is the case what ports would I need to port forward? Would there be anything else I need to do?

Thank you for your help

 

Ok, sounds like forwarding is probably the issue.

In your router you'll need to set up a rule to forward port 3306 to the local IP of the local machine where your DB is hosted.
I'm not sure if it's UDP or TCP but you can set both and find out fairly easily.

It's also possible you may still need to put the external (rust server) IP on a remote-access allow list in your mySQL software.
I'm not 100% sure about that as I've never hosted MySQL locally, but it's usually the case with provided servers.

You may also need to set firewall rule for that port, if you have active firewalls.

Set the forwarding rule and test that first, though.

 

I uploaded the ports I forwarded, and pasted the direct ip as my ip, does this look correct?
http://i.imgur.com/PUXNPmo.png
[DOUBLEPOST=1493648257][/DOUBLEPOST](00:16:24) | EnhancedBanSystem was compiled successfully in 1743ms

(00:16:24) | Unloaded plugin EnhancedBanSystem v5.0.9 by Reneb

(00:16:24) | Loaded plugin EnhancedBanSystem v5.0.9 by Reneb

(00:16:24) | MySQL: Loaded

(00:16:26) | MySql handle raised an exception in 'EnhancedBanSystem v5.0.9' plugin (MySqlException: Unable to connect to any of the specified MySQL hosts.)

(00:17:06) | Unloaded plugin EnhancedBanSystem v5.0.9 by Reneb

(00:17:06) | Loaded plugin EnhancedBanSystem v5.0.9 by Reneb

(00:17:06) | MySQL: Loaded

(00:17:08) | MySql handle raised an exception in 'EnhancedBanSystem v5.0.9' plugin (MySqlException: Unable to connect to any of the specified MySQL hosts.)

Still same error occurs :/

 

Change the root permissions in MySQL to allow any hosts

Go to phpMyAdmin, user accounts, select the root account and change hostname to %

 

Okay:
http://i.imgur.com/MbRHK9U.png

Now what? I reload plugin still same issue do I need to change config

 

Make sure your firewall & router has the port open.

 

Yeah port 3306 UDP and TCP is open

 

Wait, is the rust server on the same machine as MySQL?