uMod - Can't get MySQL connection to work - Enhanced Ban System

Posted 6 years ago

Last updated 6 years ago

Morning Chaps,

My head is now starting to hurt

... I have now tried everything to get this plugin to connect to an external IP for the MySQL database but it will not work. It still only continues to try and connect to the IP the server is being run on.

Either I'm just doing something completely wrong, or perhaps the plugin is broken?

Please see the attached screenshot.

Posted 6 years ago

It's not a plugin, Its an user problem access to your sql server.

In the sql server setup, be sure that the bind address is set to : 0.0.0.0 and not to 127.0.0.1

If it's good, what's the username in your sql server ? 'u773974818_user'@'%' ?

Posted 6 years ago

Last updated 6 years ago

ESoTeRiC
It's not a plugin, Its an user problem access to your sql server.
In the sql server setup, be sure that the bind address is set to : 0.0.0.0 and not to 127.0.0.1
If it's good, what's the username in your sql server ? 'u773974818_user'@'%' ?

Thanks for the reply.

So the username in the DB is 'u773974818_user' and I have changed the IP to '194.59.164.***' which it should be.

However it's still somehow always finding the IP of the computer the server is running on if that makes sense.

No-where does it say 'localhost' or '92.3.37.***', this is the issue I am having.

CONFIG:

{
  "Ban - Broadcast": true,
  "Ban - Default Reason": "No Reason Given",
  "Ban - Evade": true,
  "Ban - Evade Reason": "Ban Evade",
  "Ban - Log": true,
  "DataType - Files - use": false,
  "DataType - MySQL - Database": "u773974818_bans",
  "DataType - MySQL - Host": "194.59.164.***",
  "DataType - MySQL - Pass": "****",
  "DataType - MySQL - Port": 3306,
  "DataType - MySQL - use": true,
  "DataType - MySQL - User": "u773974818_user",
  "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,
  "DiscordMessages - Discord Webhook": "https://support.discordapp.com/hc/en-us/articles/228383668-Intro-to-Webhooks",
  "DiscordMessages - Use Discord": false,
  "Kick - Broadcast": false,
  "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": "194.59.164.***:28015",
  "Server Info - Platform": "Steam"
}

Posted 6 years ago

Last updated 6 years ago

make in ssh "sudo nano /etc/mysql/my.cnf"

look -> bind-address = XXX.XXX.XXX.XXX

Be sure it's without #, for my self I put 0.0.0.0, coz I dont have an fixe IP to manage the database with DBeaver

Or sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

if u use mariaDB

Posted 6 years ago

Last updated 6 years ago

I'll be honest, I'm starting to give up now :D