Skip to main content

November 2026

Every post published in November 2026, newest first. Pick a day to jump straight to it.

Posts
802
Topics
75
Reading time
91 h
Active days
15

Posts 451–480 of 802 · November 5–6, 2026

Page 16 of 27

Friday, November 6, 2026

25 of 99 posts

  1. Fixed: "The remote certificate was rejected by the provided RemoteCertificateValidationCallback" with MySql.Data

    With a .pfx file in SslCa or CertificateFile, SslMode=VerifyCA and VerifyFull refused a correct server on both macOS and Linux. Use a PEM CA file instead. Real output from .NET 10, MySql.Data 26.10.0 and MySQL 9.7.

  2. Fixed: "Failed to read file at the specified location" with MySql.Data

    MySql.Data can't find your SslCa, SslCert or SslKey file. A relative path depends on the folder the app starts in, and dotnet run --project starts it somewhere else. Use a full path. Real output from .NET 10 and MySQL 9.7.

  3. Fixed: "The host name does not match the name on the certificate" with MySql.Data

    SslMode=VerifyFull compares Server= in your connection string with the certificate's names, and MySQL's automatic certificate has none you could use. Give the server a certificate with the right Subject Alternative Name. Real output from .NET 10 and MySQL 9.7.

  4. Fixed: "The provided key is invalid" with MySql.Data

    "The provided key is invalid" and "Public key presented not for certificate signature" mean the server's certificate was signed by a different CA with the same name as yours, as every MySQL auto-generated CA has. Real output from .NET 10 and MySQL 9.7.

  5. Fixed: "The certificate authority (CA) does not match" with MySql.Data

    SslMode=VerifyCA refuses a server whose certificate wasn't signed by the CA in your SslCa file. It also happens with a file holding several CAs, because MySql.Data reads only the first. Real output from .NET 10 and MySQL 9.7.

  6. Fixed: "The specified file cannot be converted to a key" with MySql.Data

    MySql.Data only reads private keys that start with BEGIN RSA PRIVATE KEY. OpenSSL 3 and MySQL itself write BEGIN PRIVATE KEY, so a good key fails. Convert it with openssl rsa -traditional. Real output from .NET 10 and MySQL 9.7.

  7. Fixed: "No file path has been provided for the connection option SslCert" or SslKey with MySql.Data

    With PEM files, SslMode=VerifyFull in MySql.Data also demands SslCert and SslKey, even if your server never asks for a client certificate. Give it a pair, and here's the surprise: it isn't sent. Real output from .NET 10 and MySQL 9.7.

  8. Fixed: "No file path has been provided for the connection option SslCa" with MySql.Data

    SslMode=VerifyCA and VerifyFull need a CA file, and MySql.Data won't use your system's trusted certificates instead. Copy the CA and point SslCa at it. Real output from .NET 10 and MySQL 9.7.

  9. Fixed: "Unhandled exception. System.AggregateException" with "Authentication to host failed. (I/O error occurred.)" Crashes a .NET C# API with MySql.Data

    A burst of requests above Maximum Pool Size can end a whole .NET C# process with an AggregateException from MySql.Data's TLS handshake. See why, with the driver's code and real measurements, and stop it with a concurrency limit.

  10. Fixed: "ERROR 2026 (HY000): SSL connection error" with "tlsv1 alert protocol version" in MySQL

    The client and the MySQL server have no TLS version in common. Compare tls_version on the server with the client's --tls-version, and use one both accept. Real output from MySQL 9.7.

  11. Fixed: "[ERROR] [MY-000059] SSL error: Unable to get private key" in the MySQL Docker Image

    MySQL runs as uid 999 in its Docker image, so a key file mounted with mode 600 from your own account can't be read. MySQL then runs on with no working TLS. Give the file to uid 999. Real output from MySQL 9.7.

  12. Fixed: "[Warning] [MY-010068] CA certificate is self signed" in MySQL

    MySQL warns that its CA certificate is self-signed, every time it starts. For a private CA that's normal, and there's nothing to fix. Here's how to tell. Real output from MySQL 9.7.

  13. Fixed: "[Warning] [MY-015011] Failed to validate certificate because certificate has expired" in MySQL

    MySQL warns at startup that its certificate has run out, and starts with TLS anyway. Clients that check certificates fail, and those that don't carry on. Give it a new certificate. Real output from MySQL 9.7.

  14. Fixed: "[Warning] [MY-015011] Failed to validate certificate because invalid CA certificate" in MySQL

    MySQL warns at startup that its server certificate doesn't validate, because the CA file has no CA:TRUE. It carries on with TLS anyway, so it's easy to miss. Make a real CA. Real output from MySQL 9.7.

  15. Fixed: "ERROR 1045 (28000): Access denied" for an Account with REQUIRE SSL in MySQL

    A MySQL account with REQUIRE SSL gets a plain ERROR 1045 when it connects without TLS, even with the right password, and that includes a local socket. Turn TLS on, or use REQUIRE NONE. Real output from MySQL 9.7.

  16. Fixed: "ERROR 4031 (HY000): The client was disconnected by the server because of inactivity" in MySQL

    A MySQL session sat idle longer than wait_timeout or interactive_timeout, and the server closed it. Run the statement again, or raise the timeout. Real output from MySQL 9.7.

  17. Fixed: "ERROR 3888 (HY000): Failed to set up SSL" with "Unable to get private key" in MySQL

    ALTER INSTANCE RELOAD TLS failed because the key doesn't match the certificate. MySQL keeps using the old pair, so nothing's broken yet. Put the right key back and reload. Real output from MySQL 9.7.

  18. Fixed: "ERROR 3159 (HY000): Connections using insecure transport are prohibited" in MySQL

    MySQL has require_secure_transport turned on, and this connection has no TLS. Use --ssl-mode=REQUIRED, or a local socket. Real output from MySQL 9.7.

  19. Fixed: "ERROR 3118 (HY000): Access denied for user. Account is locked." in MySQL

    Someone locked this MySQL account, or a failed-login limit did. Check account_locked, then unlock it with ALTER USER if it should be open. Real output from MySQL 9.7.

  20. Fixed: "ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection" in MySQL

    The mysql client is connecting over TCP with TLS turned off, and the account's password check needs a secure connection. Use --ssl-mode=REQUIRED. Real output from MySQL 9.7.

  21. Fixed: "ERROR 1819 (HY000): Your password does not satisfy the current policy requirements" in MySQL

    MySQL's validate_password component rejected a password. See the rules, test a password's score with VALIDATE_PASSWORD_STRENGTH, and use a stronger one. Real output from MySQL 9.7.

  22. Fixed: "ERROR 1226 (42000): User has exceeded the 'max_user_connections' resource" in MySQL

    An account has reached its limit on connections. Find what's using them, and raise the limit or close them. Real output from MySQL 9.7.

  23. Fixed: "ERROR 1142 (42000): DROP command denied to user" in MySQL

    A MySQL account without the right to change tables gets ERROR 1142 for DROP, CREATE and ALTER, and TRUNCATE reports DROP too. Often that's what you want. Here's how to check, and how to grant only what's needed. Real output from MySQL 9.7.

  24. Fixed: "error 79 at 1 depth lookup: invalid CA certificate" with openssl verify

    openssl verify refuses a certificate because the CA that signed it has no CA:TRUE. It usually comes from running openssl req -x509 with no configuration file. State the flag in the command. Real output from OpenSSL 4.1.

  25. Fixed: Docker Compose Recreates a Container Because a Shell Variable Overrides .env

    A variable exported in your shell beats the same one in .env, so docker compose up recreates the container with the wrong value. With MySQL, the next sign-in then fails with ERROR 1045. Unset it. Real output from Docker Compose and MySQL 9.7.

