Failed MySQL

hello.. i try to setup the mysql access but got this.. can you help me please

MySql handle raised an exception in 'DatabaseStats v1.9.4' plugin [|70] (Authentication failed, see inner exception.)
   at MySqlStream MySql.Data.Common.Ssl.StartSSL(ref Stream baseStream, Encoding encoding, string connectionString)
   at void MySql.Data.MySqlClient.NativeDriver.Open()
   at void MySql.Data.MySqlClient.Driver.Open()
   at Driver MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at void MySql.Data.MySqlClient.MySqlConnection.Open()
   at bool Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle() in D:/a/Carbon/Carbon/Carbon.Core/Carbon.Components/Carbon.Common/src/Oxide/MySql/MySql.cs:line 220
  Inner exception:
  Mono.Security.Interface.TlsException: Handshake failed - error code: UNITYTLS_INTERNAL_ERROR, verify result: UNITYTLS_X509VERIFY_NOT_DONE
   at void Mono.Unity.Debug.CheckAndThrow(unitytls_errorstate errorState, unitytls_x509verify_result verifyResult, string context, AlertDescription defaultAlert)
   at bool Mono.Unity.UnityTlsContext.ProcessHandshake()
   at AsyncOperationStatus Mono.Net.Security.MobileAuthenticatedStream.ProcessHandshake(AsyncOperationStatus status, bool renegotiate)
   at AsyncOperationStatus Mono.Net.Security.AsyncHandshakeRequest.Run(AsyncOperationStatus status)
   at async Task Mono.Net.Security.AsyncProtocolRequest.ProcessOperation(CancellationToken cancellationToken)
MySql handle raised an exception in 'DatabaseStats v1.9.4' plugin [|70] (Authentication failed, see inner exception.)
   at MySqlStream MySql.Data.Common.Ssl.StartSSL(ref Stream baseStream, Encoding encoding, string connectionString)
   at void MySql.Data.MySqlClient.NativeDriver.Open()
   at void MySql.Data.MySqlClient.Driver.Open()
   at Driver MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at void MySql.Data.MySqlClient.MySqlConnection.Open()
   at bool Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle() in D:/a/Carbon/Carbon/Carbon.Core/Carbon.Components/Carbon.Common/src/Oxide/MySql/MySql.cs:line 220
  Inner exception:
  Mono.Security.Interface.TlsException: Handshake failed - error code: UNITYTLS_INTERNAL_ERROR, verify result: UNITYTLS_X509VERIFY_NOT_DONE
   at void Mono.Unity.Debug.CheckAndThrow(unitytls_errorstate errorState, unitytls_x509verify_result verifyResult, string context, AlertDescription defaultAlert)
   at bool Mono.Unity.UnityTlsContext.ProcessHandshake()
   at AsyncOperationStatus Mono.Net.Security.MobileAuthenticatedStream.ProcessHandshake(AsyncOperationStatus status, bool renegotiate)
   at AsyncOperationStatus Mono.Net.Security.AsyncHandshakeRequest.Run(AsyncOperationStatus status)
   at async Task Mono.Net.Security.AsyncProtocolRequest.ProcessOperation(CancellationToken cancellationToken)
MySql handle raised an exception in 'DatabaseStats v1.9.4' plugin [|70] (Authentication failed, see inner exception.)
   at MySqlStream MySql.Data.Common.Ssl.StartSSL(ref Stream baseStream, Encoding encoding, string connectionString)
   at void MySql.Data.MySqlClient.NativeDriver.Open()
   at void MySql.Data.MySqlClient.Driver.Open()
   at Driver MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at void MySql.Data.MySqlClient.MySqlConnection.Open()
   at bool Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle() in D:/a/Carbon/Carbon/Carbon.Core/Carbon.Components/Carbon.Common/src/Oxide/MySql/MySql.cs:line 220
  Inner exception:
  Mono.Security.Interface.TlsException: Handshake failed - error code: UNITYTLS_INTERNAL_ERROR, verify result: UNITYTLS_X509VERIFY_NOT_DONE
   at void Mono.Unity.Debug.CheckAndThrow(unitytls_errorstate errorState, unitytls_x509verify_result verifyResult, string context, AlertDescription defaultAlert)
   at bool Mono.Unity.UnityTlsContext.ProcessHandshake()
   at AsyncOperationStatus Mono.Net.Security.MobileAuthenticatedStream.ProcessHandshake(AsyncOperationStatus status, bool renegotiate)
   at AsyncOperationStatus Mono.Net.Security.AsyncHandshakeRequest.Run(AsyncOperationStatus status)
   at async Task Mono.Net.Security.AsyncProtocolRequest.ProcessOperation(CancellationToken cancellationToken)
