ProxySQL driver for C# Dotnet Core

Polyglot Projects ProxySQL
1

Hi,

I’m getting an error when connecting to ProxySQL from a DotNet Core app. ProxySQL is running in front of a few MySQL databases. The databases are a Percona XtraDB MySQL cluster with Galera replication.
I stop the debugger here, at conn.Open()

var connStrBuilder = new MySqlConnectionStringBuilder()
        {
            Database = "redacted",
            UserID = "redacted",
            Password = "redacted",
            Server = "redacted",
            Port = 6033,
            AllowUserVariables = true,
            CharacterSet = "utf8mb4"

        };
        var conn = new
              MySqlConnection(connStrBuilder.ConnectionString);
        conn.Open();

Then I “Step Over” and get the following error:

stackexception
stackexception1382×519 130 KB

I also tried without including the CharacterSet, but got the same error.
The MySQL Connector is from the Nuget Package called “MysqlConnector” version 1.2.1

1 Like
2

I figured it out. The percona configuration mysql-server_version was set to 8.0, however my actual mysql version was 8.0.19-10 (a mismatch) so setting the ProxySQL config to 8.0.19-10 fixed it.

1 Like