Thursday, November 5, 2026

5 of 124 posts

  1. How to Connect a .NET C# Web API to a MySQL Database — Part 4: Transactions, Row Locks and Retries with MySQL

    Make a .NET C# Web API safe under load with EF Core 10 and MySQL 9.7: put several writes in one transaction, watch row locks in three terminals, stop two people buying the last item, end deadlocks, survive a MySQL restart with no failed requests, set time limits that work, and make a retry safe after a lost COMMIT.

  2. How to Change a Status Only Once with a Conditional Update in EF Core

    Put the current status in the UPDATE's WHERE, and two requests can't both cancel one order: six at once gave one 204 and five 409s, and the stock went back once. Real code and output from EF Core 10 and MySQL 9.7.

  3. What Happens to an EF Core Transaction When the Client Disconnects

    If a client hangs up between statements, the cancellation token rolls the transaction back, with nothing applied and no error logged. If it hangs up during a blocked statement, that statement still applies. Real output from EF Core 10 and MySQL 9.7.

  4. Why You Should Not Do Slow Work Inside a Database Transaction

    A transaction holds its row locks until it ends, so a slow call inside it makes everyone else wait. Moving a 3-second call out of the transaction took another request from 2.5 seconds to 0.013. Real output from EF Core 10 and MySQL 9.7.

  5. How to Test What Happens When the Reply to a COMMIT Is Lost

    A dropped connection during COMMIT is rare, and hard to test by chance. A 45-line TCP proxy lets it reach MySQL, throws away the answer and closes the connection, so you can see what your retries really do. Real output from EF Core 10 and MySQL 9.7.