MySql handle raised an exception in 'DatabaseStats v1.9.4' plugin [|70] (Authentication failed, see inner exception.)
   at MySqlStream MySql.Data.Common.Ssl.StartSSL(ref Stream baseStream, Encoding encoding, string connectionString)
   at void MySql.Data.MySqlClient.NativeDriver.Open()
   at void MySql.Data.MySqlClient.Driver.Open()
   at Driver MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at void MySql.Data.MySqlClient.MySqlConnection.Open()
   at bool Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle() in D:/a/Carbon/Carbon/Carbon.Core/Carbon.Components/Carbon.Common/src/Oxide/MySql/MySql.cs:line 220
  Inner exception:
  Mono.Security.Interface.TlsException: Handshake failed - error code: UNITYTLS_INTERNAL_ERROR, verify result: UNITYTLS_X509VERIFY_NOT_DONE
   at void Mono.Unity.Debug.CheckAndThrow(unitytls_errorstate errorState, unitytls_x509verify_result verifyResult, string context, AlertDescription defaultAlert)
   at bool Mono.Unity.UnityTlsContext.ProcessHandshake()
   at AsyncOperationStatus Mono.Net.Security.MobileAuthenticatedStream.ProcessHandshake(AsyncOperationStatus status, bool renegotiate)
   at AsyncOperationStatus Mono.Net.Security.AsyncHandshakeRequest.Run(AsyncOperationStatus status)
   at async Task Mono.Net.Security.AsyncProtocolRequest.ProcessOperation(CancellationToken cancellationToken)
MySql handle raised an exception in 'DatabaseStats v1.9.4' plugin [|70] (Authentication failed, see inner exception.)
   at MySqlStream MySql.Data.Common.Ssl.StartSSL(ref Stream baseStream, Encoding encoding, string connectionString)
   at void MySql.Data.MySqlClient.NativeDriver.Open()
   at void MySql.Data.MySqlClient.Driver.Open()
   at Driver MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at void MySql.Data.MySqlClient.MySqlConnection.Open()
   at bool Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle() in D:/a/Carbon/Carbon/Carbon.Core/Carbon.Components/Carbon.Common/src/Oxide/MySql/MySql.cs:line 220
  Inner exception:
  Mono.Security.Interface.TlsException: Handshake failed - error code: UNITYTLS_INTERNAL_ERROR, verify result: UNITYTLS_X509VERIFY_NOT_DONE
   at void Mono.Unity.Debug.CheckAndThrow(unitytls_errorstate errorState, unitytls_x509verify_result verifyResult, string context, AlertDescription defaultAlert)
   at bool Mono.Unity.UnityTlsContext.ProcessHandshake()
   at AsyncOperationStatus Mono.Net.Security.MobileAuthenticatedStream.ProcessHandshake(AsyncOperationStatus status, bool renegotiate)
   at AsyncOperationStatus Mono.Net.Security.AsyncHandshakeRequest.Run(AsyncOperationStatus status)
   at async Task Mono.Net.Security.AsyncProtocolRequest.ProcessOperation(CancellationToken cancellationToken)
MySql handle raised an exception in 'DatabaseStats v1.9.4' plugin [|70] (Authentication failed, see inner exception.)
   at MySqlStream MySql.Data.Common.Ssl.StartSSL(ref Stream baseStream, Encoding encoding, string connectionString)
   at void MySql.Data.MySqlClient.NativeDriver.Open()
   at void MySql.Data.MySqlClient.Driver.Open()
   at Driver MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at void MySql.Data.MySqlClient.MySqlConnection.Open()
   at bool Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle() in D:/a/Carbon/Carbon/Carbon.Core/Carbon.Components/Carbon.Common/src/Oxide/MySql/MySql.cs:line 220
  Inner exception:
  Mono.Security.Interface.TlsException: Handshake failed - error code: UNITYTLS_INTERNAL_ERROR, verify result: UNITYTLS_X509VERIFY_NOT_DONE
   at void Mono.Unity.Debug.CheckAndThrow(unitytls_errorstate errorState, unitytls_x509verify_result verifyResult, string context, AlertDescription defaultAlert)
   at bool Mono.Unity.UnityTlsContext.ProcessHandshake()
   at AsyncOperationStatus Mono.Net.Security.MobileAuthenticatedStream.ProcessHandshake(AsyncOperationStatus status, bool renegotiate)
   at AsyncOperationStatus Mono.Net.Security.AsyncHandshakeRequest.Run(AsyncOperationStatus status)
   at async Task Mono.Net.Security.AsyncProtocolRequest.ProcessOperation(CancellationToken cancellationToken)
Couldn't get columns. Database ruststats might be corrupted.
Couldn't get columns. Database ruststats might be corrupted.

you need to add the colum to your plugin as guide.. a newby like me cant start this plugin

Are you using ssl certificate on the Mysql server? If so, disable it. Can you connect to the Mysql server with another client, such as PHPMyAdmin or Navicat? What version of Mysql do you have?

1. How can i disable this certificate?
2. I use my MySQL for an Ark Server.. Everything works fine.
3. I hope you can see the MySQL version on the attached file/screenshot

Please tell me more about the colums. So i cant create a table for my db without something like a guide.

