learning this msqy stuff,

have 1 database with a connected bans plugin

attempted to make another following the info and it says it has connected to the database and then i get the following error

> o.reload PermissionGroupSync Unloaded plugin Permission Group Sync v2.1.1 by Apec [Permission Group Sync] Connected to Database myserver_database.
[Lone.Design Update Checker] PermissionGroupSync.cs was just loaded in, checking for updates...
Loaded plugin Permission Group Sync v2.1.1 by Apec
[Lone.Design Update Checker] is up to date.
MySql handle raised an exception in 'PermissionGroupSync v2.1.1' plugin (MySqlException: Unable to connect to any of the specified MySQL hosts.) at MySql.Data.MySqlClient.NativeDriver.Open () [0x00057] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at MySql.Data.MySqlClient.Driver.Open () [0x0000b] in <8d7380b3d3cf4bd8be324c584f371b44>:0 0b/s in, 0b/s out at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x0004d] in <8d7380b3d3cf4bd8be324c584f371b44>:0 at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0016c] in <8d7380b3d3cf4bd8be324c584f371b44>:0

Any ideas what it causing it, or even better how to fix it please?

been speaking to my server host the past few days and they have been scratching their heads and then come up with this:

 

On investigating this further, I am seeing the below being flagged in the firewall.

Jun 9 23:41:10 ******lfd[6***]: Port Scan detected from **.*.***.6 (GB/United Kingdom/***-20-b2-******-*****-cust***.vm44.*******.net). 21 hits in the last 45 seconds - Blocked in csf for 600 secs [PS_LIMIT]

This is causing a TEMPDENY for your IP Address.

This typically means the IP is being blocked for repeated connection or port scan attempts.

I am not 100% sure how your script works, is this attempting to make a single connection attempt to connect to the remote MYSQL database or is it potentially flooding it with attempts/requests?

I might need to get this escalated and double checked for you, but any additional information on how this works could be helpful.

"

 

Any ideas anyone?

Merged post

The ip address that the port scan is detected from is the ip of my server machine

Merged post

update:

Whilst waiting for my host to find a fix,  i installed mysql and php on a spare server i had,  was able to start it and then permissiongroupsync made the database ( like it says in docs )   then the plugin removed all the vips saying they wasnt in the database.  lukily i could copy and paste from rust console and edit and readd the vips.

So looks like my host has an issue, so i will close this and ask a different question