[RiessDK]

Hello. (frist, sorry for my bad english)

For history:
Well, for just like one / two week ago, i have a game server 'talking' to my mysql server.
with no problems, it just works fine.

But for like 3-4 days ago. It just stop, (Could not start my server)
I was not sure why, game console say somthing about some plugins.
I try to disable some of the plugins, them and then my server works again.

But after not being able to get a proper answer from the logs and console.
I ended up having to reinstall my game server.

The problem is:
I'm trying to connect to remote MySQL, The MySQL driver is force to load.
I am doing this just to be safe it works, have some problem with that before.

Also, I have type my game server ip in the remote mysql connection. (Cpanel)
Also. tested it with "heidimysql" with my own ip, it works.

I have try to plugins to get a clear connection:

First plugin: mysqlt_bans.smx
second plugin: admin-sql-threaded.smx

Both say the same error in game conesole that is:
Could Not Connect to Database, error: [2003]: Can't connect to MySQL server on 'myprovider.com' (4)

I have tried me with a new created database and user.
Also, I have reinstalled 3 times.

I have try different version of SourceMod
First: 1.8.0 - 5981
second: 1.8.0 - 5967

Well now I'm lost, can't say why it will not make that connection.
It was before with no problem.

Hope some of you maybe, have a trick or can say something.

Best.
RiessDK

[OSWO]

did you comment out:

bind-address:127.0.0.1 in my.cnf

i have no clue if its a vps or a offered database.

[RiessDK]

Originally Posted by OSWO did you comment out: bind-address:127.0.0.1 in my.cnf i have no clue if its a vps or a offered database.

Both things are hosted outside, the are not on the same server.
That is also why i need to use the remote connection.

Also, my database is on a web-server. (like a webhotel service)

I don't understand what you mean with (bind-address:127.0.0.1 in my.cnf)

[micazoid]

Please show the errorlog what is mentioned in your screenshot.

Where is you gameserver at? OS? Dedicated Server or rented?

What Game is this for?

[RiessDK]

Originally Posted by micazoid Please show the errorlog what is mentioned in your screenshot. Where is you gameserver at? OS? Dedicated Server or rented? What Game is this for?

It is a rented CSGO server. And the error is in the title.

But here is the full code:

L 03/28/2017 - 14:21:33: Error log file session closed.
L 03/28/2017 - 23:50:06: SourceMod error session started
L 03/28/2017 - 23:50:06: Info (map "de_dust2") (file "errors_20170328.log")
L 03/28/2017 - 23:50:06: [mysqlt_bans.smx] [MYBans] Could Not Connect to Database, error: [2003]: Can't connect to MySQL server on 'hvid1.azehosting.net' (4)
L 03/28/2017 - 23:50:07: [SM] Exception reported: Script execution timed out
L 03/28/2017 - 23:50:07: [SM] Blaming: mysqlt_bans.smx
L 03/28/2017 - 23:50:07: [SM] Call stack trace:
L 03/28/2017 - 23:50:07: [SM]   [1] Line 18, /home/groups/alliedmodders/forums/files/5/8/2/6/8/115397.attach::OnPluginStart
L 03/28/2017 - 23:50:07: [SM] Unable to load plugin "mysqlt_bans.smx": Error detected in plugin startup (see error logs)

[micazoid]

Ask your host if he closed some ports. It worked, so the host has changed something

[OSWO]

https://gyazo.com/d18e46b34cebee69f89ce5d3721d6e1f

When it's commented out, it means the sql servers accepts all inbound requests.

[RiessDK]

Originally Posted by OSWO https://gyazo.com/d18e46b34cebee69f89ce5d3721d6e1f When it's commented out, it means the sql servers accepts all inbound requests.

Not sure i can't edit in that file, both my gameserver and my databasse.
Is hosted in a rented server. But if that not is the case. I will need a bit of more help please.

Originally Posted by micazoid https://gyazo.com/d18e46b34cebee69f89ce5d3721d6e1f Ask your host if he closed some ports. It worked, so the host has changed something

With one, the gameserver or the webhotel (there mysql databasse is)
Just to be sure.

[WildCard65]

Originally Posted by RiessDK Not sure i can't edit in that file, both my gameserver and my databasse. Is hosted in a rented server. But if that not is the case. I will need a bit of more help please. With one, the gameserver or the webhotel (there mysql databasse is) Just to be sure.

The mysql server's (on machine where database lives) config.

[RiessDK]

Originally Posted by WildCard65 The mysql server's (on machine where database lives) config.

Okay, but the MySQL is also an rented service. I am not sure i have access to that config.
Or any config at all.