You need to use MySQL or MariaDB, HidiSQL is a client? I can not see the version in the photo. Tables will generated automatically, you only need to create a database.

To disable ssl you need to edit the mysql config from server (my.ini/my.cng) and set the:

ssl=0

skip_ssl

8 hours ago, dFxPhoeniX said:

You need to use MySQL or MariaDB, HidiSQL is a client? I can not see the version in the photo. Tables will generated automatically, you only need to create a database.

yes i already use HidiSQL and i use the following config.. if i run the server with this config he doesnt create a new table with some colums

8 hours ago, dFxPhoeniX said:

To disable ssl you need to edit the mysql config from server (my.ini/my.cng) and set the:

ssl=0

skip_ssl

i cant find this folder where the server is installed

youe se.. nothing is in here

As I said, the plugin can't connect to the database because of that authentication error, so it's normal that it didn't create your tables. Use another mysql database or give me more details. The plugin is tested on MySql 5.7 and 8.0, as well as on Mariadb 11 and it works. Make sure that the certificate you are using is correct, repair the database, the error states that it could be corrupted. Also make sure you use the old authentification plugin on the server, if you use recent versions.

The old auth plugin is mysql_native_password, make sure you don't use caching_sha2_password.

Anyway, the problem is related to the ssl certificate, most likely. run in mysql server SHOW VARIABLES LIKE '%ssl%'; to see if you have ssl enabled.

1 hour ago, dFxPhoeniX said:

As I said, the plugin can't connect to the database because of that authentication error, so it's normal that it didn't create your tables. Use another mysql database or give me more details. The plugin is tested on MySql 5.7 and 8.0, as well as on Mariadb 11 and it works. Make sure that the certificate you are using is correct, repair the database, the error states that it could be corrupted. Also make sure you use the old authentification plugin on the server, if you use recent versions.

The old auth plugin is mysql_native_password, make sure you don't use caching_sha2_password.

Anyway, the problem is related to the ssl certificate, most likely. run in mysql server SHOW VARIABLES LIKE '%ssl%'; to see if you have ssl enabled.

thats my current setup

which kind of informations do you need the help me figure the problem?

btw. he dont use a ssl connection

hello?

What you show me there are the settings from the client you use for the certificate, the settings from the server you can find in the server configuration, where I said, in the my.cnf file.

I told you, I need more details, the mysql version, as well as what the configuration looks like to be able to figure out what is not working.

here.. thats the my.ini.. i dont have a my.cnf file only the my.ini

1 hour ago, dFxPhoeniX said:

What you show me there are the settings from the client you use for the certificate, the settings from the server you can find in the server configuration, where I said, in the my.cnf file.

I told you, I need more details, the mysql version, as well as what the configuration looks like to be able to figure out what is not working.

what I don't understand is why you wanted to see the content, because there isn't much in there.. I have a whole ark server network and every second file has to be connected to the database. As soon as I buy rust plugins with a database connection, it doesn't work.. either it's a general problem or it's the plugin

Yeah, you have .ini because you have the server on Windows, not on Linux.

is that all you have in this file? what other files do you have?

The plugin only uses the mysql oxide library to connect, but does not support ssl, and the authentication plugin is the old one, because of library. Most likely the problem is with the server, as I said. Try to change the authentication plugin and put the ssl code that I gave you in the mysql config, then restart.

That version of mariadb that you have should work fine.

you mean: 

ssl=0
skip_ssl
like the one from my screenshot right?

so from where can i get the newest authentication plugin version?

18 minutes ago, dFxPhoeniX said:

Yeah, you have .ini because you have the server on Windows, not on Linux.

is that all you have in this file? what other files do you have?

The plugin only uses the mysql oxide library to connect, but does not support ssl, and the authentication plugin is the old one, because of library. Most likely the problem is with the server, as I said. Try to change the authentication plugin and put the ssl code that I gave you in the mysql config, then restart.

That version of mariadb that you have should work fine.

Yeah. You only need to put this in the mysql server config for old auth plugin:

default_authentication_plugin=mysql_native_password

And update the user auth plugin

ALTER USER 'user'@'ip' IDENTIFIED WITH 'mysql_native_password' BY 'pswd';

You can check the user auth plugin by using

SELECT user, host, plugin FROM mysql.user;

ah okay.. but i have some questions..
1. from where can i get the newest version of the user auth plugin

2. where do I use the command "SELECT user, host, plugin FROM mysql.user;"

in like "cd MYSQL PATH" and then execute? like the one from my screenshot? if yes.. i got this error

The login plugin is already downloaded both the old one and the new one. you have to make sure you use the old one. add that setting to the mysql configuration. To execute the commands, you must connect to mysql with the command mysql -u user -p in cmd

what is the correct entry for the my.ini so that it uses the old version?
I tried both.. once with the path and once without.. it doesn't work
can you please tell me exactly what I have to do.. step by step to make this plugin work.. you could also use this as a guide for others.. there are probably some who have this problem