Can't connect to MySQL server on '(MySQL IP)' (10061): Authentication failed

[gijs007]

I'm having random MySQL Authentication failed errors in my TCadmin monitor and service manager on my master server for the past few months.

 

Luis told me it was an issue with my MySQL server, but this doesn't seem to be the case as I've already done the following:

• Switch from MariaDB 10.1.22 to MySQL 5.7.18
  
• Using default configuration of MySQL/MariaDB
  
• Use a different node to host the MySQL server
  

Additionally the remotes can connect normally to this MySQL server with the same username and password. This issue is limited to the master server.

 

What happens? The control panel website on the master is unreliable. (Always at around the same time in the night for a couple of minutes at 04:30 and 04:50 )

The TCadmin monitor has to be restarted at least once a week to fix errors.

Since a few days the service manager is also affected, it starts up but crashes within 2-3 minutes.

 

We always see the following MySQL error:

System.Exception: Error connecting to MySQL server. Retrying in 2 seconds (9 of 10). ---> Can't connect to MySQL server on 'mysql.elitegameservers.net' (10061): Authentication failed.
  --- End of inner exception stack trace ---
  at System.Environment.get_StackTrace()
  at TCAdmin.DatabaseProviders.MySql.MySqlManager.?()
  at TCAdmin.DatabaseProviders.MySql.MySqlManager.Connect()
  at TCAdmin.SDK.Database.DatabaseManager.Execute(String sql)
  at TCAdmin.DatabaseProviders.MySql.MySqlManager.Execute(String sql)
  at TCAdmin.SDK.Objects.ObjectBase.Find()
  at TCAdmin.SDK.Objects.Server.Find()
  at TCAdmin.SDK.Objects.Server..ctor(Int32 serverId)
  at TCAdmin.SDK.MonitorConfiguration.get_ThisServer()
  at TCAdmin.SDK.UnhandledExceptionManager.?(Boolean ?)
  at TCAdmin.SDK.UnhandledExceptionManager.ExceptionToString(Exception objException)
  at TCAdmin.SDK.UnhandledExceptionManager.UnhandledExceptionHandler(Object sender, UnhandledExceptionEventArgs e)
  at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
  at System.IO.FileStream.WriteCore(Byte[] buffer, Int32 offset, Int32 count)
  at System.IO.FileStream.FlushWrite(Boolean calledFromFinalizer)
  at System.IO.FileStream.Flush()
  at IronPython.Runtime.PythonTextWriter.Flush()
  at IronPython.Runtime.PythonFile.FlushWorker()
  at IronPython.Runtime.PythonFile.Dispose(Boolean disposing)
  at IronPython.Runtime.PythonFile.Finalize()
TCAdmin.SDK.Database.DatabaseException: Can't connect to MySQL server on '(MySQL IP)' (10061): Authentication failed. ---> Can't connect to MySQL server on 'mysql.elitegameservers.net' (10061): Authentication failed.
  --- End of inner exception stack trace ---
  at TCAdmin.DatabaseProviders.MySql.MySqlManager.?()
  at TCAdmin.DatabaseProviders.MySql.MySqlManager.Connect()
  at TCAdmin.SDK.Database.DatabaseManager.Execute(String sql)
  at TCAdmin.DatabaseProviders.MySql.MySqlManager.Execute(String sql)
  at TCAdmin.SDK.Objects.ObjectBase.Find()
  at TCAdmin.SDK.Objects.Server.Find()
  at TCAdmin.SDK.Objects.Server..ctor(Int32 serverId)
  at TCAdmin.SDK.MonitorConfiguration.get_ThisServer()
  at TCAdmin.SDK.UnhandledExceptionManager.?(Boolean ?)
  at TCAdmin.SDK.UnhandledExceptionManager.ExceptionToString(Exception objException)
  at TCAdmin.SDK.UnhandledExceptionManager.UnhandledExceptionHandler(Object sender, UnhandledExceptionEventArgs e)

This error would indicate that the password or username is wrong, but this isn't the case. TCadmin is able to connect to this database with the same credentials, this error shows up randomly.

 

I really need to get it solved, but unfortunately Luis doesn't respond to these tickets

Has anyone experienced similar issues or know a solution?

 

I'm considering reinstalling/reconfiguring TCadmin, but I'm not sure how to do this on the master while keeping all the gameservers.

[Dennis]

Try using the IP instead of the hostname. It could be related to DNS issues.

[IGH]

Are you hosting the control panel on Windows? If it's always happening around the same time, it could be Windows Update. Unlikely, but worth checking.

 

P.S. if you're going to omit your MySQL server IP, you might also want to omit the hostname.

[Dennis]

P.S. if you're going to omit your MySQL server IP, you might also want to omit the hostname.

;D

[gijs007]

Are you hosting the control panel on Windows? If it's always happening around the same time, it could be Windows Update. Unlikely, but worth checking.

 

P.S. if you're going to omit your MySQL server IP, you might also want to omit the hostname.

Windows update doesn't restart the server twice every night

 

I used the local host IP 127.0.0.1

Later I switched to a domain name by using an external MySQL server, but this didn't resolve the problem.

[mouseymars]

Comment the bind-address line in your MySQL my.cnf then restart it, should fix your problem if you're using the default config.

[gijs007]

Apparently the random errors are caused by the "Protocol=SSL" parameter for database connections. But this only causes problems on the master.

 

According to Luis the master server doesn't need SSL for the MySQL connection. If the MySQL server ran on the same server and connected trough localhost there is indeed not really a need for SSL, however it doesn't run on the localhost at the moment.

 

The primary issue is that we can't enforce SSL for the MySQL user account, which is something which we wanted to enforce to harden the security of the backend.